Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
Please can someone help me with this,
i want to store image name in mysql but it's not working, everything else is ok except image name
what am i missing?Code: Select all
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Unos vijesti</title>
</head>
<body >
<?
session_start();
if (!isset($_SESSION['user_is_logged_in']) || $_SESSION['user_is_logged_in'] !== true) {
header('Location: /home/radio057/public_html/admin/login.php');
exit;
} ?>
<?php
If ($HTTP_POST_VARS["Submit2"] <> 'Pošalji') {
?>
<div align="right"><?php
echo "<a href=\"javascript:self.history.back();\">Admin</a>";
?></div>
<form name="form" method="post" enctype="multipart/form-data" action="">
<table width="100%" border="0" cellspacing="2" cellpadding="0">
<tr>
<br>
<th width="16%" align="right" valign="top">Naslov:</th>
<th width="28%" align="left" scope="col"><input name="naslov" type="text"></th>
<th width="11%" scope="col"> </th>
<th width="45%" scope="col"></th>
</tr>
<br>
<br>
<tr>
<br>
<td rowspan="2" align="right" valign="top">Kratka vijest:</td>
<td rowspan="2"><textarea name="vijest" cols="30" rows="5"></textarea></td>
<td height="63" align="right" valign="top"><br>
Default slika:</td>
<td rowspan="2">
<select name="dslika">
<option> </option>
<option value="logo_finalfour.gif">final four</option>
<option value="test/championscup.gif">champion</option>
<option value="test/euroleague.gif">euroliga</option>
<option value="test/gy.gif">goodyear</option>
<option value="kup.gif">kup</option>
<option value="gifs/ozujskoliga_logo.gif">ozujsko liga</option>
<option value="gifs/siromeu.gif">sirom EU</option>
<option value="test/ulebcup.gif">uleb</option>
<option value="test/zdlogo.gif">zadar</option>
</select><br><br>
<input name="slikad" type="file" ></td>
</tr>
<tr>
<td height="40" align="right" valign="top"><i><font size="1">(ili odaberite novu
sliku)</font></i></td>
</tr>
<tr>
<td rowspan="2" align="right" valign="top">Duga vijest:</td>
<td rowspan="2"><textarea name="vijest_duga" cols="30" rows="5"></textarea></td>
<td align="right" valign="top" >Mala slika:</td>
<td height="40" align="left" valign="top"><input name="slika" type="file" ></td>
</tr>
<tr>
<td align="right" valign="top" >Velika slika:</td>
<td align="left" valign="top"><input name="slikav" type="file" ></td>
</tr>
<tr>
<td> </td>
<td></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align="right" valign="top">Datum objave:</td>
<td> <select name="danob">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
-
<select name="mjesecob">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
-
<select name="godob">
<option value="2002">2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
</select> </td>
</tr>
<tr>
<td align="right">Sat objave:</td>
<td colspan="2"> <select name="satob">
<option value="00">00</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
</select>
:
<select name="minob">
<option value="00">00</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
<option value="37">37</option>
<option value="38">38</option>
<option value="39">39</option>
<option value="40">40</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="44">44</option>
<option value="45">45</option>
<option value="46">46</option>
<option value="47">47</option>
<option value="48">48</option>
<option value="49">49</option>
<option value="50">50</option>
<option value="51">51</option>
<option value="52">52</option>
<option value="53">53</option>
<option value="54">54</option>
<option value="55">55</option>
<option value="56">56</option>
<option value="57">57</option>
<option value="58">58</option>
<option value="59">59</option>
</select>
</td>
<td><input type="checkbox" name="obodma" value="1"></td>
</tr>
<tr>
<td align="right" valign="top"></td>
<td></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align="right" valign="top">Autor:</td>
<td><input name="autor" type="text" id="autor"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align="right">Link:</td>
<td colspan="3"><input name="link" type="text" id="link" value="http://">
*http:// (obavezno upisati prije adrese) </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td colspan="2"><input name="Submit2" type="submit" id="Submit2" value="Pošalji"></td>
</tr>
</table>
</form>
<?php }
If ($HTTP_POST_VARS["Submit2"] == 'Pošalji') {
require ("./connect.php");
$HTTP_POST_VARS["dan"] = date("d");
$HTTP_POST_VARS["mjesec"] = date("m");
$HTTP_POST_VARS["godina"] = date("Y");
$HTTP_POST_VARS["sat"] = date("H");
$HTTP_POST_VARS["minute"] = date("i");
$naslov=$HTTP_POST_VARS[naslov] ;
$vijest=$HTTP_POST_VARS[vijest] ;
$vijest_duga=$HTTP_POST_VARS[vijest_duga];
$link=$HTTP_POST_VARS[link] ;
$autor=$HTTP_POST_VARS[autor];
$dan=$HTTP_POST_VARS[dan];
$mjesec=$HTTP_POST_VARS[mjesec];
$godina=$HTTP_POST_VARS[godina] ;
$sat=$HTTP_POST_VARS[sat] ;
$minute=$HTTP_POST_VARS[minute];
$danob=$HTTP_POST_VARS[danob] ;
$mjesecob=$HTTP_POST_VARS[mjesecob];
$godob=$HTTP_POST_VARS[godob] ;
$satob=$HTTP_POST_VARS[satob] ;
$minob=$HTTP_POST_VARS[minob] ;
$obodma=$HTTP_POST_VARS[obodma];
$dslika=$HTTP_POST_VARS[dslika];
$image=$HTTP_POST_VARS[image_name] ;
$image2 = $HTTP_POST_VARS[image2_name];
$image3=$HTTP_POST_VARS[image3_name] ;
$sql = "INSERT INTO vijesti VALUES('','$naslov' ,'$vijest','$vijest_duga','$link','$autor','$dan','$mjesec','$godina','$sat','$minute','$danob','$mjesecob','$godob','$satob','$minob','$obodma','$dslika','$image_name','$image2_name','$image3_name')";
If (mysql_query($sql)) {
echo ("<table width='650' border='0' cellspacing='0' cellpadding='0'>
<tr> <td class='txtveliki'><div align='center'>Vijest je uspješno unešena u bazu</div></td></tr></table>"); ?>
<?php
} else {
echo ("<table width='650' border='0' cellspacing='0' cellpadding='0'>
<tr> <td class='txtveliki'><div align='center'>Vijest nije unešena u bazu!!!: " .
mysql_error() . "</div></td></tr></table>");
}}
?>
</body>
</html>feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]