PHP - Updating Records But Problem With Errors And Retaining Field Values

Hi all,

i need some help in retaining the values in an <option> textbox..

I have found a code to loop the date online, and use it for Javascript jump menu, but i have no ideas how to retain the option.. here are my codes(in red),

$year1 = date('Y');
$month1 = date('m');
$day1 = date('j');

$day1 = $day1 + 1;

$year2 = date('Y') + 2;
$month2 = date('m');
$day2 = date('j');

$start_date = "$year1-$month1-$day1";
$end_date = "$year2-$month2-$day2";


$date = mktime(0,0,0,$month1,$day1,$year1); //Gets Unix timestamp START DATE
$date1 = mktime(0,0,0,$month2,$day2,$year2); //Gets Unix timestamp END DATE
$difference = $date1-$date; //Calcuates Difference
$daysago = floor($difference /60/60/24); //Calculates Days Old



$i = 0;
while ($i <= $daysago +1) {
if ($i != 0) { $date = $date + 86400; }
else { $date = $date - 86400; }



$yy1 = date('Y',$date);
$mm1 = date('m',$date);
$dd1 = date('d',$date);
$date3 = "$yy1-$mm1-$dd1" ;



echo "<option value=\"test1234.php?m=$mm1&amp;y=$yy1&amp;d=$dd1\"  ";
echo ">".$date3 ."</option>";
$i++;
}

i know that i have to something selected, but i dun understand how this set of date code loop which left me helpless.

Hello all.

I'm new here... and new to php... so please be gentle if I'm overlooking something that's blindingly obvious.

I have a 'view blog entries' page and an 'edit blog entries' page. When I go to the 'edit blog entries' page, I want the form fields to display the preexisting blog content for whatever entry I'm about to edit.

The code below does display the 'title' but it does not display the 'article' content. (However, the 'title' and 'article' content both show when I view the source code.)

Can anyone tell me what I could be doing wrong? Thanks in advance.

Code: [Select]
// Retrieve the blog post's information:
$q = "SELECT title, article FROM entries WHERE article_id=$article_id";
$r = @mysqli_query ($dbc, $q);

if (mysqli_num_rows($r) == 1) { // Valid blog entry ID, show the form.

// Get the blog entry's information:
$row = mysqli_fetch_array ($r, MYSQLI_NUM);

echo '<form action="edit_entry.php" method="post">

<p>Title:<br />
<input type="text" name="title" size="45" maxlength="80" value="' . $row[0] . '" /></p>
<p>Blog entry<br />
    <textarea name="article" id="article" cols="45" rows="5" ' . $row[1] . '></textarea>
  </p>

<p><input type="submit" name="submit" value="Submit" /></p>
<input type="hidden" name="submitted" value="TRUE" />
<input type="hidden" name="article_id" value="' . $article_id . '" />
</form>';

} else { // Not a valid entry ID.
echo '<p class="error">This page has been accessed in error.</p>';
}
mysqli_close($dbc);
?>

again my tables are

movies| ID(PK) - Titles - Category(FK) - URL
             0         Name         1               www.xyz.com


categories| ID(PK) - Category
                  1          Comedy


say i create a query  SELECT * FROM movies WHERE Category="1"

and it gave me all the movies from my table that is in the comedy category which should
look like this:

ID - Title - Category - URL
0    Name  Comedy   www.xyz
1    xyz     Comedy   www.abc
            etc..

  How can i add a drop down menu beside each movie listed in that result that would let me
change the category for it and save it ? like this,

ID - Title - Category - URL
0    Name  Comedy   www.xyz      [Dropdown]
1    xyz     Comedy   www.abc      [Dropdown]

             [Save Button]


being a newbie im going to guess that i will need a INSERT in here somewhere and not really sure how i would write my result echos. i have been trying all kinds of "update records" forms and cant get them right so i figured it may be easier to just try and create my own. if i could get some example or if you have more simple suggestions

I have a problem with an amend to an admin system I am trying to change. The shop stocks different colours of each product and the client wants to be able to update the stock levels of all colours of one product (which all share the same title) on one form. I have tried following some instructions on some sites and tried making my own and I can get it to display the form and the values correctly, but on submission it does nothing but direct me to a page without a title value in the address (e.g. www.example.com/example/stock_level_2.php?title=). I think it may be to do with the arrays I am using, has anyone got any ideas? Here is the code.

Form:
Code: [Select]
<?php
$pd_title = str_replace("_"," ",$_REQUEST["title"]);
$pd_title = str_replace("%","&#38;#37;",$pd_title);
$pd_title = str_replace("/","&#38;#47;",$pd_title);

$lookupqueryc = mysql_query("SELECT * FROM product WHERE pd_title = '".$pd_title."' ORDER BY pd_id DESC");

echo '<table><tr><th align="center" class="bodytext">Product<br />ID</th><th align="center" class="bodytext">Product Name</th><th align="center" class="bodytext">Stock Level</th></tr>';

$form = '<form name="frmAmendStock" method="post" action="stock_level_2.php?title="';
$form .=  $_GET["title"];
$form .= '" enctype="multipart/form-data">';
echo $form;
echo '<input name="submitted" type="hidden" value="true">';
$count=mysql_num_rows($lookupqueryc);
echo '<input name="count" type="hidden" value="';
echo $count;
echo '">';

                          
  while($lookupresultc = mysql_fetch_array($lookupqueryc)){  
  
        

echo '<tr><td align="center" class="bodytext">';
                                $id[]=$lookupresultc["pd_id"];
echo $lookupresultc["pd_id"];
echo '</td><td class="bodytext">';
echo $lookupresultc["pd_title"];
if (isset($lookupresultc["pd_colour"]) && $lookupresultc["pd_colour"] !="") {
echo " (";
echo $lookupresultc["pd_colour"];
echo ')';
}
if ($lookupresultc["pd_stock"] <= 5) {
echo '</td><td align="center" class="bodytext" style="border: 2px solid red;">';
echo '<input name="stock[]" type="text" id="stock" value="';
                                echo $lookupresultc["pd_stock"];
                                echo '"style="width: 50px;" />'; 
echo "</td></tr>";
}else{
echo '</td><td align="center" class="bodytext">';
echo '<input name="stock[]" type="text" id="stock" value="';
                                echo $lookupresultc["pd_stock"];
                                echo '"style="width: 50px;" />'; 
echo "</td></tr>";

}



} ?>
<tr>
                <td>&nbsp;</td>
                <td height="35"><a href="javascript: " onClick="javascript:document.forms.frmAmendStock.submit()" class="bodytext"><strong>click here to amend your stock </strong></a></td>
              </tr>
</form> </table>


And here is the code it should run on submission:
Code: [Select]
<?php
if (isset($_POST["submitted"])) {

for($i=0;$i<$_POST["count"];$i++){
mysql_query("UPDATE product SET pd_stock='$stock[$i]' WHERE pd_id='$id[$i]'");
}

}
?>

Hi, I am trying to create an admin page for a local Gym Club to allow an Administrator to be able to update club prices which then show on different screens on the site.   I have been able to display the "Prices Admin" page which basically reads a MySQL database table (pricelist), display the description, member price and non-member price and allows the user to update any of these fields.   My problem is that when I try writing the data back to the database with the "UPDATE" statement it fails, what I mean is that nothing updates.  I have at the moment commented out the actual update statement and put in a "file_put_contents" command" to try and work out what is in the various fields before the UPDATE is run.  I find that the display/INPUT works perfectly well but when I do a foreach on the $record array variable I am getting strange results.   I may not have explained this very well but here are the relevant sections of my code;   // Display and Input section   <div id="admin-area">

Hi Guys,

I am new to PHP/MYSQL. I am working on a web database project to record class attendance.
I have found this script which I have manipulated, however, I am not sure why it does not display the data. It may be something simple, I have checked over table names, field names, variable names to see that they match the database. It displays the textboxes with the php code rather than the data and all other fields display no data.

Can you help?

I will be focusing on Prepared Statements for SQL injections later.

<?php

$host="xxx"; // Host name
$username="xxx"; // Mysql username
$password="xxx"; // Mysql password
$db_name="xxx"; // Database name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");


$sql="SELECT * FROM attendance";
$result=mysql_query($sql);

// Count table rows
$count=mysql_num_rows($result);


?>


<html>
<head>
<title>Registers</title>
</head>
<body>


<?php include 'Navigation.php';?>

<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">

<table border="0" cellspacing="1" cellpadding="0" style="width: 1461px; height: 105px">

<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>Last Name</strong></td>
<td align="center"><strong>First Name</strong></td>
<td align="center"><strong>Form</strong></td>
<td align="center"><strong>Year Group </strong></td>
<td align="center"><strong>Date</strong></td>
<td align="center"><strong>Attendance</strong></td>


</tr>

<?php
while($rows=mysql_fetch_array($result)){
?>

<tr>
<td align="center"><? $Student_id[]=$rows['Student_id']; ?><? echo $rows['Student_id']; ?></td>
<td align="center"><? $firstname[]=$rows['firstname']; ?><? echo $rows['firstname']; ?></td>
<td align="center"><? $lastname[]=$rows['lastname']; ?><? echo $rows['lastname']; ?></td>
<td align="center"><? $Form_Group[]=$rows['Form_Group']; ?><? echo $rows['Form_Group']; ?></td>
<td align="center"><? $Year_Group[]=$rows['Year_Group']; ?><? echo $rows['Year_Group']; ?></td>
<td align="center"><? $Att_Date[]=$rows['Att_Date']; ?><? echo $rows['Att_Date']; ?></td>
<td align="center"><input name="Presence[]" type="text" id="Presence" value="<? echo $rows['Presence']; ?>"></td>
</tr>

<?php
}
?>

<tr>
<td colspan="7" align="center"><input type="submit" name="Submit" value="Submit Register"></td>
</tr>
</table>

</form>
</table>


<?php

// Check if button name "Submit" is active, do this
if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE attendance SET Presence='$Presence[$i]' WHERE Student_id='$Student_id[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1){
header("location:Registers.php");
}
mysql_close();
?>

 

I have got myself a bit confused whilst trying to create an 'update selected records' page. In memberlist.php, a set of records is shown, each with a checkbox. 
When the user clicks on 'Update Selected' it opens up membermultiupdate.php. I cannot get this page to recognise which id's have been passed and put them in an array so only the checked records are shown.
The page in question is at http://www.margate-fc.com/memberlist.php. When it opens membermultiupdate.php, there are currently 2 errors....

Code: [Select]
Warning: implode() [function.implode]: Invalid arguments passed in /homepages/46/d98455693/htdocs/membermultiupdate.php on line 11
which refers to
$update = implode ("','", mysql_real_escape_string ($_POST['checkbox']))

Code: [Select]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/46/d98455693/htdocs/membermultiupdate.php on line 44which is
while ($rowmembers = mysql_fetch_array($members))
I have also tried mysql_fetch_assoc there too.

I may be miles out or I may be missing something simple but I have tried for hours now to get my head around this and have not even got to the point where I can see if the actual update side works!

Any suggestions would be greatly received and I have put the relevant code from both pages below.
Thanks in advance for any help or suggestions
Steve

memberlist.php
The query to get all rows
$members = mysql_query(" SELECT * FROM users");

The submit form with checkboxes
<form name="form1" method="post" action="membermultiupdate.php">
<?php
while ($rowmembers = mysql_fetch_assoc($members))
{echo '  <tr>
<td><input type="hidden" name="id[]" value="'.$rowmembers['id'].'" />'.$rowmembers['id'].'</td> 
<td><input name="checkbox[]" type="checkbox" id="checkbox[]" value="'.$rowmembers['id'].'"></td></td> 
<td>'.$rowmembers['id'].'</td>
<td>'.$rowmembers['username'].'</td>
<td>'.$rowmembers['first_name'].'</td>
<td>'.$rowmembers['last_name'].'</td>
<td>'.$rowmembers['email'].'</td>
';
if ($rowmembers['active'] == 1)
{echo '<td> YES </td>';}
else
{echo ' <td>NO </td>';}
echo '
<td><a href="memberedit.php?member='.$rowmembers['id'].'"><img src="http://icons.iconarchive.com/icons/custom-icon-design/office/256/edit-icon.png" width="15" height="15" /></a> <img src="http://icons.iconarchive.com/icons/custom-icon-design/office/256/delete-icon.png" width="15" height="15" /></td>
</tr>';}
    
?>
<tr> 
<td colspan="4" align="center"><input type="submit" name="submit" value="Update Selected"></td> 
</tr>
</form>

membmultiupdate.php
The code bit to try to show all checked rows
if (isset ($_POST['submit']))
{
  if (is_array ($_POST['checkbox']))
  {
  $update = implode ("','", mysql_real_escape_string ($_POST['id']));

  $members = mysql_query("SELECT
  *
  FROM
  users
  WHERE
  id IN (".$update.")
  ");
  }
}

The form to show all of the checked rows
<form name="form1" method="post" action="">
<?php
while ($rowmembers = mysql_fetch_array($members))
{echo '
<tr>


  <td width="200px" align="right" style="font-weight:bold">
<label for="name">Username:</label>
  </td>
  <td width="200px" >
<input type="text" name="name" value="'.$rowmembers['username'].'" /><br>
  </td>
</tr>
<tr>
  <td width="200px" align="right" style="font-weight:bold">
<label for="name">First Name:</label>
  </td>
  <td width="200px" >
<input type="text" name="first_name" value="'.$rowmembers['first_name'].'" /><br>
  </td>
</tr>
<tr>
  <td width="200px" align="right" style="font-weight:bold">
<label for="name">Last Name:</label>
  </td>
  <td width="200px" >
<input type="text" name="last_name" value="'.$rowmembers['last_name'].'" /><br>
  </td>
</tr>
<tr>
  <td width="200px" align="right" style="font-weight:bold">
<label for="name">Email:</label>
  </td>
  <td width="200px" >
<input type="text" name="email" value="'.$rowmembers['email'].'" /><br>
  </td>
</tr>'
    
;}
    
?>
<tr> 
<td colspan="4" align="center"><input type="submit" name="update" value="update"></td> 
</tr> 
</form>

The code to update the rows from the above form and the return to memberlist.php
if($update)
{ 
foreach($_POST['id'] as $id)
{ 


$sql1="
UPDATE 
users  
SET 
username='".$_POST["name".$id]."'
, first_name='".$_POST["first_name".$id]."'
, last_name='".$_POST["last_name".$id]."'
, email='".$_POST["email".$id]."'
, ONOFF='".$_POST["ONOFF".$id]."' 
WHERE id='".$id."'"; 
$result1=mysql_query($sql1); 
} 
} 

if($result1){ 
header("location:memberlist.php"); 
} 

When submitting the form, the records are sometimes inserted and sometimes not.  I receive no errors stating what the problem is.

Code: [Select]
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO customer_tbl (customer_first_name, customer_last_name, customer_company, customer_ac, customer_phone, customer_fax_ac, customer_fax_phone, customer_email) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['customer_first_name'], "text"),
                       GetSQLValueString($_POST['customer_last_name'], "text"),
                       GetSQLValueString($_POST['customer_company'], "text"),
                       GetSQLValueString($_POST['customer_ac'], "text"),
                       GetSQLValueString($_POST['customer_phone'], "text"),
                       GetSQLValueString($_POST['customer_fax_ac'], "text"),
                       GetSQLValueString($_POST['customer_fax_phone'], "text"),
                       GetSQLValueString($_POST['customer_email'], "text"));

$customer_id = false;
if(mysql_query($insertSQL, $connCid))
$customer_id = mysql_insert_id();
else
echo "There was an error.";
}
  
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO quote_request_tbl (customer_id, quote_trans_date, quote_from_company, quote_from_address, quote_from_city, quote_from_state, quote_from_zip, quote_to_company, quote_to_address, quote_to_city, quote_to_state, quote_to_zip, quote_comments) VALUES ('$customer_id', %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['quote_trans_date'], "text"),
                       GetSQLValueString($_POST['quote_from_company'], "text"),
                       GetSQLValueString($_POST['quote_from_address'], "text"),
                       GetSQLValueString($_POST['quote_from_city'], "text"),
                       GetSQLValueString($_POST['quote_from_state'], "text"),
                       GetSQLValueString($_POST['quote_from_zip'], "text"),
                       GetSQLValueString($_POST['quote_to_company'], "text"),
                       GetSQLValueString($_POST['quote_to_address'], "text"),
                       GetSQLValueString($_POST['quote_to_city'], "text"),
                       GetSQLValueString($_POST['quote_to_state'], "text"),
                       GetSQLValueString($_POST['quote_to_zip'], "text"),
                       GetSQLValueString($_POST['quote_comments'], "text"));
  
  $quote_id = false;
if(mysql_query($insertSQL, $connCid))
$quote_id = mysql_insert_id();
else
echo "There was an error.";
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1") && (isset($quote_id))) {
  $insertSQL = sprintf("INSERT INTO building_tbl (quote_id, building_quantity, building_width, building_length, building_height, building_overhang, slope_id, building_type_id, manufacture_id, foundation_id) VALUES ('$quote_id', %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['building_quantity1'], "int"),
                       GetSQLValueString($_POST['building_width1'], "int"),
                       GetSQLValueString($_POST['building_length1'], "int"),
                       GetSQLValueString($_POST['building_height1'], "int"),
                       GetSQLValueString($_POST['building_overhang1'], "int"),
                       GetSQLValueString($_POST['slope_id1'], "int"),
                       GetSQLValueString($_POST['building_type_id1'], "int"),
                       GetSQLValueString($_POST['manufacture_id1'], "int"),
                       GetSQLValueString($_POST['foundation_id1'], "int");

  mysql_select_db($database_connCid, $connCid);
  $Result1 = mysql_query($insertSQL, $connCid) or die(mysql_error());

header('Location: index.php?view=article&id=7');
}

mysql_select_db($database_connCid, $connCid);
$query_rsSlope = "SELECT * FROM slope_tbl ORDER BY slope_id ASC";
$rsSlope = mysql_query($query_rsSlope, $connCid) or die(mysql_error());
$row_rsSlope = mysql_fetch_assoc($rsSlope);
$totalRows_rsSlope = mysql_num_rows($rsSlope);
$query_rsSlope = "SELECT * FROM slope_tbl ORDER BY slope_id ASC";
$rsSlope = mysql_query($query_rsSlope, $connCid) or die(mysql_error());
$row_rsSlope = mysql_fetch_assoc($rsSlope);
$totalRows_rsSlope = mysql_num_rows($rsSlope);

mysql_select_db($database_connCid, $connCid);
$query_rsBuildingType = "SELECT * FROM building_type_tbl ORDER BY building_type_id ASC";
$rsBuildingType = mysql_query($query_rsBuildingType, $connCid) or die(mysql_error());
$row_rsBuildingType = mysql_fetch_assoc($rsBuildingType);
$totalRows_rsBuildingType = mysql_num_rows($rsBuildingType);

mysql_select_db($database_connCid, $connCid);
$query_rsManufacture = "SELECT * FROM manufacture_tbl ORDER BY manufacture_name ASC";
$rsManufacture = mysql_query($query_rsManufacture, $connCid) or die(mysql_error());
$row_rsManufacture = mysql_fetch_assoc($rsManufacture);
$totalRows_rsManufacture = mysql_num_rows($rsManufacture);

mysql_select_db($database_connCid, $connCid);
$query_rsFoundation = "SELECT * FROM foundation_tbl ORDER BY foundation_name ASC";
$rsFoundation = mysql_query($query_rsFoundation, $connCid) or die(mysql_error());
$row_rsFoundation = mysql_fetch_assoc($rsFoundation);
$totalRows_rsFoundation = mysql_num_rows($rsFoundation);
?>

I belve the problem is in this part of the code:

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1") && (isset($quote_id)))

Many thanks in advance.

Hi guys,

I am having a real problem with this and I can't figure it out. I am not that much of a techie so take it easy on me.

I am building a survey form for a website to get feedback on the service, and naturally it can fail validation if the email address is misspelled or the security question is answered wrong. Retaining text values was easy and I managed to dig around for some solutions to retain radio button values. The problem is IT ONLY WORKS ON ONE OPTION! I tried everything including coming up with completely separate value names, yet the page still loads with all radio options set to the same shared value (usually of the last radio button question).

Here is my code:

<?PHP

$Excellent_status = 'unchecked';
$VeryGood_status = 'unchecked';
$Satisfactory_status = 'unchecked';
$Weak_status = 'unchecked';
$Horrible_status = 'unchecked';

if (isset($_POST['send'])) 
{

$selected_tk = $_POST['tk'];

if ($selected_tk == 'Excellent') {
$Excellent_status = 'checked';
}
else if ($selected_tk == 'VeryGood') {
$VeryGood_status = 'checked';
}
else if ($selected_tk == 'Satisfactory') {
$Satisfactory_status = 'checked';
}
else if ($selected_tk == 'Weak') {
$Weak_status = 'checked';
}
else if ($selected_tk == 'Horrible') {
$Horrible_status = 'checked';
}
}

$Excellent2_status = 'unchecked';
$VeryGood2_status = 'unchecked';
$Satisfactory2_status = 'unchecked';
$Weak2_status = 'unchecked';
$Horrible2_status = 'unchecked';

if (isset($_POST['send']))
{

$selected_ts = $_POST['ts'];

if ($selected_ts == 'Excellent') {
$Excellent2_status = 'checked';
}
else if ($selected_ts == 'VeryGood') {
$VeryGood2_status = 'checked';
}
else if ($selected_ts == 'Satisfactory') {
$Satisfactory2_status = 'checked';
}
else if ($selected_ts == 'Weak') {
$Weak2_status = 'checked';
}
else if ($selected_ts == 'Horrible') {
$Horrible2_status = 'checked';
}
}

?>


     <h1 align="center">Feedback Form:</h1>
     <p align="center">We highly value your input. Your feedback can help us serve you better and provide you with a holistic experience that meets or exceeds all your expectations. <br />
Please take the time to fill out the form below.</p>
     <br />
  <br />
  <p align="center"><strong>(Fields marked with a <span class="required">*</span> are necessary. The course information is to validate which course and batch the survey is regarding, and the name and email allows our admin to verify the details and gain more information from you if needed)</strong></p>
  <p align="center"><strong>The identity in this form is strictly confidential, and it will not be revealed to course trainer, co-ordinator, or your sponsor.</strong></p>
  <!--Error Message-->
  <?php echo $error;?>
  <form  method="post" name="contFrm" id="contFrm" action="">
    <label><span class="required">*</span>Name:</label>
    <input name="name" type="text" class="box" id="name" size="40" value="<?php echo $name;?>" /><br />
    <label><span class="required">*</span>Email: </label>
    <input name="email" type="text" class="box" id="email" size="40" value="<?php echo $email;?>" /><br />
    <label><span class="required">*</span>Course attended: </label>
    <input name="course" type="text" class="box" id="course" size="40" value="<?php echo $course;?>" /><br />
    <label><span class="required">*</span>Course Date and City: </label>
    <input name="dateplace" type="text" class="box" id="dateplace" size="40" value="<?php echo $dateplace;?>" /><br /><br /><br />

    <table width="980" border="1" cellpadding="5" cellspacing="1" bgcolor="#FFFFFF">
<tr>
  <td width="280" align="left" bgcolor="#285A80"><strong><font color="#FFFFFF" size="+1">Attribute</font></strong></td>      
        <td width="115">
          <div align="center">EXCELLENT! 
          </div></td>
        <td width="115">
          <div align="center">Really Good. 
          </div></td>
        <td width="115">
          <div align="center">Satisfactory. 
          </div></td>
        <td width="115">
          <div align="center">Weak, needs attention. 
          </div></td>
        <td width="115">
          <div align="center">Horrible! Unacceptable. 
          </div></td>
      </tr>
<tr>
  <td width="280" align="left" bgcolor="#71C4CD"><strong><font color="#333333">Trainer Knowledge</font></strong></td>      
        <td>
          <div align="center">
            <input type="radio" name="tk" id="Excellent" value="Excellent" <?PHP print $Excellent_status; ?>/>
          </div>
        </td>
        <td>
          <div align="center">
            <input type="radio" name="tk" id="VeryGood" value="VeryGood" <?PHP print $VeryGood_status; ?>/>
          </div>
        </label></td>
        <td>
          <div align="center"> 
            <input type="radio" name="tk" id="Satisfactory" value="Satisfactory" <?PHP print $Satisfactory_status; ?>/>
          </div>
        </td>
        <td>
          <div align="center"> 
            <input type="radio" name="tk" id="Weak" value="Weak" <?PHP print $Weak_status; ?>/>
          </div>
        </td>
        <td>
          <div align="center"> 
            <input type="radio" name="tk" id="Horrible" value="Horrible" <?PHP print $Horrible_status; ?>/>
          </div>
        </td>
      </tr>
<tr>
  <td width="280" align="left" bgcolor="#71C4CD"><strong><font color="#333333">Trainer Style and Presentation</font></strong></td>      
        <td>
          <div align="center">
            <input type="radio" name="ts" id="Excellent2" value="Excellent2" <?PHP print $Excellent2_status; ?>/>
          </div>
        </td>
        <td>
          <div align="center">
            <input type="radio" name="ts" id="VeryGood2" value="VeryGood2" <?PHP print $VeryGood2_status; ?>/>
          </div>
        </label></td>
        <td>
          <div align="center"> 
            <input type="radio" name="ts" id="Satisfactory2" value="Satisfactory2" <?PHP print $Satisfactory2_status; ?>/>
          </div>
        </td>
        <td>
          <div align="center"> 
            <input type="radio" name="ts" id="Weak2" value="Weak2" <?PHP print $Weak2_status; ?>/>
          </div>
        </td>
        <td>
          <div align="center"> 
            <input type="radio" name="ts" id="Horrible2" value="Horrible2" <?PHP print $Horrible2_status; ?>/>
          </div>
        </td>
      </tr>
    </table>
    <br /><br />
    <label>Particularly positive points you appreciated: </label>
    <textarea name="message1" cols="80" rows="3"  id="message1"><?php echo $message1;?>
</textarea><br />
    <label>Particularly negative points you found disappointing: </label>
    <textarea name="message2" cols="80" rows="3"  id="message2"><?php echo $message2;?>
</textarea><br />
    <label>Any specific message you would like to provide us: </label>
    <textarea name="message3" cols="80" rows="3"  id="message3"><?php echo $message3;?>
</textarea><br />
<label><span class="required">* Security Question</span></label><? require_once ("ClassMathGuard.php"); MathGuard::insertQuestion(); ?>
    <br />
    <br />
    <!-- Submit Button-->
    <input name="send" type="submit" class="button" id="send" value="" />
  </form>


Fact is there are 8 questions (all multiple choice with radio button answers) but I decided to save you a long code read. Basically what I get is that despite choosing different answers for each question, the retention is only of the last option or question, and all the above question choices are set to that choice button.

What is wrong?

I know how to pull data from sql table and limit down the results,

what i wanted to do is pull data from a sql table 'finished' and list data that has paid='0'

this is then limited to show the amount of rows set by variable 'maxPay'

here is my list what im pulling atm;
    <h2>Payment </h2>
    <?php 
if($userType[user_type]==28){
$queryPay = mysql_query("SELECT * FROM finished WHERE paid='0'&&method!='FALSE'&&method!='credit';") or die(mysql_error());

$queryAdmin = mysql_query("SELECT maxPay FROM `admin`;") or die(mysql_error());

$row = mysql_num_rows($queryPay);
//echo $row."row<br />";
$rowsArray = mysql_fetch_assoc($queryAdmin);
$rows = $rowsArray[maxPay];
//echo $rows."rows<br />";

if($rows>$row){
$r=$row;
}
else{
$r=$rows;
}
$s=0;
while($s<$r){
if($_POST[complete]==TRUE){
mysql_query("UPDATE `finished` SET `paid`='$_POST[paid]' WHERE `auctionID`='$_POST[aid]';");
$_POST[complete] = FALSE;

}
$s++;
}

$t=0;
while($t<$r){
$queryuser = mysql_query("SELECT * FROM finished WHERE paid='0'&&method!='FALSE'&&method!='credit';") or die(mysql_error());

$user = mysql_result($queryuser, $t, "username");
//echo $user;
$item = mysql_result($queryuser, $t, "itemName");
//echo $item;
$value = mysql_result($queryuser, $t, "marketPrice");
//echo $value;
$method = mysql_result($queryuser, $t, "method");
//echo $method;
$id = mysql_result($queryuser, $t, "auctionID");
//echo $id;



//echo $method;
if($method=='isk'){
?>
<FORM method="post" action="pay.php">
<input type="hidden" name=complete value="TRUE" />
<input type="hidden" name=paid value="YES" />
<input type="hidden" name=username value="<? echo $user; ?>" />
<input type="hidden" name=aid value="<? echo $id; ?>" />
<input type="submit" value="Paid" /><?
echo $user." won a ".$item." he selected to receive ".$value."ISK.";

echo "<br />";
?></FORM><?
}
elseif($method=='ship'){
?>
<FORM method="post" action="pay.php">
<input type="hidden" name=complete value="TRUE" />
<input type="hidden" name=paid value="YES" />
<input type="hidden" name=username value="<? echo $user; ?>" />
<input type="hidden" name=aid value="<? echo $id; ?>" />
<input type="submit" value="Paid" /><?
echo $user." won a ".$item." he selected to receive the ship.";

echo "<br />";
?></FORM><?
}
else{

}
$t++;
}

}
else{
echo "You are not an Admin.";
}
?>

and pay.php:
<?php 

header('Location: /admin.php');

include "connect.php";
echo $_POST[aid];
if($_POST[complete]==TRUE){
$tempID = (($_POST[aid])+1);
mysql_query("UPDATE `finished` SET `paid`='$_POST[paid]' WHERE `auctionID`='$tempID';") or die(mysql_error());
$_POST[complete] = FALSE;
}
?>

at the moment i am listing all my data, and processing it using pay.php, each dataset has a "paid" button, i want to change this to using a checkbox at end of each data row, and a submit button at the bottom. this way i can select which rows to update and tick the checkbox, then click submit and those rows will then be updated the value '0' in db to a value of 'YES'.

hope i explained myself clearly enough for some help.

im a relative php noob still in training. 

This is the form that I'm using and it populates just fine but when you make the changes I can't figure out how to get it to update each record in my database.
Code: [Select]
<table width="100%" cellspacing="1" cellpadding="2" border="0">
<form action="<?php echo $_SERVER["PHP_SELF"] . "?update=1"; ?>" method="post">
<tr>
<td><b>Category Name</b></td>
<td><b>Category Description</b></td>
<td><b>Order</b></td>
<td align="right"><input type="submit" value="Update"></td>
</tr>
<?php
read_cat_list($cat);
for ($i = 0; $i < $cat["count"]; $i++) {
echo "<tr>\n";
echo "<td width=\"30%\" valign=\"top\"><input type=\"text\" name=\"cat_name_" . safe_string($cat[$i]["cat_id"]) . "\" size=\"30\" maxlength=\"250\" value=\"" . safe_string($cat[$i]["cat_name"]) . "\"></td>\n";
echo "<td width=\"36%\" valign=\"top\"><textarea name=\"cat_desc_" . safe_string($cat[$i]["cat_id"]) . "\" rows=\"2\" cols=\"30\">" . safe_string($cat[$i]["cat_desc"]) . "</textarea></td>\n";
echo "<td width=\"10%\" valign=\"top\"><input type=\"text\" name=\"cat_order_" . safe_string($cat[$i]["cat_id"]) . "\" size=\"3\" maxlength=\"3\" value=\"" . safe_string($cat[$i]["cat_order"]) . "\"></td>\n";
echo "<td width=\"24%\" valign=\"top\">[&nbsp;<a href=\"#\" onmouseover=\"window.status = 'Delete " . safe_string($cat[$i]["cat_name"]) . "'; return true;\" onmouseout=\"window.status = ''; return true;\" onclick=\"javascript:del_cat(" . $cat[$i]["cat_id"] . ", '" . safe_string($cat[$i]["cat_name"]) . "'); return false;\">Delete</a>&nbsp;]</td>\n";
echo "</tr>\n";
}
?>
<tr>
<td colspan="4" align="right"><input type="submit" value="Update"></td>
</tr>
</form>
</table>
the safe_string function just cleans up the output/input from the database, This next block is my form processor for this form.
Code: [Select]
<?php
function update_cats($vars) {
$err = "";

#if ($SESSION["level"] != ADMIN) {
# $err = ERR_NOT_ENOUGH_ACCESS;
#} else {
$temp = array_keys($vars);

for ($i = 0; $i < count($temp); $i++) {
if (substr($temp[$i], 0, 9) == "cat_name_") {
if ($vars[$temp[$i]] == "") {
$err = "Category names cannot be blank.";
break;
} else {
$name_query["cat_name"] .= substr($temp[$i], 9) . ", ";
}
}
}
for ($i = 0; $i < count($temp); $i++) {
if (substr($temp[$i], 0, 9) == "cat_desc_") {
$desc_query["cat_desc"] .= substr($temp[$i], 9) . ", ";
}
}
for ($i = 0; $i < count($temp); $i++) {
if (substr($temp[$i], 0, 10) == "cat_order_") {
if ($vars[$temp[$i]] == "") {
$err = "Category orders cannot be blank.";
break;
} else {
$order_query["cat_order"] .= substr($temp[$i], 10) . ", ";
}
}
}
#}

if (!$err) {
if ($name_query["cat_name"]) {
$update_name_query  = "update category";
$update_name_query .= "   set cat_name = '" . $name_query["cat_name"] . "'";
$update_name_query .= " where cat_id in (" . substr($name_query["cat_name"], 0, -2) . ")";

update_db($update_name_query);
}

if ($desc_query["cat_desc"]) {
$update_desc_query  = "update category";
$update_desc_query .= "   set cat_desc = '" . $name_query["cat_desc"] . "'";
$update_desc_query .= " where cat_id in (" . substr($desc_query["cat_desc"], 0, -2) . ")";

update_db($update_desc_query);
}

if ($order_query["cat_order"]) {
$update_order_query  = "update category";
$update_order_query .= "   set cat_order = '" . $name_query["cat_order"] . "'";
$update_order_query .= " where cat_id in (" . substr($order_query["cat_order"], 0, -2) . ")";

update_db($update_order_query);
}
}

return $err;
}
?>
update_db is my database caller, if you need any of the functions that I use that are not here please post back and tell me.

now when I process the form all my fields change to this:

cat_name: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15,
cat_desc:
cat_id: 0

for all the records in the database table, I'm just trying to update each record with the values it needs

Here is my database table with the data.
Code: [Select]
CREATE TABLE `category` (
  `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(255) NOT NULL,
  `cat_desc` text NOT NULL,
  `cat_order` int(11) NOT NULL,
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(1, 'Hand Tossed Pizza', '', 1);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(2, 'Hand Tossed Specialty Pizzas', '', 2);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(3, 'Chicago Style Deep Dish', '', 3);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(4, 'Specialty Chicago Style Deep Dish', '', 4);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(5, 'Chicken Wings & Tenderloins', '', 5);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(6, 'Hot Sides', '', 6);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(7, 'Hot Sandwiches', '', 7);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(8, 'Cold Sandwiches', '', 8);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(9, 'Pastas', '', 9);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(10, 'Fresh Salads', '', 10);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(11, 'Fresh Breads', '', 11);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(12, 'Soups', '', 12);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(13, 'Kids Menu', '', 13);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(14, 'Drinks', '', 14);
INSERT INTO `category` (`cat_id`, `cat_name`, `cat_desc`, `cat_order`) VALUES(15, 'Desserts', '', 15);

Hope I have provided plenty of info on what I got and what I need for it todo

Thanks

hello guys moving on from inserting multiple records im now stuck with updating multiple records. i can get most of the details nailed but i need it to match the id's for the table the code i have in the sql part are
Code: [Select]
if (isset($_POST['submit'])) {
//Assign each array to a variable
$StaffMember = $_POST['StaffMember'];
$referrer = $_POST['referrer'];
$referred = $_POST['referred'];
$SentOut = $_POST['SentOut'];
$today = date("y.m.d H:i:s");
$user_id = $_SESSION['user_id'];
$IssueNum = $_POST['Referrerid'];
$limit = count($StaffMember);



$values = array(); // initialize an empty array to hold the values
for($k=0;$k<$limit;$k++){
$msg[] = "$limit New KPI's Added";



$values[$k] = "( '{$StaffMember[$k]}', '{$referrer[$k]}', '{$referred[$k]}', '{$SentOut[$k]}', '{$today}', '{$user_id}' )"; // build the array of values for the query string
}
$query = "UPDATE `Referrer` (StaffMember, referer, referred, SentOut,
  SentOutDate, SentOutBy)
  VALUES " . implode( ', ', $values ) . "
  WHERE IssueNum= '{$IssueNum[$k]}'";
 

echo $query;




}
i obviously want the records updating where the issuenumber is the same and if the check box in the form is ticked
help with this one?

hey guys, i have my code set up to run substrings through a db to check for matches...even when there is a match it wont insert correctly
Code: [Select]
$result = mysql_query("select * from friends where userid=$userid");
while($row = mysql_fetch_assoc($result))  {

$first_name = $row['first_name'];
$last_name = $row['last_name'];
$strpos_1 = strpos($friend_1, ' ');
$substr_1 = substr($friend_1, 0, $strpos_1);
$substr_2 = substr($friend_1, $strpos_1);

if($substr_1 == $first_name && $substr_2 == $last_name) {

$sql = "insert into fav_friends values('', '$userid', '$friend_1', '$friend_2', '$friend_3', '$friend_4', '$friend_5', '$friend_6')";
          $query = mysql_query($sql);
        }
}
and i don't receive any errors, any thoughts?

 

I making an web app for teachers to assess their students online. The problems I am currently having are on select only one record is displayed and after update no records are displayed in the form even though it was successfully updated.. The program has two files, index.php and process.php. The problems started when got the class name into the query to search and display the class. 

$result = $mysqli->query("SELECT * FROM data WHERE classroom = '".$classroom."' ORDER BY '.name';") or die($mysqli->error);

The query works but doesn't order by name I would like. I would be grateful if anyone could cast an eye over it and give me some tips.

Thanks guys. The beers are on me if anyone can sort it, but you'll have to come to Phnom Penh, Cambodia as that is where I live.

Anyway here's the code. process.php

<html>
<?php
session_start();

$mysqli = new mysqli("localhost","ray","password","reports") or die(mysqli_error($mysqli));

$id = 0;
$update = false;
$name = '';
$classroom = '';


if (isset($_GET['edit'])){
    $id = $_GET['edit'];
    $update = true;
    $result = $mysqli->query("SELECT * FROM data WHERE id=$id") or die($mysqli->error());
    if(isset($result->num_rows) && $result->num_rows > 0) {
        $row = $result->fetch_array();
        $name = $row['name'];
        $classroom = $row['classroom'];
        $pacomment = $row['pacomment'];           
    }
}

if (isset($_POST['update'])){
    $id = $_POST['id'];
    $pacomment = $_POST['pacomment'];   
    $mysqli->query("UPDATE data SET pacomment= '$pacomment' WHERE id=$id") or die($mysqli->error);
    
    $_SESSION['message'] = "Record has been updated!";
    $_SESSION['msg_type'] = "warning";

    header('location: index.php');

}

index,php

<?php require_once 'process.php'; ?>
 <!--************************************** Setup Messages **************************************** -->
<?php if (isset($_SESSION['message'])): ?>
            <div class="alert alert-<?=$_SESSION['msg_type']?>">
                <?php 
                    echo $_SESSION['message']; 
                    unset($_SESSION['message']);
                ?>
            </div>
        <?php endif ?>
  <!--**************************************End  Setup Messages ***********************************************  -->
<?php

?>
<!DOCTYPE html>
<html>
    <head>
    <title>Home of English Reports</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>

  <style>= 
body {
  margin: 0;
  font-family: Arial, Helvetica, sans-serif;
}

.topnav {
  overflow: hidden;
  background-color: #008080;
}

.topnav a {
  float: left;
  color: #f2f2f2;
  text-align: center;
  padding: 14px 16px;
  text-decoration: none;
  font-size: 17px;
}

.topnav a:hover {
  background-color: #ddd;
  color: black;
}

.topnav a.active {
  background-color: #4CAF50;
  color: white;
}
</style>

</head>
<body style="background-color:linen;">


 <!--************************************** End Setup Page Styles ************************************* -->
<div class="container">
<form action="index.php" method = get>
    <label for="classroom">Class name:</label><br>
    <input type="text" id="classroom" name="classroom" value="107i am"><br>

    <input type="submit" value="Submit">
</form>
</div>

 <?php $resultcomment = $mysqli->query("SELECT EnglishComment FROM comments"); ?>

    <!-- ************************************** Begin Connect DB  ************************************************ -->
    
        <div class="container" align-content-center>
        <?php
        $classroom = (isset($_GET['classroom']) ? $_GET['classroom'] : null);
        $result = $mysqli->query("SELECT * FROM data WHERE classroom = '".$classroom."' ORDER BY '.name';") or die($mysqli->error);

        ?>
    <!-- ************************************** End Connect DB ****************************************************  -->

    <div class="row justify-content-center">
        <form action="process.php" method="POST">
            <input type="hidden" name="id" value="<?php echo $id; ?>">

            <div class="form-group">
                <h1><label><?php echo $name?></label></h1>
            </div>



            <form action="process.php" method="POST">
            <input type="hidden" name="id" value="<?php echo $id; ?>">

            <div class="form-group">
                <h3><label>PA Teacher's Comment</label></h3> <select name = "pacomment">
               <?php
                    while($rows = $resultcomment-> fetch_assoc())
                    {
                        $EnglishComment = $rows['EnglishComment'];
                        echo "<option value='$EnglishComment'>$name.$EnglishComment</option>";
                    }
                    ?></h2> 
                </select><br>
                <p>

            <div class="form-group">
            <?php 
            if ($update == true): 
            ?>
                <button type="submit" class="btn btn-info" name="update">Update</button>
            <?php else: ?>
                <!-- <button type="submit" class="btn btn-primary" name="save">Save</button> -->
            <?php endif; ?>
            </div>
        </form>

    <!-- ************************************** Begin Setup Table Headers ******************************************   -->        
            <div class="row justify-content-center">
                <table class="table" width = "20%" border = "5" cellpadding = "1";>
                    <thead>
                        <tr>
                            <th><center>Action</center></th>
                            <th><center>ID</center></th>
                            <th>Name and Comment</th>
                        </tr>
                    </thead>
                    
    <!-- ************************************** End Setup Classlist Table Headers ******************************************   -->
    
    <!-- ****** Loop thru Every Record From $result Query Variable and get variables and echo each variable into the table rows  **********   -->
            <?php
                while ($row = $result->fetch_assoc()): ?>

            <tr>
                        <td>
                        <center><a href="index.php?edit=<?php echo $row['id']; ?>"
                            class="btn btn-info">Assess</a></center>                         
                        </td>
    <!-- ************************************** Put data into Classlist table rows ******************************************   -->
                    
                        <td><center><?php echo $row['studentid']; ?></center></td>
                        <td><?php echo $row['name']." ".$row['pacomment'] ?></td>
                        
            </tr>
                  
            <?php endwhile; ?>  <!-- ****************** End While() Loop ****************************   --> 
    
                </table> <!-- *************** End of Classlist Table  ******************************************   -->

            </div> 
   
        </div>
        </div>
    </body>

</html>

 

 

 

 

Edited July 25, 2020 by raymon