[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-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] 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.
?php
/*
~ * 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
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.
?php
/*
~ * 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] 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 ... Previous 1 2 3 4 Next ...
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());
?
table width=100% border=0 cellpadding=5 align=CENTER
tr
td hr align=RIGHT size=1 width=100% noshade /td
/tr
?
while($row = mysql_fetch_array($result)) {
? trtd ?
if($last_date == $row[date]):?
p class=dateb?echo $row[time]?/b
?else:?
p class=date?echo $row[time]? - b?echo $row[date]?/b
?endif;
$cat_num = $row[category_id];
$cat_result = mysql_query(select categories.category from news2, categories
where news2.category_id = categories.category_id and news2.category_id = '$cat_num');
$cat = mysql_fetch_array($cat_result);
?
br
..
/tr
?
}
?
/table
?
}
=== script for generating the pages ===
$table = 'news2'; // The name of your table in the database
$limit = '2'; // How many results should be shown at a time
$scroll = '10'; // How many elements to the navigation bar are shown at a time
// Get the total number of rows in a database
$query1 = mysql_query (SELECT * FROM news2);
$numrows = mysql_num_rows ($query1);
//
if (!isset ($_GET[show])) {
$display = 1; // Change to $NUMROWS if DESCENDING order is required
} else {
$display = $_GET[show];
}
// Return results from START to LIMIT
$start = (($display * $limit) - $limit);
$query2 = mysql_query (SELECT * FROM $table LIMIT $start,$limit);
while ($myrow = mysql_fetch_array ($query2)) {
echo p.$myrow[ROW]./p; // EDIT TO REFLECT YOUR RESULTS
}
//
$paging = ceil ($numrows / $limit);
// Display the navigation
if ($display 1) {
$previous = $display - 1;
echo a href=\$_SERVER[PHP_SELF]?show=1\ First/a | ;
echo a href=\$_SERVER[PHP_SELF]?show=$previous\ Previous/a | ;
}
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 b$i/b ;
} else {
echo a href=\$_SERVER[PHP_SELF]?show=$i\$i/a ;
}
}
}
if ($display $paging) {
$next = $display + 1;
echo | a href=\$_SERVER[PHP_SELF]?show=$next\Next /a | ;
echo a href=\$_SERVER[PHP_SELF]?show=$numrows\Last /a;
}
//
?
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] 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
... Previous 1 2 3 4 Next ...
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());
?
table width=100% border=0 cellpadding=5 align=CENTER
tr
td hr align=RIGHT size=1 width=100% noshade /td
/tr
?
while($row = mysql_fetch_array($result)) {
? trtd ?
if($last_date == $row[date]):?
p class=dateb?echo $row[time]?/b
?else:?
p class=date?echo $row[time]? - b?echo
$row[date]?/b
?endif;
$cat_num = $row[category_id];
$cat_result = mysql_query(select categories.category from
news2, categories where news2.category_id = categories.category_id and
news2.category_id = '$cat_num');
$cat = mysql_fetch_array($cat_result);
?
br
..
/tr
?
}
?
/table
?
}
=== script for generating the pages ===
$table = 'news2'; // The name of your table in the database
$limit = '2'; // How many results should be shown at a time
$scroll = '10'; // How many elements to the navigation bar are shown at
a time
// Get the total number of rows in a database
$query1 = mysql_query (SELECT * FROM news2);
$numrows = mysql_num_rows ($query1);
//
if (!isset ($_GET[show])) {
$display = 1; // Change to $NUMROWS if DESCENDING order is
required
} else {
$display = $_GET[show];
}
// Return results from START to LIMIT
$start = (($display * $limit) - $limit);
$query2 = mysql_query (SELECT * FROM $table LIMIT $start,$limit);
while ($myrow = mysql_fetch_array ($query2)) {
echo p.$myrow[ROW]./p; // EDIT TO REFLECT YOUR RESULTS
}
//
$paging = ceil ($numrows / $limit);
// Display the navigation
if ($display 1) {
$previous = $display - 1;
echo a href=\$_SERVER[PHP_SELF]?show=1\ First/a | ;
echo a href=\$_SERVER[PHP_SELF]?show=$previous\
Previous/a | ;
}
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 b$i/b ;
} else {
echo a
href=\$_SERVER[PHP_SELF]?show=$i\$i/a ;
}
}
}
if ($display $paging) {
$next = $display + 1;
echo | a href=\$_SERVER[PHP_SELF]?show=$next\Next /a |
;
echo a href=\$_SERVER[PHP_SELF]?show=$numrows\Last /a;
}
//
?
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] 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 Justin Patrin
--
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: 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 Justin Patrin -- 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] 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
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
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
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] 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
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
[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] 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
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
