free bird
دوشنبه 15 شهریور 1389, 15:40 عصر
سلام
دوستان با کدی که اینجا گذاشتم
چطور می تونم اسم عکسموبعد از upload به جای یکی از فیلدایی که دارم مثلا university توی دیتابیس bذخیره کنم:خجالت:؟
<?
$id=$_REQUEST['id'];
if($action)
{
$id = generate_id();
$name =$_POST['name'];
$university =$_POST['userfile_fname'];
$grade =$_POST['grade'];
$field =$_POST['field'];
$status =$_POST['status'];
$sex =$_POST['sex'];
$tel =$_POST['tel'];
$mobile =$_POST['mobile'];
$irancell =$_POST['irancell'];
$email =$_POST['email'];
$address =$_POST['address'];
// Check that all the fields are not NULL
if ($name)
{
/*
* Check the input values for validity.
*/
$sql="Insert into ganjineh_work values(NULL,\"". AddSlashes($name)
."\", \"". AddSlashes($university)
."\", \"". AddSlashes($grade)
."\", \"". AddSlashes($field)
."\", \"". AddSlashes($status)
."\", \"". AddSlashes($sex)
."\", \"". AddSlashes($tel)
."\", \"". AddSlashes($mobile)
."\", \"". AddSlashes($irancell)
."\", \"". AddSlashes($email)
."\", \"". AddSlashes($address)
."\", 1)";
$res=mysql_query ($sql);
if (!$res)
{
print "Database error on update: " . mysql_error();
exit;
}
else
{
$updated = 1;
}
header("Location: listwork.php");
}
}
}
if(!$action || ($action && $updated))
{
$query = "select *
from ganjineh_work a where a.id=\"$id\"";
$result = mysql_query($query);
if(!$result){
print "Database access error: abnormal termination".mysql_error();
exit;
}
$id = mysql_result($result,0,"id");
$university = stripslashes(mysql_result($result,0,"userfile_fname"));
$grade = stripslashes(mysql_result($result,0,"grade"));
$field = stripslashes(mysql_result($result,0,"field"));
$status = stripslashes(mysql_result($result,0,"status"));
$sex = stripslashes(mysql_result($result,0,"sex"));
$tel = stripslashes(mysql_result($result,0,"tel"));
$mobile = stripslashes(mysql_result($result,0,"mobile"));
$irancell = stripslashes(mysql_result($result,0,"irancell"));
$email = stripslashes(mysql_result($result,0,"email"));
$address = stripslashes(mysql_result($result,0,"address"));
}
// update current session
if ( isset($sessionVars["SELL_DATA_CORRECT"]) )
unset($sessionVars["SELL_DATA_CORRECT"]);
session_name($SESSION_NAME);
session_register("sessionVars");
require "./header.php";
require('../includes/styles.inc.php');
?>
<? $field=$_POST['field'];
switch ($field){
case 1:{
$path = ('../images/dec');
break;
}
case 2:{
$path = ('../images/furniture');
break;
}
case 3:{
$path = ('../images/view');
break;
}
case 4:{
$path = ('../images/messi');
break;
}
case 5:{
$path = ('../images/imprint tablet');
break;
}
case 6:{
$path = ('../images/reticular');
break;
}
}
$actionpic=$_REQUEST['actionpic'];
if($actionpic)
{
$userfile = $_REQUEST['userfile'];
$userfile_temp=$_FILES['userfile']['tmp_name'];
$userfile_fname=$_FILES['userfile']['name'];
if(!empty($userfile_temp) && $userfile_temp != "none" )
{
// really save this file
$fname = "$path/".substr($userfile_fname,0,strlen($userfile_fname)-3)."jpg";
$pname = $userfile_fname;
if ( file_exists($fname) )
unlink ($fname);
move_uploaded_file ( $userfile_temp, $fname );
}
}
?>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="5" BGCOLOR="#FFFFFF">
<TR>
<TD>
<TABLE WIDTH="100%" CELLPADDING="0" CELLSPACING="0" BORDER="0" BGCOLOR="#FFFFFF">
<TR>
<TD ALIGN="CENTER" COLSPAN="5">
<BR>
<FONT FACE="Verdana, Arial, Helvetica, sans-serif" SIZE="4">
<B><? print $MSG_012; ?></B>
</FONT>
<BR>
</TD>
</TR>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="5">
<?
if($ERR || $updated){
print "<TR>
<TD>
</TD>
<TD WIDTH=486>
<FONT FACE=\"Verdana,Arial, Helvetica\" SIZE=2 COLOR=red>";
if($$ERR) print $$ERR;
if($updated) print $MSG_054;
print "</TD>
</TR>";
}
?>
<FORM NAME="details" ACTION="<? print basename($PHP_SELF); ?>" METHOD="POST" enctype="multipart/form-data">
<!------------------ item description ---------------->
<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<fieldset>
<legend>تصاویر گالری عکس</legend>
<!-- <FORM NAME="pictures" ACTION="addwork.php" METHOD="POST" enctype="multipart/form-data">-->
<!-- <INPUT type="submit" NAME="actionpic" VALUE="Upload">-->
<INPUT type="file" size="30" name="userfile">
<INPUT TYPE="HIDDEN" NAME="MAX_FILE_SIZE" VALUE="<? print $MAX_UPLOAD_SIZE; ?>">
<? print $std_font; ?> <b>
<? print ":(jpg only)فایل تصویری"; ?></b></font>
<?php
$path = ('../images/dec');
if ($handle = opendir('$path/')) {
while (false !== ($file = readdir($handle))) {
if(substr($file,strlen($file)-3,3) == 'jpg'){
echo "<a href='$path/$file' target='_BLANK'>$file</a> <a href='del.php?id=$id&file=$path/$file'>حذف</a><br />";
}
}
closedir($handle);
}
?>
</fieldset>
<select name="field" style="text-align:right;" >
<option <?if($field==$MSG_1037) print "selected"; ?> value="1"><? print $MSG_1037; ?></option>
<option <?if($field==$MSG_1036) print "selected"; ?> value="2"><? print $MSG_1036; ?></option>
<option <?if($field==$MSG_1038) print "selected"; ?> value="3"><? print $MSG_1038; ?></option>
<option <?if($field==$MSG_1039) print "selected"; ?> value="4"><? print $MSG_1039; ?></option>
<option <?if($field==$MSG_1040) print "selected"; ?> value="5"><? print $MSG_1040; ?></option>
<option <?if($field==$MSG_1044) print "selected"; ?> value="6"><? print $MSG_1044; ?></option>
</select>
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1047;?>
</b> </TD>
</TR>
<!------------------ item description ---------------->
<TR>
<!--<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="hidden" name="university" size="40" value="<? $_post['fname'];?>">
</B> </TD>
<TD WIDTH="255"> <b>
</b> </TD>
</TR>
<!------------------ item description ---------------->
<!------------------ item description ---------------->
<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="name" size="40" maxlength="35" value="<? print stripslashes($name); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1033;?>
</b> </TD>
</TR>
<!------------------ item description ---------------->
<!------------------ item description ---------------->
<!--<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="tel" size="40" value="<? print stripslashes($tel); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1038;?>
</b> </TD>
</TR>-->
<!------------------ item description ---------------->
<!--<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="irancell" size="40" value="<? print stripslashes($irancell); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1040;?>
</b> </TD>
</TR>-->
<!------------------ item description ---------------->
<!--<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="email" size="40" value="<? print stripslashes($email); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":ایمیل";?>
</b> </TD>
</TR>-->
<!------------------ item description ---------------->
<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<textarea dir="rtl" name="address" cols="32" rows="5" value="<? print stripslashes($address); ?>"></textarea>
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1034;?>
</b> </TD>
</TR>
<!------------------------------------- author ---------------------------->
<TR>
<TD WIDTH="584" align="right">
</FONT>
<INPUT TYPE="submit" NAME="actionpic" VALUE="<? print $MSG_011; ?>" >
</TD>
<TD WIDTH="204"> </TD>
</TR>
</TABLE>
<INPUT type="hidden" NAME="id" VALUE="<? echo $id; ?>">
<INPUT type="hidden" NAME="offset" VALUE="<? echo $offset; ?>">
<INPUT type="hidden" NAME="searchitem" VALUE="<? echo $searchitem; ?>">
<INPUT type="hidden" NAME="action" VALUE="update">
</center>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="5" BGCOLOR="#FFFFFF">
<TR>
<td width="30%">
</td>
<td valign="top" align="center" width="40%">
<BR />
<BR />
</td>
<td width="30%">
</td>
</TR>
</TABLE>
<BR>
<BR>
<CENTER>
<FONT face="Tahoma, Arial" size="2"><A HREF="admin.php" CLASS="navigation"><? print $MSG_001 ?></A> |
<FONT face="Tahoma, Arial" size="2"><A
HREF="listwork.php?searchitem=<? print $searchitem ?>&offset=<? print $offset; ?>" CLASS="navigation"><? print $MSG_029 ?></A></FONT>
</CENTER>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<!-- Closing external table (header.php) -->
</TD>
</TR>
</TABLE>
<? include "./footer.php"; ?>
<?
$id=$_REQUEST['id'];
$offset=$_REQUEST['offset'];
$searchitem=$_REQUEST['searchitem'];
$action=$_POST['action'];
include "loggedin.inc.php";
include "../includes/messages.inc.php";
require("../includes/config.inc.php");
$userfile_fname=$_POST['userfile_fname'];
function generate_id()
{
global $name, $university;
$auction_id = md5(uniqid(rand(), true));
return $auction_id;
}
if($action)
{
$id = generate_id();
$name =$_POST['name'];
$university =$_POST['userfile_fname'];
$grade =$_POST['grade'];
$field =$_POST['field'];
$status =$_POST['status'];
$sex =$_POST['sex'];
$tel =$_POST['tel'];
$mobile =$_POST['mobile'];
$irancell =$_POST['irancell'];
$email =$_POST['email'];
$address =$_POST['address'];
// Check that all the fields are not NULL
if ($name)
{
/*
* Check the input values for validity.
*/
$sql="Insert into ganjineh_work values(NULL,\"". AddSlashes($name)
."\", \"". AddSlashes($university)
."\", \"". AddSlashes($grade)
."\", \"". AddSlashes($field)
."\", \"". AddSlashes($status)
."\", \"". AddSlashes($sex)
."\", \"". AddSlashes($tel)
."\", \"". AddSlashes($mobile)
."\", \"". AddSlashes($irancell)
."\", \"". AddSlashes($email)
."\", \"". AddSlashes($address)
."\", 1)";
$res=mysql_query ($sql);
if (!$res)
{
print "Database error on update: " . mysql_error();
exit;
}
else
{
$updated = 1;
}
header("Location: listwork.php");
}
else
{
$ERR = "ERR_005";
}
}
if(!$action || ($action && $updated))
{
$query = "select *
from ganjineh_work a where a.id=\"$id\"";
$result = mysql_query($query);
if(!$result){
print "Database access error: abnormal termination".mysql_error();
exit;
}
$id = mysql_result($result,0,"id");
$university = stripslashes(mysql_result($result,0,"userfile_fname"));
$grade = stripslashes(mysql_result($result,0,"grade"));
$field = stripslashes(mysql_result($result,0,"field"));
$status = stripslashes(mysql_result($result,0,"status"));
$sex = stripslashes(mysql_result($result,0,"sex"));
$tel = stripslashes(mysql_result($result,0,"tel"));
$mobile = stripslashes(mysql_result($result,0,"mobile"));
$irancell = stripslashes(mysql_result($result,0,"irancell"));
$email = stripslashes(mysql_result($result,0,"email"));
$address = stripslashes(mysql_result($result,0,"address"));
}
// update current session
if ( isset($sessionVars["SELL_DATA_CORRECT"]) )
unset($sessionVars["SELL_DATA_CORRECT"]);
session_name($SESSION_NAME);
session_register("sessionVars");
require "./header.php";
require('../includes/styles.inc.php');
?>
<? $field=$_POST['field'];
switch ($field){
case 1:{
$path = ('../images/dec');
break;
}
case 2:{
$path = ('../images/furniture');
break;
}
case 3:{
$path = ('../images/view');
break;
}
case 4:{
$path = ('../images/messi');
break;
}
case 5:{
$path = ('../images/imprint tablet');
break;
}
case 6:{
$path = ('../images/reticular');
break;
}
}
$actionpic=$_REQUEST['actionpic'];
if($actionpic)
{
$userfile = $_REQUEST['userfile'];
$userfile_temp=$_FILES['userfile']['tmp_name'];
$userfile_fname=$_FILES['userfile']['name'];
if(!empty($userfile_temp) && $userfile_temp != "none" )
{
// really save this file
$fname = "$path/".substr($userfile_fname,0,strlen($userfile_fname)-3)."jpg";
$pname = $userfile_fname;
if ( file_exists($fname) )
unlink ($fname);
move_uploaded_file ( $userfile_temp, $fname );
}
}
?>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="5" BGCOLOR="#FFFFFF">
<TR>
<TD>
<TABLE WIDTH="100%" CELLPADDING="0" CELLSPACING="0" BORDER="0" BGCOLOR="#FFFFFF">
<TR>
<TD ALIGN="CENTER" COLSPAN="5">
<BR>
<FONT FACE="Verdana, Arial, Helvetica, sans-serif" SIZE="4">
<B><? print $MSG_012; ?></B>
</FONT>
<BR>
</TD>
</TR>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="5">
<?
if($ERR || $updated){
print "<TR>
<TD>
</TD>
<TD WIDTH=486>
<FONT FACE=\"Verdana,Arial, Helvetica\" SIZE=2 COLOR=red>";
if($$ERR) print $$ERR;
if($updated) print $MSG_054;
print "</TD>
</TR>";
}
?>
<FORM NAME="details" ACTION="<? print basename($PHP_SELF); ?>" METHOD="POST" enctype="multipart/form-data">
<!------------------ item description ---------------->
<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<fieldset>
<legend>تصاویر گالری عکس</legend>
<!-- <FORM NAME="pictures" ACTION="addwork.php" METHOD="POST" enctype="multipart/form-data">-->
<!-- <INPUT type="submit" NAME="actionpic" VALUE="Upload">-->
<INPUT type="file" size="30" name="userfile">
<INPUT TYPE="HIDDEN" NAME="MAX_FILE_SIZE" VALUE="<? print $MAX_UPLOAD_SIZE; ?>">
<? print $std_font; ?> <b>
<? print ":(jpg only)فایل تصویری"; ?></b></font>
<?php
$path = ('../images/dec');
if ($handle = opendir('$path/')) {
while (false !== ($file = readdir($handle))) {
if(substr($file,strlen($file)-3,3) == 'jpg'){
echo "<a href='$path/$file' target='_BLANK'>$file</a> <a href='del.php?id=$id&file=$path/$file'>حذف</a><br />";
}
}
closedir($handle);
}
?>
</fieldset>
<select name="field" style="text-align:right;" >
<option <?if($field==$MSG_1037) print "selected"; ?> value="1"><? print $MSG_1037; ?></option>
<option <?if($field==$MSG_1036) print "selected"; ?> value="2"><? print $MSG_1036; ?></option>
<option <?if($field==$MSG_1038) print "selected"; ?> value="3"><? print $MSG_1038; ?></option>
<option <?if($field==$MSG_1039) print "selected"; ?> value="4"><? print $MSG_1039; ?></option>
<option <?if($field==$MSG_1040) print "selected"; ?> value="5"><? print $MSG_1040; ?></option>
<option <?if($field==$MSG_1044) print "selected"; ?> value="6"><? print $MSG_1044; ?></option>
</select>
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1047;?>
</b> </TD>
</TR>
<!------------------ item description ---------------->
<TR>
<!--<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="hidden" name="university" size="40" value="<? $_post['fname'];?>">
</B> </TD>
<TD WIDTH="255"> <b>
</b> </TD>
</TR>
<!------------------ item description ---------------->
<!------------------ item description ---------------->
<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="name" size="40" maxlength="35" value="<? print stripslashes($name); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1033;?>
</b> </TD>
</TR>
<!------------------ item description ---------------->
<!------------------ item description ---------------->
<!--<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="tel" size="40" value="<? print stripslashes($tel); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1038;?>
</b> </TD>
</TR>-->
<!------------------ item description ---------------->
<!--<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="irancell" size="40" value="<? print stripslashes($irancell); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1040;?>
</b> </TD>
</TR>-->
<!------------------ item description ---------------->
<!--<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="email" size="40" value="<? print stripslashes($email); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":ایمیل";?>
</b> </TD>
</TR>-->
<!------------------ item description ---------------->
<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<textarea dir="rtl" name="address" cols="32" rows="5" value="<? print stripslashes($address); ?>"></textarea>
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1034;?>
</b> </TD>
</TR>
<!------------------------------------- author ---------------------------->
<TR>
<TD WIDTH="584" align="right">
</FONT>
<INPUT TYPE="submit" NAME="actionpic" VALUE="<? print $MSG_011; ?>" >
</TD>
<TD WIDTH="204"> </TD>
</TR>
</TABLE>
<INPUT type="hidden" NAME="id" VALUE="<? echo $id; ?>">
<INPUT type="hidden" NAME="offset" VALUE="<? echo $offset; ?>">
<INPUT type="hidden" NAME="searchitem" VALUE="<? echo $searchitem; ?>">
<INPUT type="hidden" NAME="action" VALUE="update">
</center>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="5" BGCOLOR="#FFFFFF">
<TR>
<td width="30%">
</td>
<td valign="top" align="center" width="40%">
<BR />
<BR />
</td>
<td width="30%">
</td>
</TR>
</TABLE>
<BR>
<BR>
<CENTER>
<FONT face="Tahoma, Arial" size="2"><A HREF="admin.php" CLASS="navigation"><? print $MSG_001 ?></A> |
<FONT face="Tahoma, Arial" size="2"><A
HREF="listwork.php?searchitem=<? print $searchitem ?>&offset=<? print $offset; ?>" CLASS="navigation"><? print $MSG_029 ?></A></FONT>
</CENTER>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<!-- Closing external table (header.php) -->
</TD>
</TR>
</TABLE>
<? include "./footer.php"; ?>
ممممنووووووون
دوستان با کدی که اینجا گذاشتم
چطور می تونم اسم عکسموبعد از upload به جای یکی از فیلدایی که دارم مثلا university توی دیتابیس bذخیره کنم:خجالت:؟
<?
$id=$_REQUEST['id'];
if($action)
{
$id = generate_id();
$name =$_POST['name'];
$university =$_POST['userfile_fname'];
$grade =$_POST['grade'];
$field =$_POST['field'];
$status =$_POST['status'];
$sex =$_POST['sex'];
$tel =$_POST['tel'];
$mobile =$_POST['mobile'];
$irancell =$_POST['irancell'];
$email =$_POST['email'];
$address =$_POST['address'];
// Check that all the fields are not NULL
if ($name)
{
/*
* Check the input values for validity.
*/
$sql="Insert into ganjineh_work values(NULL,\"". AddSlashes($name)
."\", \"". AddSlashes($university)
."\", \"". AddSlashes($grade)
."\", \"". AddSlashes($field)
."\", \"". AddSlashes($status)
."\", \"". AddSlashes($sex)
."\", \"". AddSlashes($tel)
."\", \"". AddSlashes($mobile)
."\", \"". AddSlashes($irancell)
."\", \"". AddSlashes($email)
."\", \"". AddSlashes($address)
."\", 1)";
$res=mysql_query ($sql);
if (!$res)
{
print "Database error on update: " . mysql_error();
exit;
}
else
{
$updated = 1;
}
header("Location: listwork.php");
}
}
}
if(!$action || ($action && $updated))
{
$query = "select *
from ganjineh_work a where a.id=\"$id\"";
$result = mysql_query($query);
if(!$result){
print "Database access error: abnormal termination".mysql_error();
exit;
}
$id = mysql_result($result,0,"id");
$university = stripslashes(mysql_result($result,0,"userfile_fname"));
$grade = stripslashes(mysql_result($result,0,"grade"));
$field = stripslashes(mysql_result($result,0,"field"));
$status = stripslashes(mysql_result($result,0,"status"));
$sex = stripslashes(mysql_result($result,0,"sex"));
$tel = stripslashes(mysql_result($result,0,"tel"));
$mobile = stripslashes(mysql_result($result,0,"mobile"));
$irancell = stripslashes(mysql_result($result,0,"irancell"));
$email = stripslashes(mysql_result($result,0,"email"));
$address = stripslashes(mysql_result($result,0,"address"));
}
// update current session
if ( isset($sessionVars["SELL_DATA_CORRECT"]) )
unset($sessionVars["SELL_DATA_CORRECT"]);
session_name($SESSION_NAME);
session_register("sessionVars");
require "./header.php";
require('../includes/styles.inc.php');
?>
<? $field=$_POST['field'];
switch ($field){
case 1:{
$path = ('../images/dec');
break;
}
case 2:{
$path = ('../images/furniture');
break;
}
case 3:{
$path = ('../images/view');
break;
}
case 4:{
$path = ('../images/messi');
break;
}
case 5:{
$path = ('../images/imprint tablet');
break;
}
case 6:{
$path = ('../images/reticular');
break;
}
}
$actionpic=$_REQUEST['actionpic'];
if($actionpic)
{
$userfile = $_REQUEST['userfile'];
$userfile_temp=$_FILES['userfile']['tmp_name'];
$userfile_fname=$_FILES['userfile']['name'];
if(!empty($userfile_temp) && $userfile_temp != "none" )
{
// really save this file
$fname = "$path/".substr($userfile_fname,0,strlen($userfile_fname)-3)."jpg";
$pname = $userfile_fname;
if ( file_exists($fname) )
unlink ($fname);
move_uploaded_file ( $userfile_temp, $fname );
}
}
?>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="5" BGCOLOR="#FFFFFF">
<TR>
<TD>
<TABLE WIDTH="100%" CELLPADDING="0" CELLSPACING="0" BORDER="0" BGCOLOR="#FFFFFF">
<TR>
<TD ALIGN="CENTER" COLSPAN="5">
<BR>
<FONT FACE="Verdana, Arial, Helvetica, sans-serif" SIZE="4">
<B><? print $MSG_012; ?></B>
</FONT>
<BR>
</TD>
</TR>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="5">
<?
if($ERR || $updated){
print "<TR>
<TD>
</TD>
<TD WIDTH=486>
<FONT FACE=\"Verdana,Arial, Helvetica\" SIZE=2 COLOR=red>";
if($$ERR) print $$ERR;
if($updated) print $MSG_054;
print "</TD>
</TR>";
}
?>
<FORM NAME="details" ACTION="<? print basename($PHP_SELF); ?>" METHOD="POST" enctype="multipart/form-data">
<!------------------ item description ---------------->
<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<fieldset>
<legend>تصاویر گالری عکس</legend>
<!-- <FORM NAME="pictures" ACTION="addwork.php" METHOD="POST" enctype="multipart/form-data">-->
<!-- <INPUT type="submit" NAME="actionpic" VALUE="Upload">-->
<INPUT type="file" size="30" name="userfile">
<INPUT TYPE="HIDDEN" NAME="MAX_FILE_SIZE" VALUE="<? print $MAX_UPLOAD_SIZE; ?>">
<? print $std_font; ?> <b>
<? print ":(jpg only)فایل تصویری"; ?></b></font>
<?php
$path = ('../images/dec');
if ($handle = opendir('$path/')) {
while (false !== ($file = readdir($handle))) {
if(substr($file,strlen($file)-3,3) == 'jpg'){
echo "<a href='$path/$file' target='_BLANK'>$file</a> <a href='del.php?id=$id&file=$path/$file'>حذف</a><br />";
}
}
closedir($handle);
}
?>
</fieldset>
<select name="field" style="text-align:right;" >
<option <?if($field==$MSG_1037) print "selected"; ?> value="1"><? print $MSG_1037; ?></option>
<option <?if($field==$MSG_1036) print "selected"; ?> value="2"><? print $MSG_1036; ?></option>
<option <?if($field==$MSG_1038) print "selected"; ?> value="3"><? print $MSG_1038; ?></option>
<option <?if($field==$MSG_1039) print "selected"; ?> value="4"><? print $MSG_1039; ?></option>
<option <?if($field==$MSG_1040) print "selected"; ?> value="5"><? print $MSG_1040; ?></option>
<option <?if($field==$MSG_1044) print "selected"; ?> value="6"><? print $MSG_1044; ?></option>
</select>
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1047;?>
</b> </TD>
</TR>
<!------------------ item description ---------------->
<TR>
<!--<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="hidden" name="university" size="40" value="<? $_post['fname'];?>">
</B> </TD>
<TD WIDTH="255"> <b>
</b> </TD>
</TR>
<!------------------ item description ---------------->
<!------------------ item description ---------------->
<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="name" size="40" maxlength="35" value="<? print stripslashes($name); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1033;?>
</b> </TD>
</TR>
<!------------------ item description ---------------->
<!------------------ item description ---------------->
<!--<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="tel" size="40" value="<? print stripslashes($tel); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1038;?>
</b> </TD>
</TR>-->
<!------------------ item description ---------------->
<!--<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="irancell" size="40" value="<? print stripslashes($irancell); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1040;?>
</b> </TD>
</TR>-->
<!------------------ item description ---------------->
<!--<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="email" size="40" value="<? print stripslashes($email); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":ایمیل";?>
</b> </TD>
</TR>-->
<!------------------ item description ---------------->
<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<textarea dir="rtl" name="address" cols="32" rows="5" value="<? print stripslashes($address); ?>"></textarea>
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1034;?>
</b> </TD>
</TR>
<!------------------------------------- author ---------------------------->
<TR>
<TD WIDTH="584" align="right">
</FONT>
<INPUT TYPE="submit" NAME="actionpic" VALUE="<? print $MSG_011; ?>" >
</TD>
<TD WIDTH="204"> </TD>
</TR>
</TABLE>
<INPUT type="hidden" NAME="id" VALUE="<? echo $id; ?>">
<INPUT type="hidden" NAME="offset" VALUE="<? echo $offset; ?>">
<INPUT type="hidden" NAME="searchitem" VALUE="<? echo $searchitem; ?>">
<INPUT type="hidden" NAME="action" VALUE="update">
</center>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="5" BGCOLOR="#FFFFFF">
<TR>
<td width="30%">
</td>
<td valign="top" align="center" width="40%">
<BR />
<BR />
</td>
<td width="30%">
</td>
</TR>
</TABLE>
<BR>
<BR>
<CENTER>
<FONT face="Tahoma, Arial" size="2"><A HREF="admin.php" CLASS="navigation"><? print $MSG_001 ?></A> |
<FONT face="Tahoma, Arial" size="2"><A
HREF="listwork.php?searchitem=<? print $searchitem ?>&offset=<? print $offset; ?>" CLASS="navigation"><? print $MSG_029 ?></A></FONT>
</CENTER>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<!-- Closing external table (header.php) -->
</TD>
</TR>
</TABLE>
<? include "./footer.php"; ?>
<?
$id=$_REQUEST['id'];
$offset=$_REQUEST['offset'];
$searchitem=$_REQUEST['searchitem'];
$action=$_POST['action'];
include "loggedin.inc.php";
include "../includes/messages.inc.php";
require("../includes/config.inc.php");
$userfile_fname=$_POST['userfile_fname'];
function generate_id()
{
global $name, $university;
$auction_id = md5(uniqid(rand(), true));
return $auction_id;
}
if($action)
{
$id = generate_id();
$name =$_POST['name'];
$university =$_POST['userfile_fname'];
$grade =$_POST['grade'];
$field =$_POST['field'];
$status =$_POST['status'];
$sex =$_POST['sex'];
$tel =$_POST['tel'];
$mobile =$_POST['mobile'];
$irancell =$_POST['irancell'];
$email =$_POST['email'];
$address =$_POST['address'];
// Check that all the fields are not NULL
if ($name)
{
/*
* Check the input values for validity.
*/
$sql="Insert into ganjineh_work values(NULL,\"". AddSlashes($name)
."\", \"". AddSlashes($university)
."\", \"". AddSlashes($grade)
."\", \"". AddSlashes($field)
."\", \"". AddSlashes($status)
."\", \"". AddSlashes($sex)
."\", \"". AddSlashes($tel)
."\", \"". AddSlashes($mobile)
."\", \"". AddSlashes($irancell)
."\", \"". AddSlashes($email)
."\", \"". AddSlashes($address)
."\", 1)";
$res=mysql_query ($sql);
if (!$res)
{
print "Database error on update: " . mysql_error();
exit;
}
else
{
$updated = 1;
}
header("Location: listwork.php");
}
else
{
$ERR = "ERR_005";
}
}
if(!$action || ($action && $updated))
{
$query = "select *
from ganjineh_work a where a.id=\"$id\"";
$result = mysql_query($query);
if(!$result){
print "Database access error: abnormal termination".mysql_error();
exit;
}
$id = mysql_result($result,0,"id");
$university = stripslashes(mysql_result($result,0,"userfile_fname"));
$grade = stripslashes(mysql_result($result,0,"grade"));
$field = stripslashes(mysql_result($result,0,"field"));
$status = stripslashes(mysql_result($result,0,"status"));
$sex = stripslashes(mysql_result($result,0,"sex"));
$tel = stripslashes(mysql_result($result,0,"tel"));
$mobile = stripslashes(mysql_result($result,0,"mobile"));
$irancell = stripslashes(mysql_result($result,0,"irancell"));
$email = stripslashes(mysql_result($result,0,"email"));
$address = stripslashes(mysql_result($result,0,"address"));
}
// update current session
if ( isset($sessionVars["SELL_DATA_CORRECT"]) )
unset($sessionVars["SELL_DATA_CORRECT"]);
session_name($SESSION_NAME);
session_register("sessionVars");
require "./header.php";
require('../includes/styles.inc.php');
?>
<? $field=$_POST['field'];
switch ($field){
case 1:{
$path = ('../images/dec');
break;
}
case 2:{
$path = ('../images/furniture');
break;
}
case 3:{
$path = ('../images/view');
break;
}
case 4:{
$path = ('../images/messi');
break;
}
case 5:{
$path = ('../images/imprint tablet');
break;
}
case 6:{
$path = ('../images/reticular');
break;
}
}
$actionpic=$_REQUEST['actionpic'];
if($actionpic)
{
$userfile = $_REQUEST['userfile'];
$userfile_temp=$_FILES['userfile']['tmp_name'];
$userfile_fname=$_FILES['userfile']['name'];
if(!empty($userfile_temp) && $userfile_temp != "none" )
{
// really save this file
$fname = "$path/".substr($userfile_fname,0,strlen($userfile_fname)-3)."jpg";
$pname = $userfile_fname;
if ( file_exists($fname) )
unlink ($fname);
move_uploaded_file ( $userfile_temp, $fname );
}
}
?>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="5" BGCOLOR="#FFFFFF">
<TR>
<TD>
<TABLE WIDTH="100%" CELLPADDING="0" CELLSPACING="0" BORDER="0" BGCOLOR="#FFFFFF">
<TR>
<TD ALIGN="CENTER" COLSPAN="5">
<BR>
<FONT FACE="Verdana, Arial, Helvetica, sans-serif" SIZE="4">
<B><? print $MSG_012; ?></B>
</FONT>
<BR>
</TD>
</TR>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="5">
<?
if($ERR || $updated){
print "<TR>
<TD>
</TD>
<TD WIDTH=486>
<FONT FACE=\"Verdana,Arial, Helvetica\" SIZE=2 COLOR=red>";
if($$ERR) print $$ERR;
if($updated) print $MSG_054;
print "</TD>
</TR>";
}
?>
<FORM NAME="details" ACTION="<? print basename($PHP_SELF); ?>" METHOD="POST" enctype="multipart/form-data">
<!------------------ item description ---------------->
<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<fieldset>
<legend>تصاویر گالری عکس</legend>
<!-- <FORM NAME="pictures" ACTION="addwork.php" METHOD="POST" enctype="multipart/form-data">-->
<!-- <INPUT type="submit" NAME="actionpic" VALUE="Upload">-->
<INPUT type="file" size="30" name="userfile">
<INPUT TYPE="HIDDEN" NAME="MAX_FILE_SIZE" VALUE="<? print $MAX_UPLOAD_SIZE; ?>">
<? print $std_font; ?> <b>
<? print ":(jpg only)فایل تصویری"; ?></b></font>
<?php
$path = ('../images/dec');
if ($handle = opendir('$path/')) {
while (false !== ($file = readdir($handle))) {
if(substr($file,strlen($file)-3,3) == 'jpg'){
echo "<a href='$path/$file' target='_BLANK'>$file</a> <a href='del.php?id=$id&file=$path/$file'>حذف</a><br />";
}
}
closedir($handle);
}
?>
</fieldset>
<select name="field" style="text-align:right;" >
<option <?if($field==$MSG_1037) print "selected"; ?> value="1"><? print $MSG_1037; ?></option>
<option <?if($field==$MSG_1036) print "selected"; ?> value="2"><? print $MSG_1036; ?></option>
<option <?if($field==$MSG_1038) print "selected"; ?> value="3"><? print $MSG_1038; ?></option>
<option <?if($field==$MSG_1039) print "selected"; ?> value="4"><? print $MSG_1039; ?></option>
<option <?if($field==$MSG_1040) print "selected"; ?> value="5"><? print $MSG_1040; ?></option>
<option <?if($field==$MSG_1044) print "selected"; ?> value="6"><? print $MSG_1044; ?></option>
</select>
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1047;?>
</b> </TD>
</TR>
<!------------------ item description ---------------->
<TR>
<!--<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="hidden" name="university" size="40" value="<? $_post['fname'];?>">
</B> </TD>
<TD WIDTH="255"> <b>
</b> </TD>
</TR>
<!------------------ item description ---------------->
<!------------------ item description ---------------->
<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="name" size="40" maxlength="35" value="<? print stripslashes($name); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1033;?>
</b> </TD>
</TR>
<!------------------ item description ---------------->
<!------------------ item description ---------------->
<!--<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="tel" size="40" value="<? print stripslashes($tel); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1038;?>
</b> </TD>
</TR>-->
<!------------------ item description ---------------->
<!--<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="irancell" size="40" value="<? print stripslashes($irancell); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1040;?>
</b> </TD>
</TR>-->
<!------------------ item description ---------------->
<!--<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<input dir="rtl" type="text" name="email" size="40" value="<? print stripslashes($email); ?>">
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":ایمیل";?>
</b> </TD>
</TR>-->
<!------------------ item description ---------------->
<TR>
<TD WIDTH="584" VALIGN="top" ALIGN="right"> <B>
<textarea dir="rtl" name="address" cols="32" rows="5" value="<? print stripslashes($address); ?>"></textarea>
</B> </TD>
<TD WIDTH="255"> <b>
<? print $nav_font.":".$MSG_1034;?>
</b> </TD>
</TR>
<!------------------------------------- author ---------------------------->
<TR>
<TD WIDTH="584" align="right">
</FONT>
<INPUT TYPE="submit" NAME="actionpic" VALUE="<? print $MSG_011; ?>" >
</TD>
<TD WIDTH="204"> </TD>
</TR>
</TABLE>
<INPUT type="hidden" NAME="id" VALUE="<? echo $id; ?>">
<INPUT type="hidden" NAME="offset" VALUE="<? echo $offset; ?>">
<INPUT type="hidden" NAME="searchitem" VALUE="<? echo $searchitem; ?>">
<INPUT type="hidden" NAME="action" VALUE="update">
</center>
<TABLE WIDTH="100%" BORDER="0" CELLPADDING="5" BGCOLOR="#FFFFFF">
<TR>
<td width="30%">
</td>
<td valign="top" align="center" width="40%">
<BR />
<BR />
</td>
<td width="30%">
</td>
</TR>
</TABLE>
<BR>
<BR>
<CENTER>
<FONT face="Tahoma, Arial" size="2"><A HREF="admin.php" CLASS="navigation"><? print $MSG_001 ?></A> |
<FONT face="Tahoma, Arial" size="2"><A
HREF="listwork.php?searchitem=<? print $searchitem ?>&offset=<? print $offset; ?>" CLASS="navigation"><? print $MSG_029 ?></A></FONT>
</CENTER>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<!-- Closing external table (header.php) -->
</TD>
</TR>
</TABLE>
<? include "./footer.php"; ?>
ممممنووووووون