Receive data from mySQL via php

Question

Can anyone please explain why I am getting no result from my below script:
When I run the query in phpmyadmin it returns the correct result (the id), but running my below php script it echo´s out "No row found!";

<?php
if(isset($_SESSION['word'])) {
  $word = $_SESSION['word']."<br>";
    echo $word;
    $query = ("SELECT id FROM customer WHERE mobil = $word");
    if (!$query) {
    die('Invalid query: ' . mysql_error());
    }
    else {  
            $results = mysql_query($query);
            while ($row = mysql_fetch_assoc($results)) {
            echo '<pre>', print_r($row), '<pre>';
        }
            if (!$row) {
                echo "No row found!";
            }
        }
}
?>

your query is not valid use $query = mysql_query("SELECT id FROM customer WHERE mobil = '".$word."'"); — Ricky, Nov 10 '14 at 09:23
Use single quotes around the $word variable. I would suggest using PDO rather than the mysql_* functions. — Syed Hussim, Nov 10 '14 at 09:25
no no, of ccourse it is a string, but in query, all string set as value must be surround by quote — Ōkami X Oukarin, Nov 10 '14 at 09:32
I'm longing for the day when an RDBMS vendor dares take the step that non parameterized queries are syntax errors... :) — Joachim Isaksson, Nov 10 '14 at 09:39

score 2 · Answer 1 · edited May 23 '17 at 12:14

2

Your query is invalid, it should be like this:

$query = mysql_query("YOUR QUERY");

Also, you shouldn't use Mysql_ since this is deprecated and soon will be removed. Use PDO or MySQLI instead. You can find more info here:

Why shouldn't I use mysql_* functions in PHP?

edited May 23 '17 at 12:14

Community

1
1

answered Nov 10 '14 at 09:25

Matheno

4,112
6
36
53

score 0 · Answer 2 · answered Nov 10 '14 at 09:26

try this

    $results = mysqli_query($query);
     if(mysqli_num_rows($results)>0){
        while ($row = mysqli_fetch_assoc($results)) {
        echo '<pre>', print_r($row), '<pre>';
    }
     else{
            echo "No row found!";
        }
    }

score 0 · Answer 3 · answered Nov 10 '14 at 09:37

0

try this:

$query = ('SELECT id FROM `customer` WHERE mobil = "$word" ');

answered Nov 10 '14 at 09:37

Ōkami X Oukarin

435
5
16

score 0 · Answer 4 · answered Nov 10 '14 at 09:43

It should be,

<?php
require_once("db_connect.php");
  if(isset($_SESSION['word'])) {
     $word = $_SESSION['word']."<br>"; //Getting word here       
     $query = "SELECT id FROM customer WHERE mobil = $word";
     $result = mysqli_query($db,$query); //$db holds the database connection
     if (!$result) 
       {
         die('Invalid query: ' . mysqli_error($db));
      }
     else
    {
     $result_rows = mysqli_num_rows($result); //Getting the no. of rows
     if($result_rows!=0)                      // If any record present,the below code executes
     {
       while ($row = mysqli_fetch_assoc($result)) 
       {
            echo '<pre>', print_r($row), '<pre>';
        }
     }
     else
     {
       echo "No rows found";                 // If no record found,this prints.
     }
   }
 }
 ?>

Database connection (db_connect.php) :

$db = mysqli_connect("localhost","username","password","database_name");

Note : Mysql is depreciated. You should use either Mysqli or PDO.

score 0 · Answer 5 · answered Nov 10 '14 at 09:50

0

Your query is wrong.

Change this:

$query = ("SELECT id FROM customer WHERE mobil = $word");

To:

$query = ("SELECT id FROM customer WHERE mobil = '".$word."'");

But your code has many security issues.

answered Nov 10 '14 at 09:50

score 0 · Accepted Answer · answered Feb 04 '15 at 08:46

0

UPDATE and SOLVED My above script works fine, thanks to @CodingAnt (who asked: what data type this mobil fields holds?) - I checked my database and it turns out mobil was set to VARCHAR instead of INT. Changed it to INT and now everything works.

answered Feb 04 '15 at 08:46

Nomis

437
1
4
13

Receive data from mySQL via php

6 Answers6