// Connect database $conn=mysqli_connect('localhost', 'root', '******'); if (!conn) { echo'Failed to connect to MySQL:'.mysqli_error($conn); } else { echo'Success to connect to MySQL'; } echo'<hr>'; mysqli_select_db($conn, 'security') ordie ("Unable to connect to the database: security"); mysqli_query($conn, 'set names utf-8');
// take the variables if(isset($_GET['id'])) { $id=$_GET['id']; }
// query sql
$sql="SELECT * FROM users WHERE id='$id' LIMIT 0,1"; echo'SQL query:'.$sql; echo'<hr>'; $result=mysqli_query($conn, $sql); $row=mysqli_fetch_array($result, MYSQLI_BOTH); if ($row) { echo'Your Login name:'.$row['username']; echo'<hr>'; echo'Your Password:'.$row['password']; } ?>
// Connect database $conn=mysqli_connect('localhost', 'root', '******'); if (!conn) { echo'Failed to connect to MySQL:'.mysqli_error($conn); } else { echo'Success to connect to MySQL'; } echo'<hr>'; mysqli_select_db($conn, 'security') ordie ("Unable to connect to the database: security"); mysqli_query($conn, 'set names utf-8');
// take the variables if(isset($_GET['id'])) { $id=$_GET['id']; }
// query sql
$sql="SELECT * FROM users WHERE id='$id' LIMIT 0,1"; echo'SQL query:'.$sql; echo'<hr>'; $result=mysqli_query($conn, $sql); $row=mysqli_fetch_array($result, MYSQLI_BOTH); if ($row) { echo'Your Login name:'.$row['username']; echo'<hr>'; echo'Your Password:'.$row['password']; } else { print_r(mysqli_error($conn)); } ?>
// Connect database $conn=mysqli_connect('localhost', 'root', '******'); if (!conn) { echo'Failed to connect to MySQL:'.mysqli_error($conn); } else { echo'Success to connect to MySQL'; } echo'<hr>'; mysqli_select_db($conn, 'security') ordie ("Unable to connect to the database: security"); mysqli_query($conn, 'set names utf-8');
// take the variables if(isset($_GET['id'])) { $id=$_GET['id']; }
// query sql
$sql="SELECT * FROM users WHERE id='$id' LIMIT 0,1"; echo'SQL query: '.$sql; echo'<hr>'; $result=mysqli_query($conn, $sql); $row=mysqli_fetch_array($result, MYSQLI_BOTH); if ($row) { echo'You are in.........'; echo'<br>'; } else { echo''; } ?>
// Connect database $conn=mysqli_connect('localhost', 'root', '******'); if (!conn) { echo'Failed to connect to MySQL:'.mysqli_error($conn); } else { echo'Success to connect to MySQL'; } echo'<hr>'; mysqli_select_db($conn, 'security') ordie ("Unable to connect to the database: security"); mysqli_query($conn, 'set names utf-8');
// take the variables if(isset($_GET['id'])) { $id=$_GET['id']; }
// query sql
$sql="SELECT * FROM users WHERE id='$id' LIMIT 0,1"; echo'SQL query: '.$sql; echo'<hr>'; $result=mysqli_query($conn, $sql); $row=mysqli_fetch_array($result, MYSQLI_BOTH); if ($row) { echo'You are in.........'; echo'<br>'; } else { echo'You are in.........'; echo'<br>'; } ?>
// Connect database $conn=mysqli_connect('localhost', 'root', '*****'); if (!conn) { echo'Failed to connect to MySQL:'.mysqli_error($conn); } else { echo'Success to connect to MySQL'; } echo'<hr>'; mysqli_select_db($conn, 'security') ordie ("Unable to connect to the database: security"); mysqli_query($conn, 'set names gbk');
// take the variables if(isset($_GET['id'])) { $id = addslashes($_GET['id']); }
// query sql
$sql="SELECT * FROM users WHERE id='$id' LIMIT 0,1"; echo'SQL query:'.$sql; echo'<hr>'; $result=mysqli_query($conn, $sql); $row=mysqli_fetch_array($result, MYSQLI_BOTH); if ($row) { echo'Your Login name:'.$row['username']; echo'<hr>'; echo'Your Password:'.$row['password']; } ?>