PHP - Problem With Else If Inside While Statement

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?

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.

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

Well I guess I'll jump right into the code..


The function:
function isIpaddr ($ipaddr)
{
if (ereg("^([0-9]{1,3}).([0-9]{1,3}).([0-9]{1,3}).([0-9]{1,3})$", $ipaddr, $digit))
{
if (($digit[1] <= 255) && ($digit[2] <= 255) && ($digit[3] <= 255) && ($digit[4] <= 255))
{
return TRUE;
}
}

return FALSE;
}

The loop and IF statement:
if($_POST['submit_multiple']) {
$SubmittedIPs = split("[\n|\r|,|-]", $_POST['IPAddresses']);
foreach($SubmittedIPs as $IP) {
trim($IP);
if(isIpaddr($IP)) {
echo $IP." = ".gethostbyaddr($IP)."<br />";
} else {
echo "Invalid IP Address<br />";
}
}
}


There's my relevant code..

Now the only problem so far is that I am getting this:
Quote

12.34.56.78 = 12-34-56-78.test.hostname.com
Invalid IP Address
12.34.56.78 = 12-34-56-78.test.hostname.com
Invalid IP Address
12.34.56.78 = 12-34-56-78.test.hostname.com

(The IPs and Hostnames are obviously fake..)

The problem is that they are valid IP addresses and I've done a few checks to see what's wrong. I've checked the array and it is working fine by splitting up a textbox into an array of IPs and the IPs are fine inside the array. I then tested the script by echoing the output of just the function with each IP, I got all "1"s (TRUE).

I just can't figure out why it's displaying both parts of the if statement..

Thanks for any help!

Hi im new to this site so i hope this is in the right place,my table goes green when i try to say less than 14 but when i use greater the code looks ok  ,its works by itself but im using five similar else if statements for different ages(teacher doesnt want functions used yet) can anyone please help ???
Code: [Select]
else if($myAge >9 || $myage <14)
{
echo"<table width='500' border='0' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'>";
echo"<tr>";
echo"<td>";
echo"<table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#FFFFFF'>";
echo"<tr>";
echo"<td colspan='3'><h3><strong>Sports Catagory</h3></strong></td>";
echo"</tr>";
echo"<tr>";
echo"<td><hr></td>";
echo"</tr>";
echo"<tr>";
echo"<td> ".$username."  a-zA-z</td>";
echo"</tr>";
echo"<tr>";
echo"<td> ".$password." 0-9</td>";
echo"</tr>";
echo"<tr>";
echo"<td>Invalid data entered, please re-enter the data correctly</td>";
echo"</tr>";
echo"<tr>";
echo"</tr>";
echo "<tr>";
echo "<td><a href = '".$self."'> Back to Form </a></td>";
echo "</tr>";
echo "</table>";
echo"</td>";
echo"</tr>";
echo"</table>";
}

I have a series of PHP files that are referenced in index.php like this:
<?php
include("credentials.inc");
    $cxn = mysqli_connect($host, $user, $password, $dbname) 
               or die ("Connection failed.");
    include('header.php');
    include('menu.php');
    include('contact.php');
    include('home.php'); ?> 

One of my files, menu.php, brings up a JavaScript menu that was coded in Dreamweaver (yes, I cheated). However, it seems to get to the first "for" statement and stops. I can't work out what I've done wrong.

<?php
$h1 = mysqli_query($cxn, "SELECT areaID, area FROM area ORDER BY areaID");

echo("<ul id='MenuBar1' class='MenuBarHorizontal'>");
echo("<li><a href='index.php'>HOME</a></li>");
echo("<li><a href='#' class='MenuBarItemSubmenu'>PRODUCTS</a><ul>");

for ($a=0;$a<=count($h1);$a++) {
echo("<li><a href='#' class='MenuBarItemSubmenu'>".$h1[$a]['area']."</a><ul>");

$h2 = mysqli_query($cxn, "SELECT catID, category, areaID, link FROM category WHERE areaID = '".$h1[$a]['areaID']."' ORDER BY catID");

for ($b=0;$b<count($h2);$b++) {
    echo("<li><a href='".$h2[$b]['link']."'>".$h2[$b]['category']."</a></li>");
}
echo("</ul></li>");
}
echo("</ul></li>");
echo("<li><a href='services.php'>SERVICES</a></li>");
echo("<li><a href='aboutus.php'>ABOUT US</a></li>");
echo("<li><a href='contact.php'>CONTACT</a></li></ul>");

?>

Hopefully someone has an idea of where the problem is. Thanks so much in advance!

So basically I've been experimenting with setting cookies and sessions. The code in my header file will display a login if there is no $_SESSION['username']. However, the else statement verifies that there is, and echo's "hello." My problem lies in the else statement, when the login form disappears, but nothing in the else statement appears. Here's the code, I feel like I am missing something obvious.

Code: [Select]
<?php
if (!isset($_SESSION['username'])){
 echo "<li><a href='register.php'>Register</a></li>";
 echo "</ul>";
  echo "
    <table>  
    <tr>
    <form name='login' method='post' action='login.php'>
    <tr><td>Username</td> <td><input type='text' name='username'></td></tr>
    <tr><td>Password</td> <td><input type='password' name='password'></td></tr>
    <tr><td><input type='submit' name='submit' value='Login'></td></tr>
    <tr><td><input type='checkbox' name='rememberme' value='remember'> Remember</td></tr>
    </form>
    </table>
";
}else{
echo "hello";
}

?>

Thanks in advance

I am creating a class alumni web and ask a question tha requires selecting one of 3 radio buttons. If the user selects the 3rd button, I want to display an additional field.

Here is the lines of code:

<label>Are you or your spouse a Taft Class of 1965 alumni?</label>
<input type="radio" id="alumni" value=1 checked><label>yes</label>
<input type="radio" id="alumni" value=2><label>no</label>
<br>
<label>Are you a graduate of Taft Union High School?</label>
<input type="radio" id="alumni" value=3><label>yes</label>
      Error  ---> <?php
// If alumni is equal to 3 display the input field
  If ($ans == 3);{
    Echo "<input type='int' id='gradClass' size='4' maxlenght='4' placeholder='1977'>"
  }
?>
    <br>
<hr>
<br>
<span class="subheader">PRIVACY</span>
<br>


And I didn't forget a ' this time.

Could someone please assist. Thanks in advance.

My code is as follows
<?php
// Include the Sessions options
require_once('inc/session_admin.inc.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Change Record form</title>
<style type="text/css">
td {font-family: tahoma, arial, verdana; font-size: 10pt }
</style>


</head>
<body bgcolor="#64b1ff">
<div align="center">
<?php
echo '<p>Hello <b>' .($_SESSION['username']) .'</b> <a href="logging_out.php">Logout</a></p>';

$Username=$_POST['Username'];

if ($Username = $Username)
{
// Include connecting to the database
require_once('inc/connect_to_users_db.inc.php');

$query=" SELECT * FROM userinfo WHERE Username='$Username'";
$result=mysql_query($query);
$num=mysql_num_rows($result);

$i=0;
while ($i < $num) {
$FirstName=mysql_result($result,$i,"FirstName");
$LastName=mysql_result($result,$i,"LastName");
$Address1=mysql_result($result,$i,"Address1");
$Address2=mysql_result($result,$i,"Address2");
$Address2=mysql_result($result,$i,"Address2");
$Address3=mysql_result($result,$i,"Address3");
$Gender=mysql_result($result,$i,"Gender");
$Country=mysql_result($result,$i,"Country");
$MobileNumber=mysql_result($result,$i,"MobileNumber");
$EmailAddress=mysql_result($result,$i,"EmailAddress");
?>
<table width="300" cellpadding="5" cellspacing="0" border="1">
<tr align="center" valign="top">
<td align="center" colspan="1" rowspan="1" bgcolor="#64b1ff">
<h3>Edit and Submit</h3>
<form method="post" action="update_a_user_script.php">
<input type="hidden" name="update_a_user_script" value="<?php echo "$Username" ?>" />
<table cellpadding="0" cellspacing="0"  border="0">
<tr align="center" valign="top">
<td>Username:</td>
<td><input type="text" name="Username" readonly="readonly" value="<?php echo "$Username" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>First Name:</td>
<td><input type="text" name="FirstName" value="<?php echo "$FirstName" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Last Name:</td>
<td><input type="text" name="LastName" value="<?php echo "$LastName" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Address:</td>
<td><input type="text" name="Address1" value="<?php echo "$Address1" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>&nbsp;</td>
<td><input type="text" name="Address2" value="<?php echo "$Address2" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>&nbsp;</td>
<td><input type="text" name="Address3" value="<?php echo "$Address3" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Gender:</td>
<td><input type="text" name="Gender" value="<?php echo "$Gender" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Country:</td>
<td><input type="text" name="Country" value="<?php echo "$Country" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>MobileNumber:</td>
<td><input type="text" name="MobileNumber" value="<?php echo "$MobileNumber" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Email Address:</td>
<td><input type="text" name="EmailAddress" value="<?php echo "$EmailAddress" ?>" /></td>
</tr>
</table>
<input type="submit" value="Update" />
</form>
<form method="post" action="update_a_user_form.php">
<input type="submit" value="Update a Different Record" />
</form>
<form method="post" action="display_users.php">
<input type="submit" value="List all users" />
</form>
<form method="post" action="index.php">
<input type="submit" value="Administrator Interface" />
</form>
</td></tr></table>
<?php
++$i;
}
?>
<?php
}
else
{
echo 'Username not found!. Please try again';
?>
<table width="300" cellpadding="5" cellspacing="0" border="2">
<tr align="center" valign="top">
<td align="left" colspan="1" rowspan="1" bgcolor="#64b1ff">
<h3>Insert Username</h3>
<form method="post" action="update_a_user_form2.php">
Enter Username: <input type="text" name="Username" size="30" /><br />
<br />
<input type="submit" value="Submit" /><input type="reset" />
</form>
<form method="post" action="index.php">
<input type="submit" value="Administrator Interface" />
</form>
</td>
</tr>
</table>
<?php
}
?>
</div>
</body>
</html>
It will display what it's meant to display if I have a username that is in the database, however if the username doesn't exist in the database, it's meant to say "Username not found!. Please try again" and show the search box again. However if I put in a Username that doesn't exist. I get a blank page (well at the top of the page the page I do get Hello Howlin1 Logout)

What am I doing wrong?

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=350701.0

How do I fix this For Each statement when used with preg match?

//Cat_ID  &  Category Name
preg_match_all('%<a[^href=]*href=\"\/cats\.asp\?cat_id=(.*?)\" title="(.*?)">%',$data,$matches1,PREG_SET_ORDER);  // works fine 
preg_match_all('%/60/(.*?).jpg"%s',$data,$matches2,PREG_SET_ORDER); // works fine
preg_match_all('%h3><p>(.*?)<\/p>%s',$data,$matches3,PREG_SET_ORDER); // works fine

foreach ($matches1 as $val) {        //need help here
$subcat_id=$val[0][1];
$subcat=$val[0][2];
$cat_image=$val[1][1];
$cat_desc=$val[2][1];



Thanks for your help!!!

I have got a set of data for a country for each week of the year, but want to display the data a quarter at a time, using a form which posts a value into LIMIT, which was OK for the 1st quarter, but for subsequent quarters I needed to use LIMIT in the form LIMIT start, rows. I found by experiment that this had to be the last statement in the query. when I added the start I got an error: Parse error: syntax error, unexpected ',' in /homepages/43/d344817611/htdocs/Admin/Visitdata.php on line 10 Here is the SQL part of my code:

$Visit_data="SELECT WeekNo.WNo, WeekNo.WCom, Countries.Country, ctryvisits.CVisits FROM ctryvisits 
LEFT JOIN Countries
ON ctryvisits.country=Countries.CID
LEFT JOIN WeekNo
      ON ctryvisits.WNo=WeekNo.WNo
      WHERE Countries.Country = '".$_POST["Country"]."'
ORDER BY ctryvisits.WNo LIMIT '".$_POST["QUARTER"]."'" - 13, '".$_POST["QUARTER"]."'";

Is this the best way of doing what I require or is there an easier way of achieving what I want?

Hi everybody
i am beginnet with working with sql in php..so i confused.....i made one scripte and i am making the secound and now i am facing a problem....i hope u could help!!
i have a dat=abse of my chatroom....this is the code i typed...please have a look at it!
Code: [Select]
$usern=$_SESSION['etchat_'.$this->_prefix.'username'];
$con1 = mysql_connect("localhost","manosir_main","********");
if (!$con1)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("manosir_manoshos_main", $con1);
$users= mysql_query(" select etchat_user_online_user_sex  from db1_etchat_useronline where etchat_user_online_user_name = $usern ");


 
in my database, i ahve a table called db1_etchat_useronline that keeps record of online users in chatroom.
as u usee i qant to to get the user sex ( etchat_user_online_user_sex) of th current user!!! as u see i conected to database correctly but now i dont know how to echo the $users . before this i echo my sql results with mysql_fetch_array ..but  now i cant.......i got nothing!!!! can someone help me!!!!!