Jump to content

no data stored after a insert query


GRooVeZ

Recommended Posts

i want the name of a picture stored in my db after i upload it

 

the data is not stored in the db after i run this script, but i dont get errors either

 

i print the two vars before sending them, and they get printed fine

 

any help on this would be greatly appreciated

 

thanks !

 

<?php

error_reporting(E_ALL);

ini_set("display_errors", 1);

// INCLUDE THE CLASS FILE

include('ImageLib.Class.php');

include("./includes/egl_inc.php");

$displayMessage = '';

if($_POST){

if(isset($_FILES['image_file'])){

 

// SEE THE MAGIC HAPPEN

$destination_path = 'uploads/';

$post_file_name = 'image_file';

$width = 600;

$height = 400;

$scale = false;

$trim = true;

$uniqueName = true;

$img = ImageLib::getInstance()->upload($post_file_name, $destination_path, $uniqueName)->resize($width, $height, $scale, $trim)->save();

$imgstr = mysql_real_escape_string ($img);

 

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

$displayMessage = '<div class="image"><img src="'.$destination_path.$fileName.'" /><br />Uploaded And Resized...With new file name : "'.$img.'"</div><br /><br />';

 

$playerid=$_SESSION['tid'];

 

$matchdetails = mysql_fetch_array(mysql_query("SELECT id FROM ffa_matches WHERE status=2 and admin=$playerid"));

          $id = $matchdetails[id];

 

 

print $img;print $imgstr;

print $id;

 

mysql_query("

    INSERT INTO ffa_screens

        (imgname,match)

    VALUES(

        '" . mysql_real_escape_string($imgstr) . "',

        '" . mysql_real_escape_string($id) . "'

    )");

 

 

 

}}

?>

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

<html>

<head>

<title>ImageLib Samples By Rahul Kate</title>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<style>

body{font-family: arial; font-size:12px; color:#444444; padding:20px;}

li{margin-top:10px;}

.image{color:green;}

.image img{margin-bottom:5px;}

</style>

</head>

<body>

<h1>ImageLib | Upload Image, move it to Uploads folder and Resize it and Trim</h1>

<?php echo $displayMessage; ?>

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

Select Image<br />

<input type="file" name="image_file" id="image_file" />

<br />

<br />

<input type="submit" name="submit" value="Submit" />

<br />

<br />

<a href="index.html">Back TO Home</a>

</form>

</body>

</html>

Link to comment
https://forums.phpfreaks.com/topic/260477-no-data-stored-after-a-insert-query/
Share on other sites

$strSql = "
    INSERT INTO ffa_screens
        (imgname,match)
    VALUES(
        '" . mysql_real_escape_string($imgstr) . "',
        '" . mysql_real_escape_string($id) . "'
    )";
echo $strSql;
$result = mysql_query($strSql) or die(mysql_error());

$strSql = "
    INSERT INTO ffa_screens
        (imgname,match)
    VALUES(
        '" . mysql_real_escape_string($imgstr) . "',
        '" . mysql_real_escape_string($id) . "'
    )";
echo $strSql;
$result = mysql_query($strSql) or die(mysql_error());

 

4f7f567cb7641.jpg4f7f567cb7641.jpg66 INSERT INTO ffa_screens (imgname,match) VALUES( '4f7f567cb7641.jpg', '66' )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 'match) VALUES( '4f7f567cb7641.jpg', '66' )' at line 2

Archived

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

×
×
  • 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.