vb.org Archive - View Single Post

chilllax · #5 04-15-2006, 06:45 PM

It still will not work. I changed the original value of $query to what you told me to. I substituted the column names for the fieldnames, is that correct?ffa is the name of my table. Also when I try and run this script it brings up this error
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/chilllax/public_html/tournament/yourentry.php on line 40

If you need me to I can also post the code of the forms.

PHP Code:


			
<html>

<head>

<title>Your Entry</title>

</head>

<table align="center">

 <tr>

  <td>

<a href="http://www.officalhalo.com">Home</a> | 



<a href="/tournament/FFA.htm">FFA</a> |



<a href="/tournament/signup.htm">Sign Up</a> |



<a href="/tournament/results.htm">Results</a>

</td>

 </tr>

</table>

<body>

<h3 align="center">Your Entry</h3>

<?php

  $gamertag=$_POST['gamertag'];

  $eaddress=$_POST['eaddress'];

  

  if (!$gamertag || !$eaddress)

  {

      echo 'You have not entered all of the required information.<br />'

           .'Please go back and try again.';

      exit;

  }



  @ $db = new mysqli('localhost', 'chilllax_chillla', 'red123', 'chilllax_tournament');

  

if (mysqli_connect_errno())

{

    echo 'Error: Could not connect to database. Please try again later.';

    exit;

}



$query = "INSERT INTO " . TABLE_PREFIX ." ffa (gamertag, eaddress)

              VALUES ("' $gamertag . '", "' . $eaddress . '")";  



$result = $db->query($query);

if ($result)

    echo $db->affected_rows.' Entry submitted into database.';

        

$db->close();



?>

</body>

</html>

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