[PHP-DB] Addslashes / DB Sort

2004-09-27 Thread Ed Lazor
PHP / MySQL I'm using PHP to retrieve user input and store it in MySQL. PHP's addslashes function is used on data going into the database and PHP's stripslashes function is being used on data coming from the database. This is allowing me to store and retrieve data with no problems, but it's

Re: [PHP-DB] Addslashes / DB Sort

2004-09-27 Thread Jason Wong
On Tuesday 28 September 2004 02:49, Ed Lazor wrote: I'm using PHP to retrieve user input and store it in MySQL. PHP's addslashes function is used on data going into the database Use the more specific mysql_escape_string() (or friend) instead. and PHP's stripslashes function is being used

RE: [PHP-DB] Addslashes / DB Sort

2004-09-27 Thread Ed Lazor
Use the more specific mysql_escape_string() (or friend) instead. You're not supposed to use stripslashes() on data coming from the database Kk, thanks Jason =) -Ed -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Detailed db error codes

2004-09-27 Thread Bastien Koert
You need to use pg_result_error or pg_last_error. Generally, you code to run the query, in the next line you check for an error and pass the error off to some error handling function ie $result = pg_query($sql); if (pg_last_error($result) == false){ //here was an error $error =

[PHP-DB] User Activities

2004-09-27 Thread balwantsingh
hi may pls. help me i am using PHP and MYSQL. is there any command through which i can record which user modifiyed the data through which command (insert / update / delete etc.) on which time and date in a table in mysql. with best wishes balwant -- PHP Database Mailing List