Petition

[Oni]

Whats a code for creating a petition kind of thing where people add there names to it. Im assuming it will be php and i preferably dont want to dl anything. Thanks.

[Drompo]

You'd need a mysql database and a few statments.
to add a name to the list.

<?php
$con = mysql_connect("localhost","DATABASE USERNAME","DATABASE PASS");
if (!$con)
{
die('Could not connect: ' . mysql_error());
} mysql_select_db("DATABASE NAME", $con); mysql_query("INSERT INTO pertition (FirstName, LastName)
VALUES ('$firstname', '$lastname')") or die ("Could not insert");
echo "Thank you, Your name has been added to the pertition";
echo "<form method='post' action='$PHP_SELF?action=add'>

<table border=\"0\" cellpadding=\"2\" cellspacing=\"5\">

<tr><td><font face=\"Verdana\" size=\"1\"><b>First Name:</b></td><td><font face=\"Verdana\" size=\"1\"><input type=\"text\" name=\"firstname\" size=\"20\"></td></tr>

<tr><td><font face=\"Verdana\" size=\"1\"><b>Last Name:</b></td><td><font face=\"Verdana\" size=\"1\"><input type=\"text\" name=\"lastname\" size=\"20\"></td></tr>
<tr><td></td><td><input type='submit' name='submit' value='Apply!'></td></tr>
</form>";

?>

To View the pertition

<?php
// Make a MySQL Connection
mysql_connect("localhost", "DATABASE USERNAME", "DATABASE PASS") or die(mysql_error());
mysql_select_db("DATABASE NAME") or die(mysql_error());

// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM pertition")
or die(mysql_error());

echo "<table border='1'>";
echo "<tr> <th>First Name</th> <th>Last Name</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['firstname'];
echo "</td><td>";
echo $row['lastname'];
echo "</td></tr>";

}

echo "</table>";
?>

[Oni]

Thanks! :eusa_danc +rep

[Mentor]

o.0 from what i can tell the mysql table structure to go with that is a table name
'pertition' containing two rows "FirstName" and "LastName" (most likly varchar 255, or possibly text, although that would be a bit of a waste in this instance), although for a vertual petition to hold weight you do also need to record the ip, and a comments also nice.

Plus unless someone injecting some code in to the mysql is a plan, some validation of the inputs, how ever tiny, probably wouldnt go amiss "/

[Oni]

grrrr it isnt working

[Drompo]

Try
Add.php

<?php
$con = mysql_connect("localhost","DATABASE USERNAME","DATABASE PASS");
if (!$con)
{
die('Could not connect: ' . mysql_error());
} mysql_select_db("DATABASE NAME", $con);
if($action == "add") {

$add = mysql_query("INSERT INTO `pertition` ( `firstname`, `lastname`) VALUES ('$firstname', '$lastname')");

echo "Your name has been added to the pertition";

} else {

echo "<form method='post' action='$PHP_SELF?action=add'>

<table border=\"0\" cellpadding=\"2\" cellspacing=\"5\">

<tr><td><font face=\"Verdana\" size=\"1\"><b>First Name:</b></td><td><font face=\"Verdana\" size=\"1\"><input type=\"text\" name=\"firstname\" size=\"20\"></td></tr>

<tr><td><font face=\"Verdana\" size=\"1\"><b>Last Name:</b></td><td><font face=\"Verdana\" size=\"1\"><input type=\"text\" name=\"lastname\" size=\"20\"></td></tr>
<tr><td></td><td><input type='submit' name='submit' value='Apply!'></td></tr>
</form>";
}

?>
View.php

<?php
// Make a MySQL Connection
mysql_connect("localhost", "DATABASE USERNAME, "DATABASE PASS") or die(mysql_error());
mysql_select_db("DATABASE NAME) or die(mysql_error());

// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM pertition")
or die(mysql_error());

echo "<table border='1'>";
echo "<tr> <th>First Name</th> <th>Last Name</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['firstname'];
echo "</td><td>";
echo $row['lastname'];
echo "</td></tr>";

}

echo "</table>";
?>
MySQL

--
-- Table structure for table `pertition`
--

CREATE TABLE `pertition` (
`id` int(11) NOT NULL auto_increment,
`firstname` varchar(50) NOT NULL default '',
`lastname` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `pertition`
--