writing things to database [Archive]

View Full Version : writing things to database

ragtek

05-23-2006, 08:48 AM

hi
sorry for my bad english but im a austrian who never lerned it...

i'm writing on a script that had to write things from a formular to database
this is the template:
$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
$headinclude
<title>$vboptions[bbtitle]</title>
</head>
<body>
$header
$navbar
<table class="tborder"><tr><td class="alt1">
Hier gibts demn?chst wieder eine Linkliste
</td></tr></table>
<br />
<table class="tborder" width="100%"><tr><td class="alt2" colspan="3" align="center"><b>Soundsysteme</b></td></tr>
<tr class="thead" align="center"><td align="left">Name</td><td width="650px">Link</td><td width="24px">Melden</td>
$sys
</table>
<br />
<table class="tborder" width="100%"><tr><td class="alt2" colspan="3" align="center"><b>Sonstiges</b></td></tr>
<tr class="thead" align="center"><td align="left">Name</td><td width="650px">Link</td><td width="24px">Melden</td>
$son
</table>

<br />
<br />
<form action=linksliste.php method=send>
<table class="tborder" width="100%">
<tr class="alt2"><td colspan="7" align="center">Link hinzuf?gen:</td></tr>
<tr><td class="alt1" width="25px">URL:</td><td width="30px"><input type=text size=30 name=url></td><td class="alt1" width="25px">Name:</td><td width="50px"><input type=text size=50 name=beschreibung></td><td class="alt1">Kategorie:</td><td><select name="kategorie">
<option value="sys"> Soundsysteme,..
<option value="rec"> Recordstores,..
<option value="son"> Allgemeiner Link
<option value="ges"> Gesetze,§,...
</select></td></tr><tr><td colspan="7" align="center"><input type=submit border=0 value="senden"></td></table></form>

$footer
</body>
</html>

now how can i write the things that this form is sending to the database?
i have found something like :
if(isset($senden)) {

$db->query_write("INSERT INTO vb_linklist (url,beschreibung,kategorie) VALUES('$post[$url]','$post[$beschreibung]','$post[$kategorie]');");
}
but this doesnt work
can someone help please

amykhar

05-23-2006, 10:00 AM

from a form, you will need to read in the _POST variables. So, change the $post[$url] to $_POST['url'] for example and give that a shot. :)

Amy

ragtek

05-23-2006, 10:19 AM

oh i have made that but now theres a error on opening the site

http://vb.ragtek.org/linkliste.php

the php file look now so:

<?php

error_reporting(E_ALL & ~E_NOTICE);

define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'linkliste');

$phrasegroups = array();

$specialtemplates = array();

$globaltemplates = array(
'linkliste'
);
$actiontemplates = array();

require_once('./global.php');

// draw nav bar
$navbits = array();
$parentlist = array_reverse(explode(',', $foruminfo['parentlist']));
foreach ($parentlist AS $forumID)
{

$forumTitle = $forumcache["$forumID"]['title'];
$navbits["forumdisplay.php?$session[sessionurl]f=$forumID"] = $forumTitle;
}
$navbits["linkliste.php"] = "Linkliste";
$navbits = construct_navbits($navbits);

eval('$navbar = "' . fetch_template('navbar') . '";');

// ######################## Benutzercode #################

if (!empty($_GET['senden']))
{
$db->query_write("INSERT INTO vb_linklist (url,name,kategorie)
VALUES ($_POST['link'],$_POST['name'],$_POST['kategorie'])");
}
$sys='';
$son='';

global $vbulletin;

$items = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "linklist where kategorie = 'sys'");
while ($item = $vbulletin->db->fetch_array($items))
{
$sys.='<tr class="alt1"><td>'. $item['name'] .'</td><td><a target="_blank" href="'.$item['link'].'">'.$item['link'].'</a></td><td width="24px"><img src="images/bgold/buttons/report.gif" alt="melden" title="melden"></td>';
}
$vbulletin->db->free_result($items);

$items = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "linklist where kategorie = 'son'");
while ($item = $vbulletin->db->fetch_array($items))
{
$son.='<tr class="alt1"><td>'. $item['name'] .'</td><td><a target="_blank" href="'.$item['link'].'">'.$item['link'].'</a></td><td width="24px"><img src="images/bgold/buttons/report.gif" alt="melden" title="melden"></td>';
}
$vbulletin->db->free_result($items);

eval('print_output("' . fetch_template('linkliste') . '");');

?>

amykhar

05-23-2006, 10:50 AM

I'm not seeing an error, but my German isn't great. I'm going to bow out and let somebody who understands your page content help out.