note 112459 added to function.mysql-query
| From: | pepik at gmail dot cz | Date: | Wed, 19 Jun 2013 11:44:11 +0000 |
| Subject: | note 112459 added to function.mysql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-195276@lists.php.net to get a copy of this message | ||
<?php
echo '<meta http-equiv="Content-language" content="cs" />
<meta http-equiv="content-type" content="text/html"
charset="utf-8" /> ';
if(isset($_POST['go'])){ //jestli tlaÄÃtko bylo zmaÄknuté tak jdi dál,
jinak budete pÅesmÄrovánà na stránku pro registraci nového uživatele
if(isset($_POST['name']))
{
$name = ($_POST['name']);
if($name == '')
{
unset($name);
}
}
if(isset($_POST['login']))
{
$login = stripslashes(htmlspecialchars(trim($_POST['login'])));
if($login == '')
{
unset($login);
}
}
if(isset($_POST['heslo']))
{
$heslo = stripslashes(htmlspecialchars(trim($_POST['heslo'])));
if($heslo == '')
{
unset($heslo);
}
}
if(empty($name) or empty($login) or empty($heslo))
{
exit("VyplÅte vÅ¡echna pole");
}
require_once 'db.php';
$kom = new server(); // inicializace
//OvÄÅujeme, zda jÞ nenà uživatel se stejným loginem
$q1 = $kom->query("SELECT * FROM
Registrace_Sadek WHERE
login='".$login."'"); //INSERT INTO Images_Sadek
if(!$q1) { echo mysql_error() . ' - ' . mysql_errno(); }
else {
//Jestli existuje tak vyvedeme hlášenÃ
if(mysql_num_rows($q1)==1){
exit("Uživatelské jméno je obsazené, vyberte si jiné");
} else {
//V pÅÃpadÄ, že nenà tak vložÃme data o novém uživateli do databáze
$q2 = mysql_query("INSERT INTO
Registrace_Sadek(jmeno,login,heslo)
VALUES('".$name."','".$login."','".$heslo."')");
if(!$q2) { echo mysql_error() . ' - ' . mysql_errno(); }
else {
echo "DÄkuji za registraci, teÄ se můžete <a
href=\"index.php\">pÅihlásit</a>.";
}
}
}
} else { header("Location:
".$_SERVER['SERVER_ROOT']."registrace.php"); }
?>
----
Server IP: 69.147.83.199
Probable Submitter: 88.103.148.175
----
Manual Page -- http://php.net/manual/en/function.mysql-query.php
Edit -- https://master.php.net/note/edit/112459
Del: integrated -- https://master.php.net/note/delete/112459/integrated
Del: useless -- https://master.php.net/note/delete/112459/useless
Del: bad code -- https://master.php.net/note/delete/112459/bad+code
Del: spam -- https://master.php.net/note/delete/112459/spam
Del: non-english -- https://master.php.net/note/delete/112459/non-english
Del: in docs -- https://master.php.net/note/delete/112459/in+docs
Del: other reasons-- https://master.php.net/note/delete/112459
Reject -- https://master.php.net/note/reject/112459
Search -- https://master.php.net/manage/user-notes.php