mysqli_query returns number instead of varchar

Question

require 'connection.php';

if(isset($_POST['input'])){
    $input = mysqli_real_escape_string($conn ,$_POST['input']);

    $query = mysqli_query($conn,"SELECT 'Iloco' FROM ylokaknow.words WHERE English='$input'") or die(mysqli_error($conn));

print_r($query);

}

Instead of having a varchar on result I get a number

mysqli_result Object
(
    [current_field] => 0
    [field_count] => 1
    [lengths] => Array
      (
        [0]=> 5
      )

    [num_rows] => 1
    [type] => 0

)

The result should contain string or varchar. I don't know why it returns a 5 value. Please help.

`print_r(mysqli_fetch_assoc($query));` – Steve Dec 16 '15 at 13:00 — Steve, Dec 16 '15 at 13:00
now it does not return anything – Mark Klein Fermin Dec 16 '15 at 13:08 — Mark Klein Fermin, Dec 16 '15 at 13:08
@Steve it does not return anything sir. – Mark Klein Fermin Dec 16 '15 at 13:12 — Mark Klein Fermin, Dec 16 '15 at 13:12

Nana Partykar · Accepted Answer · 2015-12-16T15:27:11.413

1

Remove ' from Iloco column name.

Use this.

$query = mysqli_query($conn,"SELECT Iloco FROM ylokaknow.words WHERE English='$input'") or die(mysqli_error($conn));

On User Demand.

$query = mysqli_query($conn,"SELECT Iloco FROM words WHERE English='$input'") or die(mysqli_error($conn)); 
$row = mysqli_fetch_array($query, MYSQLI_ASSOC); 
echo $Iloco = $row['Iloco'];

edited Dec 16 '15 at 15:27

answered Dec 16 '15 at 13:19

Nana Partykar

10,556
10
48
77

same problem. can you advice a code where I can fetch single data from database and convert it to string? so I can display it in my web. – Mark Klein Fermin Dec 16 '15 at 13:23
First of all, `words` in your table name. Ok. ? Why don't u use like this `SELECT Iloco FROM words WHERE English='$input'` and check @MarkKleinFermin – Nana Partykar Dec 16 '15 at 13:24
And, you are pretty sure about column name. Means, column name are case sensitive. Are you using the same column name as in table.? Just asking @MarkKleinFermin – Nana Partykar Dec 16 '15 at 13:26
1

`echo "SELECT Iloco FROM words WHERE English='$input'";` and paste the result in your sql of php my admin. And, see what error coming @MarkKleinFermin – Nana Partykar Dec 16 '15 at 14:20
no error it returns the correct varchar. how can i post the screen shot here? – Mark Klein Fermin Dec 16 '15 at 14:48
edit in your question with screen shot @MarkKleinFermin – Nana Partykar Dec 16 '15 at 14:50
Glad you found. By the way what was the problem @MarkKleinFermin ? – Nana Partykar Dec 16 '15 at 14:59
your solution SELECT Iloco FROM words WHERE English='$input' is correct. and I put this code $queValue = mysqli_fetch_object($querry); and print it it returns my varchar. but my problem is how will I convert this into string – Mark Klein Fermin Dec 16 '15 at 15:01
Happy. :) Varchar is string. @MarkKleinFermin Enjoy Coding. – Nana Partykar Dec 16 '15 at 15:03
I mean it returns the varchar. with in object. – Mark Klein Fermin Dec 16 '15 at 15:06
1

`$query = mysqli_query($conn,"SELECT Iloco FROM words WHERE English='$input'") or die(mysqli_error($conn)); $row = mysqli_fetch_array($query, MYSQLI_ASSOC); echo $Iloco = $row['Iloco'];` Do Like this @MarkKleinFermin – Nana Partykar Dec 16 '15 at 15:15
Always Welcome @MarkKleinFermin. Feel Free To Ask In SO. Regards From India. – Nana Partykar Dec 16 '15 at 15:27

mysqli_query returns number instead of varchar

1 Answers1