Image Upload Function

rh91uk · June 22, 2006

I want to upload an image to the sql database, but I havent a clue how too! Ive tried google, but most of them are quite out of my league, as in i dont know how to add one to the following code:

[code]<?php
    session_start();
    if(!$_SESSION['username']){
            header("Location: login.php");
            exit();
        }
    include('../includes/config.inc.php');
    include('../includes/dbconnect.inc.php');

if($_GET['delete']){
    $sql = "DELETE FROM `news` WHERE id='" . $_GET['delete'] . "'";
    $result = mysql_query($sql) or die ("<b>ERROR: </b>" . mysql_error() . "<b>SQL: </b>$sql");
    header("Location: pages.php");
    exit();
}
?>
<html>
<head>
<title>Edit/Add News Story</title>
<meta http-equiv="Content-Type" content="text/html;">
<link href="/includes/style.css" rel="stylesheet" type="text/css">
<style type="text/css">

</style>
</head>
<body>
<h1>Richard Harris</h1>
<p class="style1">EDIT NEWS STORY </p>
<p><?php
                if(!isset($_POST['Submit'])){
                    $id = $_GET['edit'];
                    $sql = "SELECT * FROM `news` WHERE id='$id'";
                    $result = mysql_query($sql) or die ("<b>ERROR: </b>" . mysql_error() . "<b>SQL: </b>$sql");
                    $rows = mysql_num_rows($result);
                    while ($news = mysql_fetch_array($result)) {
                        $news_title = $news["title"];
                        $news_content = $news["content"];
                        $news_img = $news["img"];
                        }
              ?>
<form method="post" action="<?=$_SERVER['../../../../My%20Documents/admin/PHP_SELF'];?>">

              <table width="436" border="0" cellpadding="3" cellspacing="1">
                <tr>
                  <td width="67"><strong>Title</strong></td>
                  <td width="354"><input name="title" type="text" class="txtboxlrg" value="<?=$news_title;?>" size="50"></td>
                </tr>
                <input name="id" type="hidden" value="<?=$id;?>">
                <tr>
                  <td valign="top"><strong>Content</strong></td>
                  <td><textarea name="content" cols="50" rows="22" class="txtboxlrg" width="472"><?=$news_content;?></textarea></td>
                </tr>
                <tr>
                  <td></td>
                  <td align="center" class="header2"><input name="Submit" type="submit" onFocus="this.blur();" value="Update"></td>
                </tr>
              </table>
</form>
            <?php
                } else {
                        if((!$_POST['title']) || (!$_POST['content']) || (!$_POST['img'])){
                            echo "You are missing a required field, please <a href=\"javascript:history.back()\">go back</a> and correct before proceeding!";
                        } else {
                            if($_POST['id']){
                                $sql = "UPDATE `news` SET title='" . $_POST['title'] . "', content='" . $_POST['content'] . "' , img='" . $_POST['img'] . "', author='" . $_SESSION['firstname'] . " " . $_SESSION['lastname'] . "', updated=NOW() WHERE id = '" . $_POST['id'] . "'";
                                $result = mysql_query($sql) or die ("<b>ERROR: </b>" . mysql_error() . "<b>SQL: </b>$sql");
                                echo "News Item \"" . $_POST['title'] . "\" updated successfully - return to <a href=\"pages.php\" onFocus=\"this.blur();\">pages</a>!";
                            } else {
                                $sql = "INSERT INTO `news`  ( `id` , `title` , `content` , `img` , `author`,  `added` ) VALUES('', '" . $_POST['title'] . "', '" . $_POST['content'] . "', '" . $_POST['img'] . "', '" . $_SESSION['firstname'] . " " . $_SESSION['lastname'] . "', NOW())";
                                $result = mysql_query($sql) or die ("<b>ERROR: </b>" . mysql_error() . "<b>SQL: </b>$sql");
                                $id = mysql_insert_id();
                                echo "News Item \"" . $_POST['title'] . "\" added successfully - return to <a href=\"pages.php\" onFocus=\"this.blur();\">pages</a>";
                            }
                        }
                    }
                ?></p>
</body>
</html>
[/code]

If soemone here could help me, maybe write me an addition, i would be greateful!

Sign In

Image Upload Function

Recommended Posts

rh91uk

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information