PHP - Delay Before Updating Data

Hey guys,

I got another one that i could use some help on.  I have a input form that utilizes a javascript that adds additional rows to my table.  here is a look at what i got.

Code: [Select]
<script type="text/javascript">
function insertRow()
{
    var x = document.getElementById('results_table').insertRow(-1);
    var a = x.insertCell(0);
    var b = x.insertCell(1);
    var c = x.insertCell(2);
    var d = x.insertCell(3);
    var e = x.insertCell(4);

    a.innerHTML="<input type=\"text\" name=\"id\">";
    b.innerHTML="<input type=\"text\" name=\"place\">";
    c.innerHTML="<input type=\"text\" name=\"username\">";
    d.innerHTML="<input type=\"text\" name=\"earnings\">";
    e.innerHTML="<input type=\"button\" value=\"delete\" onClick=\"deleteRow(this)\">";
}

function deleteRow(r)
{
    var i=r.parentNode.parentNode.rowIndex;
    document.getElementById('results_table').deleteRow(i);
}

</script>
this is my code stored in the header of my page.  basically just a button to add a new row and a button in each row to delete rows if needed.

here is a look at my html table, pretty basic...

Code: [Select]
<table id="results_table">

            <th>Event ID</th><th>Place</th><th>Username</th><th>Earnings</th>

            <tr>
                <td><input type="text" name="id"></td><td><input type="text" name="place"></td><td><input type="text" name="username"></td><td><input type="text" name="earnings"></td><td><input type="button" value="delete" onClick="deleteRow(this)"</td>
            </tr>

        </table>
Now what I am hoping to acheive is once i submit all of these rows to the database i will insert each of these rows into their own row in the database.  is this doable?

the structure of my database is:

ResultID (Primary Key)
Place
Earnings
UserID (Foreign Key)
EventID (Foreign Key)


now i think the biggest problem i'm having with submitting data to the database is that in the original HTML form I am typing in the actual username and not the userID. 

so when it comes to processing I need to do a switch of these two things before I run my query.  Should something like this work?

Code: [Select]

$username = $_POST['username'];

$userID = "SELECT userID FROM users WHERE username="$username";

$query = mysql_query($userID);



also i've never tried to submit multiple entries at a time.  maybe i have to create an array somehow in order to capture each rows data.  any thoughts?

as always thanks for the help.

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

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

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

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

Evening,

In simple, I have a script that loops through members when submitted and sends them a confirmation email for an event. However I don't want to send 200 emails one after the other because Google would get very upset.

Thus! I attempted to use sleep()() but that didn't function as I thought it would inside the loop. Causing the entire thing to wait for the amount of seconds times the result set. So. Whats would you suggest?

Thanks.

Hello there,

I was wondering what coding would be required to block users from clicking/viewing content.

My idea was only to allow people to request songs every 2 minutes.

would I use PHP for this in terms of the request form template which is:


<?php
$song = file_get_contents('http://site.com/song.php');
if(!empty($song))
{
header('Location: song-requests-interface.php');
}
else  
{
header('Location: offline.html');
}
?>


Or would I use JS. The trouble is, I'm unsure if JS would be able to remember the users details. They could easily refresh the page.

Many thanks

Hi guys and gals, i have two sites which interact with each other, if someone lands on my local site and searches, if the answer isnt found it will transfer them to my other site which has a wider range for what they are looking for.

My question is, how would i go about delaying the transfer and displaying a message that the user is now being transfered to a different site?

I was thinking something similar to one of those uploading please wait type overlays or somthing?

Any ideas would be useful, at the moment its done with a simple form and php, but is instant.

quick questions..

i have this code



echo '<p>message of error</p>';

echo"<script type='text/javascript'> window.location='index.php'</script>";



and i want to know how could i delay the redirect to index.php for about 5 seconds or so?

i've found how to do it using header(); but I've used that before and have gotten alot of errors, which is why i use on javascript to do it for me.

Hi,

I have some queries that update some statistics in a table I have. I need these queries to run only after 15 seconds have passed however. This way if the user leaves before the 15 seconds, the queries won't run. I've tried using Sleep, however it seems to just stop all the code all together for the allotted time. There must be a way to do this.

Monday, everything worked fine.  Tuesday godaddy started updates.  Now, today this.   I'm trying to get a distinct list of years from an auto database for user input.  As mentioned, Monday this code worked no problems.  And fyi worked fine for years.

<?php
	$Car_Info_Con = mysql_connect($host,"marcomdata",$password);

	if (!$Car_Info_Con) {die('Could not connect: ' . mysql_error());}
	mysql_select_db("marcomdata", $Car_Info_Con);
	
	// Works, is fast, but not what I want.
	$Car_Info_All_SQL="SELECT * FROM car_make ORDER BY year DESC ";
	

	// These cause the page to SLOW DOWN and eventually finishes with
	// an empty select element.

	//$Car_Info_All_SQL="SELECT * FROM car_make GROUP BY year ORDER BY year DESC ";
	//$Car_Info_All_SQL="SELECT year FROM car_make GROUP BY year ORDER BY year DESC ";
	//$Car_Info_All_SQL="SELECT DISTINCT year FROM car_make ORDER BY year DESC ";


	echo $Car_Info_All_SQL . '<br />';

	$Car_Info_All_results=mysql_query($Car_Info_All_SQL);

	$year_html = '<select id="year" name="year" onchange="do_Auto(this.name,this.value)"onfocus=" clear_state(this.name);" onblur="saveData(this.name,this.value);">';

	if($cur_car_year=='') {
		$year_html.='<option></option>';
	}

	if ($Car_Info_All_results) {

		while ($row = mysql_fetch_array($Car_Info_All_results)) {
			if ($row['year']==$cur_car_year) {
				$year_html.='<option selected>'.$row['year'].'</option>';
			}
			else {
				$year_html.='<option>'.$row['year'].'</option>';
			}
		}

	}

	$year_html.='</select>';

	mysql_close($Car_Info_Con);

	echo $year_html;
?>

What am I missing?  I can take the above SQL statements and run them inside the database and it is ripping fast. For example,  SELECT year FROM car_make GROUP BY year ORDER BY year DESC returns : Showing rows 0 - 29 (79 total, Query took 0.1548 sec)    whats going on here?   don't tell me it's godaddy.  Was on the phone with them for a while already today and it "isn't anything on their end."   Options?   Thanks so much for your help!   Nick    

My host has a limit of 100 emails per hour and this is now being reached to many times a day and some emails are not being sent due to this.

Does anyone have a script or know of one that can stack emails to be sent in MySql or something and every 5 minutes send one out from the stack and then delete from the stack the ones sent.

So, I am making a CMS for my school and I am having some trouble.

It's a magazine sort of CMS and what I want is that when you click on a certain thing it continues onto the next page. Through the CMS you can create pages - when you do this each page gets a unique PID. To access the pages you have to enter the PID on the end of the URL, e.g. : http://www.myschool.com/magazine/index.php?pid=x. What I need is a code that when an image gets clicked the PID number in the URL goes up by one.

Thanks