[PHP-DB] Get away from eval()

2005-08-26 Thread veditio
Greetings, all. Thanks to those who fielded my sql injection question yesterday. Enormously helpful. On to eval(). I've got a PHP 4.3.xx and a MySQL 4.xx (sometimes 3.2xx) database that is the basis of a CMS. The story field of the content table sometimes holds PHP code that needs to be

RE: [PHP-DB] session confusion| can anyone help?

2005-08-26 Thread Bastien Koert
try defining the values as empty strings first... ?php // accesscontrol.php include_once 'common.php'; include_once 'db.php'; session_start(); $suid = ''; $spwd = ''; $suid = isset($_POST['suid']) ? $_POST['suid'] : $_SESSION['suid']; //line 7 $spwd = isset($_POST['spwd']) ? $_POST['spwd'] :

[PHP-DB] maximum number of records in a db?

2005-08-26 Thread Jordan Miller
I was just wondering what is the maximum number of records that can be successfully handled with a db. any db will do. it doesn't have to be the fastest or best, just one that can hold the maximum number of records and still be able to interact well with php. any ideas? thanks, Jordan --

Re: [PHP-DB] maximum number of records in a db?

2005-08-26 Thread Miles Thompson
At 12:11 PM 8/26/2005, Jordan Miller wrote: I was just wondering what is the maximum number of records that can be successfully handled with a db. any db will do. it doesn't have to be the fastest or best, just one that can hold the maximum number of records and still be able to interact well

Re: [PHP-DB] maximum number of records in a db?

2005-08-26 Thread Jordan Miller
i am talking about individual records, not putting all records into a very long string, if that's what you are saying. i know people routinely use millions of records... but how about billions or more? Jordan On Aug 26, 2005, at 10:29 AM, Miles Thompson wrote: At 12:11 PM 8/26/2005,

Re: [PHP-DB] maximum number of records in a db?

2005-08-26 Thread Raz
Perhaps you misunderstood what Miles wrote...never mind eh? Go here for example: http://www.mysql.com/why-mysql/ - found that in about 6 secs... raz -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: maximum number of records in a db?

2005-08-26 Thread Dan Baker
Jordan Miller [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I was just wondering what is the maximum number of records that can be successfully handled with a db. any db will do. it doesn't have to be the fastest or best, just one that can hold the maximum number of records and

Re: [PHP-DB] maximum number of records in a db?

2005-08-26 Thread Bastien Koert
like i said, billions are possible, but it becomes more of hardware issue, disk space, network availability etc bastien From: Jordan Miller [EMAIL PROTECTED] To: Miles Thompson [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB] maximum number of records in a db? Date: Fri, 26

Re: [PHP-DB] Re: maximum number of records in a db?

2005-08-26 Thread Jordan Miller
Dan, Wow, thank you very much for an actual answer. It is much appreciated. I am sorry that people like to ridicule noobs on this list. It was a simple question with a simple answer. Thank you!! Jordan On Aug 26, 2005, at 10:45 AM, Dan Baker wrote: Jordan Miller [EMAIL PROTECTED] wrote

RE: [PHP-DB] maximum number of records in a db?

2005-08-26 Thread Bastien Koert
It kinda depends on the load placed on the db. Large chunks of data in the db (like images or other files like video, pdf etc) can slow the system down. There are many databases running with over 50Million rows of data in a table. But at a certain level, its as much hardware and network

Re: [PHP-DB] Re: maximum number of records in a db?

2005-08-26 Thread Han
And I agree. I haven't asked many questions myself but have seen the responses from some people. I think you have to think that they have looked and this IS their last resort. I've found when doing searches on the web that I get presented with 5000 pages of un relevant stuff. Remember when

Re: [PHP-DB] Re: maximum number of records in a db?

2005-08-26 Thread Darryl Steyn
with questions being answered like that, i am sure many will. On 8/26/05, Raz [EMAIL PROTECTED] wrote: Jordan I am sorry that people like to ridicule noobs on this list. It was a simple question with a simple answer. Thank you!! Not at all, shame if you see it this way - it is mostly

Re: [PHP-DB] Re: maximum number of records in a db?

2005-08-26 Thread Raz
Jordan I am sorry that people like to ridicule noobs on this list. It was a simple question with a simple answer. Thank you!! Not at all, shame if you see it this way - it is mostly a case of people on this list helping you to help yourself - respect to those who've had a go at finding the