Search found 2 matches
- 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 ...
- 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 ...