How To Increase PHP/pgsql Develop. Performance?
Can anyone give me recomendations on software that can increase my performance when devenlopping Php and Postgres applications?
I'm currently working on a big project and its taking too long (3 people working on it).
View Complete Forum Thread with Replies
Related Forum Messages:
My Buttons's Value Increase Themself Without Click The Increase Button
I am creating some buttons for dynamic urls as following: < 1 2 3 > note <: for decrease. >: increase which they let user to navigate different page. it is same as this forum does. but the problem i got at the movement is that the value of button will be increase when i refresh the page without i click the button of ">". it becomes < 2 3 4 >, it is not what i want. it should change it to < 2 3 4 > from < 1 2 3 > when i click the button of the >. Code:
View Replies !
My Buttons's Value Increase Themself Without Click The Increase The Button
I am creating some buttons for dynamic urls as following: < 1 2 3 > note <: for decrease. >: increase which they let user to navigate different page. it is same as this forum does. but the problem i got at the movement is that the value of button will be increase when i refresh the page without i click the button of ">". it becomes < 2 3 4 >, it is not what i want. it should change it to < 2 3 4 > from < 1 2 3 > when i click the button of the >. Code:
View Replies !
--with-pgsql=WHERE?
I need an installation with Postgres support, and was happy to find in my phpinfo that there was a --with-pgsql=shared option in the config line. but I still got "call to undefined function: pgsql_connect (4.3.11) So I figured whatev, I'll put a new installation (PHP5, in fact), but I always fail config with: Cannot find libpq-fe.h. Please specify correct Postgresql installation path 'course i looked in my handy old webmin to see where Postgres might be... tried various paths I found in various places --with-pgsql=/var/lib/pgsql/ --with-pgsql=/usr/share/pgsql --with-pgsql=/usr/bin/psql obviously not a lib, but getting desparate...
View Replies !
PHP Installation With Pgsql
I got PostgreSQL installed and now I'm trying to get PHP installed too. I do ./configure --with-pgsql and everything works fine. But when I do make, I get this error: ext/mysql/libmysql/my_lib.o(.text+0x37a): In function `my_dir': /home/marc/extract/php-4.3.1/ext/mysql/libmysql/my_lib.c:169: undefined reference to `errno' ext/mysql/libmysql/my_lib.o(.text+0x546): In function `my_stat': /home/marc/extract/php-4.3.1/ext/mysql/libmysql/my_lib.c:588: undefined reference to `errno' ext/mysql/libmysql/my_tempnam.o(.text+0x79):/home/marc/extract/php-4.3.1/ext/mysql/libmysql/my_tempnam.c:108: more undefined references to `errno' follow collect2: ld returned 1 exit status make: *** [sapi/cgi/php] Error 1 I need php installed soon. I don't know what is causing this error to occur.
View Replies !
Hosting PHP And PGSQL DB
Can anyone recommend somewhere that offers cheap or even free web hosting for PHP scripting with a PGSQL database? I am looking to build a small website with some images and dynamic content, such as a forum/message board and wondered what it would cost me for this? I used to use themooseisloose for hosting (one-off payment of £2.77 GBP), but have been alerted that have gone bust (at some point at the end of last year). I've have googled, but was just wondering if anyone had any positive experiences of hosts that will allow this setup mentioned cheaply.
View Replies !
Error Management : Php-pgsql.
My goal : obtain the error message if the connection fail. ## my code : <?php $cnxString = "host=localhost port=5432 dbname=toto user=atlante password=aiThoo3g"; $pgsql_conn = pg_connect($cnxString, PGSQL_CONNECT_FORCE_NEW); if ($pgsql_conn) { print "Connexion réussie à : " . pg_host($pgsql_conn) . "<br/> "; } else { echo pg_last_notice($pgsql_conn); exit; } ?> ## if «php_value display_errors 1» the screen result is this one : Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: la base de données «toto» n'existe pas in /home/willou/public_html/atlanpolis/wwws/tools/checkdb.php on line 5 Warning: pg_last_notice() expects parameter 1 to be resource, boolean given in /home/willou/public_html/atlanpolis/wwws/tools/checkdb.php on line 10 ## If not, i haven't got any result. The message just appears in my logs The return of pg_connect not seems to be an connection resource when the connection fails.
View Replies !
My Dad Wants PHP & MySQL Or PgSQL Hosting
To my surprise last month, my dad wanted to start dabbling in PHP and MySQL or pgSQL. I've been helping him out a bit. He's into athletic medicine and wants to have a website to help athletes and physical therapists improve performance. His current web hosting provider -- Earthlink -- doesn't give him anything but PHP 3.0.x. I want to get him at least on PHP 4.2.x (or better) along with either MySQL or PostgreSQL (pgSQL) support. I've done some googling on this, but I wanted real user opinions on cost, customer support, uptime, etc. At this point he's just looking at something that suits him somewhere between hobbyist and early sole proprietorship strength. Shared web hosting would suit him fine. Cost might be an issue for him initially. He's going to need some sort of simplistic web interface to be able to create databases, tables, and user accounts.
View Replies !
Pgsql Socket Timeout
I am encountering a problem with PHP5 and postgresql on a fedora core 3 box. I have a database driven report application written in PHP5 on a remote server. This application allows a user to submit a sql statement created by php based on user input parameters to the postgresql server. The application works great as long as the database server can return the result set within what appears to be 2 minutes. If the query takes longer than two minutes to execute the database server will eventually finish the work *but* no rows of data appear on the web page. I am thinking that the network socket connection between the php engine and the postgresql database server gets dropped after two minutes and that is way the results never arrive at the php page. If you think this might be a plausible explanation can you provide some assistance as to how I can go about adressing this problem?
View Replies !
Ubuntu Php4-pgsql
I found some strange kind of mild install bug when installing Ubuntu 5.04 php4-pgsql module (the module that connects PHP4 to PostgreSQL). You may encounter the error: Call to undefined function: pg_connect() No amount of using Synaptic Package Manager would fix this for me. The solution was all at command line under 'root' account: $ apt-get update $ apt-get install php4-pgsql $ /etc/init.d/postgresql restart $ /etc/init.d/apache2 restart
View Replies !
MySQL And PGSQL And Hostname Question
i would like the thoughts of some folks with more experience than i have. i want to learn pgsql. i have some vb and msaccess experience and would like to learn how to use php and pgsql to develop some nice website / application functionality. however, i'm not sure the hurdle of relatively miniscule documentation and tutorials is worth the effort. i'm now thinking i should just use mysql to start and, if the need really arises, move over to pgsql. i'm busy with a lot of stuff right now - regular job, starting a business, developing a web site for the business, learning graphics programs, living life, blah, blah, blah. what is your opinion? go with the better documented db and develop more quickly but have to possibly switch over later when time may be more available and retain my hair or bite the bullet and go with pgsql? differing opinions are appreciated and encouraged so i can evaluate them based on my own set of values. also i am trying to set up localhost as my url so my hardcoded links work on my local win98 machine (actual webserve is linux). host.sam is as follows... 127.0.0.1 localhost www.easyautodeals.com my apache httpd.conf file shows the following for ServerName: ServerName www.easyautodeals.com however, when i type easyautodeals into my web browser, i go straight to my actual web server and not to my "localhost" location.
View Replies !
Irritating Warning On ->PEAR->DB->PGSQL
I am getting following message from pear. I am running RedHat 8.0, PostgreSQL is 7.3.2 PHP Version 4.2.2 and pear:db 1.6.5. Warning: pg_errormessage(): supplied argument is not a valid PostgreSQL link resource in /usr/share/pear/DB/pgsql.php on line 449 Any idea.
View Replies !
PGSQL 7.4.8 PHP 4.3.4 & Apache 2.0.49 Segmentation Fault With Client Certs
Having an issue that is specific to PHP compiled with PGSQL support with versions noted in subject line. I understand that there are many variables to consider here but believe I have narrowed down the Apache Client Cert failures to my PHP/PGSQL build. 1. Apache PHP without PGSQL works as expected using client certificates 2. Apache PHP with PGSQL works fine with standard SSL connections 3 Apache PHP with PGSQL fails with client certificates - no output other than Segmentation faults in the apache error logs as follows: [Wed Nov 30 23:26:57 2005] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec2).... I also performed same tests on another instance of Apache/PHP/PGSQL which was version 2.0.54 of apache and PHP/PGSQL versions same as subject line with same exact results. Any ideas as to the source of this problem and suggestions for tests/fixes are greatly appreciated. There are no errors in any of the logs other than what I have included so it's very difficult to see what is wrong. All I know for sure is that I am able to reproduce the results on more than one machine.
View Replies !
What's The Best Way To Develop PHP Apps ?
I'm new to PHP, I already learned the basics of the language and built some little app's for practice. I have a critical dilemma, soon enough, I probably start to develop real-world applications, fully working web-sites for paying costumers. I have 2 options for doing this: writing everything with plain PHP, or using some PHP framework. I don't want to choose something and the realize that the other is batter. I want to get used for one of this 2 programming techniques and stick with it with no regrets in the future. please try to help me here, I'm searching the web for 3 days but can't find a decent answer, many programmers started with plain PHP then wanted to try some framework but realized that changing all the apps they have been building would be a pain -so they stick with the plain php and maybe some template engine [ie- Smarty]. thats not my situation because I'm new to the language, I really want to do the best move at the beginning.
View Replies !
POLL: Which IDE Do You Use To Develop PHP?
Just curious what IDEs are popular nowadays. What do you expect from an IDE? Debugging? Do you use your IDE for debugging, or do you work like me? (Just use some smart-placed var_dump() to dive into possible problems?) Syntax highlightning? Anything else? I use Eclipse 2.1 with PHP-plugin. Reason: It is for free and works fine.
View Replies !
Develop A Web Portal In PHP
I need to develop a web portal in PHP. can someone please give me some code for php pages using a small database. 2-3 PHP Pages & a small database would b welcomed.
View Replies !
Develop Tools
What is the best tool to develop a php-website ? I used Macromedia Dreamweaver MX and Zend Studio. Are there better tools ?
View Replies !
Safe To Develop In V5.2
I'm finally making the jump from PHP 4.4.2 to v5.2 which I just downloaded but my hosting company still only supports v5.1.2. They'll eventually upgrade to 5.2 but no rollout date is set yet and I can't find a v5.1.2 version on php.net.
View Replies !
Increase Value
I have a list of items in a table. One of the sells has a numeric value, itemNumber, it is not an incremental ID but somewhat similar. Now I need to be able to detect what is the highest number in the itemNumber column and create itemNumber+1.
View Replies !
Develop A Gallery Script Using Php.
I am trying to develop a gallery script using php. When I creating thumbnail then it will echo a msg that thumbnail done and saved. How can I add a progress bar that will show the thumbnail creation process status and the image name that are in process at that time when thousands of thumbnail is creating on background.
View Replies !
PHP Web Site Develop Doc Needing
I got a order of a factory's web site and want to develop it via PHP+MySQL. But, I a real newbie about it and if you can give me some documents about it? You can send them to my email box: li_jia_qi#yahoo.com.cn or reply this msg.
View Replies !
Number Increase
I have a code which starts with a letter and then digits follow, an example code looks like D002482 How can I get php to increase the codes number by 1, leaving the letter the same. The above would look like D002483 I tried $codenum = substr('D002482', 1); $codelet = substr('D002482', 0,1); $code2 = $codenum+1; print $codelet.$code2; But that seems to remove the 00 at the start of the code.
View Replies !
How To Increase Speed?
I am building small application like utube. First thing is I want to convert different type of video format into .fl(on server side) , How can I do this? second thing is How can I increase speed So the video get visible to user as quickly as possible?
View Replies !
Increase Date
So if I have: Code: $month = date(m); I want to increase this by one to get the next month, I can add one which is fine. But if we are in December, is there an easy way to have this "rotate" to January (1) instead of going to 13? Not sure if there is a way to do this with the date function. So before somebody posts it, I want to avoid the following if possible: Code: $curr_month = date(m); if ($curr_month == "12") { $next_month = "1"; } else { $next_month = $curr_month + 1; }
View Replies !
Increase Day Function
People can select the start date and the interval (everday, every week, every month) and the end date. But the problem is how to get the date 2 weeks after eachother, etc? Also, I can't run a while loop (while(start_date < end_date) becouse php doesn't see these things as dates.
View Replies !
Easy Framework To Quickly Develop Php App
I only know basic of html/FTP knowledge but experienced in xBase programming. I am looking for nice/easy framework/tools to quickly develop a php database app (eg: table setup, master/details entries) with good looking interface and data field validation. Can you recommend any and comment/compare their features ?
View Replies !
How To Increase The Execution Time ....
How can we increase the execution time ? I told them we can increase the limit in the php.ini file then again they told me how we can do in the code?? I don't have any idea about this can any body tell me the answer .
View Replies !
Increase Date And Time
I need to increase a given date and time (by a flat text) with 30 seconds(incremental) on each item coming from my database. exmpl: item1 date Apr 24, 2007 19:00:00 item2 date Apr 24, 2007 19:00:30 item3 date Apr 24, 2007 19:01:00 someone got an idea?
View Replies !
Increase Connection On My LINUX BOX
how am i goingt o increase the connection on my linux box? currently or the default connection is 100 and i want to add up an additional like around 100 or 150. is theres any way i could do it myself? whats should i do?
View Replies !
Increase Result By 10% In Loop
I am trying to create a loop that increase the radius of a circle by a certain percent (10%) every cycle (5 times in total). The radius is entered by the user. I am trying to get the area of a circle to increase, by increasing the radius by 10% every cycle of a loop. I have started the script and have not managed to do it. The script below only increases the radius by 1 every loop. <html> <title>test</title> </head> <body> <h1>test</h1> <?php $times = 5; $i = 0; $x = 0; print '<hr />' function getnum() { $strThisPage = $_SERVER['PHP_SELF']; ........
View Replies !
Develop Internal Control System With PHP-MySql
I am NEWBIE & trying to develop internal control system with PHP-MySql & have one problem. I want to enter dynamic variable into MySql like : "I have checked report of Mr. $userName from $previousDate to $currentDate…..” Wherein - $username, $previousDate, $currentDate will be called from other table. My codes : PHP Code: INSERT INTO `checkReport ` (`schID`, `schNo`, `noteNo`, `subschName`, `content`) VALUES (1, 1, 'a', '', ' I have checked report of Mr. ‘.$username.’ from ‘.$previousDate.’ to ‘.$currentDate.’ ….) which is not working… Please guide me through.
View Replies !
Do People Develop Live On The Server Or Offline?
I have been developing on our server in a 'spare' domain up to now which makes for a <B>lot</B> of time spent uploading/testing changes as I go along. I was wondering do the majority of PHP/MySQL folks do this or do do you set everything up on your own machines? I have seen the downloads available and was wondering is it straightforward to get going offline. As soon as I had everything runnung on our server, I stuck to that.
View Replies !
How To Develop A Small Content Management Site
I am working on developing a small content management site and was wondering if there is a code out there for me to use or advice on how to write a php coded page that will bring up the record from a Mysql database and enable the user to edit it.
View Replies !
Develop A Photo Upload System For My Website
I am trying to develop a photo upload system for my website. Currently I have to upload each photo one at a time, with comments etc, into a database. This works fine, but I'd like to be able to upload all the photos at once and then write a script to comment on the photos thereafter. All I need help with is the best way to create a simple interface to upload the files. What is the quickest way? POST? FTP? Something else.
View Replies !
PHP Script Increase Server Load, What To Do?
I have built a php script and am using it on my apache server (php version 4 and red hat linux). The problem that I am facing is that whenever I use the "top" command via ssh on my server, it shows a stuck httpd request due to these php scripts. The request remains stuck for an unforeseen time, increases memory usage and thus increases server load and processing power. Not just 1, there are several such httpd requests running for a very long time and I could say that they terminate only when I do a apache restart.
View Replies !
How Do You Increase A String By 1 Each Time In A While Loop?
I thought I knew how to use a while loop, but I gues not, i'm still a n00b.:( Anyways, how do you increase a string by 1 each time in a while loop? For example, i did this (the string I am referring to is $e): <? $e = 0; while(preg_match("/[quote](.*?)[/quote]/ise", $formtext, $matches)) { $e = $e + 1; $msg = str_replace($matches[0], makequoteBox($matches[1], $e), $msg); } ?> The number comes out as 1 each time, why?
View Replies !
Random Numbers - Develop A Banner Ad Rotator On Site
I am trying to develop a banner ad rotator on my site. I DO NOT need to know the precise number of ads served per banner. Therefore, I do not want phpAds as it would be overkill and slow down my site. I have 3 banner spaces per page. Currently, I have 4 different sponsors. I just wanted to run a random number mechanism so that every tme the page is requested, 3 out of the available 4 banners are chosen automatically. So my current doe (pusedo) is something like this: seed... rand... if($x=1){ banner1 banner2 banner3 } if($x=2){ banner2 banner3 banner4 } if($x=3){ banner3 banner4 banner1 } if($x=4){ banner4 banner1 banner2 } Is this the best way? I do not see his method as being very scalable as it requires me to manually input the possible combinations. I only need a simple solution that is scalable to many sponsors but since I do NOT need to know exact impression levels (all sponsors divide up the impressions equally), I do not want to use MYSQL to "kill a fly with hammer."
View Replies !
PHP + MS Access + How To Increase The Speed Scripts Are Executed At.
Background: I have written a Call Logging and Reporting System using PHP that integrates with an existing MS Access Database. The information in the database is all held in flat tables with no relationships (I don't know why they did this) and the users are currently using VBA forms to enter info into the database, this meant that each time someone wanted to do a report of the call's recorded over the last week that they would have to go throught the database themselves and compile a report (e.g. re-type the info into excel or something). I'm using PHP/GD to generate bar/pie charts and reports in HTML, PDF and ms excel formats (well a CSV file). Question: Each call needs to be allocated a unique number, the way I'm doing this at the moment is using SQL to look through the database and find the last record and then incrementing it. The problem is that at the moment there are over 40,000 records in the database and its taking roughtly about 11 seconds for that call logging PHP page to load. Is there anyway of improving this (other than increasing memory/processing power on the server side).
View Replies !
How Can I Increase The Import Maximum Size For MySql
I have a requirement for importing a sql file in my local databse.I have exported the file from the client database.That file is more than 50mb.I want to import this sql file into my local database.My Maximum import file size showin as 8mb.I tried to change by editing the ini file.But still it showing the same.I am using phpMyAdmin.Please tell me the procedure to change the Maximum File Size for Importing sql file.
View Replies !
Sql Query For Highest Increase In Price From List
Let's say I've retrieved some data from a DB... I've got two different prices: $currentprice and $previousprice.. I would like to work out which have the highest increase in price from my list... I managed to work out porcentages by doing something like: $evolution = ($row[currentprice]-$row[previousprice])/$row[previousprice]*100; but I would like to select the top 10 highest increases for example.
View Replies !
Increase Variable Digit Output Amount
I'm working on a small script that uses polygons to find pi, and I need a way to increase the default amount of digits that are presented. Currently, each variable is displayed with 13 digits. I'd like it to be closer to 30, or higher for better accuracy. Any way to do this?
View Replies !
Develop A System For Information Distribution Over Plasma Screens In A School
I'm trying to develop a system for information distribution over plasma screens in a school. The news items are stored in a flat text file (which can be updated easyly) and I have written a php script to read the file and format it. When I have a 'page full' of information I need to be able to dwell (say 10 seconds) and then read the next bit of the file into a 'clean' page, go on doing this to eof and then loop. I seem to have a mental block at this stage. Can I clear the page? should I jump to a new page (which will be empty) -- if so how can I transfer the file postion pointer to the next page? Am I going about this completely the wrong way.
View Replies !
Use Virtual Hosts To Develop Locally But Upload Throws Error In Source File References
On my development computer, I have virtual named host set up, like www.site1.lab. When I upload those to my web site for customer review under mywebsite.com/clients/site1/ it throws some of the source file references off and it does not work properly. My references are like: require_once($_SERVER['DOCUMENT_ROOT']."/utility/top.php"); Obviously those will not work since $_SERVER['DOCUMENT_ROOT'] references mywebsite.com. Is there anything I can do in apache.conf for a virtual directory that would make it so when I upload a site for customer review, I don't have to change the source references?
View Replies !
|
TRACKER
