MySQL Insert

To safely save data to a database and safely print data stored in a database

// Safely save data to a database
$query = sprintf('
    INSERT INTO `mytable`(
        `foo`,
        `bar`
    )
    VALUES(
        "%s",
        "%s"
    )',
    mysql_real_escape_string($foo),
    mysql_real_escape_string($bar)
);
// Safely print data stored in a database
echo htmlspecialchars($foo, ENT_QUOTES, 'UTF-8');
echo htmlspecialchars($bar, ENT_QUOTES, 'UTF-8');
Did this help you? Please let me know with a comment. Thank you
Posted .

Comments (RSS)

Leave a comment