radio buttons????

GPC

trying to make a "User report" page.. and it has 3 radio buttons.. my code so far is..

<html>
<head>
<style type="text/css">
@import"TCP.css";
</style>
</head>
<body>

<center>
<form action='' method='post'>
<table border='1' cellspacing='0' cellpadding='3' bgcolor='737373' style='border-color:White;border-collapse:collapse;'>
<tr>
<td class='header' align='center'><font style="font-size: 8pt; color: Orange;"><b>Player Report</b></font></td>
</tr>

<tr>
<td align='center'><font style="font-size: 8pt; color: Orange;"><b>See moderators directly for all other issues!</b></font> <font style="font-size: 9pt; color: white;"><br><input type="radio" name="report" value="1"> Idea <input type="radio" name="report" value="2"> Bug <input type="radio" name="report" value="3"> Exploit
</td>
</tr>

<tr>
<td align='center'><font style="font-size: 9pt; color: white;">Issue Message:</font><br> <textarea cols=60 rows=5 name=themessage></textarea><br><input type=submit name=submitnews value='Report It!'><br></td>
</tr>
</table>
</form></div></div><br>

<?php
require( 'MySQL.php');
?>
</center>
<?php
if ($submitnews) {

require("MySQL.php");
mysql_connect($host,$username,$password);
mysql_select_db($mysqldatabase);

$date = date("jS F Y - h:i A");

$title = htmlspecialchars($title, ENT_QUOTES);
$themessage = htmlspecialchars($themessage, ENT_QUOTES);
$by = htmlspecialchars($by, ENT_QUOTES);

$themessage = str_replace("\n", "<br>", $themessage);

$sql = "INSERT INTO player_report (date, message, issue, username) VALUES ('$date', '$themessage', '$title', '$by')";

mysql_query($sql);

}
?>

my question is.. how do i do if statements so that it goes into the database as either 1,2 or 3 - (the result will be put into 'issue' in the database). thanks

dalecosp

Well, as a general rule of thumb during writing and debugging, when I POST a form, I put these lines of code in the handler:

print_r($_POST);
exit;

... and then I can see what variables I'll need to process.

(hint, hint).

And, welcome to PHPBuilder!

RyanJones

From the code you posted there all you would need to use is $_POST['report'] to retrieve the value 🙂

Cheers,

Ryan Jones

Houdini

$sql = "INSERT INTO `player_report` (`date`, `message`, `issue`, `username`) VALUES ('$date', '$themessage', '$report', '$by')";