The Arcive of vBulletin Modifications Site.

ragtek · #1 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:

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

amykhar · #2 05-23-2006, 10:00 AM

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

Code:

$post[$url]

to

Code:

$_POST['url']

for example and give that a shot.

Amy

ragtek · #3 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 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') . '");'); 



?>

amykhar · #4 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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05784 seconds Memory Usage 4,694KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (3)bbcode_code (2)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (4)post_thanks_box (4)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (4)post_thanks_postbit_info (4)postbit (4)postbit_onlinestatus (4)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages: