Re: Table help needed

On Sat, Oct 20, 2012 at 2:52 PM, admin <admin@buskirkgraphics.com> wrote: > I want to apologize for the comments that followed my reply, seems some people can't make > constructive comments > if their life depended on it. So happy you've taken it upon yourself to right all the wrongs in the world. Perhaps you can start by weeding your own garden. > While the more complex version in PDO is the preferred method to obtain objects > from mysql. This does require you to have the basic fundamentals of object oriented programming > skills, > which I am guessing at this point you do not have based on how the question was phrased. Not really. Writing classes would definitely require OOP skills. Using classes is quite another thing, and so much easier to get up on. The documentation is full of examples on how to do this. Reflexively, none of the lines containing PDO is any more complicated than making procedure calls. Compare mysqli procedural and object code, and PDO code: procedural: $db = mysqli_connect($host,$user,$pass,$dbname); object: $db = new mysql($host,$user,$pass,$dbname); PDO: $db = new PDO("mysql:host=$host,dbname=$dbname",$user,$pass); procedural: $result = mysqli_query($db,$sql); object: $result = $db->query($sql); PDO: $result = $db->query($sql); procedural: $row = mysqli_fetch_row($result); object: $row = $result->fetch_row(); PDO: $row = $result->fetch(); Or putting the result processing in a loop: procedural: while ($row = mysqli_fetch_row($result)) { /* process row */ } object: while ($row = $db->fetch_row($result)) { /* process row */ } PDO: foreach ($result as $row) { /* process row */ } Putting it linearly: Procedural: $db = mysqli_connect($host,$user,$pass,$dbname); $result = mysqli_query($db,$sql); while ($row = mysqli_fetch_row($result)) { /* process row */ } Object: $db = new mysqli($host,$user,$pass,$dbname); $result = $db->query($sql); while ($row = $result->fetch_row()) { /* process row */ } PDO: $db = new PDO("mysql:host=$host;dbname=$dbname",$user,$pass); foreach (($db->query($sql)) as $row) { /* process row */ } *Really* not getting how PDO is more complicated. > There are many people in the list who will gladly point you in the direction to learning aids > and tutorials to get you started. Apparently you aren't one of them. * Link I posted a few days ago: http://www.phptherightway.com/ * http://devzone.zend.com/6/php-101-php-for-the-absolute-beginner/ ** In particular: this page does *exactly* what the OP asked for: 3 column table of data: http://devzone.zend.com/6/php-101-php-for-the-absolute-beginner/ (done in the old mysql style) * if watching videos is more one's style: http://phpacademy.org/tutorials.php * if y'all like the about.com sites (I don't): http://php.about.com/ *IF*, however, the OP's stuckness is the result of not understanding HTML <table> markup, then I have a whole different set of links: * http://html.net/tutorials/html/lesson10.php - on making tables * http://w3schools.com/html/html_tables.asp - the w3schools.com site has tutorials on all kinds of webish stuff Also, in general, http://www.webmonkey.com/ has provided many beginners with a leg up on many different aspects of web development.