PHP - Updating The Looped Data

Hello all,

I have form that has several fields.  Each field will be saved to a table (which is a relations table we will call markups).  The form is built from another table which is an array of categories.  The output will build a form with each category and allow the end-user to input data for each category.  The information the user will be entering is markup values. 

Cat1 | Markup Input
Cat2 | Markup Input
Cat3 | Markup Input

I'll be saving the data in their own columns and not as an serialized array to the database.  I'm currently looping through the arrayed fields and saving the data to the markup relations table.  I've read other forums and serializing the data will be to difficult to retrieve for relationship purposes??  Anyway, here's my question:

Let's say the user is entering the markups for the first time.  They go down the list of categories and add their markups for each and click save.  Cool, no problem just do an INSERT INTO. Then, they go into the category setup screen and add a category then go back to the markup screen and now have to update the category markup that was just added. 

So now I have to do an UPDATE to the current listed markups table (no problem). But now I have to add another row in the same table from that array.  Is there a logical way of handling this.  I guess I'm looking for some ideas on how to accomplish this task.  I hope you guy understand what I'm after here.  Thanks for any suggestions on this.

 

Hello folks,
I can not seem to find out why this code is not being executed properly. Basically, I'd like to edit Records, so I am using forms to retrieve data, make modifications then save them.

Code: [Select]
<?php
//connection to db
 
$results = mysql_query("SELECT * FROM crud WHERE id=".$_GET[id]."") or die (mysql_error());
$row = mysql_fetch_assoc($results);
echo "<form action=\"\" method=\"POST\">";
echo "Year: <input type=\"text\" value=".$row['car_year']." name=\"car_year\" /> <br />";
echo "Make: <input type=\"text\" value=".$row['car_make']." name=\"car_make\" /> <br />";
echo "Model: <input type=\"text\" value=".$row['car_model']." name=\"car_model\" /><br /><br />";
echo "Description:<br /><textarea rows=\"15\" cols=\"60\" name=\"description\" />". $row['description']. "</textarea>";
echo "<br /><input type=\"submit\" value=\"save\">";
echo "</form>";

if ($_POST['save']) {
    $car_year = $_POST['car_year'];
    $car_make = $_POST['car_make'];
    $car_model = $_POST['car_model'];
    $description = $_POST['description'];

// Update data
    $update = mysql_query("UPDATE crud SET car_year='$car_year', car_make='$car_make' car_model='$car_model', description='$description' WHERE id=".$_GET['id']."") or die (mysql_error());
echo 'Update successfull';
}

?>


Please HELP!!!!

Hi I making some forms that write to mysql database, Im now in the process of making the update form so the user can update there details on the form, I want it to populate the form with existing data but its not doing it at all. Thanks in advance Attached Files  delete.php   210bytes   2 downloads  modify.php   4.03KB   4 downloads  index.php   473bytes   3 downloads

Hello:

I have a DB table with this structu
Code: [Select]
CREATE TABLE `gallery_category` (
  `category_id` bigint(20) unsigned NOT NULL auto_increment,
  `category_name` varchar(50) NOT NULL default '0',
  PRIMARY KEY  (`category_id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

What I am trying to do id pull this data into my "Edit Product" page and populate a SELECT menu with it.

I want the user to be able to re-assign a product to a new category if they chose to do so.

I want to add the data (and update the DB) to this area:
Code: [Select]
         <div style="float: left; width: 550px;">
          <select name='category_name'>
<option></option>
</select>

         </div>

This is the full page code that allows users to update product info:
Code: [Select]
<?php

include('../include/myConn.php');
include('../include/myCodeLib.php');
include('include/myCheckLogin.php');
include('include/myAdminNav.php');
include('ckfinder/ckfinder.php');
include('ckeditor/ckeditor.php');

$photo_id = $_REQUEST['photo_id'];

if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
$photo_title = mysql_real_escape_string($_POST['photo_title']);
$photo_price = mysql_real_escape_string($_POST['photo_price']);
$photo_caption = mysql_real_escape_string($_POST['photo_caption']);


$sql = "

UPDATE gallery_photos
   SET
      photo_title = '$photo_title',
      photo_price = '$photo_price',
      photo_caption = '$photo_caption'
  WHERE photo_id = $photo_id
  ";
  
mysql_query($sql) && mysql_affected_rows()

?>
<?php
}

$query=mysql_query("SELECT photo_title,photo_price,photo_caption FROM gallery_photos") or die("Could not get data from db: ".mysql_error());

while($result=mysql_fetch_array($query))
{
  $photo_title=$result['photo_title'];
  $photo_price=$result['photo_price'];
  $photo_caption=$result['photo_caption'];
}
?>

<!DOCTYPE HTML>

<html>
<head>

</head>

<body>

<div id="siteContainer">

<p>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST')
echo "<span class=\"textError\">". $photo_title ." successfully updated!</span>"
?>
</p>

<p>

         <form method="post" action="<?php echo $PHP_SELF;?>">
         <input type="hidden" name="POSTBACK" value="EDIT">
         <input type='hidden' name='photo_id' value='<?php echo $photo_id; ?>' />



         <div style="float: left; width: 120px; margin-right: 30px;">
          Category:
         </div>
         
         <div style="float: left; width: 550px;">
          <select name='category_name'>
<option></option>
</select>

         </div>





         
         <div style="float: left; width: 120px; margin-right: 30px;">
          Title:
         </div>
         
         <div style="float: left; width: 550px;">
          <input type="text" name="photo_title" size="45" maxlength="200" value="<?php echo $photo_title; ?>" />
         </div>
         
         <div style="clear: both;"><br /></div>
         
         <div style="float: left; width: 120px; margin-right: 30px;">
          Price:
         </div>
         
         <div style="float: left; width: 550px;">
          <input type="text" name="photo_price" size="45" maxlength="200" value="<?php echo $photo_price; ?>" />
         </div>
         
         <div style="clear: both;"><br /></div>
         

          Description:<br />
          <textarea cols="107" rows="1" name="photo_caption"><?php echo $photo_caption; ?></textarea>


         
         <div style="clear: both;"><br /></div>
         
         
           
         <br />
         
         <input type="submit" value="Submit" />
         
         </form>
         
</p>


</div>

</body>

</html>


How can I do this? I'm stumped ...

Thanks!

I used to be good at this but I changed servers and everything is different...  Heres my code so far:

Code: [Select]
<?php
$rated=$_REQUEST['rated'];
echo $rated;
$rating=$_REQUEST['rating'];
echo $rating;

// Make a MySQL Connection
mysql_connect("localhost", "********", "********") or die(mysql_error());
mysql_select_db("*********") or die(mysql_error());

$result = mysql_query("SELECT * FROM main WHERE username = '$rated'")
or die(mysql_error());  

$row = mysql_fetch_array( $result );

$votes = $db_field['$rating'];
$newvotes = $votes + 1;

echo $newvotes;

mysql_query("UPDATE main SET $rating = '$newvotes'
WHERE username = '$rated'");


?>
Whats going on here is the colomb that I want to update comes as a variable $rated (That works) and then the database selects the  row to update with $username (That works) and gets the variable $newvotes by taking the original value of the data its about to update and add 1 to it (That works)  Then it updates the field to $newvotes....

I don't know why the update won't go through... there are no errors....

Hi all

I have 3 tables
Table_1, Table_2 and Table_3

Table_1 is a list of countries, with name and country_id
Table_2 is a table that has 3 fields, id, name and description
Table 3 is a table that has name, Table_2_id

So what I need to do:
Display the name and description field of Table_2 in a form
Loop through the countries table and display each as an input box and display on the same form
When I fill out the form details, the name/description must be inserted into Table_2, creating an id
The input boxes data then also needs inserting into Table_3, with the foreign key of Table_2_id

So a small example would be:
Name: testing
Description:  this is a test
Country of Australia: Hello
Country of Zimbabwe: Welcome

This means that in Table_2, I will have the following:
=============================
| id   | name    | description
| 1    |  testing | this is a test
=============================

Table_3
=============================
| Table_2_id |  name         | country_id
| 1                    | Hello          | 20
| 1                    | Welcome  | 17
=============================

20 is the country_id of Australia
17 is the country_id of Zimbabwe

Code:

Generating the input fields dynamically:

                           $site_id = $this->settings['site_id'];

                           $options = '';
                           $country_code = '';
   $query = $DB->query("SELECT country_code, country_id, IF(country_code = '".$country_code."', '', '') AS sel FROM Table_1 WHERE site_id='".$this->settings['site_id']."' ORDER BY country_name ASC");
   
                               foreach ($query->result as $row)
                               {
                                        $options .= '<label>' . 'Test for ' . $this->settings['countries'][$row['country_code']] . '</label>' . '<br />';
                                        //$row['country_id'] is the country_id from Table_1
                                        $options .= '<input style="width: 100%; height: 5%;" id="country_data" type="text"  name="' . $row['country_id'] . '"  value="GET_VALUE_FROM_DB" />' . '<br /><br />';
                               }
                              echo $options;


This outputs:
Code: [Select]
Textareas go here......
<label>Test for Australia</label>
<input type="text" value="" name="20" id="country_data" style="width: 100%; height: 5%;">
<label>Test for Zimbabwe</label>
<input type="text" value="" name="17" id="country_data" style="width: 100%; height: 5%;">

Now, I need to insert the value of the input field and it's country_id (20 or 17) into Table_3 and also Table_2_id.
This then means I could get the value from Table_3 to populate 'GET_VALUE_FROM_DB'

But I'm at a loss on how I'd do this.

Could someone help me with this?

Thanks

I need help here. I am creating a system where the user will be able to update the product stock by uploading the stock of the products according to the id that has been assigned to the product. 
this is how my products table in  looks like in mysql database

 

I tried the code below but all i could not update my data into my database. And there's not error shown on my code. I do not know what is wrong with my codes. Please help me.
below the code that i use for uploading the CSV file to the data of my product_stock. 

<?php 
include 'conn.php';
if(isset($_POST["add_stock"]))
{
 if($_FILES['product_file']['tmp_name'])
 {
  $filename = explode(".", $_FILES['product_file']['tmp_name']);
  if(end($filename) == "csv")
  {
   $handle = fopen($_FILES['product_file']['tmp_name'], "r");
   while($data = fgetcsv($handle))
   {
    $product_id = mysqli_real_escape_string($conn, $data[0]);
    $product_stock = mysqli_real_escape_string($conn, $data[1]);  
    $product_status = 1 ;
    $query = "UPDATE products SET `product_stock` = '$product_stock', `product_status` = '$product_status' WHERE id = '$product_id'";
    mysqli_query($conn, $query);
   }
   fclose($handle);
   header("location: upload-product.php?updation=1");
  }
  else
  {
   echo '<script>alert("An error occur while uploading product. Please try again.")
   window.location.href = "upload-product.php"</script>';
  }
 }
 else
 {
  echo '<script>alert("No file selected! ")
  window.location.href = "upload-product.php"</script>';
 }
}
if(isset($_GET["updation"]))
{
  echo '<script>alert("Product Stock Updated successfully!")</script>';
}
?>

 <div class="col-12">
            <div class="card card-user">
              <div class="card-header">
                <h5 class="card-title">Update Product Stock</h5>
                <div class="card-body">
                <div class="form-group">
				<label for="file">Update Products stock File (.csv file)</label>
                <a href="assets/templates/product-template.xlsx" title="Download Sample File (Fill In Information and Export As CSV File)" class="mx-2">
				<span class="iconify" data-icon="fa-solid:download" data-inline="false">
				</a>
                </div>
                <form class = "form" action="" method="post" name="uploadCsv" enctype="multipart/form-data">
                <div>
                <input type="file" name="product_file" accept=".csv">
                <div class="row">
                <div class="update ml-auto mr-auto">
                <button type="submit" class="btn btn-primary btn-round" name="add_stock"> Import .cvs file</button>
                </div>
                </div>
                </div>
                </div>
                </form>
                </div>
              </div>

This is the template that i require user to key in and saved it in CSV format before uploading it. 

I'm trying to figure out how to add up all the $qty_total that exist into an overall total.

I hope I'm not oversimplifying my example..

I have this: $qty_total = $qty_insert * $d['workshop_price'];

$qty_insert loops several times and I want:

$overall_total = $qty_total + qty_total + ...however many..

Hello,
I'm going to be sending emails to users from a community calendar showing events for the day or a time frame specified elsewhere.  The problem I'm having is turning results of DB query into a string when there are multiple results for the day.  It works just fine with single results.  I understand why it doesn't work but can't figure out how to solve the problem.  Don't worry about the $eventdate as that comes from the same array as the $event_id used to call the array shown below.  I tried foreach and implode but couldn't get it working so I'm starting over and asking for your guidance on how is the best way to pull this off.  Thanks for your help.


Code: [Select]
$getevent = mysql_query("SELECT title, description from ".$conf['tbl']['events']." WHERE event_id=$event_id AND private=0");
WHILE ($gtevent = mysql_fetch_array($getevent)) {
$event_title=$gtevent['title'];
$event_description=$gtevent['description'];

$message="<p><span style=\"font-size:24px\">$event_title</span><br />$eventdate</p><p>$event_description</p>";

}  

I have this function, but it doesnt work. Basically the list outputs a list of news features, and puts a line under neath each article to seperate them. However once the last article has been reached, I don't want the break to be shown.

this is my code, any help would be appreciated as i am really struggling on this. Just need to determine the last item in the array, and stop the <hr split> from being output.
function newsFeature(){
$event = "SELECT imgname, title, content, pkID from news ORDER BY date, time DESC LIMIT 5";
$event_page = query($event);
$count = numRows($event_page);

while ($row = mysql_fetch_assoc($event_page))
{
$rowcount = $count;
$para = substr($row['content'] , 0,100);
$result .= '<article>';
$result .= '<a href="news-article.php?pkID=' . $row['pkID'] . '"><img src="uploads/thumbs/' . $row['imgname'] . '" alt="" width=116 height=83/ ></a>';
$result .= '<h2><a href="news-article.php?pkID=' . $row['pkID'] . '">' . $row['title'] . '</a></h2>';
$result .= '<p>' . $para . '...</p>';
$result .= '<p><a class="read-more" href="news-article.php?pkID=' . $row['pkID'] . '">Read more<span></span></a></p>';
$result .= '</article>';
if($row != end($row[])){
$result .= '<hr class="split">';
}
}
return $result;
}

I cannot get this INSERT to work. Not records are being added to the sys_city_dev table. No query errors are being thrown.

I am simply trying to add ALL records from all_illinois to sys_city_dev and Mid should have be add as 11 in all inserts. city_name of course will be field city_name from all_illinois.

Here is my code:

$query = "SELECT * FROM all_illinois";
      if ($results = mysqli_query($cxn, $query))
        {
          $row_cnt = mysqli_num_rows($results);
          echo $row_cnt . " Total Records in Query.<br /><br />";
          if (mysqli_num_rows($results))
            {
              while ($rows = mysqli_fetch_array($results))
                {
                  echo $rows['city_name'] . "<br />";
                  $mid_id = '11';
                  $insert_city_query = "INSERT INTO sys_city_dev (ID, Mid, cityName, forder, disdplay, cid) VALUES
(' ','" . $mid_id . "','" . $rows['city_name'] . "', '', '','')";
                  if (!$insert_city_query)
                      exit(mysql_error());
                }
            }
        }

Here is my insert table structure and 5 records dump:

--
-- Table structure for table `sys_city_dev`
--

CREATE TABLE IF NOT EXISTS `sys_city_dev` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Mid` int(11) NOT NULL DEFAULT '0',
  `cityName` varchar(30) NOT NULL DEFAULT '',
  `forder` int(4) NOT NULL DEFAULT '0',
  `disdplay` int(4) NOT NULL DEFAULT '0',
  `cid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=113970 ;

--
-- Dumping data for table `sys_city_dev`
--

INSERT INTO `sys_city_dev` (`ID`, `Mid`, `cityName`, `forder`, `disdplay`, `cid`) VALUES
(84010, 1, 'Dothan', 0, 0, 0),
(84011, 1, 'Alabaster', 0, 0, 0),
(84012, 1, 'Birmingham', 0, 0, 0),
(84013, 2, 'Flagstaff', 0, 0, 0),
(84014, 1, 'Auburn', 0, 0, 0);


And the all_illinois dump w/ 5 records:

--
-- Table structure for table `all_illinois`
--

CREATE TABLE IF NOT EXISTS `all_illinois` (
  `state_id` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `all_illinois`
--

INSERT INTO `all_illinois` (`state_id`, `city_name`) VALUES
('135', 'Abingdon'),
('135', 'Adair'),
('135', 'Addieville'),
('135', 'Addison'),
('135', 'Adrian');

Hi all, Im really struggling to build an update multiple records form, Ive built my table which calls all data i need from the db in a looped region which works fine I just cant understand how to then input these back into the table in the correct rows, if this makes sense? Ive been reading this tutorial but Its not very informative its more of a copy and paste http://www.phpeasystep.com/mysql/10.html

Hi,

I'm using php to access the mysql database using mysqli and I have a field on my table called "timestamp" and it's set as a timestamp and has current_time (I think in phpmyadmin it was a tick option so I clicked it) and when I update that row in my table the field "timestamp" doesn't update with the timestamp from when it was last updated/modified. I thought the field option timestamp automatically did that? I'm guessing not.. is there a way I can update the timestamp with the current time in my query?

                 $query1 = "select * from movies where title = '".$title."' ;";
 $result1 = mysql_query($query1) or die('Could Not Execute The Query');
 while ($row = mysql_fetch_assoc($result1) )
                       {
                       for($f=0; $f<$parts[$current_k]; $f++ )
{
        touch("$base_folder/{$hos}/".$linking[$sum].".php");


$old_part_href = $row['href_parts'];

$updated_part = $old_part_href.$new; 
$query_href = 'update movies set href_parts = \''.$updated_part.'\'';
mysql_query($query_href) or die('COULD NOT EXECUTE THE QUERY FOR PARTS HREF');
$new = "{$base_folder}/{$hos}/".$linking[$sum].".php";


$sum++;
}
                      }

what i am trying to do is take the value of href_parts and add the new href of the page to the existing value on the href_parts and update the href_parts field in my db.. but i am not getting the desired results.. all i am getting in the db is the last value that is passed in the loop in the db.. i want to save the values which are exisiting in the db and add the newly created values to itt.. can anyone help please..

I'm back, I have a code that based on my understanding should work, but needless to say doesn't

<?php
$sql ="select * from `piprice`";
$result = mysql_query($sql);
$count = mysql_num_rows($result);

echo "<table border=1><tr><td>Product Name</td><td>Item ID</td><td>Price</td><td>Enabled</td>";
echo "<form action=main.php?id=test1.php method=post>";
while ($row = mysql_fetch_array($result)) {
echo "<tr><td>".$row['product name']."</td>";
echo "<td>".$id[] = $row['item id'];$row['item id']."</td>";
echo "<td>".$row['price']."</td>";
$enabled[] = $row['enabled'];
echo"<td><select name=".$enabled."><
<option Value=".$row['enabled'].">".$row['enabled']."</option>
<option Value=Yes>Yes</option>
<option Value=No>No</option>
/select></td</tr>";
}
echo "<input name=submit type=submit value=Update>";
echo "</form></table>";
if(isset($_POST['submit']))
{

for($i=0;$i<$count;$i++){
$sql1="UPDATE `piprice` SET `enabled` = '$enabled[$i]' WHERE `item id` ='$id[$i]'";
$result1=mysql_query($sql1) or die (mysql_error());

}
}
?>

Basically I want to be able to pick yes/no and have it update in the database.

One a side note is there a good site for me to learn php on (I just know the basics) besides asking 101 questions here