vb.org Archive - writing things to database

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - writing things to database (https://vborg.vbsupport.ru/showthread.php?t=116444)

writing things to database

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:

Code:

$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,&sect;,...

         </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 :

PHP Code:


		
			
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

from a form, you will need to read in the _POST variables. So, change the

Code:

$post[$url]

Code:

$_POST['url']

for example and give that a shot. :)

Amy

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 Code:


		
			
<?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') . '");'); 



?>

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.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01109 seconds Memory Usage 1,757KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: