Single Result from Database by using mySQLi

Question

I am trying to use mySQLi for the first time  I have done it in case of loop  Loop results are showing but i am stuck when i try to show single record  Here is loop code that is working    lt  php    Connect To DB  hostname  localhost    database  mydbname    username  root    password        conn   mysqli connect  hostname   username   password          or die  Could not connect to server     mysql error          mysqli select db  conn   database          or die  Error  Could not connect to the database      mysql error            Check for Connection       if mysqli connect errno                Display Error message if fails         echo  Error  could not connect to the database please try again again        exit            gt    lt  php  query    SELECT ssfullname  ssemail FROM userss ORDER BY ssid    result   mysqli query  conn   query     num results   mysqli num rows  result     gt    lt  php   Loop through each row and display records    for  i 0   i lt  num results   i       row   mysqli fetch assoc  result     gt    lt  php    echo  Name    row  ssfullname      email     row  ssemail       n     gt   Name   lt  php print  row  ssfullname      gt   lt br   gt  Email   lt  php print  row  ssemail      gt   lt br   gt  lt br   gt    lt  php     end loop      gt    Above code is fine in case of loop  Now how do i show single record  any record  name or email  from first row or whatever  just single record  how would i do that   In single record case  consider all above loop part removed and lets show any single record without loop

User · Answer

Use  mysqli fetch row    Try this    query    SELECT ssfullname  ssemail FROM userss WHERE user id      user id   result   mysqli query  conn   query    row     mysqli fetch row  result     ssfullname    row  ssfullname     ssemail       row  ssemail

User · Answer

If you assume just one result you could do this as in Edwin suggested by using specific users id    someUserId    abc123     stmt    mysqli- gt prepare  SELECT ssfullname  ssemail FROM userss WHERE user id         stmt- gt bind param  s    someUserId     stmt- gt execute      stmt- gt bind result  ssfullname   ssemail    stmt- gt store result     stmt- gt fetch     ChromePhp  log  ssfullname   ssemail     log result in chrome if ChromePhp is used    OR as  Your Common Sense  which selects just one user    stmt    mysqli- gt prepare  SELECT ssfullname  ssemail FROM userss ORDER BY ssid LIMIT 1      stmt- gt execute     stmt- gt bind result  ssfullname   ssemail    stmt- gt store result     stmt- gt fetch      Nothing really different from the above except for PHP v 5

User · Answer

When just a single result is needed  then no loop should be used  Just fetch the row right away   In case you need to fetch the entire row into associative array     row    result- gt fetch assoc      in case you need just a single value    row    result- gt fetch row       value    row 0     false     The last example will return the first column from the first returned row  or false if no row was returned  It can be also shortened to a single line   value    result- gt fetch row   0     false   Below are complete examples for different use cases Variables to be used in the query When variables are to be used in the query  then a prepared statement must be used  For example  given we have a variable  id   query    quot SELECT ssfullname  ssemail FROM userss WHERE ud   quot    stmt    conn- gt prepare  query    stmt- gt bind param  quot s quot    id    stmt- gt execute    result    stmt- gt get result     row    result- gt fetch assoc        in case you need just a single value  query    quot SELECT count    FROM userss WHERE id   quot    stmt    conn- gt prepare  query    stmt- gt bind param  quot s quot    id    stmt- gt execute    result    stmt- gt get result     value    result- gt fetch row   0     false   The detailed explanation of the above process can be found in my article  As to why you must follow it is explained in this famous question No variables in the query In your case  where no variables to be used in the query  you can use the query   method   query    quot SELECT ssfullname  ssemail FROM userss ORDER BY ssid quot    result    conn- gt query  query      in case you need an array  row    result- gt fetch assoc       OR in case you need just a single value  value    result- gt fetch row   0     false   By the way  although using raw API while learning is okay  consider using some database abstraction library or at least a helper function in the future     using a helper function  sql    quot SELECT email FROM users WHERE id   quot    value   prepared select  conn   sql    id  - gt fetch row 0     false      using a database helper class  email    db- gt getCol  quot SELECT email FROM users WHERE id   quot     id     As you can see  although a helper function can reduce the amount of code  a class  method could encapsulate all the repetitive code inside  making you to write only meaningful parts - the query  the input parameters and the desired result format  in the form of the method s name

[php] Single Result from Database by using mySQLi

Examples related to php

Examples related to loops

Examples related to mysqli