The ProgrammersTalk Community - View Single Post - How to combine Query and Variable in PHP?

TeraTask · #2 (**permalink**) 08-06-2007, 11:04 PM

I'd write:

PHP Code:

  <?php
if ($_GET['p'] == 'submitted') {
    $adminUserName = mysql_real_escape_string(stripslashes($_POST['adminuser']));
    $adminPassword = mysql_real_escape_string(stripslashes($_POST['adminpass']));
    $query = "INSERT INTO `mycms` set adminuser='$adminUserName', adminpass='$adminPassword'"; 
    if (mysql_query($query)) {
        //Insert successful
    } else {
        //Insert failed.
        echo "Unable to add admin.  MySQL reported &quot;".mysql_error()."&quot;<br />";
    }
}
?>

Please note that everything I changed was for a specific reason.  Let me know if you have any specific questions.

The Following User Says Thank You to TeraTask For This Useful Post:
HelloWorld (08-06-2007)