i write DB fetch code in function but it does not work?

Question

I write this below function for Fetch fields from DATABASE but it does not work :

function Refresh_TBL_post() {
  global $conn;
  #DB Query Comment
  $stmt = $conn->prepare("SELECT * FROM post WHERE id=? ");
  $stmt->bind_param("s", $_REQUEST['editpostId']);
  #Run Query In DB
  $stmt->execute();
  #Get Count Of Rows    
  #Refrsh $stmt
  $stmt->get_result();
  $row = $stmt->fetch_assoc();
  return $row;
}

And i call this function like this Refresh_TBL_post(); but it does not works . How can i fix it ?

Anything thrown in the error logs, checking for errors? http://php.net/manual/en/mysqli.error.php — chris85, Aug 16 '16 at 09:22
Look at this [PDO tutorial](http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers) — B001ᛦ, Aug 16 '16 at 09:24
@bub This isn't PDO. `bind_param` is `mysqli`, `bindParam` is PDO; also look at tags.. — chris85, Aug 16 '16 at 09:24
@chris85 what is _this_? Do you mean the code above or the link? — B001ᛦ, Aug 16 '16 at 09:25
As shown here: http://stackoverflow.com/questions/10466530/mysqli-prepared-statement-unable-to-get-result Have you installed the mysqlnd driver? — AltShiftZero, Aug 16 '16 at 09:29
I don't use `mysqli` often but isn't the `get_result` suppose to be assigned to a variable then fetched? Also you've checked that each of these steps process as expected? — chris85, Aug 16 '16 at 09:54

AltShiftZero · Answer 1 · 2016-08-16T13:47:17.187

0

#Refrsh $stmt
$stmt->get_result();
$row = $stmt->fetch_assoc();
return $row;

is not the same as what you did last. You should do this:

function Refresh_TBL_post() {
  global $conn;
  #DB Query Comment
  $stmt = $conn->prepare("SELECT * FROM post WHERE id=? ");
  $stmt->bind_param("s", $_REQUEST['editpostId']);
  #Run Query In DB
  $stmt->execute();
  #Get Count Of Rows    
  #Refrsh $stmt
  $res = $stmt->get_result();
  return $res->fetch_assoc();
}

Calling with:

$row = Refresh_TBL_post();

Which should work. You fetch from get_result and not from stmt in your last post.

edited Aug 16 '16 at 13:47

answered Aug 16 '16 at 10:42

AltShiftZero

385
1
16

Did you remove the fetch_assoc from the function call in `$row=Refresh_TBL_post()->fetch_assoc();` ? Because this should work... As it is technically the same as below what you said did work. Maybe you can clarify what it is that doesn't work. How do you try to use this code? Do you get any error in the log or does it show you any errors when display_errors is turned on? – AltShiftZero Aug 16 '16 at 12:14
no errors are in my code . yes when i toke out fetch_assoc from my function . it works as well .. – Mohammadali Mirhamed Aug 16 '16 at 12:39

Mohammadali Mirhamed · Accepted Answer · 2016-08-16T10:01:38.500

-1

I changed function to below :

function Refresh_TBL_post()
    {
            global $conn;
            #DB Query Comment
             $stmt = $conn->prepare("SELECT * FROM post WHERE id=? ");
             $stmt->bind_param("s",$_REQUEST['editpostId']);
            #Run Query In DB
             $stmt->execute();
            #Get Count Of Rows  
             #Refrsh $stmt
              $stmt = $stmt->get_result();
         return $stmt;
    }

and use like this

#Refresh
$stmt_Refresh_Tbl_post=Refresh_TBL_post();
$row=$stmt_Refresh_Tbl_post->fetch_assoc();

or like this

 #Refresh
    $row=Refresh_TBL_post()->fetch_assoc();

edited Aug 16 '16 at 10:01

answered Aug 16 '16 at 09:57

Mohammadali Mirhamed

324
4
20

I would put the `fetch` in the function, and just return the `row` as an array. – chris85 Aug 16 '16 at 10:00
Why not, what happens? Don't use the same variable names. – chris85 Aug 16 '16 at 10:03
@chris85 . It can't Fetch Rows – Mohammadali Mirhamed Aug 16 '16 at 10:09

i write DB fetch code in function but it does not work?

2 Answers2