PHP - Inconsistencies With For() Loops.

i have been given this task in in uni. i was wondering it some one would be so kind to help me with it. all i have so far is this
<?php
for($x=1; $x<=3; $x=$x+1) {
print  "$x <br>";
}
 if ($x== "A") {
}




?>

the task is below



Generate a number between 1 & 3
If 1 then assign A, If 2 then assign B, If 3 then assign C
Add to a wordstring (using string concatenation with .)

We need 3 letters generated to give a 3 letter word

For loop (3)
Generate a number between 1 & 3
If 1 then assign A, If 2 then assign B, If 3 then assign
    C
Add to a wordstring (string concatenation with .)
End loop
Print 3 letter word

Hello everyone, I've already posted a question trying to resolve my problem,  but I've changed my code so much, I figured it may be best just to post a new thread with a better explanation of what I'm trying to do.  Anyway, here's what I've got:

I have a database with 2 tables: products and reservations.  I have 3 products for now, that can be reserved for any date.  I'm trying to create a page that will display all of the available products for a specific date.  The user selects the date they want to check, and then the code should check their selected date and compare it with the database to display everything that is available on that date.

The database looks like this:

Products Table:

prodid  prodname
01        item 1
02        item 2
03        item 3

Reservations Table:

prodid  resdate
01        02/22/2012
01        02/23/2012
03        02/22/2012

Here is the code that I have now:

Code: [Select]
<?php

$resultres = mysql_query("SELECT `prodid` FROM reservations WHERE `resdate` = '$resdate'") or die (mysql_error());

while ($rowres = mysql_fetch_row($resultres)) {

$resprodid = $rowres[0];

$resultavail = mysql_query("SELECT `prodid` FROM products WHERE `prodid` != '$resprodid'") or die (mysql_error());

while ($rowavail = mysql_fetch_row($resultavail)) {

$prodid = $rowavail[0];

echo $prodid;
                echo $proname;

       }

}

?>

When I select 02/21/2012, I get no results, where I should get all three products as a result, because none of them are reserved on this date.

When I select 02/22/2012, I get a result of these products, in this order: 02, 03, 01, 02.  I should get a result of ONLY 02, because this is the only product that isn't reserved for this date.

When I select 02/23/2012, I get a result of 02 and 03, which in this case would be the correct return, because 01 is the only one reserved for this date.

Any idea what I'm doing wrong here and how to fix it?  Any help is GREATLY appreciated!

Did PHP a few years ago and for the life of me i can't work out why this doesn't work:

Code: [Select]
for ( $counter2=1; $counter2 < 1000; $counter2++)
{
   for ( $counter1=1; $counter1 < 1000; $counter1++)
   {
      echo "Fixed bug";
   }
}

and yet this does

Code: [Select]
for ( $counter2=1; $counter2 < 100; $counter2++)
{
   for ( $counter1=1; $counter1 < 100; $counter1++)
   {
      echo "Fixed bug";
   }
}


I tested it because I have a rather large amount of data to retrieve from an XML file and i kept receiving errors

Hi,

I'm trying to create a script that imports a CSV file but gives the user 3 options:

1. If Exists Update
2. If Exists Keep Both
3. If Exists Ignore New

The keep both is easy, I just insert everything without checks.

However, the other 2 are a little bit tricky (in my mind anyway). I've been told I could create loops and that there isn't any easy way to do this with MySQL. I cannot use ON DUPLICATE KEY because the column that I'm checking cannot be unique (because I have the keep both option).

Is it efficient in PHP to create a loop that checks each row to see if it exists? I'm a little hesitant because the files could be big and I'm not sure how efficient PHP is with CPU and memory resources.

The App I'm making is designed to run in a business environment but it may run on servers that are handling more than one thing (not just web services).

If anyone could give me a few pointers I'd be most grateful.

Thanks.

Hello, lately I have been having a problem with my simple PHP script. Out of the blue the following script doesnt seem to work properly,
function sanitize_tags($content, $bad_tags = '') {
    foreach ($bad_tags as $tag) {
        $stripped_tags = str_replace($tag, '', $content);
        return $stripped_tags;
    }

    return $content;
}

$contents = "<html>
<head>
</head>

<body>yutu<style>ghghl;kl;<script>hfjhk
</body>
</html>";
$bad_tag = array("<style>", "<script>");

$sanitize = sanitize_tags($contents, $bad_tag);
echo $sanitize;

Basically, when the function is invoked, only the first element in the array is used by the function. It seems like the second+ elements arent even iterated. Why is it only the first element is iterated? I have a feeling its going to be something extremely obvious.

Thanks in advance.

I'm trying to send an email that has a list created from a while loop to multiple people with an email list created from while loop.  Can someone please help me figure this out?  My brain is fried.  Here's the code that I have:

This is producing an error message that reads: Parse error: syntax error, unexpected '{' in /home/content/29/6879529/html/calhoun/admin/sendreport.php on line 22
Code: [Select]
<?php
include("conf.inc.php");

$result = mysql_query("SELECT `prefix`,`lname`,`email` FROM admin");
$row = mysql_fetch_row($result);

$result2 = mysql_query("SELECT `to`,`from`,`subject`,`message`,`date` FROM allmsgs WHERE reported = 'n' ORDER BY `messid` ASC");
$row2 = mysql_fetch_row($result2);

$cdate = date('m-d-Y');

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

$prefix = $row[0];
$lname = $row[1];
$adminemail = $row[2];
$fullname = "$prefix $lname";

$sendto = "$adminemail";
$emailsubject = "Webstats Report For $cdate.";

while ($row2 = mysql_fetch_row($result2){ // This is line 22.

$to = $row2[0];
$from = $row[1];
$subject = $row[2];
$message = $row[3];
$datetime = $row[4];

$eachmessage = "<p>
<hr width=\"400\">
To: $to<br>
From: $from<br>
On $datetime<br>&nbsp;<br>
$subject<br>$nbsp;<br>
$message
</p>";

}

$emailmessage = "<html>
<body>
$fullname,
<p>
Here is a list of the messages that have been exchanged in the last 24 hours.</p>
$eachmessage
</body>
</html>";

// To send HTML mail, the Content-type header must be set
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

// Additional headers

$headers .= 'From: Webstats <reports@webstats.com>' . "\r\n";

// Mail it
mail($sendto, $emailsubject, $emailmessage, $headers);

}

?>

hey guys, in my script i displays status' the users have posted. However when the users status' got over like 20, i noticed it was affected load times greatly as lots of SQL is looping.

Code: [Select]
<?php
   $sql =  sqlcount(mysql_query("SELECT * FROM statuses LEFT JOIN users ON statuses.userid = users.id ORDER BY statusid DESC"));
while ($row = mysql_fetch_assoc($sql)) {
$status_id = htmlspecialchars($row['statusid']);
$status = htmlspecialchars($row['status']);
$time_posted = htmlspecialchars($row['time_posted']);
$status_userid = htmlspecialchars($row['userid']);
$sql2 = sqlcount(mysql_query("SELECT username,avatar_url FROM users WHERE id=$status_userid LIMIT 1"));
while ($row2=mysql_fetch_array($sql2)){
$usernamestatus = $row2['username'];
$avatar_url = $row2['avatar_url'];
if (empty($avatar_url)) {
$avatar = "<img src='$directory_self/images/default_avatar.gif' height='50px' width='50px' />";
}else{
$avatar = "<img src='$directory_self/photos/$usernamestatus/$avatar_url' height='50px' width='50px' />";
}
echo '<div id="content">';
echo "<br />";
echo $avatar;
echo "<a href=\"profile.php?id=$status_userid\">". $usernamestatus ."</a>";
echo "<br />";
  $status = str_replace(array_keys($bbcode), array_values($bbcode), $status);
echo $status;
if($userid == $status_userid){
echo " <span class=x><a href=delete_status.php?id=$status_id>x</a></span>";
}
echo "<br />";
echo format_date($time_posted);
echo "<br />";
echo "<br />";
?>
<div id="like<?php echo"$status_id"; ?>"><a href="#" style="text-decoration: none" class="like" id="<?php echo"$status_id"; ?>"><span class="like_b"> <?php echo LANG_LIKE; ?> </span></a></div>
  <div id="unlike<?php echo"$status_id"; ?>" style="display:none"><span class="youlike_b"> <?php echo"$user"; echo  LANG_LIKES_THIS; ?> </span><a href="#" class="unlike" id="<?php echo"$status_id"; ?>"><span class="unlike_b"> <?php echo LANG_UNLIKE; ?> </span></a></div>
<?php
echo "</div>";
}
}
?>
Is there a way to shorten this code and make it run faster, without as many queries?
Cheers

Here's the code, I had used the query in the header, and now I'm using it to display the links in a table. What happens is that it only returns the first row and not the second third or fourth rows. When it does display the first row, it'll display it a lot of times. Here it is

Code: [Select]
<?php
    if($_GET['place']==addnetwork){
        //display current networks 
        echo "<table border=1>";
        echo "<tr><td>Network Name</td><td>URL</td></tr>";
        
        while ($query1 = mysql_fetch_assoc(mysql_query("select name,url from s_links"))) {
            $networkname = $query1['name'];
            $networkurl = $query1['url'];

            
            echo "<tr><td>$networkname</td><td>$networkurl</td></tr>";
            
        }
        echo "</table>";
    }
?>

I created the code below and it outputs the following number output:
1111111773526604115551144611337112281111221111345 6789101121111100352004110051100611007110081100221 1003456789101141111100352004110051100611007110081 1002211003456789101151111100352004110051100611007 1100811002211003456789101123111110035200411005110 06110071100811002211003456789101134
Anyways if you look at the code, I need to be able to add the values on a single colony, idcol, with the same type and subtype, btid/stid, generated as the $prod variable. buildings with the same subtype generate the same resource, in this case, several iron mines and a single copper mine are present, but there are also 9 other types of resource buildings. How do I collect on the prods which go together?
Code: [Select]
<?php
$dbhost = 'localhost:3306';
$dbuser = 'lordofth_aos';
$dbpass = 'flarge';
$dbname = 'lordofth_aos';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error connecting to mysql');
mysql_select_db($dbname);
$query="SELECT id FROM users";
$result=mysql_query($query);
$num=mysql_num_rows($result);
$i=0;
$idn=1;
while($i<$num){
$queryii="SELECT idcol FROM colony WHERE id=$idn";
$resultii=mysql_query($queryii);
$numt=mysql_num_rows($resultii);
$id=mysql_result($result, $i);
echo $id;
$ii=0;
$ibt=1;
while($ii<$numt){
$querypty="SELECT btid FROM ptypes WHERE btid=$ibt";
$resultpty=mysql_query($querypty);
$numpty=mysql_num_rows($resultpty);
$idcol=mysql_result($resultii, $ii);
echo $idcol;
$bt=0;
$btid=mysql_result($resultpty, $bt);
echo $btid;
$bte=1;
while($bt<$numpty){
$querystid="SELECT stid FROM ptypes WHERE stid=$bte";
$resultstid=mysql_query($querystid);
$numstid=mysql_num_rows($resultstid);
$st=0;
$stid=mysql_result($resultstid, $st);
echo $stid;
$ste=1;
while($st<$numstid){
$bidum=0;
$querybpid="SELECT bpid FROM blueprints WHERE btid=$btid AND stid=$stid";
$resultbpid=mysql_query($querybpid);
$numbpid=mysql_num_rows($resultbpid);
while($bidum<$numbpid){
$bidumb=0;
$bidumbg=mysql_result($resultbpid, $bidum, 'bpid');
echo $bidumbg;
$querybid="SELECT COUNT(bid) AS count, workers, efficiency 
FROM buildings
INNER JOIN blueprints ON buildings.bpid=blueprints.bpid
WHERE blueprints.btid=$btid AND blueprints.stid=$stid AND buildings.bpid=$bidumbg AND buildings.idcol=$idcol";
$resultbid=mysql_query($querybid);
$staff=mysql_result($resultbid, $bidumb, 'workers');
$effic=mysql_result($resultbid, $bidumb, 'efficiency');
$count=mysql_result($resultbid, $bidumb, 'count');
echo $staff;
echo $effic;
echo $count;
$prod=$staff*$effic*$count;
echo $prod;
$bidumb++;
$bidum++;
}
$st++;
$ste++;
}
$bt++;
$bte++;
}
$ii++;
}
$i++;
$idn++;
}
?>

i am sorry for this reason English is bad
I want to use two nested loops ( while )
Once the model code will loop
as in the picture will come under the colors of the model and the model code

1.while only model result
2. while it is of colors and unit
after
exit loop next code

Code: [Select]
<table width="376" cellspacing="0"  class="stats" width:100%>
  <tr>
   
    <td colspan="9" align="center"><?php echo $secim ?></td>
  </tr>
  <?php 
   while(odbc_fetch_into($sql_result, &$row)) { 
   $unit1 = floor($row[3]); 
   $unit2 = floor($row[4]); 
   $unit3 = floor($row[5]); 
   $unit4 = floor($row[6]); 
   $unit5 = floor($row[7]); 
    ?>
    <tr>
      <td colspan="2" align="left" valign="top"><?php echo"$row[0]";?></td>
      <td>36</td>
      <td>38</td>
      <td>40</td>
      <td>42</td>
      <td>44</td>
    </tr>
    <tr>       
       <td width="114" align="right" valign="top"><img src= <?php echo"images/Resize/$row[2]"?>></td>
  <?php //this table block 
1.while only model 
2. while it is of colors and unit 
after
exit loop
?>
       <td width="25" valign="top"><?php echo"$row[1]";?></td>
      <td width="25"valign="top"><?php echo"$unit1";?></td>
       <td width="25"valign="top"><?php echo"$unit2";?></td>
        <td width="25"valign="top"><?php echo"$unit3";?></td>
       <td width="25"valign="top"><?php echo"$unit4";?></td>
       <td width="25"valign="top"><?php echo"$unit5";?></td>
  </tr>
 <?php }  }?>
 <?php  
 odbc_free_result($sql_result); 
 odbc_close($connection); 
 ?>
</table>

Man this is really driving me nuts. I can see my array values with echo inside the loop but outside nothing is shown. What am I missing here? If anything it should show the last value in the loop.

while ($x = mysql_fetch_array($query_name,MYSQL_NUM))
{
echo $x[0];
}
echo $x[0];

Hi all,

I am desperately in need of some help here. I have been troubleshooting these codes for days, and I have posted this similar question quite a couple of times, and there is no answer from anyone... I am really in a bad shape now. Could someone please enlighten me to my problem?

I have created 2 while loops...apparently the 2nd while loop overwrites the 1st while loop record.

Meaning to say...1st while loop generates values of
'Math'
'Eng'
'Chi'
'Sci'
AND store it in $subject_data, createLevelCheckboxes($subject_data, $level_data, 5);

Apparently, the 2nd while loop takes only the last record 'Sci' from $subject_data and continues the looping. Which gives me results like

Level 1
Sci

Level2
Sci

Level3
Sci

I would like to attain something like....
Level 1
Math

Level2
Eng

Level3
Chi

Level4
Sci


Is there any reset which I need to do?



while($data = mysqli_fetch_array($sql)) 
    {
        if($current_level_id != $data['level_id']) 
        {
            $checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);
            $current_level_id = $data['level_id'];
            $subject_data = array();
        }
        //Add the current record to the $level_data array
        $subject_data[] = $data;
    }

while($data1 = mysqli_fetch_array($sql1)) //Iterate throug the DB results
    {

$checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);

$level_data = array();

$level_data[] = $data1;

}
    $checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);

Hello, I am new in php and have made only little so fare. I am trying to make a script, but the script stops. I dont know how loops work.
Quote

<?php
$lenkzeit = 4.5;
$lenkunter = 1;
$ruhezeit1 = 11;
$ruhezeit2 = 9;
$stunden1 = 0;

$km = 1000;
$kmh = 80;

$stunden0 = $km/$kmh;
$stunden01 = $stunden0;

while ($stunden01 > $lenkzeit){
$stunden1 = $stunden1 + $lenkzeit + 1;
$stunden01 = $stunden01 - $lenkzeit;    //Stops here

   if ($stunden01 > $lenkzeit) {
   $stunden1 = $stunden1 + $lenkzeit + $ruhezeit;
   $stunden01 = $stunden01 - $lenkzeit;
   }
}
if ($stunden01 < $lenkzeit) {
$srunden1 = $stunden1 + $stunden01;
$stunden01 = 0;
}
echo $srunden1;
?>

My goal here is to have it foreach group from the DB it'll create a new frameset with the groupName as the legend and then under each of those it will create another foreach for each of the fields inside of that group that has a enabled value of 0 from the db.  Both queries work correctly. I just get trouble writing foreach loops and I'm not sure how this one is going to work out.

Code: [Select]
<?php

session_start(); // Access the existing session

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

$defaultCharID = $_SESSION['defaultCharID'];

$styleIDQuery = "
    SELECT
        characters.styleID
    FROM
        characters
    WHERE
        characters.ID = '" . $defaultCharID . "'";
$styleIDResult = mysqli_query ( $dbc, $styleIDQuery ); // Run The Query
$row = mysqli_fetch_array( $styleIDResult, MYSQL_ASSOC );
$styleID = $row[ 'styleID' ];

$biofieldsQuery = "
    SELECT 
        fields.*,
        groups.* 
    FROM 
        fields 
        INNER JOIN groups 
            ON fields.groupID = groups.ID 
    WHERE 
        groups.styleID = '" . $styleID . "' AND fields.styleID = '" . $styleID . "' AND groups.enabled = 0 AND fields.enabled = 0";
$biofieldsResult = mysqli_query ( $dbc, $biofieldsQuery ); // Run The Query
$row = mysqli_fetch_array( $biofieldsResult, MYSQL_ASSOC );
$groupName = $row[ 'groupName' ];

?>

<script type="text/javascript">
$(document).ready(function() {

});
</script>

<!-- Title -->
<div id="title" class="b2">
<h2>Character Management</h2>
<!-- TitleActions -->
<div id="titleActions">
<!-- ListSearch -->
<div class="listSearch actionBlock">
<div class="search">
<label for="search">Recherche</label>
<input type="text" name="search" id="search" class="text" />
</div>
<div class="submit">
<button type="submit" id="search-button" class="button"><strong><img src="img/icons/search_48.png" alt="comments" class="icon "/></strong></button>
</div>
</div>
<!-- /ListSearch -->
</div>
<!-- /TitleActions -->
</div>
<!-- Title -->

<!-- Inner Content -->
<div id="innerContent">

    <form action="#" id="bioForm" >
    <fieldset>
    <legend><?php echo $groupName; ?></legend>
            <div class="field required">
    <label for="matchType">Match Type Name</label>
    <input type="text" class="text" name="matchType" id="matchType" title="Match Type Name"/>
    <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>
            <input type="submit" class="submit" name="submitMatchType" id="submitMatchType" title="Submit Match Type" value="Submit Match Type"/>
    </fieldset>
    </form>

</div>
<!-- /Inner Content -->

I know this function will get one result, I suspect foreach is the wrong loop to use,  should I be using a loop at all? Can someone correct me please.

 

public function getSites($site) {
		$sql = "SELECT * FROM website WHERE website_id = ?";
		$stmt = $this->connect()->prepare($sql);
		$stmt->execute($site)
		$siten = $stmt->fetch();
			
		foreach ($siten as $row) {
			$title = $row["website_title"];
			$wname = $row["website_name"];
			$image1 = "header.jpg";
			$metadesc = $row["website_description"];	
			$wurl = $row["website_url"];
			$gtag = $row["website_gtag"];
			$gmap = $row["website_map"];
			$wcss = $row["website_css"];
		}
	}

 

Edited February 23 by guymclarenza