File upload into MySQL database failing.

Hi. I have a problem here. I want to upload a file together with its semester. So I create two field. One for the semester and one for the file to be uploaded. But the script doesn't work. I don't know why. However, if I try to upload the file without the semester field, the script is working. May be the problem comes from the semester field. This is my codes.

Form.php

?>

Expand|Select|Wrap|Line Numbers

 <?php require_once('Connections/connection.php'); ?><?php

if (!isset($_SESSION)) {

  session_start();

}
 
// ** Logout the current user. **

$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";

if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){

  $logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);

}
 
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
 
  $_SESSION['MM_Username'] = NULL;

  $_SESSION['MM_UserGroup'] = NULL;

  $_SESSION['PrevUrl'] = NULL;

  unset($_SESSION['MM_Username']);

  unset($_SESSION['MM_UserGroup']);

  unset($_SESSION['PrevUrl']);
 
  $logoutGoTo = "login_option.php";

  if ($logoutGoTo) {

    header("Location: $logoutGoTo");

    exit;

  }

}

?>

<?php

$colname_rsSearchJKM_sem = "-1";

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

  $colname_rsSearchJKM_sem = (get_magic_quotes_gpc()) ? $_GET['sesi'] : addslashes($_GET['sesi']);

}

mysql_select_db($database_connection, $connection);

$query_rsSearchJKM_sem = sprintf("SELECT sesi FROM sesi");

$rsSearchJKM_sem = mysql_query($query_rsSearchJKM_sem, $connection) or die(mysql_error());

$row_rsSearchJKM_sem = mysql_fetch_assoc($rsSearchJKM_sem);

$totalRows_rsSearchJKM_sem = mysql_num_rows($rsSearchJKM_sem);

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Untitled Document</title>

<style type="text/css">

<!--

body {

    background-image: url(images/backgrounding.gif);

    background-repeat: no-repeat;

    background-attachment: fixed;

}

-->

</style></head>
 
<body>

<div align="center">

<table width="828" border="2">

  <!--DWLayoutTable-->

  <tr>

    <td width="822" height="148" valign="top" bgcolor="#6699FF"><form id="form1" name="form1" method="post" action="">

      <img src="banner/header.gif" width="822" height="128" />

      <?php include 'selamat_datang.php'; ?>

      <?php include 'jam.php'; ?>

      <?php include 'dropDOwn.php'; ?>

    </form></td>

  </tr>

  <tr>

    <td height="32" valign="top" bgcolor="#6699FF"><p align="right">&nbsp;<a href="<?php echo $logoutAction ?>"><font color='#FF0000'>Keluar</font></a></p>

        <p align="center">

        <p align="center" style="font-family:'Lucida Handwriting'; font-size: 24px; color:#990000"><strong>JABATAN KEJURUTERAAN MEKANIKAL</strong></p>        

        <p align="center">        

        <p align="center">

        <form action="Upload.php" method="post">

        <div align="left"><strong>SESI:</strong>

        <select name="uploaded_file" type="file" id="uploaded_file" &nbsp;name="uploaded_file">

        <?php 

            $sql="SELECT sesi FROM sesi";

            $result =mysql_query($sql);

            while ($data=mysql_fetch_assoc($result))

            {

                 echo "<option value=\"{$data['sesi']}\">{$data['sesi']}</option>";

                }

            ?>

          </select>

         </p>

            <p>     

          <div align="left">

                <p><strong>ABSTRAK:</strong>

                      <input name="uploaded_file" type="file" size="40" id="uploaded_file"&nbsp;name="uploaded_file" />

              </p>

                <p><br />

                      <input type="submit"&nbsp;value="Upload file" />

                  </p>

                        </p>

        </form>
 
<p>&nbsp;    </p>

<p><a href="listJKM.php">Lihat semua abstrak</a>

</p>

*</p>

      <p>&nbsp;</p>

      <p>&nbsp;</p>

      <p>&nbsp;</p></td>

  </tr>

  <tr>

    <td height="18" valign="top" bgcolor="#6699FF"><form id="form4" name="form4" method="post" action="">

      <div align="center">

        <?php include 'copyright.php'; ?>

          </div>

    </form>

    </td>

  </tr>

</table>

</div>

</body>

</html>

<?php

mysql_free_result($rsSearchJKM_sem);

?>

Upload.php

Expand|Select|Wrap|Line Numbers

 <?php
 
if (!isset($_SESSION)) {

  session_start();

}
 
// ** Logout the current user. **

$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";

if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){

  $logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);

}
 
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){

  $_SESSION['MM_Username'] = NULL;

  $_SESSION['MM_UserGroup'] = NULL;

  $_SESSION['PrevUrl'] = NULL;

  unset($_SESSION['MM_Username']);

  unset($_SESSION['MM_UserGroup']);

  unset($_SESSION['PrevUrl']);
 
  $logoutGoTo = "login_option.php";

  if ($logoutGoTo) {

    header("Location: $logoutGoTo");

    exit;

  }

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Untitled Document</title>

<style type="text/css">

<!--

body {

    background-image: url(images/backgrounding.gif);

    background-repeat: no-repeat;

    background-attachment: fixed;

}

-->

</style></head>
 
<body>

<div align="center">

<table width="828" border="0">

  <!--DWLayoutTable-->

  <tr>

    <td width="822" height="148" valign="top" bgcolor="#6699FF"><form id="form1" name="form1" method="post" action="">

      <img src="banner/header.gif" width="822" height="128" />

      <?php include 'selamat_datang.php'; ?>

      <?php include 'dropDown.php'; ?>

    </form></td>

  </tr>

  <tr>

    <td height="32" valign="top" bgcolor="#6699FF"><p align="right">&nbsp;<a href="<?php echo $logoutAction ?>"><font color='#FF0000'>Keluar</font></a></p>

        <p align="center">

<?php
 
if(isset($_FILES['uploaded_file'])) 

{ 
 
    if($_FILES['uploaded_file']['error'] == 0) 

    {
 
        $dbLink = mysqli_connect("localhost", "root", "", "inovasi");

        if(mysqli_connect_errno()) {

            die("MySQL connection failed: ". mysqli_connect_error());

        }       

        $sesi = mysqli_real_escape_string($dbLink, $_FILES['uploaded_file']['sesi']);

        $name = mysqli_real_escape_string($dbLink, $_FILES['uploaded_file']['name']);

        $mime = mysqli_real_escape_string($dbLink, $_FILES['uploaded_file']['type']);

        $size = $_FILES['uploaded_file']['size'];

        $data = mysqli_real_escape_string($dbLink, file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
 
        $query = "

            INSERT INTO FileStorage (

                FileName, FileMime, FileSize, FileData, Created, sesi

            )

            VALUES (

                '{$name}', '{$mime}', {$size}, '{$data}', NOW(), '{$sesi}'

            )";
 
        $result = mysqli_query($dbLink, $query);
 
        if($result) 

        {

            echo "Berjaya! Abstrak telah di upload.";

        }

        else 

        {

            echo "Error! Failed to insert the file";

            echo "<pre>". mysqli_error($dbLink) ."</pre>";

        }

    }

    else 

    {

        echo "Error! 

                An error accured while the file was being uploaded. 

                Error code: ". $_FILES['uploaded_file']['error'];

    }

    mysqli_close($dbLink);

}

else 

{

    echo "Gagal! Abstrak tidak berjaya di upload!";

}

echo '<p>Klik <a href="JKM_admin.php">di sini</a> untuk kembali</p>';

?>
 
&nbsp;</p>

      </td>

  </tr>

  <tr>

    <td height="18" valign="top" bgcolor="#6699FF"><form id="form4" name="form4" method="post" action="">

      <div align="center">

        <?php include 'copyright.php'; ?>

          </div>

    </form>

    </td>

  </tr>

</table>

</div>

</body>

</html>

Someone please help me...Thanks

Jul 1 '09 #1

Subscribe Post Reply

2232

dlite922

1,584

Expert 1GB

That's too much code to go through and find one problem. Have you done your part of troubleshooting? what's the semester field? if with it, it fails, have you tried looking into to see if it's correct?

can you run a manual test query with the semester field from a client?

At least trace the problem (follow the values with die(print_r($value)) lines) until you find the code that doesn't do what it's suppose to do.

Good luck,

Dan

Jul 1 '09 #2

by: Alper Adatoz | last post by:

Hi, i have a little problem. i hope u guys give me a clear solution (: db: mssql i just want to put jpeg file to the image field at the mssql db. and after that i want to call it back..

PHP

easiest way to upload a file to a MySql database

by: windandwaves | last post by:

Hi Folk I want my clients to load up a file to a MySql database. The file should contain rows with name, email, address, city What would be the easiest way (in terms of the big picture), to...

PHP

mySQL import text file too big?

by: news | last post by:

Our production database in an exported textfil runs about 60 MB. Compressed that's about 9 MB. I'm trying to import the export into another machine running FC3 and mySQL 11.18, and it appears as...

MySQL Database

Making sure a file exists before uploading it

by: Nathan Sokalski | last post by:

I have a form that allows the user to upload a file. Even though <input type="file" runat="server"> is intended to have the user choose the file using the browse button, it still allows them to...

ASP.NET

upload a MS word file from asp.net to MySQL

by: slingare | last post by:

Hi, I am new to asp.net and I am having a problem when I try to upload a word document from asp.net to Mysql database. I have a field of type mediumblob in mysql table. I looked for some...

.NET Framework

Warning: fopen() [function.fopen]: failed to open stream: No such file or directory

by: siyaverma | last post by:

i am trying to upload csv file from user's computer to main server the code i am using is if(((isset($_GET)) && ($_GET=="yes")) ) { $typefield = $_GET; echo...

PHP

The BEST "FREE" Pure ASP 10MB File Upload

by: hotflash | last post by:

Hi All, I found the best pure ASP code to upload a file to either server and/or MS Access Database. It works fine for me however, there is one thing that I don't like and have tried to fix but...

ASP / Active Server Pages

PHP File Uploader

by: Jacotheron | last post by:

I need a PHP script that can upload music files (mp3). The script is for a home project I have started a while ago. I have a MySQL database of all the music that I have. Other computers on the...

PHP

multiple file upload to server and MySQL database

by: johngault | last post by:

I've been working with this PHP page for several days now and I'm stumped. The page is supposed to allow the user to upload up to six images for their profile. When the user adds an image it (the...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

File upload into MySQL database failing.

Similar topics