Re: [PHP-DB] Version Upgrade
hi all, Sorry, I meant to say PHP 4.3. Will it be very different from PHP4.2.2 that my programs may perform strangely if I upgrade to PHP4.3? many thanks, Hwee - Original Message - From: "Gary Every" <[EMAIL PROTECTED]> To: "Ng Hwee Hwee" <[EMAIL PROTECTED]> Sent: Thursday, May 20, 2004 9:23 PM Subject: RE: [PHP-DB] Version Upgrade > MySQL 4.0.19 is the latest stable release, and PHP 4.2.3 will work well > for you. MySQL 4.1 is still in beta. > > > Gary Every > Sr. UNIX Administrator > Ingram Entertainment Inc. > 2 Ingram Blvd, La Vergne, TN 37089 > "Pay It Forward!" > > -Original Message- > From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 20, 2004 5:15 AM > To: DBList > Subject: [PHP-DB] Version Upgrade > > Hi all, > > I'm running on PHP 4.2.2 and MySQL 3.23.54 > > I would like to do an upgrade... What would be the highest version > number that I can upgrade to without causing any possible conflict? > > I'm thinking of upgrading to PHP 4.2.3 and MySQL 4.0.4 because they have > some features that I need. > > But I will like to be more adventurous so will PHP 4.2.3 and MySQL 4.1 > be advisable? > > Many thanks, > Hwee Hwee -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Forum Software
Of course it all depends on how complex you want these forums to be. I've been working on my own forums system, which can be viewed at http://marcjon.no-ip.com/juicylucy It's made with PHP 5.0rc2 and MySQL 4.0. It does that job (though coding PHP is just a hobby for my right now, so anything that I want does the job). -- Marcjon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Passthru Strangeness
Hi All, My win32 server is not in safe_mode but I can only use passthru for simple commands like "dir" and "type" but when I try to do say a "ping" it simply returns no output but no error either. Anyone have an idea what's going on? I have used it for ping in the past. Ultimately I plan to use it to launch local DB functions, but I can't even get it to ping. Thanks. <>< Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] how to reuse DB results
Aaron Wolski wrote: Is there any way I can make a call to the DB for some records. Display some info from a column or two say at the top of the page and then display the full result set in a while() loop? Look for the seek() function of whatever database you're using, i.e. mysql_data_seek() to reset the results set. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how to reuse DB results
Yeah, that's kind of what I was thinking. The logic in your pseudocode seems correct. However, I'm not sure about the bit where you do: $resultset[] = $results Not because it's wrong, just because I always have to refer back to some form of documentation when putting result sets into an array to make sure I'm doing it right because PHP has that whole Resource thingy (I can see you all cringing now) that represents result sets. Seems to me there's a little more to it than what's written out above. But I'm certain it's possible to put a result set right into an array. And once you have that, you can echo() out whatever members of the array you want and the reset() function will reset the array pointer to the beginning allowing you to loop through the array and echo out the results. Give it a go though, this can't be too far off. Rich > -Original Message- > From: Aaron Wolski [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 20, 2004 4:26 PM > To: 'Hutchins, Richard'; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] how to reuse DB results > > > Hi Richard! > > Thanks. > > Ok.. let me see if I got this straight > > Db_query... > While($results) > { > > $resultset[] = $results; > > } > > //display initial data needed > echo "{$resultset[0]} {"{$resultset[3]}"; > > //display full results further down page > reset($resultset); > > while($resultset) > { > > //display full result set here > > } > > > Is my logic right or completely off base? > > Thanks! > > A > > > > > -Original Message- > > From: Hutchins, Richard [mailto:[EMAIL PROTECTED] > > Sent: May 20, 2004 4:19 PM > > To: [EMAIL PROTECTED] > > Subject: RE: [PHP-DB] how to reuse DB results > > > > Off the top of my head, you could do the db call once, > assign the full > > result set to an array, pull off the parts you want at the > top of the > > page, > > then use reset($arrayname) to put the pointer back to the > beginning of > the > > array then use a loop to print out the whole thing at the bottom of > the > > page. > > > > That's just one way though. There are probably others available with > and > > without the use of a db abstraction class. > > > > HTH, > > Rich > > > > > -Original Message- > > > From: Aaron Wolski [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, May 20, 2004 4:14 PM > > > To: [EMAIL PROTECTED] > > > Subject: [PHP-DB] how to reuse DB results > > > > > > > > > Hi All, > > > > > > Got this logic problem I don't know how to solve. > > > > > > Is there any way I can make a call to the DB for some records. > > > > > > Display some info from a column or two say at the top of the page > and > > > then display the full result set in a while() loop? > > > > > > Right now, I am making two calls to the Db to get the > data I need to > > > display at the top of the page and then a second query to retrieve > the > > > full result set. > > > > > > I'm confused! > > > > > > Thanks for any help! > > > > > > Aaron > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] how to reuse DB results
adodb has a moveFirst() function. You should be able to use it to display x rows then $rs->moveFirst() and then use a while loop to display all of them. HTH, =C= : : Cal Evans : Evans Internet Construction Company : 615-260-3385 : http://www.eicc.com : Building web sites that build your business : Aaron Wolski wrote: Hi All, Got this logic problem I don't know how to solve. Is there any way I can make a call to the DB for some records. Display some info from a column or two say at the top of the page and then display the full result set in a while() loop? Right now, I am making two calls to the Db to get the data I need to display at the top of the page and then a second query to retrieve the full result set. I'm confused! Thanks for any help! Aaron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Forum Software
I just want to know if there are any good forum tutorials out there... I mean, I am using vBulletin 3 - so I cant say anything is better than it. - Original Message - From: "Galbreath, Mark A" <[EMAIL PROTECTED]> To: "'Room 11 Designs'" <[EMAIL PROTECTED]> Sent: Thursday, May 20, 2004 8:54 PM Subject: RE: [PHP-DB] Forum Software > Why would you want to? PHPBB2 is awesome! > > -Original Message- > From: Room 11 Designs [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 20, 2004 3:51 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Forum Software > > > Hi there everyone, > > I was wondering how hard it is to write your own forum, maybe even as > complicated as PhpBB... > > Any help out there? > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how to reuse DB results
Hi Richard! Thanks. Ok.. let me see if I got this straight Db_query... While($results) { $resultset[] = $results; } //display initial data needed echo "{$resultset[0]} {"{$resultset[3]}"; //display full results further down page reset($resultset); while($resultset) { //display full result set here } Is my logic right or completely off base? Thanks! A > -Original Message- > From: Hutchins, Richard [mailto:[EMAIL PROTECTED] > Sent: May 20, 2004 4:19 PM > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] how to reuse DB results > > Off the top of my head, you could do the db call once, assign the full > result set to an array, pull off the parts you want at the top of the > page, > then use reset($arrayname) to put the pointer back to the beginning of the > array then use a loop to print out the whole thing at the bottom of the > page. > > That's just one way though. There are probably others available with and > without the use of a db abstraction class. > > HTH, > Rich > > > -Original Message- > > From: Aaron Wolski [mailto:[EMAIL PROTECTED] > > Sent: Thursday, May 20, 2004 4:14 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] how to reuse DB results > > > > > > Hi All, > > > > Got this logic problem I don't know how to solve. > > > > Is there any way I can make a call to the DB for some records. > > > > Display some info from a column or two say at the top of the page and > > then display the full result set in a while() loop? > > > > Right now, I am making two calls to the Db to get the data I need to > > display at the top of the page and then a second query to retrieve the > > full result set. > > > > I'm confused! > > > > Thanks for any help! > > > > Aaron > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how to reuse DB results
Off the top of my head, you could do the db call once, assign the full result set to an array, pull off the parts you want at the top of the page, then use reset($arrayname) to put the pointer back to the beginning of the array then use a loop to print out the whole thing at the bottom of the page. That's just one way though. There are probably others available with and without the use of a db abstraction class. HTH, Rich > -Original Message- > From: Aaron Wolski [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 20, 2004 4:14 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] how to reuse DB results > > > Hi All, > > Got this logic problem I don't know how to solve. > > Is there any way I can make a call to the DB for some records. > > Display some info from a column or two say at the top of the page and > then display the full result set in a while() loop? > > Right now, I am making two calls to the Db to get the data I need to > display at the top of the page and then a second query to retrieve the > full result set. > > I'm confused! > > Thanks for any help! > > Aaron > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] how to reuse DB results
Hi All, Got this logic problem I don't know how to solve. Is there any way I can make a call to the DB for some records. Display some info from a column or two say at the top of the page and then display the full result set in a while() loop? Right now, I am making two calls to the Db to get the data I need to display at the top of the page and then a second query to retrieve the full result set. I'm confused! Thanks for any help! Aaron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] sybase and php
Ever since we have been using PHP to access data in our Sybase database, database permissions have been spontaneously disappearing from the tables that are being looked at! It happens on the time frame of a couple months between times. To fix it, I have to go into Sybase and grant select permission on the affected table. Has anybody else ever had this problem? Did you solve it? Thanks! Julia
[PHP-DB] Re: Forum Software
Room 11 Designs wrote: Hi there everyone, I was wondering how hard it is to write your own forum, maybe even as complicated as PhpBB... Any help out there? To completely write something that complicated and featureful takes a long time. Why not just use PHPBB? -- paperCrane -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Forum Software
Hi there everyone, I was wondering how hard it is to write your own forum, maybe even as complicated as PhpBB... Any help out there?
[PHP-DB] Re: Am I missing something? Why doesn't php have a 'date' variable
Ross Honniball wrote: Hello. I've been using php for about 5 months now. One of the first things I noticed it was missing was a standard in-built manner of handling dates. I assumed that, being inexperienced, I was probably missing something and in time all would become clear. It's a while later now and I still think it sucks that it doesn't have a standard date variable type. Why doesn't it have a standard class or variable type to help process dates in a standard manner? Php should offer a DATE variable type (in addition to string, int, array, object etc.). Dates could be stored by utilising standard date functions. eg. $birthday = SetDate('23-07-1985', 'dmy'); Use of this function would effectively declare $birthday as a field of type date. (note that I wish this was my birthday). Standard maths could be performed on date fields for comparison. eg. $newdate = $start_date + $birthdate - 5; // as in days if ($date1 < $date2) ..whatever..; And of course standard routines for formating dates, standard routines for showing time between dates / times etc. This frustrated me so much that I recently wrote a class to emulate, as best as possible, this level of functionality, which would actually be quite adequate if Windows didn't suck. But due to some lunatic Windows limitation, it will only work on dates between 1970 and 2038. Hmmm. Nice one, Bill (are we in for another 'new millenium' problem on windows machines in 2038?). Anyway, am I missing something, or do other people find this a glaring omission in an otherwise spiffing product? Ross PS note that in refering to dates above, I really mean date + time. PSS Technical note: As you all know, internally the only rational way to store dates is as a sequential number from an chosen starting date - eg. 1-1-1960, 1-1-1970, whatever. Prior dates are simply stored as negative numbers. . . Ross Honniball. JCU Bookshop Cairns, Qld, Australia. . You are missing a bit. Integers are generally used for Dates in PHP, using the UNIX Timestamp format. You can use strtotime() and date() to convert between timestamp and string formats. Of course, this only works for dates back to 1970. You should have come to the list before now. ;-) There's a class in PEAR that deals with pretty much any date you'll need and has lots of funcitons for adding, subtracting, formatting, etc. http://pear.php.net/package/Date -- paperCrane -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Display mysql query results divided in dynamic numbered pages
Look at: http://www.phpclasses.org/browse/package/92.html It's a pager class that does: << Previous 1 2 3 4 5 6 7 8 9 10 Next >> Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 "Pay It Forward!" -Original Message- From: Kpromos [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 8:35 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Display mysql query results divided in dynamic numbered pages Importance: High Dears, I'm new to php, so I'm not able to solve the following problem. I have a function with a while loop that generates the results of a mysql query. I'd need to generate a flow of the results, divided in pages as ... 1 2 3 4 ... The function I'm using follows .. and also the script that should generate the numbered pages. Someone could help me in incorporating the script that follows too? = function displaying the results == function display($show_what) { switch ($show_what) { case "": $sql = "select * from news2 ORDER BY date DESC, time DESC"; break; } display_posts($sql); } function display_posts($sql) { connect(); $result = mysql_query($sql) or die(mysql_error()); ?> - .. ".$myrow[ROW].""; // EDIT TO REFLECT YOUR RESULTS } // $paging = ceil ($numrows / $limit); // Display the navigation if ($display > 1) { $previous = $display - 1; echo "<< First | "; echo "< Previous | "; } if ($numrows != $limit) { if ($paging > $scroll) { $first = $_GET[show]; $last = ($scroll - 1) + $_GET[show]; } else { $first = 1; $last = $paging; } if ($last > $paging ) { $first = $paging - ($scroll - 1); $last = $paging; } for ($i = $first;$i <= $last;$i++){ if ($display == $i) { echo "$i "; } else { echo "$i "; } } } if ($display < $paging) { $next = $display + 1; echo "| Next > | "; echo "Last >>"; } // ?> Thanks for all, Alessandro Folghera -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Display mysql query results divided in dynamic numbered pages
Dears, I'm new to php, so I'm not able to solve the following problem. I have a function with a while loop that generates the results of a mysql query. I'd need to generate a flow of the results, divided in pages as ... 1 2 3 4 ... The function I'm using follows .. and also the script that should generate the numbered pages. Someone could help me in incorporating the script that follows too? = function displaying the results == function display($show_what) { switch ($show_what) { case "": $sql = "select * from news2 ORDER BY date DESC, time DESC"; break; } display_posts($sql); } function display_posts($sql) { connect(); $result = mysql_query($sql) or die(mysql_error()); ?> - .. ".$myrow[ROW].""; // EDIT TO REFLECT YOUR RESULTS } // $paging = ceil ($numrows / $limit); // Display the navigation if ($display > 1) { $previous = $display - 1; echo "<< First | "; echo "< Previous | "; } if ($numrows != $limit) { if ($paging > $scroll) { $first = $_GET[show]; $last = ($scroll - 1) + $_GET[show]; } else { $first = 1; $last = $paging; } if ($last > $paging ) { $first = $paging - ($scroll - 1); $last = $paging; } for ($i = $first;$i <= $last;$i++){ if ($display == $i) { echo "$i "; } else { echo "$i "; } } } if ($display < $paging) { $next = $display + 1; echo "| Next > | "; echo "Last >>"; } // ?> Thanks for all, Alessandro Folghera -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Request database_queryf() functions.
If you need a better source example/layout goto: http://nopaste.php-q.net/59720 William Bailey wrote: Hi All, After having been talking to lots of people in irc lately who are haveing problems with SQL injection etc i think that haveing a *_queryf() function would be really useful to help people esp when it comes to integers and the id=$id where $id = "1 OR" and name='$name' where $name = "name' OR" issues for example. Most of the sprintf formatting would take care of itself but any %s would automatically have addslashes() applied. I have a php implementation below for the mysql database. Let me know what you think or if i have missed anything. /* ~ * MySQL queryf() function example. ~ */ define('DEBUG', true); // usage: // mysql_queryf($query, $link_identifier = NULL, $arg1, $arg2$argN); function mysql_queryf() { ~$args = func_get_args(); ~if(!isset($args[0]) || !(is_null($args[1]) || is_resource($args[1]) ) ){ ~return false; ~} ~$formatString = array_shift($args); ~$linkIdentifier = array_shift($args); ~$parts = preg_split('/%([ 0]|\'.)?-?[0-9]*(\\.[0-9]*)*[%abcdufosxX]/', $formatString, -1, PREG_SPLIT_OFFSET_CAPTURE); ~$newString = ""; ~for($i = 0; $i < count($parts); $i++){ ~$start = $parts[$i][1] + strlen($parts[$i][0]); ~if(isset($parts[$i + 1][1])){ ~$length = $parts[$i + 1][1] - $start; ~}else{ ~$length = strlen($formatString) - $start; ~} ~$formatCode = substr($formatString, $start, $length); ~$newString .= $parts[$i][0].sprintf($formatCode, (isset($args[$i]) ? ((substr($formatCode, -1, 1) == 's') ? addslashes($args[$i]) : $args[$i]) : NULL)); ~} ~if(DEBUG === true){ ~print("Query is:\n".$newString."\n"); ~}else{ ~if(is_resource($linkIdentifier)){ ~return mysql_query($newString, $linkIdentifier); ~}else{ ~return mysql_query($newString); ~} ~} } mysql_queryf('SELECT * FROM blah WHERE id=%d AND name=\'%\'.-34s\' AND account=\'%0.2f\' AND blah=%06d AND value > \'30%%\'', NULL, '1 OR', 'name\'s'); ?> Output: Query is: SELECT * FROM blah WHERE id=1 AND name='name\'s...' AND account='0.00' AND blah=00 AND value > '30%' -- Regards, William Bailey. Pro-Net Internet Services Ltd. http://www.pro-net.co.uk/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Request database_queryf() functions.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All, After having been talking to lots of people in irc lately who are haveing problems with SQL injection etc i think that haveing a *_queryf() function would be really useful to help people esp when it comes to integers and the id=$id where $id = "1 OR" and name='$name' where $name = "name' OR" issues for example. Most of the sprintf formatting would take care of itself but any %s would automatically have addslashes() applied. I have a php implementation below for the mysql database. Let me know what you think or if i have missed anything. /* ~ * MySQL queryf() function example. ~ */ define('DEBUG', true); // usage: // mysql_queryf($query, $link_identifier = NULL, $arg1, $arg2$argN); function mysql_queryf() { ~$args = func_get_args(); ~if(!isset($args[0]) || !(is_null($args[1]) || is_resource($args[1]) ) ){ ~return false; ~} ~$formatString = array_shift($args); ~$linkIdentifier = array_shift($args); ~$parts = preg_split('/%([ 0]|\'.)?-?[0-9]*(\\.[0-9]*)*[%abcdufosxX]/', $formatString, -1, PREG_SPLIT_OFFSET_CAPTURE); ~$newString = ""; ~for($i = 0; $i < count($parts); $i++){ ~$start = $parts[$i][1] + strlen($parts[$i][0]); ~if(isset($parts[$i + 1][1])){ ~$length = $parts[$i + 1][1] - $start; ~}else{ ~$length = strlen($formatString) - $start; ~} ~$formatCode = substr($formatString, $start, $length); ~$newString .= $parts[$i][0].sprintf($formatCode, (isset($args[$i]) ? ((substr($formatCode, -1, 1) == 's') ? addslashes($args[$i]) : $args[$i]) : NULL)); ~} ~if(DEBUG === true){ ~print("Query is:\n".$newString."\n"); ~}else{ ~if(is_resource($linkIdentifier)){ ~return mysql_query($newString, $linkIdentifier); ~}else{ ~return mysql_query($newString); ~} ~} } mysql_queryf('SELECT * FROM blah WHERE id=%d AND name=\'%\'.-34s\' AND account=\'%0.2f\' AND blah=%06d AND value > \'30%%\'', NULL, '1 OR', 'name\'s'); ?> Output: Query is: SELECT * FROM blah WHERE id=1 AND name='name\'s...' AND account='0.00' AND blah=00 AND value > '30%' - -- Regards, William Bailey. Pro-Net Internet Services Ltd. http://www.pro-net.co.uk/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFArKwGzSfrYDJMXmERAlTAAJ9NMfOG3nLlsU4kPGPDB0UekYh70QCfYBqS 8FDg6oC1MtUWgaK6A/GYmsg= =MtCS -END PGP SIGNATURE- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Slow php-mysql
First that was not only the first connection that sucks but all. Second, the holy solution to my problem was to move all to another server, with the exactly the same config (software but new hardware) and all is now fine. It is a very strange issue that I continu to try to understand. If I find the problem I will post the answer for sure !! Phpdiscuss - Php Newsgroups And Mailing Lists wrote: Hi Dez, I think I got exactly the same problem. I have W2003 Advanced Server running with IIS 6 and PHP 4.3.4. On a nother machine I have MySQL 4.1.0-alpha-nt. Now any connection from any other host in the network (e.g. running phpMyAdmin) to the DB works just fine (hosts running IIS or Apache). But from this one IIS server it takes about 7 seconds to come up with the first connection. every other following connection in the same script works just fine and fast. Except if I use the "new connection" flag in the mysql_connect, then it takes 7 seconds per query. This is almost driving me nuts, as I just don`t know where to look anymore! Have you found a solution? Drez wrote: Hi all, I recently change my apche, php mysql server for a better one. I installed all the same versions of software on the new server (except for php which was 4.36 RC2). I have apache 1.3 + mysql 3.23.58 + php 4.36. Im on a WinXp Pro os. I copy the exact config for the my.ini, httpd.conf and php.ini files. The result is unfortunatly a very slow application. For exemple, it takes 5-10 secoonds to phpMyAdmin to load after the login, but when a do a big query, with the query interface, it clocks under 1 second. I thought It was the php then, but a big while loop took not much time then normal to print out. Then maybe the apache, but page containing only HTML print well. I try to put a connection and disconnection in the While loop and it slow down all the process. With this little test I thing that it come from MySql. I try some setting like "output_buffering" without result. If someone can help me identify for sure the guilty process with some test a can't imagine myself Thanks, and sorry for my bad english I do my best! Drez -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Version Upgrade
Hi all, I'm running on PHP 4.2.2 and MySQL 3.23.54 I would like to do an upgrade... What would be the highest version number that I can upgrade to without causing any possible conflict? I'm thinking of upgrading to PHP 4.2.3 and MySQL 4.0.4 because they have some features that I need. But I will like to be more adventurous so will PHP 4.2.3 and MySQL 4.1 be advisable? Many thanks, Hwee Hwee