RE: [PHP-DB] Institute

2004-11-09 Thread Murray @ PlanetThoughtful
May you pls. suggest me a good institute for learning PHP AND MYSQL in and around Delhi or Noida (INDIA). preferably Noida. I don't know what the availability of training is like in your area, but if you find training difficult to find, there are several good textbooks that take you from

[PHP-DB] Executing SQL query with ODBC

2004-11-09 Thread Petrus Ali Saputra
Here is my code: $conn = odbc_connect(Ta Fara,,); $query = SELECT * FROM Config; $result = odbc_exec($conn, $query); echo odbc_num_rows($result); This code never give me a 0 result even there is some data. How can I solve it? Thank you. -- Petrus Ali Saputra

Re: [PHP-DB] Executing SQL query with ODBC

2004-11-09 Thread Simon Rees
Hi Most databases don't return the number of rows in the results of a select statement to odbc_num_rows. See: http://www.php.net/manual/en/function.odbc-num-rows.php Usually the way to determine the number of rows a select returns is to either fetch them all and count them or do an additional

RE: [PHP-DB] session_destroy();

2004-11-09 Thread Norland, Martin
session_regenerate_id is what you're looking for http://us2.php.net/manual/en/function.session-regenerate-id.php Note that it keeps the session data, so you still need to session_destroy if you want to purge the data. - Martin Norland, Database / Web Developer, International Outreach x3257 The

RE: [PHP-DB] Question

2004-11-09 Thread Norland, Martin
Does your form tag have enctype=multipart/form-data ? e.g. form action=?php echo($_SERVER['REQUEST_URI']) ? method=post enctype=multipart/form-data - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent

[PHP-DB] Re: session_destroy();

2004-11-09 Thread Sebastian Mendel
Chris Payne wrote: I need to destroy a session in the browser so when they log out it clears all the session data from the browser, I have tried: session_destroy(); But it doesnt seem to do it as the browser keeps the same PHPSessionID. What is the best way to destroy a session and generate a new

[PHP-DB] mysqldump

2004-11-09 Thread Aaron Todd
I have created a PHP script that looks like: ?php $filename = /var/www/html/db_backup_ . date(n-j-y)..sql; exec('mysqldump -u * -p* database $filename'); ? For some reason this doesnt work and I cant figure out why. There is no error that comes back. When I run the mysqldump

Re: [PHP-DB] mysqldump

2004-11-09 Thread David Orlovich
I wonder if you need to specify the full pathname for mysqldump - when it's being executed by a script it may not know where mysqldump is, whereas if you execute it yourself your PATH tells it where to go, which might be why it works under that circumstance. HTH, David. On 10/11/2004, at 6:59

Re: [PHP-DB] mysqldump

2004-11-09 Thread David Orlovich
also ... I notice you have a space after the -u - should that be there? David. On 10/11/2004, at 6:59 AM, Aaron Todd wrote: I have created a PHP script that looks like: ?php $filename = /var/www/html/db_backup_ . date(n-j-y)..sql; exec('mysqldump -u * -p* database $filename'); ?

Re: [PHP-DB] mysqldump

2004-11-09 Thread Aaron Todd
As far as I know...yes. Thats what I have seen on every post I have looked at and also, thats the way it worked from the console. It wouldnt work with no space. Thanks for your reply, Aaron David Orlovich [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] also ... I notice you

RE: [PHP-DB] mysqldump

2004-11-09 Thread Bastien Koert
Does that user have permissions to run the mysql dump ? Bastien From: Aaron Todd [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] mysqldump Date: Tue, 9 Nov 2004 12:59:31 -0500 I have created a PHP script that looks like: ?php $filename = /var/www/html/db_backup_ . date(n-j-y)..sql;

Re: [PHP-DB] mysqldump

2004-11-09 Thread Jason Wong
On Tuesday 09 November 2004 17:59, Aaron Todd wrote: I have created a PHP script that looks like: ?php $filename = /var/www/html/db_backup_ . date(n-j-y)..sql; exec('mysqldump -u * -p* database $filename'); ? For some reason this doesnt work and I cant figure out why. There

Re: [PHP-DB] mysqldump

2004-11-09 Thread Aaron Todd
Jason, I tried the double quotes but that didn't seem to matter. I also put the command string in a variable and then am running the variable with exec. Still it doesnt work. $filename = /home/virtual/site341/fst/var/www/html/db_backup_ . date(n-j-y)..sql; $command =

Re: [PHP-DB] mysqldump

2004-11-09 Thread Jason Wong
On Tuesday 09 November 2004 19:12, Aaron Todd wrote: Please do not top post (google top post). I tried the double quotes but that didn't seem to matter. It does matter. I also put the command string in a variable and then am running the variable with exec. Still it doesnt work.

[PHP-DB] Do You Need addslashes() When Using Bind Variables

2004-11-09 Thread Francis Chang
Hi, I'm using the Oracle database though I think this question is generic to all databases. If you're using bind variables and preparing the SQL statements ahead of time, do you still need to call addslashes() before binding the strings to the bind variables? Thanks in advance. Francis --