Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $username = $_POST['username'];
- $password = $_POST['password'];
- $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');
- while($row = mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- $username = mysql_real_escape_string($_POST['username']);
- $password = $_POST['password'];
- $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '$username'");
- if($result === FALSE) {
- die(mysql_error()); // TODO: better error handling
- }
- while($row = mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- mysql_connect($host, $username, $password) or die("cannot connect");
- mysql_select_db($db_name) or die("cannot select DB");
- $sql = "SELECT * FROM table_name";
- $result = mysql_query($sql);
- if (false === $result) {
- echo mysql_error();
- }
- mysql_query("
- SELECT * FROM Users
- WHERE UserName
- LIKE '".mysql_real_escape_string ($username)."'
- ");
- $username = $_POST['username'];
- $password = $_POST['password'];
- $result = mysql_query("
- SELECT * FROM Users
- WHERE UserName LIKE '".mysql_real_escape_string($username)."'
- ");
- if($result)
- {
- while($row = mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- } else {
- echo 'Invalid query: ' . mysql_error() . "n";
- echo 'Whole query: ' . $query;
- }
- $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '$username'");
- mysql_select_db('database name ')or DIE('Database name is not available!');
- $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');
- f($result === FALSE) {
- die(mysql_error());
- $username = $_POST['username'];
- $password = $_POST['password'];
- $query = "SELECT * FROM Users WHERE UserName LIKE '$username'";
- echo $query;
- $result = mysql_query($query);
- if($result === FALSE) {
- die(mysql_error("error message for the user"));
- }
- while($row = mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '%$username%'");
- while($row = mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- $username = $_POST['username'];
- $password = $_POST['password'];
- $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '%$username%'") or die(mysql_error());
- while($row = mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');
- $username = $_POST['username'];
- $password = $_POST['password'];
- $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');
- if( $result === FALSE ) {
- trigger_error('Query failed returning error: '. mysql_error(),E_USER_ERROR);
- } else {
- while( $row = mysql_fetch_array($result) ) {
- echo $row['username'];
- }
- }
- $query = "SELECT Name,Mobile,Website,Rating FROM grand_table order by 4";
- while( $data = mysql_fetch_array($query))
- {
- echo("<tr><td>$data[0]</td><td>$data[1]</td><td>$data[2]</td><td>$data[3]</td></tr>");
- }
- $username = $_POST['username'];
- $password = $_POST['password'];
- $result = mysql_query("SELECT * FROM Users WHERE UserName ='$username'");
- while($row = mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- <?php
- $username = $_POST['username'];
- $password = $_POST['password'];
- $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '".$username."'");
- while($row = mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- ?>
- mysql_query("SELECT * FROM Users WHERE UserName ='".$username."'");
- $username = $_POST['username'];
- $password = $_POST['password'];
- $sql = "SELECT * from Users WHERE UserName LIKE '$username'";
- $result = mysql_query($sql,$con);
- while($row = mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- $results = mysql_query($connt, "SELECT * FROM users");
- <?php
- $servername = "localhost";
- $username = "username";
- $password = "password";
- $dbname = "myDB";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "SELECT id, firstname, lastname FROM MyGuests";
- $result = $conn->query($sql);
- if ($result->num_rows > 0) {
- // output data of each row
- while($row = $result->fetch_assoc()) {
- // code here
- }
- } else {
- echo "0 results";
- }
- $conn->close();
- ?>
- $username = $_POST['username'];
- $password = $_POST['password'];
- $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');
- if(!$result)
- {
- echo "error executing query: "+mysql_error();
- }else{
- while($row = mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- }
- if (isset($_GET['q1mrks']) && isset($_GET['marks']) && isset($_GET['qt1'])) {
- $Q1mrks = $_GET['q1mrks'];
- $marks = $_GET['marks'];
- $qt1 = $_GET['qt1'];
- $qtype_qry = mysql_query("
- SELECT *
- FROM s_questiontypes
- WHERE quetype_id = '$qt1'
- ");
- $row = mysql_fetch_assoc($qtype_qry);
- $qcode = $row['quetype_code'];
- $sq_qry = "
- SELECT *
- FROM s_question
- WHERE quetype_code = '$qcode'
- ORDER BY RAND() LIMIT $Q1mrks
- ";
- $sq_qry = mysql_query("
- SELECT *
- FROM s_question
- WHERE quetype_code = '$qcode'
- LIMIT $Q1mrks
- ");
- while ($qrow = mysql_fetch_array($sq_qry)) {
- $qm = $qrow['marks'] . "<br />";
- $total += $qm . "<br />";
- }
- echo $total . "/" . $marks;
- }
- include_once(db_connetc.php');
- // Create a connection
- $connection = mysql_connect("localhost", "root", "") or die(mysql_error());
- //Select database
- mysql_select_db("db_name", $connection) or die(mysql_error());
- $employee_query = "SELECT * FROM employee WHERE `id` ='".$_POST['id']."';
- $employee_data = mysql_query($employee_query);
- if (mysql_num_rows($employee_data) > 0) {
- while ($row = mysql_fetch_array($employee_data)){
- echo $row['emp_name'];
- } // end of while loop
- } // end of if
- $username = $_POST['uname'];
- $password = $_POST['pass'];
- $result = mysql_query('SELECT * FROM userData WHERE UserName LIKE $username');
- if(!empty($result)){
- while($row = mysql_fetch_array($result)){
- echo $row['FirstName'];
- }
- }
- <?php
- $username = $_POST['username'];
- $password = $_POST['password'];
- $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '".mysql_real_escape_string($username)."'")or die(mysql_error());
- while($row=mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- ?>
- $username = $_POST['username'];
- $password = $_POST['password'];
- $result = mysql_query("SELECT * FROM Users WHERE UserName =`$usernam`");
- $result = mysql_query("SELECT * FROM Users WHERE UserName LIKE '%$username%'");
- if (isset($_GET['q1mrks']) && isset($_GET['marks']) && isset($_GET['qt1'])) {
- $Q1mrks = $_GET['q1mrks'];
- $marks = $_GET['marks'];
- $qt1 = $_GET['qt1'];
- $qtype_qry = mysql_query("
- SELECT *
- FROM s_questiontypes
- WHERE quetype_id = '$qt1'
- ");
- $row = mysql_fetch_assoc($qtype_qry);
- $qcode = $row['quetype_code'];
- $sq_qry = "
- SELECT *
- FROM s_question
- WHERE quetype_code = '$qcode'
- ORDER BY RAND() LIMIT $Q1mrks
- ";
- $sq_qry = mysql_query("
- SELECT *
- FROM s_question
- WHERE quetype_code = '$qcode'
- LIMIT $Q1mrks
- ");
- while ($qrow = mysql_fetch_array($sq_qry)) {
- $qm = $qrow['marks'] . "<br />";
- $total += $qm . "<br />";
- }
- echo $total . "/" . $marks;
- }
- $username = $_POST['username'];
- $password = $_POST['password'];
- $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE $username');
- if($result){
- while($row = mysqli_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- }
- $username = $_POST['username'];
- $password = $_POST['password'];
- $result = mysql_query('SELECT * FROM Users WHERE UserName LIKE {$username}');
- while($row = mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
Add Comment
Please, Sign In to add comment