image into a database

garydt · February 27, 2007

I'm trying to put an image into the same record as the logged-on username and other data by using 'update' but, from what i read i have to use the 'upload' command. Can you tell me if i can upload an image into the same record as the logged-on username, and if so, how?

Heres my code to update the record

<?php

session_start();

?>

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

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

$user = $_SESSION['MM_Username'];

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {

$updateSQL = sprintf("UPDATE userinformation SET why=%s, howlong=%s, decade=%s, song=%s, album=%s, pictur=%s, aboutu=%s WHERE usernm='$user'",

GetSQLValueString($_POST['why'], "text"),

GetSQLValueString($_POST['sincewhen'], "text"),

GetSQLValueString($_POST['decad'], "text"),

GetSQLValueString($_POST['favsong'], "text"),

GetSQLValueString($_POST['favealbum'], "text"),

GetSQLValueString($_POST['file'], "text"),

GetSQLValueString($_POST['textarea'], "text"),

GetSQLValueString($_POST['hiddenField'], "text"));

mysql_select_db($database_elvisdb, $elvisdb);

$Result1 = mysql_query($updateSQL, $elvisdb) or die(mysql_error());

$updateGoTo = "userpage.php";

if (isset($_SERVER['QUERY_STRING'])) {

$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";

$updateGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $updateGoTo));

}

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

<head>

<title>Untitled Document</title>

<!--

.style1 {font-family: Arial, Helvetica, sans-serif}

.style5 {font-family: Helvetica, Arial, "Times New Roman"}

-->

</style>

</head>

<body>

<form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="form1" id="form1">

<tr>

<td bgcolor="#FFFFFF"><div align="left" class="style5">Why do you like/love Elvis </div>

</span> <span class="style5">

</span>

<label>

</div>

</label> </td>

</tr>

<tr>

<td bgcolor="#FFFFFF"><div align="left" class="style5">How long have you been an Elvis fan </div>

</span> <span class="style5">

</span>

<label>

</div>

</label> </td>

</tr>

<tr>

<td bgcolor="#FFFFFF"><div align="left" class="style5">Which Elvis decade is your favourite? </div>

</span> <span class="style5">

</span>

<label>

<option>All 3 decades</option>

</select>

</div>

</label> </td>

</tr>

<tr>

<p>

<label> Your favourite Elvis song<br />

</label>

</p>

</div></td>

</tr>

<tr>

<p>Your favourite Elvis album

</label>

</p>

</div></td>

</tr>

<tr>

<td bgcolor="#FFFFFF"><label> Upload a photo <br />

</label></td>

</tr>

<tr>

<label> About you <br />

</label>

</div></td>

</tr>

<tr>

</label></td>

</tr>

</table>

<p>

</p>

<p>

</p>

</form>

</body>

</html>

Adika · March 2, 2007

Hi!

You cannot upload pictures into the database!!!!

What you need to do, is to upload a picture into some folder in your web site, and just add the filename to the database next to the user login record.

All the best,

Adika

Sign In

image into a database

Recommended Posts

garydt

Link to comment

Share on other sites

Adika

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information