是否可以在$ stmt-> prepare（$ query）的查询中使用*？

Question

I know this might be a noob question. I am still a newbie in php specially in using mysqli.

is it possible to use * in query for $stmt->prepare() and using bind_result()? for example i have to select 50 columns in 1 table with conditions as parameter cause if I type all 50 columns it will take time. so in this scenario how can I get the result?

$stmt->prepare("Select * from table where col1 = ? and col2=? and col3=? and col4=?")
$stmt->bind_param("ssss",$col1, $col2, $col3, $col4)
$stmt->execute()

Thanks. I appreciate your help.

Answer 1

Yes, of course.
Just use $res = $stmt->get_result() followed by familiar $row = $res->fetch_assoc() stuff

However, for a newbie, you are indeed strictly advised to choose PDO over mysqli.