Jump to content


PHP/MySQL INSERT INTO Multiple Tables from Basic Form

insert into phpmysql upload file

  • Please log in to reply
3 replies to this topic

#1 kanoy83

  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 31 July 2013 - 11:14 PM

hi guys,

i have simple form submission with title, description and file upload, this file having size,type,filename will insert to table3, ALL same time after ADD.

am trying to make a simple PHP form submission and insert data to 3 MySQL tables:

-category_name (dropdown menu)

-category_id(FK, automatic when dropdown selected) NOT WORKING

table2: (automatic insert file properties info here)

-id // auto increment
-table1_id(FK, automatic get ID from table1) NOT WORKING

-category(drop down)
-upload file (get the file info like type,ext,size,filename)

Status: it is inserting but only 2 not working


$sql2, I just try to use it but some problem in real escape string, but anyway, I think this is simple, maybe either mysql statement or handling of php data?

here's the CODE:

<strong>Fill up the form:</strong><br /><br>            	

	<form enctype="multipart/form-data" action="upfileone.php" method="POST">
		Date: <?php echo date("d-M-Y") ?>
                <input type="text" name="title" value="<?php echo $sel_filepage['file_title']; ?>" id="file_title" />

                <textarea name="description" rows="4" cols="24">
				<?php echo $sel_filepage['content']; ?></textarea>
        <select name="select_cat">
        <?php $cat_set = get_all_categs();
    	    while($category = mysql_fetch_array($cat_set)){
				$catname = $category['cat_name'];
                echo '<option value="'.$catname.'">'.$catname.'</option>';
		<label for="file">Choose File to Upload:</label>
	    <input type="file" name="upfile" id="upfile" > <br /><br />
	    <input type="hidden" name="MAX_FILE_SIZE" value="1000000" />
	    <input type="hidden" name="filepage" value="<?php echo $_GET['filepage']?>">
	    <input type="submit" name="upload" value="Add" class="pure-button pure-button-success">
	    <a href="content.php?filepage=<?php echo $sel_filepage['id']; ?>" class="pure-button">Cancel</a>
	</form> <!-- END FORM -->




// directory to be saved
$target = "server/php/files/";
$target = $target . basename($_FILES['upfile']['name']);

// gets info from FORM

$currentDate = date("Y-m-d");
$file_title = $_POST['title'];
$content = $_POST['description'];
$category = $_POST['select_cat'];
$upfile = ($_FILES['upfile']['name']);

$currentDate = date("Y-m-d");
$file_title  = mysqli_real_escape_string($_POST['title']);
$content     = mysqli_real_escape_string($_POST['description']);
$category    = mysqli_real_escape_string($_POST['select_cat']);
$upfile      = ($_FILES['upfile']['name']);

// connects to db
$con = mysqli_connect("localhost", "root", "password", "database");
	echo "error connection" . mysqli_connect_error();

// insert to database
$sql = "INSERT INTO filepages (category_id,file_title,content)
VALUES ('$category','$file_title','$content')";

$new_id = mysqli_insert_id($con); 

$sql2 = "INSERT INTO fileserv (filepages_id, filetype, filesize, filedate, filename) 
VALUES ($new_id, '{$_FILES["upfile"]["type"]}', '{$_FILES["upfile"]["size"]}', '$currentDate', '{$_FILES["upfile"]["name"]}')"; 

if(!mysqli_query($con, $sql2)) 
    die('Error ' . mysqli_error()); 

	$sql3 = "BEGIN
  			INSERT INTO filepages (category_id, file_title, content)
				VALUES ('$category','$file_title','$content')
			INSERT INTO fileserv (file_date)
				VALUES ($currentDate)

if(!mysqli_query($con, $sql2))
	die('Error ' . mysqli_error());
echo "1 File Added <br>";

    if (file_exists("server/php/files/" . $_FILES["upfile"]["name"]))
      echo $_FILES["upfile"]["name"] . " already exists. ";
		insertFile(	$_POST['filepage'], 
					($_FILES["upfile"]["size"] / 1024), 
      	move_uploaded_file($_FILES["upfile"]["tmp_name"],"server/php/files/" . $_FILES["upfile"]["name"]);
		echo "The FILE " . basename($_FILES['upfile']['name']) . " has been uploaded.<br>";
      	echo "Stored in: " . "server/php/files/" . $_FILES["upfile"]["name"] . "<br>";
		echo "Upload: " . $_FILES["upfile"]["name"] . "<br>";
		echo "Type: " . $_FILES["upfile"]["type"] . "<br>";
		echo "Size: " . ($_FILES["upfile"]["size"] / 1024) . " kB<br>";
		echo "Temp file: " . $_FILES["upfile"]["tmp_name"] . "<br>";

#2 Muddy_Funster

  • Members
  • PipPipPip
  • Advanced Member
  • 3,383 posts

Posted 01 August 2013 - 07:41 AM

*cough* *cough* Triggers *cough* *cough*

Please: "This doesn't work..." is not a question.  We're not the government: we don't have anything to view what your doing on your computer.  Help us help you by asking a good question.


"Things needed to ask a "good" question:

  • A description of the context of your issue (Optional but can be a huge help in certain circumstances)
  • What is the actual problem (Mandatory)
  • What does the code actually do (Mandatory)
  • What you think the code should do / What you want the code to do (Mandatory)
  • What things have you tried so far (Optional, but missing it out just wastes your time and ours)
  • The actual code as you are running it - minus any personal information like Database Login Credentials (Mandatory - don't just post pseudo, the vast majority of issues are syntax and not logic)
  • As much info about your development environment as you can give - even if it's just letting us know you are using a hosting provider instead of a local install (Optional, but some questions can not be answered without it.)

#3 kanoy83

  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 02 August 2013 - 06:07 PM



sorry, i think you posted to different thread.

#4 jazzman1

  • Moderators
  • Advanced Member
  • 2,715 posts
  • LocationMississauga, Canada

Posted 02 August 2013 - 10:03 PM

Create a stored procedure in mysql and call it inside the php script.


Take a look at that examples - http://php.net/manua...-procedures.php

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users