Storing image name in mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
stipe
Forum Newbie
Posts: 11
Joined: Sun Sep 25, 2005 6:09 pm

Storing image name in mysql

Post by stipe »

feyd | Please use

Code: Select all

and

Code: 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">&nbsp;</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>&nbsp;</td>
    <td></td>
    <td>&nbsp;</td>
    <td>&nbsp;</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>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td align="right" valign="top">Autor:</td>
    <td><input name="autor" type="text" id="autor"></td>
    <td>&nbsp;</td>
    <td>&nbsp;</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>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</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

and

Code: 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]
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

where oh where should I begin? ;) I know! Please try not to double post.

List of bugs and issues I see in the quick look over:
  • Your session will (very likely) not start due to you starting the session after output has been sent to the browser. (Read for further details39])
  • $HTTP_POST_VARS is deprecated and should be avoided from usage (as of PHP 4 I believe)
  • Looking for the submit button can and often is dangerous as most forms can be submitted (legitimately) without it. To see an illustration, click into a text field after filling in the form correctly and press enter in IE.
  • "link," your file, will not be in the $HTTP_POST_VARS. Instead it will be in $_FILES or $HTTP_POST_FILES (I think)
  • regarding this sort of code:

    Code: Select all

    $vijest_duga=$HTTP_POST_VARS[vijest_duga];
    $link=$HTTP_POST_VARS[link] ;     
    $autor=$HTTP_POST_VARS[autor];  
    $dan=$HTTP_POST_VARS[dan];
    Always, always, always quote named array indices like so:

    Code: Select all

    $vijest_duga=$HTTP_POST_VARS['vijest_duga'];
    $link=$HTTP_POST_VARS['link'] ;     
    $autor=$HTTP_POST_VARS['autor'];  
    $dan=$HTTP_POST_VARS['dan'];
that about covers it.
stipe
Forum Newbie
Posts: 11
Joined: Sun Sep 25, 2005 6:09 pm

storing image name in mysql

Post by stipe »

Sorry for mistakes, i will fix bugs, but can you tell me how to put image_name in mysql,everything else
work fine except that
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

you don't have any fields that would create such a variable.
stipe
Forum Newbie
Posts: 11
Joined: Sun Sep 25, 2005 6:09 pm

storing image name in mysql

Post by stipe »

And what is wrong with this

Code: Select all

$image=$HTTP_POST_VARS[image_name] ;
$image2 = $HTTP_POST_VARS[image2_name];
$image3=$HTTP_POST_VARS[image3_name]  ;
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Re: storing image name in mysql

Post by Chris Corbyn »

stipe wrote:And what is wrong with this

Code: Select all

$image=$HTTP_POST_VARS[image_name] ;
$image2 = $HTTP_POST_VARS[image2_name];
$image3=$HTTP_POST_VARS[image3_name]  ; 

//should be....
$image=$_POST['image_name'] ;
$image2 = $_POST['image2_name'];
$image3=$_POST['image3_name']  ;

Code: Select all

$image=$HTTP_POST_VARS[image_name] ;
$image2 = $HTTP_POST_VARS[image2_name];
$image3=$HTTP_POST_VARS[image3_name]  ; 

//should be....
$image=$_POST['image_name'] ;
$image2 = $_POST['image2_name'];
$image3=$_POST['image3_name']  ;
Post Reply