PHP PDO returning single row

Question

UPDATE 2   So is this the most optimized it can get    DBH   new PDO   connection string goes here       STH    DBH - gt  prepare   select figure from table1       STH - gt  execute      result    STH - gt  fetch     echo  result   figure      DBH   null    UPDATE 1   I know I can add limit to the sql query  but I also want to get rid of the foreach loop  which I should not need   ORIGINAL QUESTION   I have the following script which is good IMO for returning many rows from the database because of the  foreach  section   How do I optimize this  if I know I will always only get 1 row from the database   If I know I will only ever get 1 row from the database  I don t see why I need the foreach loop  but I don t know how to change the code    DBH   new PDO   connection string goes here       STH    DBH - gt  prepare   select figure from table1       STH - gt  execute      result    STH - gt  fetchAll     foreach   result as  row         echo  row  figure        DBH   null

User · Answer

You could try this for a database SELECT query based on user input using PDO    param     GET  username      query  dbh- gt prepare  SELECT secret FROM users WHERE username  param     query- gt bindParam   param    param    query- gt execute      result    query - gt  fetch     print r  result

User · Answer

DBH   new PDO   connection string goes here      STH -  DBH - gt  prepare   select figure from table1 ORDER BY x LIMIT 1       STH - gt  execute     result    STH - gt  fetch    echo  result   figure      DBH   null    You can use fetch and LIMIT together  LIMIT has the effect that the database returns only one entry so PHP has to handle very less data  With fetch you get the first  and only  result entry from the database reponse   You can do more optimizing by setting the fetching type  see http   www php net manual de pdostatement fetch php  If you access it only via column names you need to numbered array   Be aware of the ORDER clause  Use ORDER or WHERE to get the needed row  Otherwise you will get the first row in the table alle the time

User · Answer

how about using limit 0 1 for mysql optimisation   and about your code    DBH   new PDO   connection string goes here       STH -  DBH - gt  prepare   select figure from table1       STH - gt  execute      result    STH - gt fetch PDO  FETCH ASSOC   echo  result  figure      DBH   null

User · Answer

Did you try    DBH   new PDO   connection string goes here      row    DBH- gt query   select figure from table1   - gt fetch    echo  row  figure     DBH   null

User · Answer

Just fetch  only gets one row  So no foreach loop needed  D   row     STH - gt  fetch      example  ty northkildonan     dbh   new PDO   --- connection string ---       stmt    dbh- gt prepare  SELECT name FROM mytable WHERE id 4 LIMIT 1      stmt- gt execute      row    stmt- gt fetch

User · Answer

If you want just a single field  you could use fetchColumn instead of fetch - http   www php net manual en pdostatement fetchcolumn php

User · Answer

Thanks to Steven s suggestion to use fetchColumn  here s my recommendation to cut short one line from your code    DBH   new PDO   connection string goes here      STH    DBH- gt query   select figure from table1      result    STH- gt fetchColumn    echo  result   DBH   null

[php] PHP PDO returning single row

Examples related to php

Examples related to pdo