Unable to insert data in MySQL database [duplicate]

by

I suggest using PDO or MYSQLi because MySQL_ is depreciated. Not only that, you’re not escaping your values and are exposing yourself to some issues such as MySQL injection

$pdo = new PDO("mysql:host=localhost;dbname=db","root","password");
$query = $pdo->prepare("INSERT INTO `metabase` (url, title, image, description) VALUES(:url, :title, :image, :descr)");
$query->bindValue(":url", "http://www.imgur.com", PDO::PARAM_STR);
$query->bindValue(":title", $title, PDO::PARAM_STR);
$query->bindValue(":image", $image, PDO::PARAM_STR);
$query->bindValue(":descr", $descr, PDO::PARAM_STR);
$query->execute();

More Related Contents:

  1. Comma separated numeric values – PHP CodeIgniter
  2. php+mysql Fatal error: Call to undefined function mysql_connect()
  3. Using PHP data in MySQL [closed]
  4. How to add Hyperlink on php/html table that displays information from mysql database [closed]
  5. How to display errors for my MySQLi query? [duplicate]
  6. How to retrieve images from MySQL database and display in an html tag
  7. Automated or regular backup of mysql data
  8. Fatal error: Call to undefined function session_register()
  9. PHP: Warning: sort() expects parameter 1 to be array, resource given
  10. PHP date() format when inserting into datetime in MySQL
  11. Save PHP array to MySQL?
  12. implement LIKE query in PDO
  13. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  14. Executing multiple SQL queries in one statement with PHP
  15. Special characters in PHP / MySQL
  16. Fetching single row, single column with PDO
  17. MySQL db question marks instead of hebrew characters..?
  18. “Warning: Cannot modify header information – headers already sent by” error [duplicate]
  19. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  20. Easy way to export a SQL table without access to the server or phpMyADMIN
  21. How I can create installer for website. PHP mysql [closed]
  22. “No such file or directory” or “No such host is known” when running migrations
  23. How to join two tables with ssp.class.php
  24. How to convert IPv6 from binary for storage in MySQL
  25. Eloquent many-to-many-to-many – how to load distant relation easily
  26. How do you make good use of multicore CPUs in your PHP/MySQL applications? [closed]
  27. Update query PHP MySQL [duplicate]
  28. Do I have to use mysql_real_escape_string if I bind parameters?
  29. How to get a list of databases?
  30. How to sort MYSQL fulltext search results by relevancy

Leave a Comment