Search found 2 matches

by PeteClimbs
Sun Aug 23, 2009 10:45 am
Forum: PHP - Code
Topic: Fetching an object using mysqli prepared statements
Replies: 0
Views: 158

Fetching an object using mysqli prepared statements

With the usual MySqli I can do: $the_year=$_GET['y']; $rslt=$db->query("SELECT * FROM cars where year=$the_year"); while($oAuto=$rslt->fetch_object('MyCarClass')) { doSomething($oAuto); } But, I would like to do something like this (parts omitted): $stmt->prepare('SELECT * FROM cars WHERE ...
by PeteClimbs
Sun Aug 23, 2009 10:12 am
Forum: PHP - Code
Topic: How do I hide a resultset column from being displayed?
Replies: 2
Views: 100

Re: How do I hide a resultset column from being displayed?

I'm a little puzzled as the answer, assuming I understand your question correctly, is rather simple, i.e., something like:   <?php $key=$_GET['key']; // or whatever $dbconn=new mysqli('host','usreid','passwd','db_name') or die(' Connect Error!'); $result=$dbconn->query("SELECT a,b,c FROM locks ...