vb.org Archive - View Single Post - Tried and failed adding php code to a custom page.

vietfancy · #1 03-26-2008, 07:35 PM

I tried and failed to add some php code to a custom page.

Would anyone help? is there a better way to do this?

here is what i wanna add to a custom page:

PHP Code:


			
<?php include("scripts/database.php"); ?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">



<html xmlns="http://www.w3.org/1999/xhtml">





<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />



<title></title>

<style>



</style>

</head>









<body>

<?php

    if ($_REQUEST['success'] == "added"){

        echo "<h1>news added, waiting on Admin approval</h1>";

    }

?>

<a href="addnews.php">Add news</a><br />

<a href="admin/news.php">Admin<a/><br /><br /><br /><br />







<?php

    //to dsiplay the news

    $q = mysql_query("SELECT * FROM news WHERE live = 1")or die(mysql_error());

    $c = mysql_num_rows($q);

    

    if ($c == 0){

        echo "no newss in database";

    }else{

        $tC = rand(0, $c-1);

            

        mysql_data_seek($q, $tC);

        $r = mysql_fetch_assoc($q);

        $id = $r['id'];

        $originalString = "<b>".$r['word']."</b><br />"; 

        $upperCase = strtoupper($originalString);

        echo "$upperCase";

        

        

        list($c1, $c2, $c3, $c4, $c5) = unserialize($r['clues']);

        $originalString = $c1."<br />".$c2."<br />".$c3."<br />".$c4."<br />".$c5."<br />";

        $upperCase = strtoupper($originalString);

        echo "$upperCase";



    }

?>

<br /><br />

<?php

    echo "We currently have $c cards in the database\n";

?>



<br /><br /><br />

<form action="scripts/rate.php" method="POST">

    <input type="radio" name="rating" value="1" checked /> 1  

    <input type="radio" name="rating" value="2" /> 2  

    <input type="radio" name="rating" value="3" /> 3  

    <input type="radio" name="rating" value="4" /> 4  

    <input type="radio" name="rating" value="5" /> 5  

    <input type="hidden" value="<?=$id; ?>" name="id" />

    <input type="submit" name="submit" value="Rate Me" />

</form>

<br /><br /><br />

<?php

    $qRate = mysql_query("SELECT * FROM rating WHERE newsId = $id")or die(mysql_error());

    $cRate = mysql_num_rows($qRate);

    $total = 0;

    if ($cRate == 0){

        echo "this card has not been rated yet";

    }else{

        while ($rRate = mysql_fetch_assoc($qRate)){

            $total += $rRate['rating'];

        }

        $total = $total/$cRate;

        

        echo "Score is ".round($total, 2)." from $cRate votes";

    }    

?>

<br /><br />





</body>

</html>

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01280 seconds Memory Usage 1,810KB 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: