Databases
in [PHP]
|
Injection Attack? I have a DB on a site that is not really up anymore (a redirect because of a merger), and it seems to have been attacked. I always use REMOTE_IP so that I have a record and able to ban IP's of the endless form spammers, however on this attack, the IP listed is my local IP (actually my old one since I changed I... 25 Feb 2010 17:08
Need a tool for mysql file Hi All, I have a mysql database file of around 1 GB in size. Is their any tool which which I can see all the database without uploading it on phpmyadmin on localhost. I have tried to upload it on localhost but it said the file size is too large (I have changed the ini file as well but no luck ). I need a tool w... 25 Feb 2010 17:08
SELECT LIKE with "%" and without "%" "Eleonora De Marinis" <eleonora.demarinis(a)garr.it>, haber iletisinde sunlari yazdi:49FE92D0.2060406(a)garr.it... $sql = "SELECT * FROM table WHERE ID ='$_GET[id]' AND title LIKE '%$_GET[word]%'"; -------- Original Message -------- Subject: [PHP-DB] SELECT LIKE with "%'" and without "%'" From:... 24 Feb 2010 06:27
mysql_close() Does mysql_close() close all open database connections? How would I specify which connection to close? Ron ... 20 Feb 2010 18:02
Login query I am wondering what others do for a login query. I think there could be two results: correct e-mail & password; correct e-mail & wrong password So far my login query is: SELECT * FROM `member` WHERE `email` = '$my_email' AND `pass` LIKE BINARY '$my_password' LIMIT 1 This wouldn't tell me if the user has the... 18 Feb 2010 17:23
Using mssql serial command in PHP 5.3 I am using the EasyPHP5.3.0 and MS SQL Server Management Studio Express 9.00.2047.00 Config of EasyPHP5.3.0 ================== PHP 5.3.0 Apache 2.2.13 MySQL 5.1.37 PhpMyAdmin 3.2.1 I want to use mssql command (e.g. mssql_connect) as my db connector. When I run my code the following error has prompted. Ca... 18 Feb 2010 20:45
Getting total quantities Hello List, I have a situation where I want to figure out the total number of products in my database. I want to read all the fields $ProductStock and add them together to get the TOTAL number of products, not just the number of rows in my database. Any pointers on the code to use for adding multiple rows f... 15 Feb 2010 01:07
PHP Objects and SQL Results Hi all, I'm currently having a problem correctly formatting a table within a while loop. I'm using an object to store the results of a query, and using the while to iterate through it each row to produce the output: $query = "SELECT * FROM foo WHERE UserID = " .$uID . " ORDER BY bar"; $result = mysql_query(... 13 Feb 2010 16:05
php_warn some of my web pages having the following issue when i call them Warning:main(main_page.html.php): failed to open stream: No such file or directory in /www/htdocs/web/public/public.php on line 50 Warning:main(): Failed opening 'main_page.html.php' for inclusion (include_path='.:/usr/local/lib/php') in /www/htdocs/... 16 Feb 2010 18:25 |