Jump to content

use a php form which is populated by mysql to insert into different table

tgribble

By tgribble
in PHP Coding Help

Recommended Posts

tgribble Newbie

tgribble

Posted
Posted

hello

 

i have a db with name which populates a form dropdown list

there are various variables like this in the form.

the user selects their choices and then submits the form to a new db table

 

 

at the moment it does not capture the dropdown data to the insert sql

 

help please

 

here is the code:

 

===============================

 

<?php

include ('connect.php');

 

// Insert any new image into database

if(isset($_POST['xsubmit']) && $_FILES['imagefile']['name'] != "") {

  $fileName = $_FILES['imagefile']['name'];

  $fileSize = $_FILES['imagefile']['size'];

  $fileType = $_FILES['imagefile']['type'];

  $content  = addslashes (file_get_contents($_FILES['imagefile']['tmp_name']));

  $jeweltype = $_POST['jeweltype'];

  $jewelsize = $_POST['jewelsize_in'];

  $jewelcolour = $_POST['jewelcolour_in'];

  $jewelmaterial = $_POST['jewelmaterial_in'];

  $jewelgender = $_POST['jewelgender_in'];

 

  if(!get_magic_quotes_gpc()) {

    $fileName = addslashes($fileName);

  }

 

  // Checking file size

  if ($fileSize < 150000) {

    mysql_query ("INSERT into jewel_images (name,size,type,content,jeweltype,jewelsize,jewelcolour,jewelmaterial,jewelgender) "

  . "values ('$fileName','$fileSize','$fileType','$content','$jeweltype','$jewelsize','$jewelcolour','$jewelmaterial','$jewelgender')");

  } else {

    $err = "The Image file to too large!";

  }

}

 

// Find out about latest image

 

$gotten = mysql_query("select * from jewel_images order by row_id desc");

$row    = mysql_fetch_assoc($gotten);

$bytes  = $row['content'];

 

// If this is the image request, send out the image

 

if ($_REQUEST['pic'] == 1) {

  header("Content-type: $row[type];");

print $bytes; 

}

?>

<html>

<head>

<title>Upload an image to a database</title>

</head>

<body>

  <font color="#FF3333"><?php echo $err ?></font>

  <table>

    <form name="Upload" enctype="multipart/form-data" method="post">

      <tr>

        <td>Upload <input type="file" name="imagefile"><br />

            Jewelery Type:

            <select>

            <?php

            $sql="SELECT jeweltype FROM jeweltypes";

            $result =mysql_query($sql);

            while ($data=mysql_fetch_assoc($result)){

            ?>

            <option value ="jeweltype" ><?php echo $data['jeweltype'] ?></option>

            <?php } ?>

            </select>

            <br />

            Jewelery Size:

            <select>

            <?php

            $sql="SELECT jewelsize FROM jewelsizes";

            $result =mysql_query($sql);

            while ($data=mysql_fetch_assoc($result)){

            ?>

            <option value ="jewelsize" ><?php echo $data['jewelsize'] ?></option>

            <?php } ?>

            </select>

            <br />

            Jewelery Colour:

            <select>

            <?php

            $sql="SELECT jewelcolour FROM jewelcolours";

            $result =mysql_query($sql);

            while ($data=mysql_fetch_assoc($result)){

            ?>

            <option value ="jewelcolour_in" ><?php echo $data['jewelcolour'] ?></option>

            <?php } ?>

            </select>

            <br />

            Jewelery Material:

            <select>

            <?php

            $sql="SELECT jewelmaterial FROM jewelmaterials";

            $result =mysql_query($sql);

            while ($data=mysql_fetch_assoc($result)){

            ?>

            <option value ="jewelmaterial_in" ><?php echo $data['jewelmaterial'] ?></option>

            <?php } ?>

            </select>

            <br />

            Jewelery Gender:

            <select>

            <?php

            $sql="SELECT jewelgender FROM jewelgenders";

            $result =mysql_query($sql);

            while ($data=mysql_fetch_assoc($result)){

            ?>

            <option value ="jewelgender_in" ><?php echo $data['jewelgender'] ?></option>

            <?php } ?>

            </select>

            <br />

        <input type="submit" name="xsubmit" value="Upload">

        </td>

      </tr>

      <tr>

      <td>Latest Image</td>

      </tr>

      <tr>

        <td><img src="?pic=1"></td>

      </tr>

    </form>

</table>

</body>

</html>

 

 

 

tgribble Newbie

tgribble

Posted
  • Author
Posted

here is the query page: print.php

 

<html> 

<head><title>Your Page Title</title></head> 

<body> 

<?php 

$database="josh_jewel"; 

mysql_connect ("localhost", "joshjewel", "jewelery"); 

@mysql_select_db($database) or die( "Unable to select database"); 

$result = mysql_query( "SELECT jewelcolour FROM jewel_images" ) 

or die("SELECT Error: ".mysql_error()); 

$num_rows = mysql_num_rows($result); 

print "There are $num_rows records.<P>"; 

print "<table width=400 border=1>\n"; 

while ($get_info = mysql_fetch_row($result)){ 

print "<tr>\n"; 

foreach ($get_info as $field) 

print "\t<td><font face=arial size=1/>$field</font></td>\n"; 

print "</tr>\n"; 

} 

print "</table>\n"; 

?> 

</body> 

</html>

 

the data with the

 

=================

<td>Upload <input type="file" name="imagefile"><br />

            Jewelery Type:

              <select>

              <?php

              $sql="SELECT jeweltype FROM jeweltypes";

              $result =mysql_query($sql);

              while ($data=mysql_fetch_assoc($result)){

              ?>

              <option value ="jeweltype" ><?php echo $data['jeweltype'] ?></option>

              <?php } ?>

              </select>

              <br />

            Jewelery Size:

              <select>

              <?php

              $sql="SELECT jewelsize FROM jewelsizes";

              $result =mysql_query($sql);

              while ($data=mysql_fetch_assoc($result)){

              ?>

              <option value ="jewelsize" ><?php echo $data['jewelsize'] ?></option>

              <?php } ?>

              </select>

              <br />

            Jewelery Colour:

              <select>

              <?php

              $sql="SELECT jewelcolour FROM jewelcolours";

              $result =mysql_query($sql);

              while ($data=mysql_fetch_assoc($result)){

              ?>

              <option value ="jewelcolour_in" ><?php echo $data['jewelcolour'] ?></option>

              <?php } ?>

              </select>

              <br />

            Jewelery Material:

              <select>

              <?php

              $sql="SELECT jewelmaterial FROM jewelmaterials";

              $result =mysql_query($sql);

              while ($data=mysql_fetch_assoc($result)){

              ?>

              <option value ="jewelmaterial_in" ><?php echo $data['jewelmaterial'] ?></option>

              <?php } ?>

              </select>

              <br />

            Jewelery Gender:

              <select>

              <?php

              $sql="SELECT jewelgender FROM jewelgenders";

              $result =mysql_query($sql);

              while ($data=mysql_fetch_assoc($result)){

              ?>

              <option value ="jewelgender_in" ><?php echo $data['jewelgender'] ?></option>

              <?php } ?>

              </select>

              <br />

        <input type="submit" name="xsubmit" value="Upload">

===============================

 

are is not submitted to the new db table

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.