note 114853 added to function.phpinfo
| From: | goengoen at live dot nl | Date: | Mon, 14 Apr 2014 20:40:26 +0000 |
| Subject: | note 114853 added to function.phpinfo | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-199269@lists.php.net to get a copy of this message | ||
<?php
// Connectie maken met database
$connection = mysql_connect('localhost', 'root', '');
if (!$connection){
die("Database Connection Failed" . mysql_error());
}
$select_db = mysql_select_db('test');
if (!$select_db){
die("Database Selection Failed" . mysql_error());
}
?>
--------------login and cookie------------------------------
<?
// Controleren op sessie
if(isset($_SESSION['userID'])) {
echo "U mag op deze pagina komen";
}else{
echo " U mag niet op deze pagina komen" ;
}
?>
<?php
// Uitvoeren als het een post submission krijgt
if(isset($_POST['submit'])) {
// Variabelen ophalen en beveiligen via mysql real escape string
$email = mysql_real_escape_string($_POST['email']);
$wachtwoord = sha1(mysql_real_escape_string($_POST['wachtwoord']));
// Waardes uit database ophalen
$result = mysql_query('SELECT userID, email FROM gebruikers WHERE gebruikers.email =
'.$email.' AND gebruikers.wachtwoord=.'$wachtwoord) or die('Database connectie
is gefaalt');
// Sessie aanmaken voor de user
if(mysql_num_rows($sesult) > 0) {
$row = mysql_fetch_array($result);
$_SESSION['userID'] = $row['userID'];
}
}
?>
<form action="login.php" method="post">
<input type = "text" name="email"/>
<input type = "password" name = "wachtwoord"/>
<input type = "submit" name = "submit" value ="inloggen"/>
</form>
---------------------registration--------------------------------
<?php
// Connectie maken met database
require('connect.php');
// Form informatie ophalen
if (isset($_POST['email']) && isset($_POST['wachtwoord'])){
// Variabelen aanmaken met form informatie
$email = $_POST['email'];
$wachtwoord = $_POST['wachtwoord'];
// Variabelen in database zetten
$query = "INSERT INTO
gebruikers (email, wachtwoord) VALUES
('$email', '$wachtwoord')";
$result = mysql_query($query);
// Als de mysql query ingevoerd is bericht geven
if($result){
$msg = "Registratie gelukt!";
}else{
$msg = "Registratie niet gelukt" ;
}
// Bericht weergeven
echo $msg;
}
?>
----
Server IP: 83.137.20.135
Probable Submitter: 86.95.63.129
----
Manual Page -- http://php.net/manual/en/function.phpinfo.php
Edit -- https://master.php.net/note/edit/114853
Del: integrated -- https://master.php.net/note/delete/114853/integrated
Del: useless -- https://master.php.net/note/delete/114853/useless
Del: bad code -- https://master.php.net/note/delete/114853/bad+code
Del: spam -- https://master.php.net/note/delete/114853/spam
Del: non-english -- https://master.php.net/note/delete/114853/non-english
Del: in docs -- https://master.php.net/note/delete/114853/in+docs
Del: other reasons-- https://master.php.net/note/delete/114853
Reject -- https://master.php.net/note/reject/114853
Search -- https://master.php.net/manage/user-notes.php