note 82074 added to function.mysql-fetch-array
| From: | jp_gt500 at hotmail dot com | Date: | Wed, 26 Mar 2008 21:42:09 +0000 |
| Subject: | note 82074 added to function.mysql-fetch-array | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-137610@lists.php.net to get a copy of this message | ||
?php
$link = mysql_connect("Localhost","webmaster","mfweb")
or die ("no se ha podido conectar");
mysql_select_db("JuanPabloDelgado")
or die("Error al tratar de selecccionar esta base");
mysql_close($link);
function quitar($mensaje)
{
$mensaje = str_replace("<","<",$mensaje);
$mensaje = str_replace(">",">",$mensaje);
$mensaje = str_replace("\'","'",$mensaje);
$mensaje = str_replace('\"',""",$mensaje);
$mensaje = str_replace("\\\\","\\",$mensaje);
return $mensaje;
}
if(trim($HTTP_POST_VARS["nick"]) != "" &&
trim($HTTP_POST_VARS["email"]) != "")
{
$sql = "SELECT id FROM usuarios WHERE
nick='".quitar($HTTP_POST_VARS["nick"])."'";
$result = mysql_query($sql);
if($row = mysql_fetch_array($result))
{
echo "Error, nick escogido por otro usuario";
}
else
{
$sql = "INSERT INTO usuarios (nick,password,nombre,email) VALUES (";
$sql .= "'".quitar($HTTP_POST_VARS["nick"])."'";
$sql .= ",'".quitar($HTTP_POST_VARS["password"])."'";
$sql .= ",'".quitar($HTTP_POST_VARS["nombre"])."'";
$sql .= ",'".quitar($HTTP_POST_VARS["email"])."'";
$sql .= ")";
mysql_query($sql);
echo "Registro exitoso!";
}
mysql_free_result($result);
}
else
{
echo "Debe llenar como minimo los campos de email y password";
}
mysql_close();
?>
----
Server IP: 130.206.1.5
Probable Submitter: 201.220.113.247
----
Manual Page -- http://www.php.net/manual/en/function.mysql-fetch-array.php
Edit -- https://master.php.net/note/edit/82074
Del: integrated -- https://master.php.net/note/delete/82074/integrated
Del: useless -- https://master.php.net/note/delete/82074/useless
Del: bad code -- https://master.php.net/note/delete/82074/bad+code
Del: spam -- https://master.php.net/note/delete/82074/spam
Del: non-english -- https://master.php.net/note/delete/82074/non-english
Del: in docs -- https://master.php.net/note/delete/82074/in+docs
Del: other reasons-- https://master.php.net/note/delete/82074
Reject -- https://master.php.net/note/reject/82074
Search -- https://master.php.net/manage/user-notes.php