MySQL error when inserting data containing apostrophes (single quotes)?

by

Escape the quote with a backslash. Like 'Kellogg\'s'.

Here is your function, using mysql_real_escape_string:

function insert($database, $table, $data_array) { 
    // Connect to MySQL server and select database 
    $mysql_connect = connect_to_database(); 
    mysql_select_db ($database, $mysql_connect); 

    // Create column and data values for SQL command 
    foreach ($data_array as $key => $value) { 
        $tmp_col[] = $key; 
        $tmp_dat[] = "'".mysql_real_escape_string($value)."'"; // <-- escape against SQL injections
    } 
    $columns = join(',', $tmp_col); 
    $data = join(',', $tmp_dat);

    // Create and execute SQL command 
    $sql="INSERT INTO ".$table.'('.$columns.')VALUES('. $data.')'; 
    $result = mysql_query($sql, $mysql_connect); 

    // Report SQL error, if one occured, otherwise return result 
    if(!$result) { 
        echo 'MySQL Update Error: '.mysql_error($mysql_connect); 
        $result=""; 
    } else { 
        return $result; 
    } 
}

More Related Contents:

  1. php+mysql Fatal error: Call to undefined function mysql_connect()
  2. Using PHP data in MySQL [closed]
  3. drop down menu using php and mysql [closed]
  4. php code for multiple search box after connecting to mysql [closed]
  5. Checking the availability of rooms
  6. How to sort user data by id
  7. PHP PDO prepared statements
  8. Using PHP 5.5’s password_hash and password_verify function
  9. Example of how to use bind_result vs get_result
  10. mysqli::query(): Couldn’t fetch mysqli
  11. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  12. Levenshtein: MySQL + PHP
  13. Incorrect Integer (2147483647) is inserted into MySQL?
  14. I need my PHP page to show my BLOB image from mysql database
  15. How to test if a MySQL query was successful in modifying database table data?
  16. jQuery UI Sortable, then write order into a database
  17. How do i “echo” a “Resource id #6” from a MySql response in PHP?
  18. Delete multiple rows by selecting checkboxes using PHP
  19. mysql_real_escape_string VS addslashes
  20. How to add a delete button to a PHP form that will delete a row from a MySQL table
  21. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  22. Is there any way to check the performance of mysql Indexing
  23. Understanding pdo mysql transactions
  24. Password_Hash not working on my PHP login
  25. Select last 20 order by ascending – PHP/MySQL
  26. Formatting an SQL timestamp with PHP
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. Difference between mysql_fetch_array and mysql_fetch_row?
  29. 500 Internal Server Error?
  30. Aggregated query without GROUP BY

Leave a Comment