Learn VBA & Macros in 1 Week!

PHP - If Else Statement Within While Loop

Full Excel VBA Course - Beginner to Expert

If Else Statement Within While Loop	View Content

I am trying to build this out in my head, but I am unsure of the correct way to do it.

I am running a sql query to pull info from the DB. I already have it checking the number of rows with a if statement, but I need it to check to see if a particular row is empty. If it is empty it needs to echo out one thing and if not another. But I also need it to run the loop till it ends with all the info from the DB is out. I am having it check to see if there is an image path in the row. If not have it echo the HTML without the image path and if so, have it included. but some results may or may not have an image so it needs to display both not one or the other.

Here's my code. I am pretty sure I have this structured wrong (Well, I know it's wrong cause it doesn't run):

Code: [Select]

<?php

$sql = "select * from tbl_tribue where letter = '$_GET[letter]' order by letter asc";
$result = mysql_query($sql,$conn);
$num_rows = mysql_num_rows($result);

if ($num_rows=="0") {
echo "<p>No pet tributes for the letter.</p>";

} else {

while ($row = mysql_fetch_array($result)){
$petname = $row['petname'];
$desc = $row['description'];
$family = $row['familyname'];
$img = $row['imgpath'];

if ($img="") {

echo <<<END

<div>
<p><strong>$petname</strong><br />
$desc<br />
<em>- $family</em></p>
</div>

END;
}
} else {

echo <<<END

<div>
<img src="$img" class="photoWithBorder2" style="float:left; margin-right:10px; margin-bottom:10px;" />
<p><strong>$petname</strong><br />
$desc<br />
<em>- $family</em></p>
</div>

END;
}
}

?>

I left out the DB info. Anyways, I am I close or WAY off the mark? Thanks for any help!

Full Excel VBA Course - Beginner to Expert

Need Help With If Statement And Loop

Similar Tutorials

View Content

Hi,

Im building a custom theme for wordpress and i need some help with a loop, its not wordpress specific code just a general if and loop. heres what i have.

Code: [Select]
$pages = get_pages('parent=0&sort_column=menu_order');
if ($pages) {
$output='';
foreach ($pages as $page) {
if($page->post_status=='publish'){
$output.='<li class=top><a href="'.$page->guid.'" class=top_link><span>'.$page->post_title.'</span></a>';

$sub_pages = get_pages( 'child_of ='. $page->ID);
if ($sub_pages){

foreach ($sub_pages as $sub_page) {
if($sub_page->post_status=='publish'&& $sub_page->post_parent== $page->ID)
{
if($sub_page->guid==" ")
{

}
else
{
$output.='<ul class=sub>';
$output.='<li><a href="'.$sub_page->guid.'">'.$sub_page->post_title.'</a></li>';
$output.='</ul>';
}
}
}

}}
$output.='</li>';
}
}
What im trying to do is only echo <ul class=sub> and the inside <li> if there is something in sub_page guid. I managed to build this code and it works, but i need to move the <ul></ul> outside of the loop so it doesnt repeat over and over again, but i also dont want it being echoed if sub_page->guid is empty

sorry for my poor explanation im doing the best i can.

Thanks in advance for any help

Stumped On Loop If Statement..

Similar Tutorials

View Content

If I have code that looks something like this:

<?php
$t = array('one','two','three','_four','_five','_six');
$u = 'five';
foreach ($t as $v) {
if (substr($v,0,1) != '_') { // if begins with an underscore, remove it, unless it is equal to _$u
echo $v.'<br />';
}
}
?>

I am trying to take out all array items that begin with an underscore except the one that is equal to this..

_five

something like

$v == '_'.$u

So what should be echoed is this:

one
two
three
_five

Is there any way to do this with only an if, and not an if/else??

Thanks..

If...elseif...else Statement With A Loop

Similar Tutorials

View Content

My PHP skills aren't that good but I know what I want to do as I have used other programming languages before.

I run a WordPress website about a Church and its Cemetery. I have been researching the graves for the last 2 years and have added each grave to the website via a Custom Post Type with the buried occupants.

In WordPress I have used a plugin called Advanced Custom Fields and have set each grave to allow at least 5 people buried there.

So the following code below is used to check if the fields have any value which would represent each person in that grave and add it to the page. I don't know how to add it as a database table so this is the easiest way I could think of.

echo '<div id="section-grave">';
echo "<h3>Who's buried in this Grave?</h3>";
//echo '<p>Listed below, are the people buried in this grave.</p>';
if(get_field('is_burial_date_known')) {
    // start For Loop
    for ($x = 1; $x <= 5; $x += 1) {
        $name_of_deceased = 'name_of_deceased_' . $x;
        $burial_date = 'burial_date_' . $x;
        $clergy_name = 'clergy_name_' . $x;
        if(get_field($name_of_deceased)) {
           echo '<p>' . $x . ') ' . get_field($name_of_deceased) . '</p>'; 
        }
        if(get_field($burial_date)) {
           echo '<p>Burial Date: ' . get_field($burial_date) . '</p>'; 
        }
        if(get_field($clergy_name)) {
           echo '<p>Buried By: ' . get_field($clergy_name) . '</p>';
           echo '<hr>';
        }
    } // end For Loop
} else {
     echo '<p>Nobody buried here.</p>';
}
echo '</div>';

I want to add a paragraph above which I have commented out to show how many people are buried in that grave. So if it was only one person then it should say 1 person as oppose to people. So I need a way of counting the names but I can't see a way how to do it.

It will probably based on an IF...Elseif...Else statement and which ever condition is right it just displays the correct line or paragraph. I need a way of counting thetotal number of people per grave but outputting the total relies on the loop which is after the paragraph or line.

I hope I have explained it properly so can anyone see how I can do it please?

Colin

If Statement Inside Of A While Loop

Similar Tutorials

View Content

After it goes through the while loop its supposed to take the ID of the first one in the loop and find out its awardType and then with the awardType variable go through the the if statement. After it displays it the code that fits the awardType variable then it gets the second item in the while loop and then with the ID of the second item takes it back to get the awardType and then goes back through the if statement again. I'm not sure what I'm doing wrong. As of right now all its doing is displaying its awardName and a blank dropdown.

Code: [Select]
<?php

session_start(); // Access the existing session

// Include the database page
require ('../../inc/dbconfig.php');l

$userID = $_SESSION['userID'];

$statusQuery = "
    SELECT
        *
    FROM
        statuses";
$statusResult = mysqli_query ( $dbc, $statusQuery ); // Run The Query

$awardQuery = "
    SELECT
        awards.ID,
        awards.awardName,
        awards.awardType
    FROM
        awards";
$awardResult = mysqli_query ( $dbc, $awardQuery ); // Run The Query
$row = mysqli_fetch_array ( $awardResult, MYSQL_ASSOC );

$awardType = $row[ 'awardType' ];

$charactersQuery = "
    SELECT
        characters.ID,
        characters.characterName
    FROM
        characters
    ORDER BY
        characters.characterName";
$charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query

$matchQuery = "
    SELECT
        eventSegments.ID,
        eventSegments.segmentTitle
    FROM
        eventSegments
        INNER JOIN events
            ON eventSegments.eventID = events.ID
    WHERE
        DATE_FORMAT(events.bookingDate,'%Y') = DATE_FORMAT(curdate(),'%Y')";
$matchResult = mysqli_query ( $dbc, $matchQuery ); // Run The Query

?>

Code: [Select]
<fieldset>
<legend>Nominees</legend>
<?php
        mysqli_data_seek( $awardResult, 0 );
        while ( $row = mysqli_fetch_array ( $awardResult, MYSQL_ASSOC ) ) { ?>
<?php if ($awardType == 'Singular') { ?>
<div class="field required">
<label for="charactersDrop"><?php echo $row['awardName']; ?></label>
<select class="dropdown" name="charactersDrop" id="charactersDrop" title="Characters Drop">
<option value="">- Select -</option>
<?php
                    while ( $row = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) {
                        print "<option value=\"".$row['ID']."\">".$row['characterName']."</option>\r";
                    }
                ?>
</select>
<input type="button" value="Add Character" class="" onclick="HandlerCharacters()"/>
<ul id="characterList">
</ul>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
<? } else { ?>
<div class="field required">
<label for="events"><?php echo $row['awardName']; ?></label>
<select class="dropdown" name="events" id="events" title="Events for <?php echo date("Y") ?>">
<option value="">- Select -</option>
<?php
                    while ( $row = mysqli_fetch_array ( $matchResult, MYSQL_ASSOC ) ) {
                        print "<option value=\"".$row['ID']."\">".$row['segmentTitle']."</option>\r";
                    }
                ?>
</select>
<input type="button" value="Add Match" class="" onclick="AddMatch()"/>
<ul id="matchList">
</ul>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
<?php } ?>
<?php } ?>

Convert If Statement To For Loop

Similar Tutorials

View Content

Hello!

I am going to end up ending with many If-Else statements so I'm hoping someone can change this into a for loop for me, I will learn this way too

Code: [Select]
if(empty($_GET['start']))
{
$active_1_20 = 'active';
$limit_by = 'LIMIT 0,20';
$rank = 1;
}
elseif($_GET['start']==21)
{
$active_21_40 = 'active';
$limit_by = 'LIMIT 20,40';
$rank = 21;
}
elseif($_GET['start']==41)
{
$active_41_60 = 'active';
$limit_by = 'LIMIT 40,60';
$rank = 41;
}
elseif($_GET['start']==61)
{
$active_61_80 = 'active';
$limit_by = 'LIMIT 60,80';
$rank = 61;
}

You can see the obvious pattern, next one will be elseif($_GET['start']==81) and I want it to end to elseif($_GET['start']==501)

Much appreciated anyone!

Thanks.

Loop In If And Switch Statement

Similar Tutorials

View Content

Code: [Select]
<?php

echo '<form action="hwCase.php" method="post">
    Enter number <input type="text" name="number"/><br />
    </form>';

$input = $_POST['number'];

// if a number is entered in the form, ie not null
if (isset($input))
{
switch ($input)
{
// if number entered is less than 0, ie negative number
case ($input<0):
echo "Enter a positive number.";
break;
// if number entered is greater than 1000
case ($input>1000):
echo "Enter a number less than 1000.";
break;
// if number entered is not a number, ie a letter, a character
case (!ctype_digit($input)):
echo "<br><img src=\"squidward.jpg\"><br><br>Enter a valid number. ";
break;
// if valid number is entered, loop "hello world" that many times
case (($input>0) && ($input<1000)):
echo "hello world " . $input . "<br />";
break;
// if anything else is entered
default:
echo "Enter a number.";
break;
}
}
// if no number is entered in the form, ie null
else
{
echo "Please enter a number.";
}
?>
For some reason, my loop doesn't work. Please help me fix it! Thanks in advance! I need to loop this part:

Code: [Select]
case (($input>0) && ($input<1000)):
echo "hello world " . $input . "<br />";
break;

If Statement In Foreach Loop

Similar Tutorials

View Content

Object- Take array of IP addresses and add up all occurrences of a particular IP address.

//$item is an array of IP addresses

foreach ($item as $key => $unique_ip)
{
if($unique_ip == $ip)
$a++;
}
echo $a;

I get a blank page. What am I missing?

For Loop To Populate Switch Statement

Similar Tutorials

View Content

i am trying to get the allowed file types from the database into a switch statement but with no luck so far. They types are in the database like: jpg, png, gif. All seperated with a comma and all in one db column. I am then splitting them at the comma and inserting them into $file_list. In the switch statement i want it to be like:

switch($ext)
{
case "jpg": case "png": case "gif":
break;
}

how can i make this possible? here is my code so far:

$ext = strtolower(pathinfo($_FILES['Filedata']['name'], PATHINFO_EXTENSION));

$f_types = $f_types_info['file_types'];
$f_types = preg_split("|\,|", $f_types);
$types = count($f_types);
$file_list = "";

for($i=0; $i<$types; $i++)
{
$file_list .= $f_types[$i];
}

switch ($ext)
{
case $file_list:
break;
default:
$error = "File Type Not Allowed";
break;
}

Mysql Fetch Array Loop If Statement

Similar Tutorials

View Content

Hi, Does anyone have a clue how I might solve this little issue: I have a MySQL query, for example:

<?php
// Make a MySQL Connection
$query = "SELECT * FROM staff";
    
$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){

    if($row['clock'] < time()) {
    echo "<b>"$row['name']. " - ". $row['age']"</b>";
    echo "<br />";

    } else {

    echo $row['name']. " - ". $row['age'];
    echo "<br />";

    }
}
?>

Taking data from the following table setup: name - age - clock Timmy Mellowman - 23 - 09:00:00
Sandy Smith - 21 - 12:00:00
Bobby Wallace - 15 - 14:00:00 What im trying to achieve is compare the current time to the time in the clock column and depending if it's earlier or later, change the styling of the results. The above code does appear to work somewhat however it seems to change the styling of all results in one go, rather than individually when it passes the time in the cell, which is what im looking for. Thanks

Having A For Loop Inside A Mysql Select Statement

Similar Tutorials

View Content

Is it possible to have a loop inside a mysql select statement? If yes, can someone please give me an idea.

Loop -> Loop -> Loop, Performance Issues.

Similar Tutorials

View Content

Hey. So the issue I'm having is consecutive loops on semi-large arrays, over and over. Consider this array:

$firstArray = array(
'row1' => array(
'dates' => array(
'2014-01-01' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-02' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-03' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-04' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-05' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-06' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-07' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
)
),
'row2' => array(
'dates' => array(
'2014-02-01' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-02' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-03' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-04' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-05' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-06' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-07' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-08' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-09' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
)
)
);

Originally the data comes from ~2-3 database tables, of course. But to ilustrate the point, this is how the main array looks like. This array usually contains anywhere between 10-50 rows, each row containing at least 10 dates, with 10 key/values each. And after setting up all the data, it needs to be processed. Currently this is how a friend of mine did it..

$placeDataHere = array();
foreach($firstArray as $key => $dates) {
foreach($dates as $date => $values) {
foreach($values as $key => $value) {
$placeDataHere['DV_' . $date]['SM_' . $key] = 'KS_' . $value;
//Followed by another ~50-70 lines of processing the 3 loop's data..
...
...
....
....
....
....
....
....
}
}
}

Obviously this isn't good practise, but we can't seem to figure out a better way of doing it, since both the data and the loops are horribly nested. This loop and setup of $firstArray is run anywhere between 10-20 times/request, due to amount of users we wish to process. So, the result is that this code can take up to over 2-3 minutes to complete, which isn't really optimal performance. In short my question is, are there any better methods of handling this with the data setup we currently have?

If Statement Inside If Statement Not Working

Similar Tutorials

View Content

I'm having issues with the following:

Code: [Select]
<?php
session_start();
$_SESSION['username']=$_POST['username'];
$_SESSION['password']=$_POST['password'];
if($_SESSION['username']=="username" && $_SESSION['password']=="password"){
if($_GET['product']=="add"){
$content.='
<p><label>Product Name:</label> <input type="text" name="product_name" size="30" />
<label>Product Price:</label> <input type="text" name="product_price" size="5" />
</p>
<p><label>Product Category:</label> <input type="text" name="product_category" size="30" /></p>
<p><label>Product Link:</label> <input type="text" name="product_link" size="30" /></p>
<p><label>Product Image:</label> <input type="text" name="product_image" size="30" /></p>
<p><label>Product Tag:</label> <input type="text" name="product_tag" size="30" /></p>
<p><label>Product Keywords:</label> <input type="text" name="keyword" size="30" /></p>
<p><label>Product Features:</label><br />
<textarea name="product_features" rows="10" cols="60"></textarea>
</p>
<p><label>Product Pros:</label><br />
<textarea name="product_pros" rows="5" cols="30"></textarea>
</p>
<p><label>Product Cons:</label><br />
<textarea name="product_cons" rows="5" cols="30"></textarea>
</p>
<p><label>Product Description:</label><br />
<textarea name="product_description" rows="10" cols="60"></textarea>
</p>
<p><label>Product Notes:</label><br />
<textarea name="product_notes" rows="5" cols="30"></textarea>
</p>
';
$logout='<div><a href="./acp_admincp.php?log-out">Log-Out</a></div>';
}
elseif($_GET['product']=="view"){
}
else{
$content.='
<a href="./admincp.php?product=add">Add New Product</a>
<br />
<a href="./admincp.php?product=view">View Products</a>
';
}
}
elseif(isset($_GET['log-out'])){
session_start();
session_unset();
session_destroy();
header("Location: ./admincp.php");
}
else{
$content='
<form action="./admincp.php" method="post">
<p><label>Username:</label> <input type="text" name="username" size="30" />';
$content.='</p>
<p><label>Password:</label> <input type="password" name="password" /></p>';
$content.='<p><input type="submit" value="Submit" name="Submit" /></p>
</form>';
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<base href="http://ghosthuntersportal.com/" />
<title>Ghost Hunter's Portal - Admin Control Panel</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="verify-v1" content="" />
<meta name="keywords" content="ghost, hunters, hunter, ghosts, spirit, spirits, paranormal, investigation, investigator, investigators, k2, emf, meter, kii" />
<meta name="description" content="Ghost Hunters Potal. Parnormal research equipment store." />
<meta name="author" content="Andrew McCarrick" />
<meta name="robots" content="index, follow"
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<img src="./logo.png" alt="Ghost Hunter's Portal Admin Control Panel" />
<br />
<div style="color: #AA44AA; font-size: 26px; margin-top: -30px; margin-left: 125px;">Admin Control Panel</div>
<?php
echo $logout;
echo $content;
?>
</body>
</html>

I can log-in, and get to the page with the two links on it. However, once I click one of the links it falls back to the log-in page, and it ends up being a never ending loop.

It's doing this:
Log-In --> Page with links ---> Log-In page again

Should be doing this:
Log-In --> Page with links --> Add Product page or View Products page

I can never get into the the actual sub page.

Just to be clear, the address bar actually shows product=add or product=view, but it still shows the log-in page.

Calculation Displays Correct Answer In Foreach Loop But Not In While Loop. Why?

Similar Tutorials

View Content

Below is my output on the browser:

Student: Kevin Smith (u0867587)
Course: INFO101 - Bsc Information Communication Technology Course Mark 70 Grade
Year: 3

Module: CHI2550 - Modern Database Applications Module Mark: 41 Mark Percentage: 68 Grade: B

Session: AAB Session Mark: 72 Session Weight Contribution 20%

Session: AAE Session Mark: 67 Session Weight Contribution 40%

Module: CHI2513 - Systems Strategy Module Mark: 31 Mark Percentage: 62 Grade: B

Session: AAD Session Mark: 61 Session Weight Contribution 50%

Now where it says course mark above it says 70. This is incorrect as it should be 65 (The average between the module marks percentage should be 65 in the example above) but for some stange reason I can get the answer 65. I have a variable called $courseMark and that does the calculation. Now if the $courseMark is echo outside the where loop, then it will equal 65 but if it is put in while loop where I want the variable to be displayed, then it adds up to 70. Why does it do this.

Below is the code:

Code: [Select]
$sessionMark = 0;
$sessionWeight = 0;
$courseMark = 0;

$output = "";

$studentId = false;
$courseId = false;
$moduleId = false;

while ($row = mysql_fetch_array($result))
{

$sessionMark += round($row['Mark'] / 100 * $row['SessionWeight']);
$sessionWeight += ($row['SessionWeight']);
$courseMark = ($sessionMark / $sessionWeight * 100);

if($studentId != $row['StudentUsername'])
{

//Student has changed
$studentId = $row['StudentUsername'];

$output .= "<p><strong>Student:</strong> {$row['StudentForename']} {$row['StudentSurname']} ({$row['StudentUsername']})\n";

}

if($courseId != $row['CourseId'])
{

//Course has changed
$courseId = $row['CourseId'];

$output .= "<br><strong>Course:</strong> {$row['CourseId']} - {$row['CourseName']} <strong>Course Mark</strong>" round($courseMark) "<strong>Grade</strong> <br><strong>Year:</strong> {$row['Year']}</p>\n";

}

if($moduleId != $row['ModuleId'])
{

//Module has changed
if(isset($sessionsAry)) //Don't run function for first record
{

//Get output for last module and sessions
$output .= outputModule($moduleId, $moduleName, $sessionsAry);
}

//Reset sessions data array and Set values for new module

$sessionsAry = array();
$moduleId = $row['ModuleId'];
$moduleName = $row['ModuleName'];
}

//Add session data to array for current module

$sessionsAry[] = array('SessionId'=>$row['SessionId'], 'Mark'=>$row['Mark'], 'SessionWeight'=>$row['SessionWeight']);

} //Get output for last module

$output .= outputModule($moduleId, $moduleName, $sessionsAry);

//Display the output
echo $output;
I think the problem is that it is outputting the answer of the calculation only for the first session mark. How in the while loop can I do it so it doesn't display it for the first mark only but for all the session marks so that it ends up showing the correct answer 65 and not 72?

Foreach Loop - How To Not Loop Witha "," On Last Loop

Similar Tutorials

View Content

Hey guys,

Got another question im hoping someone can help me with.

I have a foreach loop (for use in a mysql query):

   foreach ($interests as $interest) {
     $query .= "($id, $interest), ";
   }

problem is i do not want the comma(,) in the last loop.

Is there some kinda of function i can use so it does not insert it on last loop?

Or should i just use a for loop with a nested if loop? something like ;

   for($i=0; $i < count($interests); $i++){
      $query .=
      "($id, '$interests[$i]')";
      if($i + 1 < count($interests)) {
         $query .= ", ";
      }
      }

Cheers guys

For Loop & While Loop Working, But Results Are Wrong In Both

Similar Tutorials

View Content

I am working to echo the results in a while or for loop... Both of my sample codes work, but the results are wrong!

The while loop ONLY echos a result IF the first record in the postings table matches the id passed (does not display a result unless the first record has a match)

The if loop displays ALL listings with the same name (counts them all) so there are no unique listings!

<?php

$posts_by_city_sql = "SELECT * FROM postings WHERE id='$_GET[id]'";
$posts_by_city_results = (mysqli_query($cxn, $posts_by_city_sql)) or die("Was not able to grab the Postings!");

/* While Loop */
while($posts_by_city_row = mysqli_fetch_array($posts_by_city_results)) {
echo "<li><a href='posting_details.php?id=$posts_by_city_row[id]'>$posts_by_city_row[title]</a></li>";
}

/* For Loop */
$posts_by_city_row = mysqli_fetch_array($posts_by_city_results);

for ($i=0; $i<sizeof($posts_by_city_row); $i++) {
echo "<li><a href='posting_details.php?id=$posts_by_city_row[id]'>$posts_by_city_row[title]</a></li>";
}

?>

Results with for loop (there are 7 total unique book names, but it's just counting the first match on id 7 times like below):

AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners
AJAX for Beginners

If Statement To Switch Statement

Similar Tutorials

View Content

Hello Everyone,
I have to change the if statements to a switch statement, in this game. Can anyone help? Thanks.

var checkKeyPressed = function (e) {
// Press key A or key D to make dog run to the left or right
// The running speed is specified by the step variable, 10 by default.
// If you replace 10 with a larger integer, the dog will run faster.

    //press A, dog runs left
    if (e.keyCode == "65") {
        if (prex[0] > 5) {
            prex[0] = prex[0] - step;
        }
    }
    //press D, dog runs right
    if (e.keyCode == "68") {
        if (prex[0] < right) {
            prex[0] = prex[0] + step;
        }
    }
};

Ahh Going Crazy! While Loop Inside Of While Loop

Similar Tutorials

View Content

Good Evening - I am in the process of trying to call back a list of categories and sub categories using a WHILE LOOP inside of a WHILE LOOP. It works on a different part of the site within the admin panel but not here. Here it only calls one sub category and moves on to the next parent category instead of finishing the loop and pulling all sub categories out...

// CATEGORIES

$query = "SELECT * FROM cat";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{

$catid = $row['id'];
$catname = $row['name'];

$output .= "<li class=\"level0 nav-2 parent\" onmouseover=\"toggleMenu(this,1)\" onmouseout=\"toggleMenu(this,0)\">
<a href=\"product.php?cat=$catid\">
<span>$catname</span>
</a>\n";

$querynav = "SELECT * FROM subcat WHERE pid = '$catid'";
$resultnav = mysql_query($querynav);

while($array = mysql_fetch_array($resultnav, MYSQL_ASSOC))
{

$subcatid = $row['id'];
$subcatname = $row['name'];

$output .= "<ul class=\"level0\">
<li class=\"level1 nav-2-1 first\">
<a href=\"product.php?cat=$catid&subid=$subcatid\">
<span>$subcatname</span>
</a>
</li>
</ul>
</li>";
}

}

A While Loop In A For Loop Problem

Similar Tutorials

View Content

A WHILE loop in a FOR loop problem

Script about links and sublinks from 1 table.

In fact 2 questions about that.
1) In the FOR loop I have for example to do the loop 3 times. (needs to find 3 results withing the loop with if and else)
When first time, he's gonna search within the WHILE loop that holds (for example) 10 records of the DB in a variable.
He needs to search for rowid number 5, he found it
He goes out of the WHILE loop and goes searching again but now for rowid number 2

Now it seem that the WHILE loop start searching for number 2 but won't start from his first row in the variable (10 rows from the db ).
He start at row number 6 instead of beginning all over again !!!

-> so the order of the numbers of rows MUST be in an ascending order, ortherwise he won't find them all ! But the numbers I have are NOT in an ascending order !!!
Why doesn't the WHILE loop begin again from his row 1 in the variable ?

FOR loop
{
WHILE loop { content here, break; }
}

2) even when I get all the result in an ascending order, he won't go doing a second search but with a different rowid number that he gets from the FOR loop.
It is giving me back indeed the right new rowid number, but the WHILE loop is doing nothing.
I have put many echo "..."; and other stuff for checking but can't find the cause !

Here's the code :

Code: [Select]
// $ResultShow = 10 rows from mysql db
if(isset($ResultShow)){

if (mysql_num_rows($ResultShow) >= 1){

//$linksuborder = "2,3,4";
$array1 = explode(",", $linksuborder);
sort($array1);

for ($n = 0; $n < count($array1); $n++){ // searchin for the right row id in the variable $ResultShow where we find the numbers for next loop
$r1 = each($array1);

While($Row2 = mysql_fetch_array($ResultShow)) {

if($Row2["linkid"] == $r1['value']) // found it, now look for the numbers that we'll put in an array
{ echo "---here the content---";

// linksuborder is where numbers from row id's are stored like 5,2,8
//now put them in an array
$array2 = explode(",", $Row2["linksuborder"]);
sort($array2);

for ($n2 = 0; $n2 < count($array2); $n2++){
$r2 = each($array2);

////// here searching for the sublinks //////
While ($Row3 = mysql_fetch_array($ResultShow))
{
if($Row3["linkid"] == $r2['value']) // search for the right row id within the variable $ResultShow
{
echo "---here the content---";
break; // found it, so no need to do the rest of the loop

} // end if
} //end while
////// end searching for sublinks //////

} // end for
} // end if

else
{
echo "--- content here ---";
}

} // end while
} // end for

} //end if
} // end if

Table :

linkid linksuborder linktitle
1 2,3,4
2 9,7,8 mainlink1
3 10 mainlink2
4 mainlink3
5
6
7 sublink3
8 sublink2
9 sublink1
10 sublink4

-> linksuborder 2,3,4 are the row id's for the mainlink
-> than we put the numbers 9,8,7 (also row id's) mentioned in row linkid 2 also in a new array
-> now we can search for the sublinks
-> get the details from row linkid 9, than 7, than 8

-> First mainlink is compleet, now go to row linkid 3 to do it all over again for the next mainlink...

RESULTS from an sorted array -> sort($linksuborder);
-------------------------------------------------------------
mainlink1 : sublink1, sublink2, sublink3

mainlink2 : **no result back but it should *

mainlink 3 : **no result back but it should *

How To Use While Loop Inside While Loop?

Similar Tutorials

View Content

Hi,

I am new to PHP. Can someone explain me clearly how to use while loop inside while loop to print "*" in square shape.

Thank you for your help.

While Loop Inside While Loop

Similar Tutorials

View Content

Hi..
I have while loop inside while loop but I encountered problem in displaying data inside while loop or the second while loop.

here is my code:

Code: [Select]
<?php
  error_reporting(0);
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
?>
<script type="text/javascript">
function showDetails(pcode) {

var clickElement = pcode.value;
var click_id = pcode.id;

// var value_ = document.getElementById(click_id).checked
// = document.getElementById(clickElement).checked;
//var Table = (document.getElementsByName('list')[0].value);

var Table = document.getElementById('kanban_list');

var rows = Table.rows;

var strSelect = document.getElementById(click_id).value;
//alert(strSelect)

for (var i = 0; i < rows.length; i++) {
var row = rows[i];
//row.style.display = (row.id.substr(0,3) == strSelect) ? 'none' : '';
//row.style.display = (row.id.substr(0,3) == strSelect) ?
// row.style.display = 'none';
// row.style.display = '';

if (row.id.substr(0,3) == strSelect) {
row.style.display = ((document.getElementById(click_id).checked) == false) ? 'none' : ''
}
//(document.getElementById(click_id).checked == false) ? 'none' : '' : '';

}

}

</script>
<?php
$sql = "SELECT kc.PCODE, kc.count_wip_chemical_weighing, kc.count_wip_compounding, kc.count_wip_extrusion,
kc.count_wip_forming, kc.count_wip_deflashing, kc.kanban, kc.virtual, p.max_lot, p.min_lot FROM kanban_checker kc
JOIN plan p ON kc.PCODE = p.PCODE ORDER BY p.PCODE";
$result = mysql_query($sql, $con);
?><label>Display Details:</label><input onclick='showDetails(this);' id='chkDetail' type='checkbox' checked='checked' value='wip'/>
<?php
echo "<table id='kanban_list'>";
echo "<tr>
        <th> PCODE </th>
        <th> LOT CODE </th>
        <th> CHEMICAL WEIGHING </th>
        <th> COMPOUNDING </th>
        <th> EXTRUSION </th>
        <th> FORMING </th>
        <th> DEFLASHING </th>
        <th> KANBAN </th>
        <th> VIRTUAL </th>
        <th> MAX LOT </th>
        <th> MIN LOT </th>
     </tr>";
while($row = mysql_fetch_assoc($result)){
    echo "<tr>
        <td>$row[PCODE]</td>
        <td> </td>
       
        <td>$row[count_wip_chemical_weighing]</td>
        <td>$row[count_wip_compounding]</td>
        <td>$row[count_wip_extrusion]</td>
        <td>$row[count_wip_forming]</td>
        <td>$row[count_wip_deflashing]</td>
        <td>$row[kanban]</td>
        <td>$row[virtual]</td>
        <td>$row[max_lot]</td>
        <td>$row[min_lot]</td>
        </tr>";
$sql = "SELECT kd.LOT_CODE, kd.wip_chemicalweighing, kd.wip_compounding, kd.wip_extrusion, kd.wip_forming, kd.wip_deflashing
FROM kanban_data kd JOIN plan p ON kd.PCODE = p.PCODE ORDER BY p.PCODE ";
$result_kanban_data = mysql_query($sql, $con);

while($row_data = mysql_fetch_assoc($result_kanban_data)){
    echo "<tr id='wip'>
    <td></td>
    <td> $row_data[LOT_CODE]</td>
    <td> $row_data[wip_chemicalweighing]</td>
    <td> $row_data[wip_compounding]</td>
    <td> $row_data[wip_extrusion]</td>
    <td> $row_data[wip_forming]</td>
    <td> $row_data[wip_deflashing]</td>
    </tr>";
}
}
echo "</table>";

?>
I attach the image of result from this code

But the output that I want is all LOT_CODE with P35 PCODE will only display below P35
and all LOTCODE with P35M PCODE will only display below P35M.

Thank you

I hope somebody can help me..