Insert Data From Another Table With Foreign Key?

Mar 20, 2011

I have a problem inserting a data into another table that has foreign key using PHP. I have a table named CUSTOMER_INFORMATION with fields(customer_no(PK), first_name, last_name, etc..) and a CATERING_RESERVATION table with fields(catering_no(PK), type_of_event, number_of_persons, customer_no(FK), etc).. I wanted to insert the customer_no in the CATERING_RESERVATION table but I have this error:

"Cannot add or update a child row: a foreign key constraint fails (`thesis/catering_reservation`, CONSTRAINT `catering_reservation_ibfk_1` FOREIGN KEY (`customer_no`) REFERENCES `customer_information` (`customer_no`) ON DELETE CASCADE)"

But I think I lack some codes on this. I'm just a newbie in php.[code]...


View 1 Replies


Insert Query Doesn't Insert Data To Mysql Database Table?

i have a recipe table and ingredient table the primary key of both tables are auto increament and primary key of recipe is foreign key in ingredient. i post data from html to php.Note that my ingredient textboxes are generated dynamically and successfully post the data to php script. posted data is correct when i insert this data to table my query working fine but data is not added to mysql table. my code and output is

$sql = "insert into recipe (rec_id, Name, Overview,category, Time, Image) values ('', '$name','$overview','$category','$time','$TARGET_PATH')";
$result = mysql_query($sql) or die ("Could not insert data into DB: " . mysql_error());
$rec_id = mysql_insert_id();


View 5 Replies

Grab Data From A Table, Echo, Then Insert It Into A New Table...

I'm trying to do is count the number of times usernames shows up in a table. I then want to reinsert that information into a different table with the Username in column1 & the occurrences in column2 for every user that is echoed on the page. Code:

View 5 Replies

Checkbox Form - Insert Row Data From One SQL Table To Another Table?

I have two tables "tbl_jobs" and "tbl_jobs_done". I have an SQL query which displays and formats my daily job list from tbl_jobs SQL database, and has a checkbox at the end of each row. I want to be able to select 1, 2, 3 or more checkboxs and then click my submit button which will then insert the data into my second MySQL database named "tbl_jobs_done". i have spent hours and hours looking at tutorials and other peoples forum posts but can't seem to find something that hits home and works for me I only need the jobs_id field data from the tbl_jobs to be inserted into tbl_jobs_done table and into jobs_id field. I have other data on the form that will also be submitted. But in general, that's all I need. Here is my SQL Query ->


View 4 Replies

Find All Of The Rows In The Primary Table That Doesn't Exist In The Foreign Table

i have 2 databases, one uses the primary key of another as the foreign key. I want to find all of the rows in the primary table that doesn't exist in the foreign table. e.g:

table jobs:


table companies

from the example above i want to find all companies that have NOT had any jobs between one date and another.

View 5 Replies

CakePHP - Custom HasOne Object Association - Using A Join Table Instead Of In-table Foreign Keys?

In CakePHP, I'm trying to build a $hasOne relationship, but I can't add a foreign key to the tables (for legacy reasons). Is there any way I can create a join table (object1_object2) and link them together like this? I want to leverage Cake's powerful object relationship functionality, so if there's a way I can make this custom association permanent throughout the model, without always building a custom $options array for each find(), that'd be great. (Maybe a bindModel in the Model's initalize()?)

View 2 Replies

Use Multiple Foreign Keys In One Table Referencing Another Table In Cakephp?

Using cakephp, I have a generic address table, which I want to link to customers, vendors, contacts. most of the tables only have a 1 to 1 relationship, but I want my customers table to have 2

perhaps for clarification: I have a customers table

id, int
mailing_address_id, int
billing_address_id, int

and an addresses table

addr, varchar
city, varchar

Now I know I could put a customer_id in the addresses table. But I don't want to do that because I have a vendors table, and contacts table, and other tables that all are going to use the addresses table. the customer_id would not really be relavant to those other tables.

I'd like the Customer model to automatically link in the two addresses

View 4 Replies

Update Table While Insert Data To Another Table

it seem like mine coding din work.

$conn=mysql_connect('localhost','root','') or die ('Could not connect to server');
$today = date("Y.m.d");
mysql_select_db('hms', $conn);

$ok = mysql_query("INSERT INTO check_in(ID,room_no,datein)values ('$ID','$room','$today')", $conn);

if( $ok ){

$up = mysql_query("UPDATE studtable SET checked = 'checkin' where [ID] = '%ID');

if(mysql_affected_rows( $up ) == 1)
echo'Checked IN!'
}else { echo'No such student to check in' }}
else { echo'Check In FAILED, please check again'}?>[php]

View 1 Replies

Put The Value Of One Field In The First INSERT Into The Second As A Foreign Key

I am developing what could be likened to a very simple php/mysql forum solution for a client. I have come to an instance where I need to do two INSERT queries on my MySQL database to put data into two tables. However i need to put the value of one field in the first INSERT into the second as a foreign key sorta thing.

The field i need the value for is an auto incrementing field. Is it possible to return the value of the auto incremented field after and INSERT query so that i can then use this value and insert it into the second table. I think I could probably do this by doing a SELECT query in between to find the max value of that column and then use that but I can't see this being the most efficient method.

View 1 Replies

Using Session To Insert Foreign Key?

i am trying to use a session to insert in to the database a user_id of a user who is posting a topic in to the topic table to act as a foreign key in the topic table. but i kept getting 0 in the user_id column instead of the real userid below is my code.

<?php require_once('Connections/forum_con.php'); ?>
//initialize the session


View 2 Replies

Insert Data And View Data From Multiple Table?

Can some 1 tearch how to insert data and view data from multiple table, by primary key and unique.

View 8 Replies

MySQL Insert With Undefined Foreign Key?

I have some table with such schema (simplified):

INDEX FK_folders_folders_id (parent),
CONSTRAINT FK_folders_folders_id FOREIGN KEY (parent)

1 folder can have many subfolders and can belongs to one another folder. If it's root folder then parent will contain it's own ID. The problem is: how can I create root folder? ID is auto_increment and I can get it only after inserting a row but I cant insert row while parent is not defined. Recursion...

View 1 Replies

Insert Data Into A Table

PHP Code:

$connection = mysql_connect("localhost", "******", "******");
if (!$connection)
die('Could not connect: ' . mysql_error());

mysql_select_db("trickyph_testdb1", $connection) or die('Could not select DB.');
$query = "INSERT INTO users (FirsName, LastName, Address, City) VALUES ('Jimmy', 'Watts', &#39484; Wolfer Ln.', 'Springston')";
mysql_query($query, $connection);

View 5 Replies

Insert XML Data To SQL Table

how to handle xml files. Here's the scenario, I have XML file, i want that each data from my xml file will be inserted into my database. How can I do that?

View 5 Replies

Data Not Getting Insert In To Table?

I am getting the error msg; Mysql error, data not saved, try again -You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7

PHP Code:
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="merchandising"; // Database name


View 2 Replies

Insert Data To A Table

I just can't figure out why it isn't sending the data to the table, I've check the names over and over, all the info is parsed correctly, but it falls flat at: $result = mysql_query($sql);

View 4 Replies

Insert Data To Table

i have a user(members) form that pulls from my database 3 fields: name, age, about. i want the user to be able to edit their info then re-submit back to the database. however, i want to have some control as to what they edit their info to. so instead of just update the info back to the database.

i want to hve any fileds that have 'changed' by the user get put to a different table(review), so after i have approved the changes i will 'update the master user table. is there a logical way that i could do this, i guess just flag any fields that have changed when the user form is submitted.

View 1 Replies

Insert Data Into A Table?

I am trying to insert data into a table, but I am not able to insert it. I wanted to see what the error was using mysql_error() function, but it does not return any error string for me.

global $error;

View 2 Replies

Using An Array To Insert Data Into A Table.

This works:
$col1 = 2;
$col2 = 2;
$col3 = 2;
$col4 = 2;
$query = "INSERT INTO test (a,b,c,d) VALUES ($col1,$col2,$col3,$col4)";

and this does not

$col = array(2,2,2,2);

$query = "INSERT INTO test (a,b,c,d) VALUES ($col)";

View 6 Replies

Mysql_query - Insert Data Into A Table

I have the following code to insert data into a table. Why doesn't it work?

$query="INSERT INTO logs (ipaddress,sid,cid,vid) VALUES ($ipaddress,$sid,$cid,$vid)";

View 3 Replies

Insert Data In A Html Table

here is the code:


foreach($a as $key)
echo '<table><tr><td>'.$key.'</table></tr></td>'

foreach($d as $key=>$value)
echo '<table><tr><td>'.$key.'<td>'.$value.'</table></tr></td>'

foreach($e as $key=>$value)
echo '<table><tr><td>'.$key.'<td>'.$value.'</table></tr></td>'.

View 2 Replies

Fastest Way To Insert Data Into Table?

I am trying to find the fastest way to insert data into a table (data from a select) I always clear the table:


Then I do this to insert the data:

INSERT INTO table(id,total) (SELECT id, COUNT(id) AS Total FROM table2 GROUP BY id);

Someone told me I shouldn't do this. He said this would be much faster: CREATE TABLE IF NOT EXISTS table (PRIMARY KEY (inskey)) SELECT id, count(id) AS total FROM table2 GROUP BY id I think my solution is cleaner, because I don't have to check for the table.

View 7 Replies

Can't Insert Data In Pmsout Table

I'm trying to insert some data into 2 tables, in the first table the data are going OK, but in the second no ... why?

include ("blocks/db.php");
if (!empty($_SESSION['username']) and !empty($_SESSION['password']))
$username = $_SESSION['username'];

The problem is: I can't insert data in pmsout table

View 5 Replies

Insert Xml Data Into Mysql Table?

So far I can read and print the data using simple xml or dom. My next step is insert the data into a mysql table.

View 3 Replies

Insert Data Into Different Database Table?

Through one html form how to insert data into different database table.

View 23 Replies

Insert Data Into Two Table From A Web Form?

table person
table email

What is the sql comment for insert data form a web form into these tables? In the web form I have a text box for name and dynamic text box for email

View 4 Replies

Copyrights 2005-15, All rights reserved