www.webdeveloper.com
Results 1 to 3 of 3

Thread: PHP/MySQL INSERT INTO Multiple Tables from Basic Form

  1. #1
    Join Date
    Jul 2013
    Posts
    2

    PHP/MySQL INSERT INTO Multiple Tables from Basic Form

    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:
    -id
    -category_name (for dropdown menu)

    table1:
    -id
    -category_id (FK, automatic when dropdown selected) NOT WORKING
    -title
    -description

    table2: (automatic insert file properties info here)
    -id // auto increment
    -table1_id (FK, automatic get ID from table1) NOT WORKING
    -filetype
    -filesize
    -filedate
    -filename

    FORM:
    -Date
    -Title
    -description
    -category(drop down)
    -upload file (get the file info like type,ext,size,filename)

    Status: it is inserting but only 2 not working

    I think this is simple, maybe either mysql statement or handling of php data?

    Please help, cheers

    PHP 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"?>
                 
                <p>Title:
                    <input type="text" name="title" value="<?php echo $sel_filepage['file_title']; ?>" id="file_title" />
                </p>

                   <p>Description:<br>
                    <textarea name="description" rows="4" cols="24">
                    <?php echo $sel_filepage['content']; ?></textarea>
                </p>
              
               Category:
            <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>';
                }
            
    ?>
            </select>
            <br><br>
            <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 -->
    ACTION FILE:

    PHP Code:
    <?php
    require_once("includes/functions.php");

    // 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");
    if(
    mysqli_connect_errno())
    {
        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)
                COMMIT";
    */

    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. ";
          }
        else
          {
            
    insertFile(    $_POST['filepage'], 
                        
    $_FILES["upfile"]["type"], 
                        (
    $_FILES["upfile"]["size"] / 1024), 
                        
    $_FILES["upfile"]["name"]);          
              
    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>";
            
          }
    ?>
    Last edited by NogDog; 07-31-2013 at 07:43 PM. Reason: changed [code] tags to [php]

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    22,284
    I don't see any place where you actually execute the query you define as $sql.
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

  3. #3
    Join Date
    Jul 2013
    Posts
    2
    sorry,

    please try to change this lines, i comment out some lines and change $sql to $sql, this works but same problem of 2 data not working.

    Code:
    /*$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()); 
    }  
    */
    
    if(!mysqli_query($con, $sql))
    {
    	die('Error ' . mysqli_error());
    }
    echo "1 File Added <br>";

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center

"

"

X vBulletin 4.2.2 Debug Information

  • Page Generation 0.25142 seconds
  • Memory Usage 2,904KB
  • Queries Executed 15 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)bbcode_code
  • (2)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (3)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (26):
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/functions_navigation.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_facebook.php
  • ./includes/functions_calendar.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (71):
  • init_startup
  • friendlyurl_resolve_class
  • init_startup_session_setup_start
  • database_pre_fetch_array
  • database_post_fetch_array
  • init_startup_session_setup_complete
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • load_show_variables
  • load_forum_show_variables
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • strip_bbcode
  • friendlyurl_clean_fragment
  • friendlyurl_geturl
  • forumjump
  • cache_templates
  • cache_templates_process
  • template_register_var
  • template_render_output
  • fetch_template_start
  • fetch_template_complete
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • build_navigation_data
  • build_navigation_array
  • check_navigation_permission
  • process_navigation_links_start
  • process_navigation_links_complete
  • set_navigation_menu_element
  • build_navigation_menudata
  • build_navigation_listdata
  • build_navigation_list
  • set_navigation_tab_main
  • set_navigation_tab_fallback
  • navigation_tab_complete
  • fb_like_button
  • showthread_complete
  • page_templates