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'];
- }
- $result = mysqli_query($mysqli, 'SELECT ...');
- // mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given
- while( $row=mysqli_fetch_array($result) ) {
- ...
- $result = $mysqli->query($mysqli, 'SELECT ...');
- // Call to a member function fetch_assoc() on a non-object
- while( $row=$result->fetch_assoc($result) ) {
- ...
- $result = $pdo->query('SELECT ...', PDO::FETCH_ASSOC);
- // Invalid argument supplied for foreach()
- foreach( $result as $row ) {
- ...
- $stmt = $mysqli->prepare('SELECT ...');
- // Call to a member function bind_param() on a non-object
- $stmt->bind_param(...);
- $stmt = $pdo->prepare('SELECT ...');
- // Call to a member function bindParam() on a non-object
- $stmt->bindParam(...);
- $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'];
- }
- $username = mysqli_real_escape_string($mysqli, $_POST['username']);
- $result = mysqli_query($mysqli, "SELECT * FROM Users WHERE UserName LIKE '$username'");
- // mysqli_query returns false if something went wrong with the query
- if($result === FALSE) {
- yourErrorHandler(mysqli_error($mysqli));
- }
- else {
- // as of php 5.4 mysqli_result implements Traversable, so you can use it with foreach
- foreach( $result as $row ) {
- ...
- $username = $mysqli->escape_string($_POST['username']);
- $result = $mysqli->query("SELECT * FROM Users WHERE UserName LIKE '$username'");
- if($result === FALSE) {
- yourErrorHandler($mysqli->error); // or $mysqli->error_list
- }
- else {
- // as of php 5.4 mysqli_result implements Traversable, so you can use it with foreach
- foreach( $result as $row ) {
- ...
- $stmt = $mysqli->prepare('SELECT * FROM Users WHERE UserName LIKE ?');
- if ( !$stmt ) {
- yourErrorHandler($mysqli->error); // or $mysqli->error_list
- }
- else if ( !$stmt->bind_param('s', $_POST['username']) ) {
- yourErrorHandler($stmt->error); // or $stmt->error_list
- }
- else if ( !$stmt->execute() ) {
- yourErrorHandler($stmt->error); // or $stmt->error_list
- }
- else {
- $result = $stmt->get_result();
- // as of php 5.4 mysqli_result implements Traversable, so you can use it with foreach
- foreach( $result as $row ) {
- ...
- 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');
- $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'];
- }
- }
- $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'];
- }
- $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'];
- $sql = "SELECT * from Users WHERE UserName LIKE '$username'";
- $result = mysql_query($sql,$con);
- while($row = mysql_fetch_array($result))
- {
- echo $row['FirstName'];
- }
- $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."'");
- $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 = mysqli_query('SELECT * FROM Users WHERE UserName LIKE $username');
- if($result){
- while($row = mysqli_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;
- }
- <?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'];
- }
- ?>
- error_reporting(E_ALL);
- ini_set('display_errors', 1);
- $sql = "SELECT `foo` FROM `weird_words` WHERE `definition` = ?";
- $query = $mysqli->prepare($sql)); // assuming $mysqli is the connection
- $query->bind_param('s', $definition);
- $query->execute();
- $sql = "SELECT `foo` FROM `weird_words` WHERE `definition` = ?";
- if($query = $mysqli->prepare($sql)) { // assuming $mysqli is the connection
- $query->bind_param('s', $definition);
- $query->execute();
- // any additional code you need would go here.
- } else {
- $error = $mysqli->errno . ' ' . $mysqli->error;
- echo $error; // 1054 Unknown column 'foo' in 'field list'
- }
- $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%'");
- $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'];
- }
- }
Add Comment
Please, Sign In to add comment