Scripts
Beginners Nieuws SysteemPJE
Hallo :) Ik heb zelf een heel klein nieuwsysteempje gemaakt met behulp van mensen hierzo , en ik dacht laat ik hem even posten voor de beginners zoals ik die makkelijk willen beginnen het SysteemPJE bevat 3 bestanden Index.php // laat de nieuwsberichten zien , Post.php // Hiermee post je een nieuw bericht Connect.php // hier mee maakt het systeempje verbinding met je DB :) Het zal niet op z,n mooist gescript zijn en ik heb zelf het script dmv andere script in elkaar gezet
beginners-nieuws-systeempje
[code]
MYSQL DB
//
CREATE TABLE `nieuws` (
`Titel` varchar(50) collate latin1_general_ci NOT NULL,
`Auteur` varchar(20) collate latin1_general_ci NOT NULL,
`Bericht` varchar(160) collate latin1_general_ci NOT NULL
) ENGINE=MyISAM ;
//
Index.php
___________
<?php
require_once('connect.php');
$sql = "
SELECT Titel, Auteur, Bericht
FROM nieuws
ORDER BY Auteur ASC, Bericht ASC
";
if (!$res = mysql_query ($sql)) {
echo '<pre>';
echo htmlentities ($sql);
trigger_error (mysql_error ());
echo '</pre>';
}
else {
while ($row = mysql_fetch_assoc ($res)) {
echo '<hr>';
echo '<p><i>Titel: </i>' . $row['Titel'] . '</p>';
echo '<p><i>Auteur: </i>' . $row['Auteur'] . '</p>';
echo '<p><i>Bericht:</i><b> ' . $row['Bericht'] . '</b></p>';
}
}
?>
[/code]
Post.php
___________
[code]
<?php
ini_set ('display_errors', 1);
error_reporting (E_ALL);
require_once('connect.php');
?>
<form action="" method="post">
<table width=410" border="0" align="center" cellspacing="0" cellpadding="0">
<tr>
<td height="5"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
<tr>
<td height="5" bgcolor="CCCCCC">
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td width="4"> </td>
<td>Nieuwsysteem V1</td>
<td width="4"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="E7EBEF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4"> </td>
<td width="120" align="left">Titel</td>
<td width="274" align="right"><input type="text" name="Titel" size="30"></td>
<td width="12"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="E7EBEF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4"> </td>
<td width="120" align="left">Auteur</td>
<td width="274" align="right"><input type="text" name="Auteur" size="30"></td>
<td width="12"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="E7EBEF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4"> </td>
<td width="120" align="left">Bericht</td>
<td width="274" align="right">
<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveResults" U-File="fpweb:///_private/form_results.csv" S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
<p><textarea rows="5" name="Bericht" cols="20"><br></textarea></p>
</form>
Er staat standaar <BR> laat dat staan !</td>
<td width="12"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="5"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
<tr>
<td height="30" align="left" bgcolor="#E7EBEF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4"> </td>
<td width="197" align="left"> </td>
<input type="hidden" value="1" name="afhandeling">
<td width="197" align="right"><input type="submit" value="Voeg toe" name="submit"></td>
<td width="12"> </td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<div style="position: absolute; width: 373px; height: 66px; z-index: 1; left: 316px; top: 301px; border-style: dashed" id="laag1">
© Copyright 2007 Kevin Riemers,<br>
Script Made By Kevin Riemers</div>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$sql_query = "
INSERT INTO nieuws
SET
Titel = '".mysql_real_escape_string ($_POST['Titel'])."',
Auteur = '".mysql_real_escape_string ($_POST['Auteur'])."',
Bericht = '".mysql_real_escape_string ($_POST['Bericht'])."'";
if (!$result = mysql_query($sql_query)) {
echo '<pre>';
echo htmlentities (str_replace ("\t", '', $sql_query));
trigger_error (mysql_errno () . ': ' . mysql_error ());
echo '</pre>';
}
}
?>
[/code]
Connect.php
______________
[code]
<?php
// Database gegevens.
$db_host = 'localhost'; // Server
$db_user = 'Databse username'; // Gebruikersnaam
$db_pass = 'Databse Wachtwoord'; // Wachtwoord
$db_name = 'Databse naam '; // Database
mysql_connect($db_host, $db_user, $db_pass) or die('Er kon geen verbinding met de server worden gemaakt.');
mysql_select_db($db_name) or die('Ik kon de juiste database niet vinden.');
?>
[/code]
Reacties
0