The Arcive of Official vBulletin Modifications Site.

Dean C · #1 04-07-2003, 08:27 AM

Ok well its taken me about a week to get the layout coded up for my new site and i have the news intigrated succesfully. I'm proud of myself

Well currently the news has to be added manually through the db so i tried writing a script to add the news through a page quickly and easily.

Here is what i have:

PHP Code:


			
<html>

<head><title>Add News</title></head>

<body>

<?php



$form = "<form action=\"$PHP_SELF\" method\"post\">";

$form .= "<b>Title</b>";

$form .= "<input type=\"text\" name=\"title\" size=\"50\" value=\"$title\"><br />";

$form .= "Content:<br /> <textarea name=\"content\" cols =\"45\" rows=\"4\">$comments</textarea><br />";

$form .= "<input type=\"submit\" name=\"submit\" value =\"submit\"></form>";



if (!$submit) {

    $msg = $form;

} else if (!$title or !$content) {

  $msg = "<b>Please complete all fields</b><br /><br />";

  $msg .= $form;

} else if ($submit and $content and $title) {

   $conn = @msql_connect("localhost","root","mist") or die("Could not connect to db");

   $rs = @mysql_select_db("designdevise",$conn) or die ("Could not select db");

   $sql = "insert into news (title,content) values (\"$title\",\"$content\")";

   $query = @mysql_query($sql,$conn) or die("Could not execute query");

       if($query)

       {

       $msg = "News added";

       }

}



echo($msg);



?>

</body>

</html>

Now its just not working right. The page loads. But when i click submit to post the news it doesn't come up with the message that the news has been added or it could not execute the query. It's just a blank page. I'm sure this is such an easy problem to fix if someone could point me in the right direction

Regards

- miSt

mr e · #2 04-07-2003, 04:33 PM

try this, not sure if it'll work, but i rewrote some of it

PHP Code:


			
<html>

<head><title>Add News</title></head>

<body>

<?php



$form = "<form action=\"$PHP_SELF\" method\"post\">";

$form .= "<b>Title</b>";

$form .= "<input type=\"text\" name=\"title\" size=\"50\" value=\"\"><br />";

$form .= "Content:<br /> <textarea name=\"content\" cols =\"45\" rows=\"4\"></textarea><br />";

$form .= "<input type=\"submit\" name=\"submit\" value =\"submit\"></form>";



if (!$_POST['submit']) {

    $msg = $form;

} else if (empty($_POST['title']) or empty($_POST['content'])) {

  $msg = '<b>Please complete all fields</b><br /><br />';

  $msg .= $form;

} else if ($_POST['submit'] and $_POST['content'] and $_POST['title']) {

   $conn = @msql_connect("localhost","root","mist") or die("Could not connect to db");

   $rs = @mysql_select_db("designdevise",$conn) or die ("Could not select db");

   $sql = "insert into news (title,content) values (\"$title\",\"$content\")";

   $query = @mysql_query($sql,$conn) or die("Could not execute query");

       if($query)

       {

       $msg = "News added";

       }

}



echo($msg);



?>

</body>

</html>

Dean C · #3 04-07-2003, 05:43 PM

Thankyou mr e but someone already helped me out - i knew it was something off because with out the global post var it added the fields into the url which i did not want

Stupid PHP reference book

- miSt

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03438 seconds Memory Usage 2,202KB Queries Executed 13 (?)
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 (2)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (3)post_thanks_box (3)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (3)post_thanks_postbit_info (3)postbit (3)postbit_onlinestatus (3)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:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!