PHP - If Statement Inside Of A While Loop

I am wondering if it is possible to create 2 queries, and use 1 while statement?
Something like:

Code: [Select]
while (($row = mysql_fetch_array($rs_getevent)) && ($row = mysql_fetch_array($rs_getevent2))) {
Is something like this possible?

Hello guys im new to php i been coding for like a week now, i  need some help here i have been stuck for like 6 hours XD,is it possible to write an IF Statement inside an echo?


//this is what i want to do 
// echo a table and a delete button
// and if you click on the delete button it echoes out "DELETED"


echo "

<table width='528px'>
<tr>
<td>
</td>
<td>
<center><font size='5'>$tittle</font></center><br>
</td>
</tr>
<tr>
<td>
</td>
<td>
$message
</td>
</tr>
<tr>
<td>
</td>
<td>
<font size='1'>Posted By:<font color='green'>$author</font> on <font color='gray'>$date</font> at <font color='gray'>$time</font></font>
<input id='delete' name='delete' type='submit' value='Delete' >

 if ($_POST['delete']) {  echo "DELETED";     } 


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

";

Hi everyone.

i'm trying to write an if statement for several scenerios
1. if the date entered in '$DateDue' is overdue, meaning greater than todays date, then display the word 'Late'.
2. if the date entered in '$DateDue' is not yet past, meaning its greater than todays date, then display the word 'ok'.
3. if the date entered in '$DateDue' is within a week of todays date, then display the word 'warning'

the code snippet below is my partial script. it runs perfectly without embedding the 'php if statement' on the first td row. So my problems a
1. how to embed a php if statement in table results and
2. have OK, LATE or WARNING to be displayed based on if $DateDue expires or not.
there are no errors in the code below, it just echos the line '<?php if ($DataDue > CURDATE()) {echo "OK";} elseif ($DateDue < CURDATE()) {echo "LATE";} else {echo "Warning";}?>' instead of displaying OK, LATE or Warning.

I'd appreciate any assistance you could provide. thanks.

Code: [Select]
           
// echo out the contents of each row into a table
echo "<tr>";
echo '<td nowrap><?php if ($DataDue > CURDATE()) {echo "OK";} elseif ($DateDue < CURDATE()) {echo "LATE";} else {echo "Warning";}?>' . mysql_result($result, $i, 'DateDue') . '</td>';
echo '<td nowrap>' . mysql_result($result, $i, 'Description') . '</td>';
echo '<td nowrap>' . mysql_result($result, $i, 'CompanyName') . '</td>';   
echo "</tr>";

I am trying to create a daily event listing.

The list will have Day & Date as the heading. Then it will list the events ORDERED BY the time.

First thing I'd like to do is skip or not show the days that do not have an event.
Ex.
Monday, January 23, 2012
7am event
8am event
6pm event

since Tuesday has no events, I'd like tuesday to not be in the list, but if the next tuesday has an event It'll need be visible.
Tuesday, January 24, 2012
(No events)

Wednesday, January 25, 2012
9am event
12 pm event
8pm event

The 2nd thing I'd like to do is If a particular day and time has more than one event, I'd like the time to show once and then list the events.
ex.
Monday, January 23, 2012
7am event
        event
        event
8am event
6pm event


Here's the code: since the listing is for a range of 7 days I've only included 3 days worth of code. I've include the mysql_statements for pulling the information as well as the php code to show how it's being rendered and placed.  HTML excluded.

Code: [Select]
<?php
//TODAY
$today2 = date('l, F j, Y');//php to format date

$today_rehearsals = mysql_query(" SELECT Id, date, time, title, campus, room, ministry, category FROM events
     LEFT JOIN dates on events.dateId=dates.dateId
     LEFT JOIN time ON events.timeId=time.timeId
     LEFT JOIN campus ON events.campusId=campus.campusId
     LEFT JOIN rooms ON events.roomId=rooms.roomIdLEFT JOIN ministries on events.ministryId=ministries.ministryId
     LEFT JOIN category on events.categoryId=category.categoryIdWHERE ministry='music' AND date='$today' OR category='music' AND date='$today'            
     ORDER By date, time")

//////DAY  ONE
$day1= mktime(0,0,0, date("m"), date("d")+1, date("Y")); //php to get current date and add 1 day
$day_1 = date("l, F j, Y", $day1); //php to format date

$day1_rehearsal = mysql_query("SELECT Id, date, time, title, campus, room, ministry, category FROM events 
     LEFT JOIN dates ON events.dateId=dates.dateIdLEFT JOIN time ON events.timeId=time.timeId
     LEFT JOIN campus ON events.campusId=campus.campusId
     LEFT JOIN rooms ON events.roomId=rooms.roomId
     LEFT JOIN ministries ON events.ministryId=ministries.ministryId
     LEFT JOIN category ON events.categoryId=category.categoryId
     WHERE ministry='music' AND date=CURDATE()+1 OR category='music' AND date=CURDATE()+1 ORDER BY time" ) or die(mysql_error());

/////DAY 2
$day2= mktime(0,0,0, date("m"), date("d")+2, date("Y")); //php to get current date and add 2 days
$day_2 = date("l, F j, Y", $day2); //php to format date

$day2_rehearsal = mysql_query("SELECT Id, date, time, title, campus, room, ministry, category FROM events 
     LEFT JOIN dates ON events.dateId=dates.dateIdLEFT JOIN time ON events.timeId=time.timeId
     LEFT JOIN campus ON events.campusId=campus.campusId
     LEFT JOIN rooms ON events.roomId=rooms.roomId
     LEFT JOIN ministries ON events.ministryId=ministries.ministryId
     LEFT JOIN category ON events.categoryId=category.categoryId
     WHERE ministry='music' AND date=CURDATE()+2 OR category='music' AND date=CURDATE()+2 ORDER By time")or die(mysql_error()); 



////TODAY
echo "$today2"; //renders Today's date 
    
     while($row = mysql_fetch_array( $today_rehearsals )){ 
          $time=date_create($row['time']);//grab time for db          
          $for_time=date_format($time, 'g:i a');//format time for viewing on page   

           echo "$for_time";           
           echo $row['title'];           
           echo $row['campus'] . " " . $row['room'];    
     }


////day1
echo "$day_1"; //renders day_1's (tomorrow's) date

     while($row = mysql_fetch_array( $day1_rehearsal )){ 
          $time=date_create($row['time']);//grab time for db         
          $for_time=date_format($time, 'g:i a');//format time for viewing on page
                          
          echo "$for_time";          
          echo $row['title'];          
          echo $row['campus'] . " " . $row['room'];
          }

////day2
echo "$day_2"; //renders day_2's (day after tommorrow) date

     while($row = mysql_fetch_array( $day2_rehearsal )){                      
         $time=date_create($row['time']);//grab time for db
         $for_time=date_format($time, 'g:i a');//format time for viewing on page                                     

          echo "$for_time"; 
          echo $row['title'];
          echo $row['campus'] . " " . $row['room'];
          }

MOD EDIT: code tags fixed . . .

I have a bunch of checkboxes I am pulling from a database, like so.
Code: [Select]
<?$true_query = mssql_query("SELECT * FROM checkbox_datbase ORDER BY ID ASC");
                  while ($true_row = mssql_fetch_assoc($true_query))
                  {
                  $eth_id = $true_row['ID'];
                  $eth_name = $true_row['Value'];
                  echo "<input type=\"checkbox\" name=\"eth_$eth_id\" value=\"1\" class=\"input\" id=\"Ethnic_01\"/>$eth_name <br />";
                  }
?>How do I put these into a database that I have settup where it needs to match up with a userid. I am trying to do this, and can get it to look correctly by echoing out the various parts, but I can't put while loops into a variable, right? So how would I get all of this into one line in my $sql variable?

Code: [Select]
echo "INSERT INTO new_database (UserId,";
                  $true_query = mssql_query("SELECT * FROM checkbox_datbase ORDER BY ID ASC");
                  while ($true_row = mssql_fetch_assoc($true_query))
                  {
                  $eth_id = $true_row['ID'];
                  $eth_eth_id = $_POST['eth_' . $eth_id . ''];
                       echo " $eth_id, ";
                      }
                      echo "DateUpdated) VALUES ('$user_ID', ";
                     
                    $true_query = mssql_query("SELECT * FROM checkbox_datbase ORDER BY ID ASC");
                  while ($true_row = mssql_fetch_assoc($true_query))
                  {
                  $eth_id = $true_row['ID'];
                  $eth_eth_id = $_POST['eth_' . $eth_id . ''];
                       echo "'$eth_eth_id', ";
                      }
                     echo "'$currenttime')";
This echoes something that looks like this
INSERT INTO user_ethnicity (UserId, 1, 2, 3, 4, 5, 6, 7, 8, DateUpdated) VALUES ('', '', '', '', '', '', '', '', '', '2012-01-23 13:24:18 PM')
, which I need the actual statement to be
$sql = "INSERT INTO user_ethnicity (UserId, 1, 2, 3, 4, 5, 6, 7, 8, DateUpdated) VALUES ('259', '', '', '1', '', '1', '', '', '', '2012-01-23 13:24:18 PM')";

Can anyone help me with this?

Hey guys!

Im trying to setup an IF statement on my home page.

Its purpose is to show EITHER a login form and state your not logged in if it cannot find a stored cookie OR if it does find a stored cookie it will NOT show the HTML form and state you are logged in.

I have it mostly working apart from the fact Im not sure how to insert a HTML form into PHP IF statement and make it work. Since I dont want the user to see the login form when they are already logged in.

Here is a link to the php script: http://pastebin.com/aenq4gbE

Here is link to the live page: http://jfbsystems.co.uk/secure

Any help or ideas would be much appreciated!

JellyFishBoy

Hi I am new to PHP and this is my first post one here so appologies is this questions seems a bit dumb!

I have an if clause such that if a button is pressed on my web page then i want to reload the page and include a new form on it.

I am having a problem getting the $_SERVER['PHP_SELF'] command to work from iside a echo command. I must not be escaping the code correctly with back slashes:

I currently have the line :

 
echo"<form method=\"POST\" action=\"\<?$_SERVER['PHP_SELF']?\>\">";


However this doesnt seem to work as my page just doesnt display in the browser.

Any advice is much appreciated.

Thanks for taking the time to read.

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!

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

Hi

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

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;

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?

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.

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