php function for sql query doesn't work - 500 error

Asked Jan 28 '17 at 18:11

Active Jan 28 '17 at 18:14

Viewed 23 times

my code doesn't works ... it returns only a 500 error :(

function getfromdb($select, $tablenme, $wherewhat, $whereval) { 

  $msntps = $conn->query("SELECT $select FROM $tablenme WHERE $wherewhat = '$whereval'")->fetch_object()->$selectval; 
  return $msntps;
}

and then i would like get something with

echo getfromdb("email", "users", "username", "testusername");

edited Jan 28 '17 at 18:14

asked Jan 28 '17 at 18:11

John x3

1

you have to pass `$conn` also as a parameter – Alive to die - Anant Jan 28 '17 at 18:12
how :o __________ – John x3 Jan 28 '17 at 18:16
you need to search PDO tutorials for accessing data from db. you will get some good and easy to understand example – Alive to die - Anant Jan 28 '17 at 18:16
but `echo $conn->query("SELECT something FROM testtable WHERE username = 'testuser'")->fetch_object()->something;` still works .. – John x3 Jan 28 '17 at 18:19
and btw i use mysqli `$conn = new mysqli($servername, $username, $password, $dbname);` – John x3 Jan 28 '17 at 18:21
`function getfromdb($select, $tablenme, $wherewhat, $whereval,$conn) { ` – Alive to die - Anant Jan 28 '17 at 18:23

php function for sql query doesn't work - 500 error

0 Answers0