Databases
StackOverflow2013
Postsdbo
POSaving file path to Database / SQL
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSaving file path to Database / SQL
    primarykey
    data
    text
    <p>INTRO: I'm creating a 'Social network' site. It's more of a learning exercise than a business venture. I have created the simple version of login and registration (without encryption) they use PHPMyadmin and work.</p> <p>I've created a form to upload a picture (to later be displayed). The picture saves to the server, then i need to store the path to the db... but thats the bit where is all going wrong!!</p> <p>Every page includes "session_start();"</p> <p>Form:</p> <pre><code>&lt;form action="upload_ppl.php" method="post" enctype="multipart/form-data"&gt; &lt;label for="file"&gt;Filename:&lt;/label&gt; &lt;input type="file" name="file" id="file"&gt;&lt;br&gt; &lt;input type="submit" name="submit" value="Submit"&gt; &lt;/form&gt; </code></pre> <p>upload_ppl.php:</p> <pre><code>&lt;?php session_start(); $allowedExts = array("gif", "jpeg", "jpg", "png"); $temp = explode(".", $_FILES["file"]["name"]); $extension = end($temp); if ((($_FILES["file"]["type"] == "image/gif") || ($_FILES["file"]["type"] == "image/jpeg") || ($_FILES["file"]["type"] == "image/jpg") || ($_FILES["file"]["type"] == "image/pjpeg") || ($_FILES["file"]["type"] == "image/x-png") || ($_FILES["file"]["type"] == "image/png")) &amp;&amp; ($_FILES["file"]["size"] &gt; 2000) &amp;&amp; in_array($extension, $allowedExts)) { if ($_FILES["file"]["error"] &gt; 0) { echo "Return Code: " . $_FILES["file"]["error"] . "&lt;br&gt;"; } else { echo "Upload: " . $_FILES["file"]["name"] . "&lt;br&gt;"; echo "Type: " . $_FILES["file"]["type"] . "&lt;br&gt;"; echo "Size: " . ($_FILES["file"]["size"] / 1024) . " kB&lt;br&gt;"; echo "Temp file: " . $_FILES["file"]["tmp_name"] . "&lt;br&gt;"; if (file_exists("upload/" . $_FILES["file"]["name"])) { echo $_FILES["file"]["name"] . " already exists. "; } else { $image_name= $FILES["file"]["name"]; $path=move_uploaded_file($_FILES["file"]["tmp_name"], "upload/" . rand().$_FILES["file"]["name"]); echo "Stored in: " . "upload/" . $_FILES["file"]["name"]; if(mysql_query("INSERT INTO *table* (*column*) VALUES ('$path')")){ echo "Successfull!!";} else { echo 'fail';} } } } else { echo "Invalid file"; } ?&gt; </code></pre> <p>Please note that on the 'connection.page' upon login the db connection is established! Do I need to carry this forward with a session variable, just create a new connection all together? I've tried tons. All suggestions appreciated. Thanks guys!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USIsaac Bennetch
    1. USjustsimpleshh
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSaving file path to Database / SQL
      1. UScameronjonesweb
      1. VTFavorite
    2. VO
      singulars
      1. POSaving file path to Database / SQL
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSaving file path to Database / SQL
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. CO"It's more of a learning exercise than a business venture." - That's what they all say ;-)
      singulars
      1. POSaving file path to Database / SQL
      1. USStrawberry
    2. COPlease don't use `mysql_*` functions anymore, they are deprecated. See [Why shouldn't I use mysql_* functions in PHP?](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php) for details. Instead you should learn about [prepared statements](http://bobby-tables.com/php.html) and use either [PDO](http://php.net/pdo) or [MySQLi](http://php.net/mysqli). If you can't decide which, [this article](http://php.net/manual/en/mysqlinfo.api.choosing.php) will help you. If you pick PDO, [here is a good tutorial](http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers).
      singulars
      1. POSaving file path to Database / SQL
      1. USMarcel Korpel
    3. CO@Strawberry If i was good enough to take on FB I wouldn't need to post this question lol.
      singulars
      1. POSaving file path to Database / SQL
      1. USjustsimpleshh
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload