Sunday, 15 June 2014

mysqli - Select all from the db -


I have to print all the user in DB but how do I do this? I could not bind because there was no point to compulsion?

Here's my code:

  session_start (); 'Inc / connect.php' is required; $ Hey = $ mysqli- & gt; Ready ("Select * From User"); $ Ha & gt; Executed (); $ Ha & gt; Bind_result ($ all); $ Ha & gt; Bring (); $ Ha & gt; near (); Resonate per dollar;  

If there are seven columns in the table user , then < Code> Bind_result Seven variable name:

  $ hey-> Tie_Response ($ column_on, $ column_to, $ column_three, $ column_fur, $ column_fiv, $ column_cix, $ column_service);  

Of course, use variable names that reflect the nature of the data displayed.

Now all together:

  session_start (); 'Inc / connect.php' is required; $ Hey = $ mysqli- & gt; Ready ("Select * From User"); $ Ha & gt; Executed (); $ Hey- & gt; Bind_salt ($ id, $ fname, $ lname, $ email, $ phone, $ addy, $ age); While ($ hey-> fetch ()) {echo "$ id $ fname $ lname $ email $ phone $ addy $ age 
"; } $ Hey- & gt; Close ();

I like to be clear with SQL and call columns in my results:

  SELECT id, fname, lname, email, phone, Addy is added to the table in the table to protect my questions in the  

... column from the era.


No comments:

Post a Comment