vb.org Archive - View Single Post

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01075 seconds Memory Usage 1,781KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post 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 showpost_complete
Messages: