Learn VBA & Macros in 1 Week!

PHP - Loop -> Loop -> Loop, Performance Issues.

Full Excel VBA Course - Beginner to Expert

Loop -> Loop -> Loop, Performance Issues.	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?

Full Excel VBA Course - Beginner to Expert

Performance On Thousands Of Selects In While Loop

Similar Tutorials

View Content

Hello, Any ideas why server resources not exhausted on the code below, when my.cnf and php.ini are both set to use half the resources each? PHP & MySQL will both utilize all allotted resources on other scripts, so it's not a tuning problem. There is no script-side tuning. The bottleneck: pdo select as shown below

foreach($bigList as $listObject) {
                $sql = $dbl->prepare("SELECT * FROM fewMillionRows WHERE indexedCol1=:indexedCol1 AND indexedCol2=:indexedCol2 AND indexedCol3=:indexedCol3 AND indexedCol4=:indexedCol4 LIMIT 1");
                $sql->execute($preparedValues);
                $return = $sql->fetchAll(PDO::FETCH_ASSOC);
}

On a dedicated server with 8GB RAM, the server uses >5% cpu/ram but takes a long time to finish the script. Second Question What are some alternative designs? Because the column values all happen to be alphanumeric, I could select the entire table and store it in an array. Accessing the keys like so: indexedCol1indexedCol2indexedCol3indexedCol4. Results: MyISAM - Select Whole Table: 30 seconds MyISAM – Select Individual Rows (10k times) – 68 seconds InnoDB – Select Whole Table: 30 seconds InnoDB – Select Individual Rows (10k times) – 131 seconds I am surprised it takes so long to select a whole table. The server resources use 1% for about 20 seconds, then cpu/ram jump to 30%+ for about 10 seconds. This is still drastically faster than individual selects. In this instance, $bigList is over 500k items. At 68 seconds per 10k rows it’s absurdly long. Building an array with key/values is the only realistic way I currently know of, but I suspect there is a much better way of doing this. As far as I know, I cannot do a select like so: SELECT * FROM t1 WHERE (column1,column2,column3) IN ((val1, val2,val3), (val4, val5,val6)) There is no way to determine whether a row was found for each entry as far as I know.

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 .= "Student: {$row['StudentForename']} {$row['StudentSurname']} ({$row['StudentUsername']})\n";

}

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

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

$output .= " Course: {$row['CourseId']} - {$row['CourseName']} Course Mark" round($courseMark) "Grade Year: {$row['Year']}\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

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\">
$catname
</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\">
$subcatname
</a>
</li>
</ul>
</li>";
}

}

Having Issues With Inserting Data Into Array Inside Loop

Similar Tutorials

View Content

Hello all,

What I'm trying to do is insert dynamic data supplied by the user into an array, but for some reason, the loop only builds arrays inside of arrays (or so it seems) and doesn't create an array with unique indexes and associated data.

I was hoping someone could point me in the right path? I've searched numerous forums, threads and google but cannot find an answer.

Here is the code snippet I'm working on. What it's supposed to do is collect a user's input, which is a Quantity amount and a high number, and based on that amount, create an array of random integers. This is my latest attempt. Now, maybe I'm just losing it, but when I place print_r($output) inside the loop, I see how it's being created but no unique indexes, just nested arrays. When I place it outside of the loop, I only receive one array with one index and value even though a high quantity was sent to the script.

Code: [Select]

$i = 1;

while ($i <= $Quantity){

$output = array(rand($RandLow, $RandHigh));

$i++;
}
print_r($output);

Here is another attempt, which again proved to be unsuccessful, at least to my tire brain.

Code: [Select]

$i = 1;

while ($i <= $Quantity){

$output = rand($RandLow, $RandHigh);
$total = array($output);

$i++;
}

print_r($total);
I've tried the for() loop as well but I just can't seem to make heads or tails of this and I'm sure it's going to be something simple that I'm missing.

Thanks in advance for any help and insight if you know a better way to do this.

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 *

Looking To Fit A While Loop Instead Of A Foreach Loop Here

Similar Tutorials

View Content

Code: [Select]
<?php
$hierachy = new hierachy;
$iterator = new RecursiveIteratorIterator(new recursiveArrayIterator($hierachy->getLocalSubNodes($name1)));
try {
 foreach($iterator as $key=>$value)
 {
 echo $value = substr($value,0,-1).' ';
 }
 }
catch(Exception $e)
 {
 echo $e->getMessage();
 }?>

Foreach Loop Or For Loop?

Similar Tutorials

View Content

I'm having a really bad brain fart and I cannot get the logic correct here lol.

I need divs wrapped around every set of 5 images so if there is a total of 8 images then there would be 2 sets of divs (first with 5 images, second with 3 images) and if there was 12 images then there would be 3 sets of divs (first two with five images, last one with 2 images) etc etc What am I doing wrong and is there an easier way to do this?

http://pastebin.com/QfsFxe4G

Thanks!

Loop Inside A Loop

Similar Tutorials

View Content

So I have a PHP parent page that is accesses that scans the database for the passed token in the URL and then replaces content on the template page using a loop. My issue is that I am trying to use a loop on the secondary page which causes the white screen of death. From what I can tell the loop inside a loop is causing the issue.
I'll paste the code below, let a newbie know if you have any ideas or can point me in the right direction.

Thanks everyone!

Here is the chunk of code from the parent page with the loop function....

// output pre content
eval("\$preContent = \"$preContent\";");
print_r( replaceChar($preContent) );

$sqlSearch = "SELECT * FROM ".$row[tdbd_name]." WHERE ".$sqlKeyword." LIMIT ".MAX_ROWS;
$resultSearch = mysql_query($sqlSearch);

while($displayrows = mysql_fetch_assoc($resultSearch)) {
 $display = replaceTokens($loopTemplate);
 $display = str_replace('\\', '[backslash]', $display);
 $display = str_replace('[%', '$displayrows[', $display);
 $display = addslashes(str_replace('%]', ']', $display));
 $display = replaceTokens($display);
 $display = changeCase($display);

 eval("\$display = \"$display\";");

 $display = stripslashes($display);
 $display = str_replace('[backslash]', '\\', $display);
 $display = replaceChar($display);

 print_r( $display );

}
// output post content

And here is the loop function from the page that the above code loops through replacing tokens in.

<?php
$mySQLServer = "xxxxxxxxx";
$mySQLUser = "xxxxxxxxxx";
$mySQLPass = "xxxxxxxx";
$mySQLDB = "xxxxxxxxxxxxx";
$SQLToday = date("m/d/y") . " ";
$SQLsevendays = mktime(0,0,0,date("n"),date("j")-7,date("Y"));
$SQLsevenname = (date("l", $SQLsevendays));
$SQLsevennumber = (date("jS", $SQLsevendays));
$dbhandle = mssql_connect($mySQLServer, $mySQLUser, $mySQLPass)
or die("Couldn't connect to SQL Server on $myServer");
$selected = mssql_select_db($mySQLDB, $dbhandle)
or die("Couldn't open database $myDB");
$query = "WEB_ApproveHistory @State='CA', @Days=5, @Records=8";
$data = mssql_query($query);
$result = array();

while ($row = mssql_fetch_object($data))
{
$result[] = $row;
$returnedresults = (97*($row->TotalApprovals)) ;
}

$englishreturnedresults = number_format($returnedresults);
echo 'In just the last week since ' . $SQLsevenname . ' the ' . $SQLsevennumber . ' has delivered ';
echo $englishreturnedresults;
echo ' Here are just a few people ';

echo '<ul class="BulletCheck">';

mssql_next_result($data);

while ($row = mssql_fetch_object($data))
{
$result[] = $row;
echo '<li>' . ' ' . $row->FirstName . ' From '. $row->City . ', ' . $row->State .' PreApproved On ' .$row->ApprovedDate . '</li>';
}

mssql_close($dbhandle);
?>

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..

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.

To Loop Or Not To Loop?

Similar Tutorials

View Content

Hello. I have a simple SQL query that returns a list of names, this is good and all is right with the world. I would like to associate a number with each person, a RANDOM number that will change each time I call the page. Desired result: Number | Name 18 | Jeff 2 | Tammy 12 | Steve 10 | Phil 5 | Michelle etc. etc. Pool of numbers will be from 1 to 30. Sometimes the names pool will result in 18 rows or 27 rows or any number in between. I just need to assign a number from 1 to 30 to each name that is not the same each time. Here's my loop.

while ($row= mysql_fetch_array($result)) {
	$lastname = $row["lastname"];
	$firstname = $row["firstname"];

	$numbers = range(1, 30);
	shuffle($numbers);
	foreach ($numbers as $number) {
	}

echo "<tr>
		<td class='results'>$number</td>
		<td class='results'>$firstname $lastname</td>
	</tr>";
}

Here's the problem I'm encountering: 1) If I leave the FOREACH inside the loop, I wind up with one or two repeated $number(s). 2) If I take the FOREACH outside the loop, I wind up with the first integer from the $numbers range repeated as many times as there are names I'm just not sure how to achieve a unique designation for each name. Could someone point me in the right direction? Thanks so much!

For Loop

Similar Tutorials

View Content

I know I can do this.... foreach ($conversations as $conversation)

but can I do this foreach ($conversations as $conversation and $messages as $message)

Let me know. I need both of these in my for loop.

Help With While Loop

Similar Tutorials

View Content

Hey guys,

I got some questions about the while loop

It's dealing with the "qset" as you can see below:

Code: [Select]
$get = "SELECT qset from mailing_list where email = '$email'";
$result = mysqli_query($connect, $get) or die($connect);
while ($row = mysqli_fetch_array($result)){
extract($row);
$qset = rsort($row);
$qset = (int)end($row);

}

if (empty($qset) || $qset < 1){
$qset = 1;
return $qset;
} elseif ($qset >=1){
$qset = $qset + 1;
return $qset;
}

echo $qset;
Nothing echoed out... Why?

Also it seems like the script got stuck at the while loop, as no sql commands that follow up are processed

Any help is appreciated!

Thanks

Xml Loop

Similar Tutorials

View Content

I'm trying to grab the data for several products, then list the attributes for each product. I'm ending up with the same attributes from Attribute id="259". Can anyone fix my problem?
XML example
Code: [Select]
<RelatedAttributes>
<Attribute id="259">
<name>Brand</name>
<AttributeValues>
<AttributeValue id="258888">
<name>HON</name>
</AttributeValue>
<AttributeValue id="276682">
<name>Office Star</name>
</AttributeValue>

<Attribute id="296935">
<name>Stores</name>
<AttributeValues>
<AttributeValue id="18893">
<name>Test</name>
</AttributeValue>
</AttributeValues>
</Attribute>
</RelatedAttributes>

php Code
Code: [Select]
foreach($xml->RelatedAttributes->Attribute as $attribute){
echo $attribute->name; //main Attribute Name

foreach($xml->RelatedAttributes->Attribute->AttributeValues->AttributeValue as $attribute_values){
echo $attribute_values->name; //subtopic for main Attribute

}}

For Loop Followed By A While Loop

Similar Tutorials

View Content

The output for the below code is;

the for loop number is 0
the for loop number is 1
the for loop number is 2
the for loop number is 3
the for loop number is 4
the for loop number is 5
the while loop number 7
the while loop number 8
the while loop number 9

Code: [Select]
$i = 0;
for ($i=0; $i<6; $i++)
{echo "the for loop number is $i ";}

while ($i<9)
{$i++ ;
echo "the while loop number $i ";}
If at the end of my for loop $i = 5, and then in my while loop 1 is added to $i ($i++) then why doesnt my while loop
output begin with; the while loop number 6 ?

How To Set This Up With A For Loop?

Similar Tutorials

View Content

Code:

<?php
    /*
     * HASHTAGS
     */
    if(isset($_POST['hashtag0'])) {
        $hashtag0 = $_POST['hashtag0'];
    }
    if(isset($_POST['hashtag1'])) {
        $hashtag1 = $_POST['hashtag1'];
    }
    if(isset($_POST['hashtag2'])) {
        $hashtag2 = $_POST['hashtag2'];
    }
    if(isset($_POST['hashtag3'])) {
        $hashtag3 = $_POST['hashtag3'];
    }
    if(isset($_POST['hashtag4'])) {
        $hashtag4 = $_POST['hashtag4'];
    }
    if(isset($_POST['hashtag5'])) {
        $hashtag5 = $_POST['hashtag5'];
    }
    if(isset($_POST['hashtag6'])) {
        $hashtag6 = $_POST['hashtag6'];
    }
    if(isset($_POST['hashtag7'])) {
        $hashtag7 = $_POST['hashtag7'];
    }
    if(isset($_POST['hashtag8'])) {
        $hashtag8 = $_POST['hashtag8'];
    }
    if(isset($_POST['hashtag9'])) {
        $hashtag9 = $_POST['hashtag9'];
    }
    if(isset($_POST['hashtag10'])) {
        $hashtag10 = $_POST['hashtag10'];
    }
    if(isset($_POST['hashtag11'])) {
        $hashtag11 = $_POST['hashtag11'];
    }
    if(isset($_POST['hashtag12'])) {
        $hashtag12 = $_POST['hashtag12'];
    }
?>

<?php

// Stores the hashtags taken from the form inside an array.
        $hashtags = array($hashtag0, $hashtag1, $hashtag2, $hashtag3, $hashtag4, $hashtag5, $hashtag6, $hashtag7, $hashtag8, $hashtag9, $hashtag10, $hashtag11, $hashtag12 );

?>

Basically, the script checks if the "$_POST['']" variable from the form is set and then it stores the "given" "values" from the form inside an array. I tried it with this:

<form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
    <?php
        for($i = 0; $i < 12; $i++){
           echo "<input type='text' name='hashtag" . $i . "' />";
        }
    ?>
    <input type="submit" name="submit" />
</form>

<?php

if(isset($_POST['submit'])){
    for($i = 0; $i < 12; $i++) {
        if(isset($_POST['hashtag$i'])){
            $hashtags = array($_POST['hashtag$i']);
        }
    }

        print_r($hashtags);
}
?>

With this example I get the following notice:

Notice: Undefined variable: hashtags in C:\xampp\htdocs\hashtags\index.php on line 19

It points to "print_r()". I would appreciate the suggestions.
Edited by glassfish, 22 October 2014 - 10:03 AM.

Php Loop

Similar Tutorials

View Content

how would i loop the below script so that more than one file can be uploaded. my form lets you select more than one image but i am not sure how to loop the below.
Code: [Select]
if( isset($_POST['submit']) ) {
include('thumbnail.php');

$userfile = $_FILES['uploaded_image']['name'];
$file_size = $_FILES['uploaded_image']['size'];
$file_temp = $_FILES['uploaded_image']['tmp_name'];
$file_err = $_FILES['uploaded_image']['error'];
$folder = $_POST['folder'];
$path = "../../gallery/gallery_files/gallery/$folder/";
$path1 = "../../gallery/gallery_files/gallery/$folder/thumbnails/";

$image = new SimpleImage();
$image->load($file_temp);
$image->resizeToWidth(600);
$image->save($path.$userfile);
$image->resizeToWidth(110);
$image->save($path1.$userfile);
} else {
}

Need Help With While Loop

Similar Tutorials

View Content

I recently added a mysql query and a while loop to my expiration date script but now it doesn't work.

The script is suppose to send the user an email x days before it expires.

Code: [Select]
<?php

include("../includes/connect.php");

$query = "SELECT expiry_date FROM model";
$result = $db->query($query);

$num_results = $result->num_rows;

$exp_date = strtotime($row['expiry_date']); // YYYY-MM-DD
$today = strtotime("now");
$expiration_date = strtotime("+3 days", $exp_date);

$i=0;
while ($i < $num_results); {
$row = $result->fetch_assoc();

if ($expiration_date > $today) {
echo "Valid: Yes ";
echo "Today: $today ";
echo "Expire date: $expiration_date";

include('../../pear/Mail-1.2.0b1/Mail.php');

## EMAIL CODE HERE ##

echo "Your email has been sent to $recipients";

$i++;
} else {
echo "No results found.";
}
}

?>
Right now the script just echos "No results found". The mysql table has 11 entries and one of them is about to expire so the user should be sent an email but the code above doesn't work. Does anyone see anything wrong with the code above?