Hmmmmmmmmmmmmmmmmm

Hmmmmmmmmmmmmmmmmm
Now I think the site has crashed, it wont load.
PHP Code:[LEFT]<?[/LEFT]
[LEFT]$name = $_GET['name'];[/LEFT]
[LEFT]echo "Hi, your name is $name";[/LEFT]
[LEFT]?>[/LEFT]
[LEFT][/LEFT]
I normally do something like this when inserting values using SQL:
Feel free to use it if you give me credit ^_^PHP Code:function PrepareSQLIn($val, $type, $defval = "", $notdefval = "")
{
$val = (!get_magic_quotes_gpc()) ? addslashes($val) : $val;
switch ($type) {
case "text":
$val = ($val != "") ? "'" . $val . "'" : "NULL";
break;
case "long":
case "int":
$val = ($val != "") ? intval($val) : "NULL";
break;
case "double":
$val = ($val != "") ? "'" . doubleval($val) . "'" : "NULL";
break;
case "date":
$val = ($val != "") ? "'" . $val . "'" : "NULL";
break;
case "def":
$val = ($val != "") ? $defval : $notdefval;
break;
}
return $val;
}
//Make the SQL query
$SQLQuery = sprintf("UPDATE something SET `value`=%s WHERE somethingelse=%s",
PrepareSQLIn($var1, "inserttypehere"),
PrepareSQLIn($var2, "inserttypehere"));
Last edited by Tomm; 09-08-2006 at 10:15 AM.
Tom i dont use a MySQL Database
Want to hide these adverts? Register an account for free!