************
* news.php *
************
<?php
// detter er til fremvisning af nyhederne
include 'config.php';
include 'mysqlconnect.php';
$num = 10; // antallet af viste nyheder!
$get = "SELECT ".$col." FROM `".$table."` LIMIT ".$num."";
$result = mysql_query($get);
while ($data = mysql_fetch_assoc($result)){
print "<img src=\"show.image.php?id=".$data['id']."&pic=1\">";
print "<img src=\"show.image.php?id=".$data['id']."&pic=2\">";
print "<img src=\"show.image.php?id=".$data['id']."&pic=3\">";
print "<img src=\"show.image.php?id=".$data['id']."&pic=4\">";
}
?>
******************
* show.image.php *
******************
<?php
//denne sender billedet så browseren kan forstå det
include 'config.php';
include 'mysqlconnect.php';
if ($_GET['pic'] == "1"){
$code = addslashes($_GET['id']);
$result = mysql_query("SELECT ".$col." FROM `".$table."` WHERE `id`='$code'");
$data = mysql_fetch_assoc($result);
$pic1 = $data['pic1'];
print $pic1;
}
else {}
if ($_GET['pic'] == "2"){
$code = addslashes($_GET['id']);
$result = mysql_query("SELECT ".$col." FROM `".$table."` WHERE `id`='$code'");
$data = mysql_fetch_assoc($result);
$pic2 = $data['pic2'];
print $pic2;
}
else {}
if ($_GET['pic'] == "3"){
$code = addslashes($_GET['id']);
$result = mysql_query("SELECT ".$col." FROM `".$table."` WHERE `id`='$code'");
$data = mysql_fetch_assoc($result);
$pic3 = $data['pic3'];
print $pic3;
}
else {}
if ($_GET['pic'] == "4"){
$code = addslashes($_GET['id']);
$result = mysql_query("SELECT ".$col." FROM `".$table."` WHERE `id`='$code'");
$data = mysql_fetch_assoc($result);
$pic4 = $data['pic4'];
print $pic4;
}
else {}
?>
***************
* new.add.php *
***************
<?php
include 'config.php';
include 'mysqlconnect.php';
if (isset($_POST['addnow']) == "add"){
//int(id) longtext(type) longtext(år) longtext(pris) longtext(km) longblob(pic1) longblob(pic2) longblob(pic3) longblob(pic4)
$type = $_POST['type'];
$aar = $_POST['aar'];
$pris = $_POST['pris'];
$udstyr = $_POST['udstyr'];
$km = $_POST['km'];
$pic1 = $_FILES['pic1']['tmp_name'];
$pic1 = addslashes(fread(fopen($pic1,"r"),filesize($pic1)));
$pic2 = $_FILES['pic2']['tmp_name'];
$pic2 = addslashes(fread(fopen($pic2,"r"),filesize($pic2)));
$pic3 = $_FILES['pic3']['tmp_name'];
$pic3 = addslashes(fread(fopen($pic3,"r"),filesize($pic3)));
$pic4 = $_FILES['pic4']['tmp_name'];
$pic4 = addslashes(fread(fopen($pic4,"r"),filesize($pic4)));
echo "yes";
$query = "INSERT INTO `".$table."` VALUES ('', '".$type."', '".$aar."', '".$pris."', '".$udstyr."', '".$km."', '".$pic1."', '".$pic2."', '".$pic3."', '".$pic4."')";
if (mysql_query($query)) {}
else {$_POST['error'] = "Can't do SQL query - ".mysql_error();}
}
else {}
print "
<form action=\"\" method=\"post\" enctype=\"multipart/form-data\">
<input type=\"hidden\" value=\"add\" name=\"addnow\">
<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
<td>Type:<br><input type=\"text\" name=\"type\" style=\"width:300px; \"></td>
</tr>
<tr>
<td><br>År:<br><input name=\"aar\" style=\"width:300px;\"><td>
</tr>
<tr>
<td><br>Pris:<br><input type=\"text\" name=\"pris\"style=\"width:300px;\"></td>
</tr>
<tr>
<td><br>udstyr:<br><input type=\"text\" name=\"udstyr\"style=\"width:300px;\"></td>
</tr>
<tr>
<td><br>KM:<br><input name=\"km\" style=\"width:300px;\"></td>
</tr>
<tr>
<td><br>Billede nr1:<br><input type=\"file\" name=\"pic1\" style=\"width:300px;\"></td>
</tr>
<tr>
<td><br>Billede nr2:<br><input type=\"file\" name=\"pic2\" style=\"width:300px;\"></td>
</tr>
<tr>
<td><br>Billede nr3:<br><input type=\"file\" name=\"pic3\" style=\"width:300px;\"></td>
</tr>
<tr>
<td><br>Billede nr4:<br><input type=\"file\" name=\"pic4\" style=\"width:300px;\"></td>
</tr>
<tr>
<td><br><input type=\"submit\" name=\"addnow\" value=\"Tilføj\"><input type=\"reset\" name=\"reset\" value=\"Reset\"></td>
</tr>
</table>
</form>";
?>
**************
* config.php *
**************
<?php
// The News DataBase need some info...
$host = "localhost"; // Hosten på databasen (Hvis egen localhost server skrived der endten "localhost" eller "". (disse " skrives ikke)
$user = "username"; // Brugernavnet til databasen
$pass = "password"; // kodeordet til databasen
$base = "database"; // databasens navn
$col = "*"; // kolonnernes navne. "*" for alle
$table = "salg"; // tabellens navn
?>
********************
* mysqlconnect.php *
********************
<?php
if (!mysql_connect($host,$user,$pass))
{
print "database error: can't connect to database at shost: $host - ".mysql_error();
exit();
}
else
{
if (!mysql_select_db($base))
{
print "database error: can't open database $fd_db_name - ".mysql_error();
exit();
}
else {}
}
?>
******************************
* !! DATABASEN JEG BRUGTE !! *
******************************
# phpMyAdmin SQL Dump
# version 2.5.7-pl1
#
http://www.phpmyadmin.net#
# Host: localhost
# Generation Time: Nov 03, 2004 at 03:51 PM
# Server version: 4.0.18
# PHP Version: 4.3.8
#
# Database : `funny`
#
CREATE DATABASE `funny`;
USE funny;
# --------------------------------------------------------
#
# Table structure for table `salg`
#
CREATE TABLE `salg` (
`id` int(11) NOT NULL auto_increment,
`type` longtext NOT NULL,
`aar` longtext NOT NULL,
`pris` longtext NOT NULL,
`udstyr` longtext NOT NULL,
`km` longtext NOT NULL,
`pic1` longblob,
`pic2` longblob,
`pic3` longblob,
`pic4` longblob,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `salg`
#
Ny bruger
Nybegynder
Opret
Preview
