send one table values to another table with new fields how?

**Claus Mygind** · Feb 5 '15, 02:25 PM

In your receiving app where you want to update the 2nd table:

1) get rid of this line

Code:

    echo "<pre>", print_r($_REQUEST, true), "</pre>";

2)you don't want to "echo" the $sql variable so delete "echo"

3)
Another way to write the same code for the $sql statment is using the "set" method, which makes it easier for the programmer (you) to read would be like this

Code:

    $sql= 'insert into '.$exam.' set 
		id ="", 
		exam ='.$exam.', 
		regno ='.$regno.',
		name ='.$name.',
		class ='.$class.',
		batch ='.$batch.',
		institute ='.$institute.',
		fname ='.$fname.',
		mname ='.$mname.',
		mobile ='.$mobile.',
		email ='.$email.',
		stumark ='.$_POST[stumark];

**webtechbharathi** · Feb 6 '15, 07:55 AM

dear Claus Mygin,
i am happy with your solution but i get some trouble to store this "stumark" field to my table here i attach my updated query with "stumark" int this query working 100% correct but my table not get this value of stumark, and i copy and paste the update query to my wampp its updated and stored successfully.bu t i run webpage its not store to db.
here i attach my updated php file.

Code:

<html>
<head><title>sub vendors upadate</title>
<?php
include("menu.php"); ?>
</head>
<body>
<?php 
echo "<pre>", print_r($_REQUEST, true), "</pre>";
$id=$_GET['id'];
include("db.php");

if(isset($_GET['id']))
{

if(isset($_POST['submit']))
{  
//$id=$_POST['id'];
$exam=$_POST['exam']; echo"<br>";
 $regno=$_POST['regno'];echo"<br>";
 $name=$_POST['name'];echo"<br>";
 $class=$_POST['class'];echo"<br>";
 $batch=$_POST['batch'];echo"<br>";
 $institute=$_POST['institute'];echo"<br>";  
 $stumark=$_POST['stumark'];echo"<br>";
 $fname=$_POST['fname'];echo"<br>";
 $mname=$_POST['mname'];echo"<br>";
 $mobile=$_POST['mobile'];echo"<br>";
 $email=$_POST['email'];echo"<br>";
echo  $sql=("update ".$_REQUEST['exam']." SET exam= '$exam',regno= '$regno',name= '$name',class= '$class',batch= '$batch',
institute= '$institute',stumark= '$stumark',fname= '$fname',mname= '$mname',mobile= '$mobile',email='$email' where id='$id'");
if($sql)
{
//header('location:vendorsview.php');
}
}
}

**Claus Mygind** · Feb 13 '15, 03:58 PM

You missed inserting all the . between your string and parameters.

You have

Code:

echo  $sql=("update ".$_REQUEST['exam']." SET exam= '$exam',regno= '$regno',

It should be. I've underlined the . to point them out to you.

Code:

echo  $sql=("update ".$_REQUEST['exam']." SET exam= '[B][U].[/U][/B]$exam[B][U].[/U][/B]',regno= '[B][U].[/U][/B]$regno[B][U].[/U][/B]',

**Claus Mygind** · Feb 16 '15, 01:34 PM

Here is a more complete example of what I think you are trying to do. Many assumptions had to be made about what you are doing. But if you remove all my comments you will see very few line of code are required to update a table with new information (see the 2nd code insert below in this reply). And remember this is only one way to do it.

Code:

<?php

	/*
	---------------------------------------
	you don't need to create an output
	page if all you are doing is updating
	the database table.  Just return the
	update result to the calling page.

	see example below.
	---------------------------------------
	*/
//	<html> ---NOT NEEDED
//		<head>
//			<title>sub vendors upadate</title>---NOT NEEDED
//			include("menu.php"); 
//		</head>---NOT NEEDED
	
//		<body>---NOT NEEDED

		
try  /* Error trap entire the applet. */
{
		
		
		/*
		--------------------------------
		store your input parameters
		in a simple variable $c,

		it just makes it easier to read
		--------------------------------
		*/
		$c = $_REQUEST;

/*-EXAMPLE OF WHAT SHOULD BE IN YOUR DB.PHP MODULE-----------------------------
		/*
		---------------------------------
		We must assume this is where 
		you have your database connection
		---------------------------------
		*/
//		include("db.php");

		/*
		-----------------------------------------------------
		HERE IS ONE EXAMPLE OF WHAT SHOULD BE INSIDE YOUR DB.PHP MODULE

		there are several methods to connect your database
		like pdo and mysqli.  this is just one example of
		what should be in your db.php library module.

		if you add a class like this one below you can add
		your own custom functions inside of it which you can
		call from your other apps
		-----------------------------------------------------
		*/
		class dbcnx extends mysqli
		{
		} // end custom class dbcnx


		/*
		-----------------------------------------------
		after you create your extended mysqli class
		assign it to an easy to understand variable
		like this

		Note the reference to your custom class dbcnx

		Be sure to add your login parameters
		-----------------------------------------------
		*/
		$db = new dbcnx("000.000.00.0", "your user login", "your user's password", "your database name");
		 
		/* check connection to make sure it connected otherwise stop */
		if (mysqli_connect_errno()) {
			throw new Exception("Connection to database failed");
			exit();
		}

/*-END EXAMPLE OF WHAT SHOULD BE IN YOUR DB.PHP MODULE-----------------------------*/

/*
---------------------------------------------
Now back to your program to update the table
---------------------------------------------
*/
 

		/*
		----------------------------
		Use this test to see 
		if you passed the parameter

		Remember you stored the input
		parameters in $c
		----------------------------
		*/
		if(isset($c['id']))
		{
			/*
			-----------------------------------------
			we will assume all your table columns
			are CHAR, so we will enclosed the values
			in quotes " ", otherwise the database
			update will fail.
			-----------------------------------------
			*/
	 
			$sql=(	'UPDATE '    .$c['exam'].
					' SET exam="' .$c['exam'].'" '.
					',regno="'    .$c['regno'].'" '.
					',name="'     .$c['name'].'" '.
					',class="'    .$c['class'].'" '.
					',batch="'    .$c['batch'].'" '.
					',institute="'.$c['institute'].'" '.
					',stumark="'  .$c['stumark'].'" '.
					',fname="'    .$c['fname'].'" '.
					',mname="'    .$c['mname'].'" '.
					',mobile="'   .$c['mobile'].'" '.
					',email="'    .$c['email'].'" '.
				' WHERE id="'     .$c['id'].'")';

			/*
			-----------------------------------------------
			To execute the $sql statement we now reference
			our database connection which was defined as
			$db in our custom class.
			-----------------------------------------------
			*/

			if($db->query($sql))
			{

				//header('location:vendorsview.php');
				/*
				if this is what you want to do here
				you better read the manual

				http://php.net/manual/en/function.header.php

				to make sure you include the exit command
				
				
				Personally I would return a success or failure
				notice to the original calling page instead

				*/

				$responseText = 'There was '.$db->affected_rows.' row(s) updated';
				/*
				---------------------------------
				this should give you a count of 1 
				if the update was sucessful
				---------------------------------
				*/

			}else{
				/*if your query fails exit the program here */
				throw new Exception("sql query failed");
			}
		}

} // end try
catch (exception $e) 
{
	/* if a error occured it would end up here*/
	$responseText = 'An error occured :<br>' .$e->getMessage();
}

/*
either you return some text of the success or the error
*/
echo $responseText;
?

If your database connection program is properly setup as I have suggested above, this is the only code needed to update your table

Code:

<?php
try  /* Error trap entire the applet. */
{
		$c = $_REQUEST;
		if(isset($c['id']))
		{
			$sql=(	'UPDATE '    .$c['exam'].
					' SET exam="' .$c['exam'].'" '.
					',regno="'    .$c['regno'].'" '.
					',name="'     .$c['name'].'" '.
					',class="'    .$c['class'].'" '.
					',batch="'    .$c['batch'].'" '.
					',institute="'.$c['institute'].'" '.
					',stumark="'  .$c['stumark'].'" '.
					',fname="'    .$c['fname'].'" '.
					',mname="'    .$c['mname'].'" '.
					',mobile="'   .$c['mobile'].'" '.
					',email="'    .$c['email'].'" '.
				' WHERE id="'     .$c['id'].'")';

			if($db->query($sql))
			{
				$responseText = 'There was '.$db->affected_rows.' row(s) updated';
			}else{
				/*if your query fails exit the program here */
				throw new Exception("sql query failed");
			}
		}

} // end try
catch (exception $e) 
{
	$responseText = 'An error occured :<br>' .$e->getMessage();
}

echo $responseText;
?>

send one table values to another table with new fields how?

send one table values to another table with new fields how?

Comment

Comment

Comment

Comment