mystic7 Posted October 2, 2013 Share Posted October 2, 2013 Hey, I'm just learning PHP. Used to be an ASP programmer so I'll have a lot of questions on how to do things in php that I used to do in ASP. Anyway, I am teaching myself by building a blog from an HTML template. Afterwards I'll study my code to really see what does what, proper syntax etc. On my home page there are two div's, each with different names but each containing the same information, i.e. a preview of a blog post. I have it so the two most recent posts show. The way I'm doing it is, I'm calling the top post with the following SQL statement: $sql="SELECT * FROM $tbl_name ORDER BY id DESC LIMIT 1"; I'm then displaying that post in the first div. For the second div, I'm retrieving the post previous to that with this SQL statement: $id = $rows['id']; $id2 = $id - 1; $sql="SELECT * FROM $tbl_name WHERE id = $id2"; This all works, but I'm wondering if there is a way to loop through the recordset and grab the two latest posts and then display them. The thing that's stopping me right now is the fact that the two posts are contained within two differently named divs. Or is my method acceptable as is? Quote Link to comment Share on other sites More sharing options...
cyberRobot Posted October 2, 2013 Share Posted October 2, 2013 (edited) I would suggest grabbing both of the new entries at the same time. $sql="SELECT * FROM $tbl_name ORDER BY id DESC LIMIT 2"; You could then use a loop to separate the entries to display the divs. Decrementing the $id variable may work for the most part. But what if one of the row IDs gets removed? Edited October 2, 2013 by cyberRobot Quote Link to comment Share on other sites More sharing options...
mystic7 Posted October 2, 2013 Author Share Posted October 2, 2013 Hey, thanks for responding. As I said this is just a fake blog that I'm using to get familiar with php syntax, so right now it doesn't matter if a row ID gets deleted. In fact that already happened so I just manually renumbered the recordsets in phpMyAdmin. If I may be so dense, could you explain, or point me to, directions on how to separate the entries using a loop? I know how to loop through recordsets in a database but I've never looped through recordsets after I've called for them. Again, if it's a normal looping procedure, how do I display the two recordsets inside two different divs? Quote Link to comment Share on other sites More sharing options...
mystic7 Posted October 2, 2013 Author Share Posted October 2, 2013 EDIT: OK, I used a loop, and changed my SQL statement, and it does pull the last two posts and displays them, but the second one is not formatted nicely because it's going by the CSS rules for the first div. I'm going to try and come up with a way to dynamically change the name of the div with each loop in the meantime but if you have a better solution I'd love to hear it. Quote Link to comment Share on other sites More sharing options...
Ch0cu3r Posted October 2, 2013 Share Posted October 2, 2013 (edited) You can do something like $classes = array('class1', 'class2'); // define div classes here $i = -1; // initiate counter to -1 while(/* how you fetch next record */) { $class = $classes[++$i]; // get the next class, ++$i will increment $i by 1 echo '<div class="' . $class . '">your div contents</div>'; } On the first iteration it'll set the div class to class1 and on the secoud iteration it'll set the class to class2 Edited October 2, 2013 by Ch0cu3r Quote Link to comment Share on other sites More sharing options...
mystic7 Posted October 2, 2013 Author Share Posted October 2, 2013 I did come up with a way to dynamically change the div name, and it did the trick, but the pages layout is not looking so great. Since my main point is to learn PHP I'm gonna let it go for now. Quote Link to comment Share on other sites More sharing options...
mystic7 Posted October 2, 2013 Author Share Posted October 2, 2013 You can do something like $classes = array('class1', 'class2'); // define div classes here $i = -1; // initiate counter to -1 while(/* how you fetch next record */) { $class = $classes[++$i]; // get the next class, ++$i will increment $i by 1 echo '<div class="' . $class . '">your div contents</div>'; } On the first iteration it'll set the div class to class1 and on the secoud iteration it'll set the class to class2 Yes, that's exactly what I did, if slightly less elegantly But as I said, it messes up other CSS layout rules, so I'll leave it and concentrate on the PHP portion for now. I will, however, keep your code as a better way of implementing what I did with my usual half wit solution. Thanks! Quote Link to comment Share on other sites More sharing options...
mystic7 Posted October 2, 2013 Author Share Posted October 2, 2013 Also (sorry, I'm not allowed to edit my posts yet) the div names were "post_box" and "post_box post_box_last", which I can't change using your method (it's a template I found, again, for the purpose of learning PHP, not web design). This is the code I used, which actually worked, but like I said, messed up other parts of the page layout: $count = 1; If ($count = 1) { $div = "post_box"; } Else { $div = "post_box post_box_last"; } Quote Link to comment Share on other sites More sharing options...
mystic7 Posted October 2, 2013 Author Share Posted October 2, 2013 Looking at the page source I see that it's not actually changing the name of the div. I'm going to tweak the code a bit. I'll post back if I find a solution. Quote Link to comment Share on other sites More sharing options...
mystic7 Posted October 2, 2013 Author Share Posted October 2, 2013 Can anyone tell me what's wrong with my If...Else statement? My $count is changing from 1 to 2 but the value of "div" is not changing. // Start looping rows in mysql database. $count = 1; while($rows=mysql_fetch_array($result)){ $mystring = $rows['message']; If ($count = 1) { $div = ("post_box"); } Else { $div = ("post_box post_box_last"); } ?> <div class="<? echo $div; ?>"> <img src="images/templatemo_image_01.jpg" alt="image" /> <div class="post_box_right"> <h2><? echo $rows['title']; ?></h2> <div class="post_meta"><strong>Date: </strong><strong><? echo $rows['dateday']; ?></strong> <? echo $rows['datemonth']; ?> <? echo $rows['dateyear']; ?>| <strong>Author: </strong><? echo $rows['name']; ?></div> <p><? echo substr($mystring, 0, 100); ?>...</p> <a href="blog_post.php?id=<? echo $rows['id']; ?>" class="more">Read more</a><br /> <div class="category">Category: <a href="#">Freebies</a>, <a href="#">Templates</a> | <a href="blog_post.php">244 comments</a></div> </div> <?php // close while loop $count = $count + 1; } Quote Link to comment Share on other sites More sharing options...
Ch0cu3r Posted October 2, 2013 Share Posted October 2, 2013 Your if statement is wrong If ($count = 1) that argument will always return true and thus the class never changes. To compare if $count is equal to 1. You need to use the equals to comparison operator (==). The above line should read If ($count == 1) Quote Link to comment Share on other sites More sharing options...
mystic7 Posted October 2, 2013 Author Share Posted October 2, 2013 GOT IT! I had to alter your classes code a bit but I got it working: // Retrieve data from database $sql="SELECT * FROM $tbl_name ORDER BY id DESC LIMIT 2"; $result=mysql_query($sql); // Start looping rows in mysql database. $classes = array('post_box', 'post_box post_box_last'); // define div classes here $i = -1; // initiate counter to -1 while($rows=mysql_fetch_array($result)){ $divname = $classes[++$i]; // get the next class, ++$i will increment $i by 1 $mystring = $rows['message']; ?> <div class= "<? echo $divname; ?>"><img src="images/templatemo_image_01.jpg" alt="image" /> <div class="post_box_right"> <h2><? echo $rows['title']; ?></h2> <div class="post_meta"><strong>Date: </strong><strong><? echo $rows['dateday']; ?></strong> <? echo $rows['datemonth']; ?> <? echo $rows['dateyear']; ?>| <strong>Author: </strong><? echo $rows['name']; ?></div> <p><? echo substr($mystring, 0, 100); ?>...</p> <a href="blog_post.php?id=<? echo $rows['id']; ?>" class="more">Read more</a><br /> <div class="category">Category: <a href="#">Freebies</a>, <a href="#">Templates</a> | <a href="blog_post.php">244 comments</a></div> </div> <div class="cleaner"></div> </div> <?php // close while loop } Quote Link to comment Share on other sites More sharing options...
Ch0cu3r Posted October 2, 2013 Share Posted October 2, 2013 Did you see my post above why your code wasn't working correctly Your if statement is wrong If ($count = 1) that argument will always return true and thus the class never changes. To compare if $count is equal to 1. You need to use the equals to comparison operator (==). The above line should read If ($count == 1) Quote Link to comment Share on other sites More sharing options...
mystic7 Posted October 2, 2013 Author Share Posted October 2, 2013 Your if statement is wrong If ($count = 1) that argument will always return true and thus the class never changes. To compare if $count is equal to 1. You need to use the equals to comparison operator (==). The above line should read If ($count == 1) Right, forgot about that. There's no equivilent in ASP for ==. Thanks for all your help! Quote Link to comment Share on other sites More sharing options...
mystic7 Posted October 2, 2013 Author Share Posted October 2, 2013 So are you saying my If/Then statement would have worked if I'd used the == operator? Again, sorry for all the posts but I'm not allowed to edit my previous posts. Quote Link to comment Share on other sites More sharing options...
Ch0cu3r Posted October 2, 2013 Share Posted October 2, 2013 (edited) So are you saying my If/Then statement would have worked if I'd used the == operator?yeah Edited October 2, 2013 by Ch0cu3r Quote Link to comment Share on other sites More sharing options...
cyberRobot Posted October 2, 2013 Share Posted October 2, 2013 For what it's worth, the following link shows the comparison operators in PHP: http://php.net/manual/en/language.operators.comparison.php Can this topic be marked as solved? Quote Link to comment Share on other sites More sharing options...
ignace Posted October 2, 2013 Share Posted October 2, 2013 (edited) GOT IT! I had to alter your classes code a bit but I got it working: // Retrieve data from database $sql="SELECT * FROM $tbl_name ORDER BY id DESC LIMIT 2"; $result=mysql_query($sql); // Start looping rows in mysql database. $classes = array('post_box', 'post_box post_box_last'); // define div classes here $i = -1; // initiate counter to -1 while($rows=mysql_fetch_array($result)){ $divname = $classes[++$i]; // get the next class, ++$i will increment $i by 1 $mystring = $rows['message']; ?> <div class= "<? echo $divname; ?>"><img src="images/templatemo_image_01.jpg" alt="image" /> <div class="post_box_right"> <h2><? echo $rows['title']; ?></h2> <div class="post_meta"><strong>Date: </strong><strong><? echo $rows['dateday']; ?></strong> <? echo $rows['datemonth']; ?> <? echo $rows['dateyear']; ?>| <strong>Author: </strong><? echo $rows['name']; ?></div> <p><? echo substr($mystring, 0, 100); ?>...</p> <a href="blog_post.php?id=<? echo $rows['id']; ?>" class="more">Read more</a><br /> <div class="category">Category: <a href="#">Freebies</a>, <a href="#">Templates</a> | <a href="blog_post.php">244 comments</a></div> </div> <div class="cleaner"></div> </div> <?php // close while loop } uhm.. right. A few pointers: 1) Always write <?php not just <?. The short notation may be turned off and then your code is displayed in the browser. 2) Always properly indent your code. 3) Separate HTML and PHP. <?php // PHP processing here // include the HTML include 'posts.view.php'; Inside posts.view.php you would write something like and use PHP's alternative syntax:http://php.net/manual/en/control-structures.alternative-syntax.php <?php foreach ($posts as $post): ?> <div class="post <?php alternate('class1', 'class2'); ?>"> .. $post here .. </div> <?php endforeach; // notice this tag here ?>which makes for maintainable code. Edited October 2, 2013 by ignace Quote Link to comment Share on other sites More sharing options...
Solution mystic7 Posted October 2, 2013 Author Solution Share Posted October 2, 2013 Thanks for the tips. Like I said I literally just started learning PHP two days ago, so you'll have to forgive my lack of coding etiquette. Yes, you can mark this solved. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.