PHP - Loop Through Mysql Table And Perform Action On Row And Previous Row Field Php

Hi, when I submit a form I want to update a field in the "daterange" table.  In the form the id field (RID) from "daterange" is selected prior to submit.  Basically, I want to change the STATUS field to B (from A).

The structure of daterange table is as follows:

RID (key field)
DEND
MONTH
DATE
SITE
PRICE
STATUS

What is the easiest way to accomplish this?

Here is the code from the form (if it will help)...
Code: [Select]
<?php
//**************************************
//     Page load dropdown results     //
//**************************************
function getTierOne()
{
$result = mysql_query("SELECT DISTINCT MONTH FROM daterange") 
or die(mysql_error());

  while($tier = mysql_fetch_array( $result )) 
  
{
   echo '<option value="'.$tier['MONTH'].'">'.$tier['MONTH'].'</option>';
}

}

//**************************************
//     First selection results     //
//**************************************
if($_GET['func'] == "drop_1" && isset($_GET['func'])) { 
   drop_1($_GET['drop_var']); 
}

function drop_1($drop_var)
{  
    include_once('db.php');
$result = mysql_query("SELECT * FROM daterange WHERE DEND > DATE(NOW()) AND STATUS='A' AND MONTH='$drop_var' ORDER BY DATE, SITE")
or die(mysql_error());

echo '<select name="RID">
      <option value=" " disabled="disabled" selected="selected">Choose a Reservation</option>';

   while($drop_2 = mysql_fetch_array( $result )) 
 
{
 echo '<option value="'.$drop_2['RID'].'">'.$drop_2 ['DATE']. ', '.$drop_2 ['SITE']. ', '.$drop_2 ['PRICE'].'</option>';
}

echo '</select> ';

echo "<br />";

echo "</select><p align=left><label><font size=\"2\" face=\"Arial\">First Name: <input type=\"text\" name=\"FNAME\" size=\"50\" maxlength=\"50\" tabindex=\"1\"<br />";

echo "<p align=left><label>Last Name: <input type=\"text\" name=\"LNAME\" size=\"50\" maxlength=\"50\" tabindex=\"2\"<br />";

echo "<p align=left><label>Address Line 1: <input type=\"text\" name=\"ADDR1\" size=\"50\" maxlength=\"50\" tabindex=\"3\"<br />";

echo "<p align=left><label>Address Line 2: <input type=\"text\" name=\"ADDR2\" size=\"50\" maxlength=\"50\" tabindex=\"4\"<br />";

echo "<p align=left><label>City: <input type=\"text\" name=\"CITY\" size=\"50\" maxlength=\"50\" tabindex=\"5\"<br />";

echo "<p align=left><label>State (abbrev.): <input type=\"text\" name=\"STATE\" size=\"2\" maxlength=\"2\" tabindex=\"6\"<br />";

echo "<p align=left><label>Zip Code: <input type=\"text\" name=\"ZIP\" size=\"5\" maxlength=\"5\" tabindex=\"7\"<br />";

echo "<p align=left><label>Contact Phone Number: (<input type=\"text\" name=\"PHONE1\" size=\"3\" maxlength=\"3\" tabindex=\"8\"";
echo "<label>)<input type=\"text\" name=\"PHONE2\" size=\"3\" maxlength=\"3\" tabindex=\"9\"";
echo "<label>-<input type=\"text\" name=\"PHONE3\" size=\"4\" maxlength=\"4\" tabindex=\"10\"<br />";

echo "<p align=left><label>Email: <input type=\"text\" name=\"EMAIL\" size=\"50\" maxlength=\"50\" tabindex=\"11\"<br />";
echo '<input type="submit" name="submit" value="Book Now!" /><br />';
echo '<input type="reset" name="submit" value="Reset" /><br />';
}
?>

I'm trying to create a search form where members of a site can search other members whose user information is stored in a mysql database.  One of the search parameters is gender which searches for records from a column in the database called gender where members can either have the value "man" or "woman".  The user can choose between 3 options from a pull down menu named gender (man, woman, both).  Then I'm thinking about using a select query to search the database upon submission of the form, which goes something like this:
Code: [Select]

$sql= SELECT* FROM members WHERE gender ='{$_POST['gender']}' ;

Now I can easily assign the value "man" for the option man in the pull down menu and "woman for the option woman, to match their corresponding names in the database.  The problem lies with the "both" option which has to be either man or woman.  I'm thinking about assigning it the value "man OR woman" so that when the form is submitted, the query would read: SELECT*FROM members WHERE gender ='{$_POST[man OR woman']};
I just don't know if this would be a right usage of the OR keyword and if such a query would work.  Before trying it out, I'd like to know if this makes any sense and if not, what's an alternative way to work around this?

Hi,

I'm trying to get a number of different keywords from many table fields, and i want to count them according to the occurrence of each keyword, so it should be like (keyword1 occurred 10 times for example ).

the problem is when i use count in for loop:
 
Code: [Select]

      $tags = explode("|", $row[0]);
     $i=1;
$count = 0;
for($i; $i<count($tags); $i++){
    print "$count {$tags[$i]}<br />";
    $count++;
}
   
it counts the occurrence of key words in each field separately from the rest (i.e.

Code: [Select]
0 day
1 night

0sun
1 moon

0 clouds
1 rain

)

2 keywords in each field (some other fields got more).

I want the count to be more like:
Code: [Select]
1 day
2 night

3 sun
4 moon

5 clouds
6 rain

thanks

Here is one part of php code. Here I try to show in last 1 month which dates exactly user made orders. When I run the SQL code in command prompt it works. I think problem is in while loop.

Thanks beforhand for contribution.


$query = "SELECT Date FROM orders WHERE User='$username' and DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= Date;";
$result = mysql_query($query,$link_id) or die (mysql_error());

echo "<table border='1'>
        <tr>
          <td>&nbsp;Last 1 month's orders:</td>
        </tr>";
   
      while($order_date = mysql_fetch_row($result)) {
        echo "<tr>";
          echo "<td>" . $order_date[0] . "</td>";
        echo "</tr>";
      }
     
      echo "</table>

I am trying to place a unique number into a mysql table.

Currently, my code generates a random number, then is supposed to scan through the table for that number.
If the code finds that number already in the table, it generates a new random number and repeats the process.
I have commented my code for the purpose of this help forum:

Code: [Select]
        $result = mysqli_query($link,"SELECT * FROM testTable");

do
{
$end = true; //prepares end of loop
$idNum = rand(1,10); //rand(1,999999);  <-- for testing purposes I have reduced the number generated
$idNumTx = (string)$idNum;

                //loop through the rows
while ($row = mysqli_fetch_assoc($result))
{
if ($row['idNum'] = $idNum) //check if the random number equal to this row
{
$end = false; //prep end of loop repeat
echo $idNumTx; //display rand number that failed for testing purposes
echo " NO! "; //display error for testing purposes
}
}
} while(!$end);

I know I must be doing something wrong, as when I run this, it runs the if statement within the while loop always executes, and I get an output like:
Code: [Select]
1 NO! 1 NO! 1 NO! 1 NO! 1 NO! 1 NO! 5 Win

Win is when it places the value before it, in this case 5, into the table. However, the value of 5 might already be in the table and it doesn't seem to matter.
I execute the code multiple times, and it seems to increase the number of "# NO!" almost (but not every) time. However, each time ALL of the "# NO!" are the same #, and the "# Win" just seems to be random (as it should be, but not unique).

Checking the table after shows me random numbers between 1 and 10 (as it should) in the correct field, but the are not unique. (Ex/ Both row 1 and 5 could have the same value, say 6)

I'm hopefully doing something simple wrong, so someone please point it out to me

Hello, my name Rustam, do the work - PHP MySQL JS jQuery and Yii framework. Quickly.

This is my first real jump into PHP, I created a small script a few years ago but have not touched it since (or any other programming for that matter), so I'm not sure how to start this.

I need a script that I can run once a day through cron and take the date from one table/filed and insert it into a different table/field, converting the human readable date to a Unix date.

Table Name: Ads
Field: endtime_value (human readable date)

to

Table Name: Node
Field: auto_expire (Converted to Unix time)

Both use a field named "nid" as the key field, so the fields should match each nid field from one table to the next.  Following a tutorial I have been able to insert into a field certain data, but I don't know how to do it so the nid's match and how to convert the human readable date to Unix time.  Thanks in advance!.

Why won't this increment the database field by 1?


$sql2="update 'users' set 'TimesLoggedOn' = 'TimesLoggedOn' + 1 where 'BarcodeID' = $barcode";

mysql_query($sql2);


Thanks!

I am currently working on an application to schedule conferences.  I have everything completed to create a conference including start time and duration.  The problem I have now though is how do I monitor MySQL for the conferences that are created and perform actions when the duration of the conference is up? I was looking into MySQL events but those seem to be only internal events and are not able to execute anything outside of that. I was thinking about a infinite loop that queries MySQL and sleeps for one second but thought that this might be a lot of load on the server. Any thoughts I really appreciate it.

This way seems not good.

<?php
$username ="MANCENT";
$user_input_x = _xmouse.movement ;//FLASH
$user_input_y = _ymouse.movement ;//FLASH

while(true)
{
$updatepos = mysql_query("UPDATE users_float SET user_input_x = '$user_input_x' , user_input_y = '$user_input_y' WHERE username = '$username'");
}

This way works but whats a better way?

?>

This topic has been moved to HTML Help.

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

Hi there,

I was wondering if it was possible to change a forms action field with PHP.

Basically, if there are several checkboxes for the user to select and a specific checkbox was selected, how would I redirect users to an alternative webpage on submit?

I've been playing around with several methods, and one of them was:

Code: [Select]
<?php
 
if(isset($_POST['Example']) &&
   $_POST['Example'] == 'FormValueGoesHere')
{
    echo ('./page1.php');
}
else
{
    echo ('./page2.php');
}   
 
?>


But the form action would only display page1.php even with nothing selected.

Maybe I'm just being stupid because it's getting late, but I'd appreciate any assistance.

Thanks

I use foreach to echo a list of tags come out of an array as
Code: [Select]
foreach ($array as $tag) {
echo "$tag,";
}This produces "tag1,tag2,tag3,". The problem is the last ",". How to tell the foreach loop to avoid including "," after the last sequence?

Hi all,
I have a fairly simple problem, but i cannot get to it. I have a page, that displays one (1) record at the time, and I want to have forward and back buttons (links) at the top and bottom of the page. Can anyone help me with that???
Here is a part of my code.

Code: [Select]
<form method="get">
<table border="0" width="90%" cellpadding="2" cellspacing="2" align="center">
<tr><td align="center">
  Select first letter or kind of the story:
  <input type="hidden" name="link" value="stories.php">
<input type="hidden" name="Pripadnost" value="3">
<select name="letter" onchange="this.form.submit()">
<?PHP
$letter =  trim($_REQUEST["letter"]);
?>

<option value="Sve" <?PHP echo $letter == "All" ? " selected " : "" ; ?>>All</option>
<?PHP
include_once ("/includes/databaseMySQL.php");
mysql_set_charset('utf8');

$SQL = "Select distinct ucase(left(title,1)) as sl FROM tblStoryes order by sl";

$rs_data = mysql_query($SQL) or die(mysql_error());
while ($row_data = mysql_fetch_assoc($rs_data)) {
      ?>
      <option value="<?PHP echo $row_data["sl"]; ?>"<?PHP echo $letter == $row_data["sl"] ? " selected " : "" ;
  echo ">".$row_data["sl"] ;?></option>
      <?PHP
 // ******************  Listed all the first letters of the titles into a drop box. *********************** //
} ?>
</select> &nbsp; &nbsp; &nbsp;
Bosnian <input type="checkbox" name="Bosnian " <?PHP echo isset($_REQUEST["Bosnian "]) ? "checked=checked" : "" ;?> onclick="this.form.submit()" />  &nbsp;
Turkish <input type="checkbox" name="Turkish "  <?PHP echo isset($_REQUEST["Turkish "]) ? "checked=checked" :  "" ;?> onclick="this.form.submit()" />  &nbsp;
Arabian <input type="checkbox" name="Arabian "  <?PHP echo isset($_REQUEST["Arabian "]) ? "checked=checked" : ""  ;?> onclick="this.form.submit()" />

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

<table border="0" width="90%" cellpadding="2" cellspacing="2" align="center">
<?PHP
$id = -1;
$rs_data = mysql_query("Select max(id) as maxid from  tblStories WHERE aktivno = True") or die(mysql_error());
$row_data = mysql_fetch_assoc($rs_data);
$maxid = (int) $row_data["maxid"];

 // ******************  Found the largest ID from the table. *********************** //

$SQL = "SELECT * FROM tblStories WHERE aktivno = True ";


if ( strlen($letter) < 3 && strlen($letter) > 0 ) {
$SQL = $SQL . " and ucase(left(`title`, 1)) = '" . $Letter . "'";
}

$lang = 0;
$lang = $lang + isset($_REQUEST["Bosnian"]) * 4;
$lang = $lang + isset($_REQUEST["Turkish"]  ) * 2;
$lang = $lang + isset($_REQUEST["Arabian"] );
switch ($lang) {
    case 6: // bos i tur
        $SQL = $SQL . " and ( Bosanski = 1 or Turski = 1 ) ";
        break;
    case 5: // bos i ar
        $SQL = $SQL . " and ( Bosanski = 1 or Arapski = 1) ";
        break;
case 4: // bos
        $SQL = $SQL . " and Bosanski = 1 ";
        break;
    case 3: // tur i ar
        $SQL = $SQL . " and ( Turski = 1 or Arapski =1) ";
        break;
    case 2: // tur
        $SQL = $SQL . " and Turski = 1 ";
        break;
    case 1: // ar
        $SQL = $SQL . " and Arapski =1 ";
        break;
}


if (trim($_REQUEST["DBid"]) <> ""  or  $_REQUEST["DBid"] > 0)
$SQL = $SQL . " and  id > " . trim($_REQUEST["DBid"]) ;
$SQL = $SQL . " LIMIT 1"; //order by naslov

$rs_data = mysql_query($SQL) or die(mysql_error());
echo "<!--" . $SQL . " : Jezik je:" . $lang . "-->";
while ($row_data = mysql_fetch_assoc($rs_data)) {
$id = (int) $row_data["ID"];
?>
  <tr>
<td align="center" colspan=3>
       <h3><?PHP echo $row_data["Title"];?> </h3>
    </td>
    </tr>   
    <tr>
      <td width=20%>&nbsp;
      </td>
      <td align="justify" width=60%>
        <?PHP  echo $row_data["tekst"]; // tekst = text, but not keyword ?>
      </td>
      <td width=20%>&nbsp;
      </td>
    </tr>
<?PHP
}
?>
</table>
<p>

<?PHP
// ****************************** HEEEEELLLLPPPPPP ******************************* //
?>

<table border="0" width="90%" cellpadding="1" align="center">
  <tr>
    <td align="center"><a href="?DBid=1<?PHP
foreach($_REQUEST as $arr => $elem){
if ( $arr != "DBid") echo "&" . $arr . "=" . $elem;
} ?>"> &lt;&lt;</a></td>
    <td align="center"><a href="?DBid=<?PHP
echo $_REQUEST["id"];
foreach($_REQUEST as $arr => $elem){
if ( $arr != "DBid") echo "&" . $arr . "=" . $elem;
}
?>" >&lt;</a></td>
<?PHP if (  $maxid <=  $id ) { ?>
    <td align="center">&gt;</td>
    <td align="center">&gt;&gt;</td>
<?PHP }
  else
  {?>
    <td align="center"><a href="?DBid=<?PHP
echo $id ;
foreach($_REQUEST as $arr => $elem){
if ($arr != "DBid") echo "&" . $arr . "=" . $elem;
}
?>">&gt;</a></td>
    <?PHP if ( ($id + 9) <  $maxid ) { ?>
    <td align="center"><a href="?DBid=<?PHP
echo $id+10 ;
foreach($_REQUEST as $arr => $elem){
if ($arr != "DBid") echo "&" . $arr . "=" . $elem;
}
?>">&gt;&gt;</a></td>
    <?PHP
    }
    else
      {?>
        <td align="center">&gt;&gt;</td>
<?PHP }?>   
<?PHP }?>
  </tr>
</table>
</form>