Learn VBA & Macros in 1 Week!

PHP - Include In For-loop

Full Excel VBA Course - Beginner to Expert

Include In For-loop	View Content

Hello,

I have some php-files containing variables with same names but different data.

$arr = array("file1.php", "file2.php", "file3.php");

I want to "get access" to these variables/data. One php-file at a time. This is what i am doing right now:

for($i=0; $i<sizeof($arr); $i++)
    include $arr[$i];

This does work in the first 2 php-files in the array but not on any other of them unless i change start-value of $i. Could you maybe help me solve this?

Edited July 16, 2019 by cyberRobot
added code tags / removed text background

Full Excel VBA Course - Beginner to Expert

Include() Nested Within A Loop

Similar Tutorials

View Content

Hi Everyone,

I'm trying to use a while loop to dynamically include() .php files if a preg_match condition concerning the file name returns true, e.g.

if ( $hDirectory = opendir($_SERVER["DOCUMENT_ROOT"])) {

   while (false !== ($strFileName = readdir($hDirectory))) {

      if ( pathinfo($strFileName, PATHINFO_EXTENSION ) == "php" ) {
         if ( preg_match("/frm_/", $strFileName) ) {
            include_once $strFileName;
         }
      }
echo $strFileName;
   }
   closedir($hDirectory);
}

But, it doesn't seem to work as I thunked it would - the loop iterates several times but then unexpectedly exits, which is wrong because there are hundreds of .php files with 'frm_' in the filename!. Thoughly, as I did expect, should I comment out the include() statement all files names get echoed! and things are happy!!!!

Analogiciously, I'm doing this because I'm lazy and want to be able to 'drop' .php files into the same directory and have my script automagically include them in my project save me from writing another freaking include statement! Am going about this the wrong way? If so, how did y'all get around the tedious task of having to write hundreds of bloody include() statements in your projects? I've seen this question asked a few times in Google-land, but not answered, which leds me to believe I'm doing something deliciously-evil.

Cheers,
Daniel

Include Inside An Include

Similar Tutorials

View Content

Hi

Still a new comer when it comes to PHP.

I have a situation where I want to use an include within an include and I am having trouble with my file paths.

My main header include, includes everything for each page of my site, beyond the opening of the body to incorporate my navigation etc conditionally loading in css, and loading in titles and meta data etc depending on the page in question.

This header needs to reference another include called the-pod.php which is required for every page, the only trouble is I want to use / to reference the root of the server and this is breaking my code. I can't use ../../ etc as its a different path depending on where the master file is located.

So my question is how do I get around this?

Can the root of the server or path to the root be stored in a variable? and if so how would I write this.

Any tips / advice will be greatly appreciated.

Include() Inside Another Include()

Similar Tutorials

View Content

Hi Guys.. Merry Christmas

Im kinda new to this fantastic world of PHP and i have a little problem i hope you can help me with.

Im trying to build a website where I use include() to genereate my content. On my index.php i have a menu which includes
content in a content div from external .php pages, my structure kinda goes like this.. (simplified)

site/
index.php
content/
fronpage.php
products.php
contact.php

The HTML looks like this.

<div id="menu">
<ul>
<li><a href="index.php?page=frontpage">frontpage</a></li>
<li><a href="index.php?page=products">frontpage</a></li>
<li><a href="index.php?page=contact">frontpage</a></li>
</ul>
</div

<div id="main">

<?php
include('/content/'.$_GET['page'].'.php');
?>

</div>

This all works very fine, but my problem is, can I have a include inside an already included page?
I would like to have a menu on my products.php site, but that page is already included from above,
and i would like the menu on the products.php site to stay as the content from the nested include
changes with input from the /products folder.

my idea was something like this.

site/
index.php
content/
frontpage.php
products.php
contact.php
products/
product1.php
product2.php

the HTML on the index.php is the same as above and then i would add the include() on the
products.php page, so its kinda the same thing, but one inside the other.

HTML inside the products.php folder

<div id="sub_menu">
<ul>
<li><a href="#">frontpage</a></li>
<li><a href="#">frontpage</a></li>
<li><a href="#">frontpage</a></li>
</ul>
</div

<div id="sub_main">

<?php
include('/content/products'.$_GET['#'].'.php');
?>

</div>

I dont know how to link to the new files so they will be included while the first include still stays on the page.

Any of you know how and if this can be done? Or maybe at better way to do it?

Hope this made sense, my first PHP question

Thanks

Include Inside Of Include

Similar Tutorials

View Content

CanI put one INCLUDE statement INSIDE of another INCLUDE statement?

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?

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

<? Include("include/session.php"); ?>

Similar Tutorials

View Content

When I put this above all else in my document and test it offline, all I see is code in the browser. But when I test it on my web server, I can view the markup and whatnot.

Does anyone know why this is?

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>";
}

}

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") . "<br />";
$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);
?>

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).'<br />';
        }
    }
catch(Exception $e)
    {
    echo $e->getMessage();
    }?>

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.

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 *

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

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!

Php Include ()

Similar Tutorials

View Content

Hi,

I'm so new to PHP.

Kindly help me figure out on how to use include function..

situation is..

I am going to include a head.php file

/includes/head.php

this is the path where i want to include head.php

/menu/menulist/list

in "list" folder that is where I want to include head.php
include works on folder "menulist" but not on 3rd folder "list"

any advise on how tot solve this problem of mine?

Thanks

Where Should I Put My Include

Similar Tutorials

View Content

I have to store my Authorize.net Payment Gateway values somewhere safe. (i.e. Outside of the Web Root)

I tried this code but my checkout page that formerly worked with local values in Test Mode is crashing.

// Include Authorize.net Values.
require_once('/var/www/vhosts/MyWebsite.com/private/auth_config.php');

I think the issue is that private maybe can't be read or included by other files?

Would using another Linux directory solve my problem?

Debbie

Need Help With Include...

Similar Tutorials

View Content

Okay if I use an include to include a login script the login button doesn't work at all but it works on the page itself just not on the include

http://store.crytell.com/

when I attempt to login nothing happens Im sure I have the script dir right

Code: [Select]
<body bgcolor="#100f14">
<?
/**
* Main.php
*
* This is an example of the main page of a website. Here
* users will be able to login. However, like on most sites
* the login form doesn't just have to be on the main page,
* but re-appear on subsequent pages, depending on whether
* the user has logged in or not.
*
* Written by: Jpmaster77 a.k.a. The Grandmaster of C++ (GMC)
* Last Updated: August 26, 2004
*/
include("./storelogin/include/session.php");
?>

<html>
<title>Jpmaster77's Login Script</title>
<body>

<table>
<tr><td>

<?
/**
* User has already logged in, so display relavent links, including
* a link to the admin center if the user is an administrator.
*/
if($session->logged_in){
echo "<h1>Logged In</h1>";
echo "Welcome <b>$session->username</b>, you are logged in. <br><br>"
."[<a href=\"./storelogin/userinfo.php?user=$session->username\">My Account</a>]   "
."[<a href=\"./storelogin/useredit.php\">Edit Account</a>]   ";
if($session->isAdmin()){
echo "[<a href=\"./storelogin/admin/admin.php\">Admin Center</a>]   ";
}
echo "[<a href=\"./storelogin/process.php\">Logout</a>]";
}
else{
?>

<h1>Login</h1>
<?
/**
* User not logged in, display the login form.
* If user has already tried to login, but errors were
* found, display the total number of errors.
* If errors occurred, they will be displayed.
*/
if($form->num_errors > 0){
echo "<font size=\"2\" color=\"#ff0000\">".$form->num_errors." error(s) found</font>";
}
?>
<form action="./storelogin/process.php" method="POST">
<table align="left" border="0" cellspacing="0" cellpadding="3">
<tr><td>Username:</td><td><input type="text" name="user" maxlength="30" value="<? echo $form->value("user"); ?>"></td><td><? echo $form->error("user"); ?></td></tr>
<tr><td>Password:</td><td><input type="password" name="pass" maxlength="30" value="<? echo $form->value("pass"); ?>"></td><td><? echo $form->error("pass"); ?></td></tr>
<tr><td colspan="2" align="left"><input type="checkbox" name="remember" <? if($form->value("remember") != ""){ echo "checked"; } ?>>
<font size="2">Remember me next time     
<input type="hidden" name="sublogin" value="1">
<input type="submit" value="Login"></td></tr>
<tr><td colspan="2" align="left"><br><font size="2">[<a href="./storelogin/forgotpass.php">Forgot Password?</a>]</font></td><td align="right"></td></tr>
<tr><td colspan="2" align="left"><br>Not registered? <a href="./storelogin/register.php">Sign-Up!</a></td></tr>
</table>
</form>

<?
}

/**
* Just a little page footer, tells how many registered members
* there are, how many users currently logged in and viewing site,
* and how many guests viewing site. Active users are displayed,
* with link to their user information.
*/
echo "</td></tr><tr><td align=\"center\"><br><br>";
echo "<b>Member Total:</b> ".$database->getNumMembers()."<br>";
echo "There are $database->num_active_users registered members and ";
echo "$database->num_active_guests guests viewing the site.<br><br>";

include("./storelogin/include/view_active.php");

?>

</td></tr>
</table>

</body>
</html>
Code: [Select]
<?include_once "./storelogin/main.php"; // this will include a.php?>

Include Help

Similar Tutorials

View Content

I have an include file and a php file in different directories and I can't figure out what I'm doing wrong trying to get them to relate to one another.

webhost/website/includes/include.inc

webhost/website/modules/module/page.php

How do I get the page.php to use the include.inc file?

I'd think it would be "../../include.inc", but that isn't working