Learn VBA & Macros in 1 Week!

PHP - Adding A <form> In A Loop Duplaicate Data Going Into Database.

Full Excel VBA Course - Beginner to Expert

Adding A <form> In A Loop Duplaicate Data Going Into Database.	View Content

So i have an event page where it will show the next 3 events, then i need logged in users to click either of two buttons to say there attending or not attending.

i have the below code showing events, and the <form> and the submit and both buttons, but if i submit 1 button on event ID: 1 it inserts data into the database but for event ID: 2, and if i click the button on event ID :2 it also puts it into database with eventid:2

so no matter which event i click it seems to submit data with the latest event ID shown on page, and not for "each" event seperatly.

i have moved the submit query everywhere around and still same results or duplicate results if its in the loop.

i assume its looping the submit and only submitting the latests event ID.

<?php
if ($result = $con->query("SELECT * FROM events ORDER BY id ASC LIMIT 3")) {
if ($result->num_rows > 0) {
while ($row = $result->fetch_object()) {
$event_id = $row->id;
// set up table and echo data!
echo "<table border='1' cellpadding='2' width='50%'>";
echo "<tr><td>";
echo "<p><img src='images/raid_banners/" . $row->bannerimg . "'>" . $row->name . " (iLvl: " . $row->itemlevel . ")</p>";
echo "<p>Event Starts: " . $row->datestart . " - " . $row->timestart . "</p>";
echo "<p>Event Ends: " . $row->dateend . " - " . $row->timeend . "</p>";
echo "<p>Raid Lead: " . $row->raidlead . "</p>";
echo "<form action='' name='$event_id' method='post'>";
// Process and populate SELECT form element
echo "<select name=\"charname\">";
$sql = mysqli_query($con, "SELECT * FROM characters WHERE userid = $userid");
while ($row = $sql->fetch_assoc()){ echo "<option value=\"{$row['id']}\">{$row['charname']}</option>"; }
echo "</select>";
echo "<input type='hidden' name='raidid' value ='$event_id'>";
echo "<input type='hidden' name='action' value='submit' />";
echo "<input type=\"submit\" name=\"submit\" value=\"going\">";
echo "<input type=\"submit\" name=\"submit\" value=\"notgoing\">";
echo "</form></td></tr></table><br><br>"; 
 } 
 if(isset($_POST['action'])){
$charid = $_POST['charname'];
$submit = $_POST['submit'];
// Submit the data from dropdown in the form
mysqli_query($con,"INSERT INTO eventsignup (eventid, charid, userid, status) VALUES ('$event_id', '$charid', '$userid', '$submit')");  } 
}
else { echo "No results to display!"; } }
else { echo "Error: " . $con->error; }
$con->close();
?>

View Content

I almost have it but I am missing something. The form is being sent and the row is being created but there is not data. It is blank. I know it is something simple I am missing but I cannot figure it out If anyone can look at my code below and tell me what I am missing to make the inputed info be seen, I would sure appreciate it.

<?php

include_once('class/class_email.php');

// contact to database
$connect = mysql_connect("localhost", "admin", "password") or die ("Error , check your server connection.");

mysql_select_db("database");

$fname = $_POST['fname'];
$lname = $_POST['lname'];
$email = $_POST['email'];
$company = $_POST['company'];
$telephone = $_POST['telephone'];
$comments = $_POST['comments'];
$EID = $_POST['eid'];
extract ($_POST);

// Pick up the form data and assign it to variables
// 
$id = intval($id);
$fname = strip_tags($fname);
$lname = strip_tags($lname);
$email = strip_tags($email);
$company = strip_tags($company);
$telephone = intval($telephone); 


$query="INSERT INTO users(`id`, `fname`, `lname`, `email`,`company`,`telephone`) VALUES('$id','$fname','$lname','$email','$company','$telephone')";

echo $query;

mysql_query($query)  or die(mysql_error());
echo mysql_error();

$SQL_GetEquipment = "SELECT * FROM `new_equip` WHERE `id`='$EID' LIMIT 1;";
$result = mysqli_query($connect,$SQL_GetEquipment);
$row = mysqli_fetch_assoc($result);
$EmailBody = "$fname $lname has requested a quote from NAPE on Item $EID\n 

Information on quote request: \n
Name: $fname $lname \n
Email: $email \n
Company: $company \n
Number: $telephone  \n 
Comments: $comments  \n 
\n
Information Requested for: {$row['itemname']}\n
The URL to {$row['itemname']} is: http://www.mydomain.com.com/new-product.php?Item=$EID
\n
Click to send a quote now:\n
http://www.mydomain.com.com/Admin/send-quote.php?id=$EID ";

$e = new email();

//First value is the URL of your server, the second the port number
$e->set_server( 'mail.mydomain.com.com', 26);

//First value is your username, then your password
$e->set_auth('noreply@mydomain.com', '112233');

//Set the "From" setting for your e-mail. The Name will be base64 encoded
$e->set_sender( 'Quote Requested', 'noreply@mydomain.com' );

//for one recipient
//$send_to = array('myemail@mydomain.com','myemail2@mydomain.com');
$send_to = ('myemail@gmail.com');
//you may also specify multiple recipients by creating an array like this:
//$send_to = array('foo1@localhost.local', 'foo2@localhost.local', 'foo3@localhost.local');


$subject = 'Quote Request from NAPE';
$body = "$EmailBody";
if( $e->mail($send_to, $subject, $body, $headers) == true )
{
  //message was received by the smtp server
  //['last'] tends to contain the queue id so I like to save that string in the database
  echo 'last: '.htmlspecialchars($e->srv_ret['last']).'';
}else{
  //something went wrong
  echo 'all: '.nl2br(htmlspecialchars($e->srv_ret['all'])).'';
  echo 'full:'.nl2br(htmlspecialchars($e->srv_ret['full'])).'';
}

?>

Insertng Data From A Form Into A Mysql Database

Similar Tutorials

View Content

I am having difficulty inserting the following codes values into my database. I know that the variables contain a value as I am displaying them on the output screen.

Code: [Select]
$link = mysql_connect($db_host,$db_user,$db_pass) or die('Unable to establish a DB connection');

mysql_select_db($db_database,$link);
mysql_query("SET names UTF8");
$usr = $userid;
$golfer = $_REQUEST['golfer'];
$tourney = $_REQUEST['tournament'];
$backup = $_REQUEST['backup'];
date_default_timezone_set('US/Eastern');
$time = date("Y-m-d H:i:s");
$t_id=1;

mysql_query("INSERT INTO weekly_picks (t_id, tournament, user, player, backup, timestamp) VALUES ('$t_id', '$tournament', '$usr', '$golfer', '$backup', '$time') or die('Error, insert query failed')");

echo $t_id; echo "<br />";
echo $tourney; echo "<br />";
echo $usr; echo "<br />";
echo $golfer; echo "<br />";
echo $backup; echo "<br />";
echo $time; echo "<br />";
echo $userdetail['email']; echo "<br />";

$to = $userdetail['email'];
$subject = "Weekly Tournament Pick for: $tourney";
$message = "This email is to confirm your pick for $tourney has been received.
Your pick is: $golfer.
Your backup pick is: $backup
The time it was submitted was $time
Do not reply to this email, the mailbox does not exist.
Contact me with any issues at xxxxxxx@xxxxxxx.com";

$from = "noreply@chubstersgcc.com";
$headers = "From:" . $from;
mail($to,$subject,$message,$headers);
?>

<div>
<p>This is to confirm that your pick has been submitted for the following tournament: <?php echo $tourney; ?>. A confirmation of your pick as also been emailed to you.</p>
<p>Your golfer: <?php echo $golfer; ?></p>
<p>Your backup: <?php echo $backup; ?></p>
<p>Your pick was submitted at: <?php echo $time; ?></p>
</div>

Please Help With Inserting Data Into The Database (using Html Form)

Similar Tutorials

View Content

Lets say I have this database:

table brand [brandID] [brandName] where brandID -> auto increment and one brand always has the same brandID
table product [brandID] [productID] [price] where productID -> auto increment

I want to insert new product into the database using only values [brandName] and [price]
and want brandID and productID to be created automatically

I use this form:

<form id="insertingDataToBrand" action="administratorCode.php" method="post">
<div>Brand Name: <input type="text" name="brandName"/></div>
<div>Price: <input type="text" name="price"/></div>
</form>

And here is the php code:

<?php
   //connection to database
   include 'connectToDatabase.php';

   //data retrieveing
   $brand = $_POST['brandName'];
   $price = $_POST['price'];

   //As I am inserting to two different tables I use two INSERT statements
   $sql = "INSERT INTO brand (brandName) values ('$brand')";

   mysql_query($sql) or die (mysql_error());

   //as brandID is created automatically I am going to insert the same value to another table
   $last_id = mysql_insert_id ();

   $sql = "INSERT INTO product (price, brandID) values ('$price', '$last_id')";

?>

This should work just fine (it doesnt tho) BUT my question is:

I have 3 different brands (brand A with brandID 1, brand B with brandID 2, brand C with brandID 3).
When want to insert brand D, automatically created brandID should be automatically set to 4. BUT
when I want to insert product of the same brand, lets say brand A (with different productID) brandID is automatically set to 4(or higher) as well.

What do I have to do(use) so it would be able to realise what brandID should be added?

Thanks a lot.

Form Data Not Being Entered Into Mysql Database

Similar Tutorials

View Content

I have deleted mysql info for safety reasons.

Here are the two webpage's codes i'm using right now

menu.php
<?
session_start();
if(!session_is_registered(myusername)){
header("location:login.php");
}

?>

<html><title>ChronoServe - Saving Time</title>
<link href="style.css" rel="stylesheet" type="text/css">
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="container">
  <tr>
    <td>
    <table width="335px" height="50%" border="1" align="center" cellpadding="0" cellspacing="0" class="centered">
      <tr>
        <td>
              <form method="post" action="insertvalues.php">
        <table width="100%" border="0" align="center" cellpadding="3" cellspacing="10">
      <tr>
        <td colspan="2"><div align="center" class="font2">Activation Information</div></td>
      </tr>
      <tr>
        <td colspan="2"></td>
      </tr>
      <tr>
        <td width="40%" class="font3">First Name :</td>
        <td width="60%">          <div align="center">
            <input name="firstname" type="text" class="font3" id="firstname" maxlength="25" />
            </div></td>
      </tr>
      <tr>
        <td class="font3">Last Name :</td>
        <td>          <div align="center">
            <input name="lastname" type="text" class="font3" id="lastname" maxlength="25" />
            </div></td>
      </tr>
      <tr>
        <td height="28" class="font3">Phone Number :</td>
        <td>          <div align="center">
            <input name="pnumber" type="text" class="font3" id="pnumber" maxlength="10" />
            </div></td>
      </tr>
      <tr>
        <td class="font3">Personnel Activated :</td>
        <td>          <div align="center">
            <input name="numberactivated" type="text" class="font3" id="numberactivated" maxlength="3" />
            </div></td>
      </tr>
      <tr>
        <td height="37" colspan="2"></td>
      </tr>
      <tr>
        <td colspan="2"><div align="center">
          <input name="submit" type="Submit" class="font3" value="Submit" />
        </div>
       </td>
      </tr>
    </table>
     </form></td>
      </tr>
    </table>
    </td>
  </tr>
</table>
</body>
</html>

insertvalues.php
<?php
if(isset($_POST['Submit']))
{
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$pnumber = $_POST['pnumber'];
$numberactivated = $_POST['numberactivated'];

mysql_connect ("deleted", "deleted", "deleted") or die ('Error: ' . mysql_error());
mysql_select_db ("deleted");

$query = "INSERT INTO disney_database (id, firstname, lastname, pnumber, numberactivated, date) VALUES ('NULL', '".$firstname."', '".$lastname."', '".$pnumber."', '".$numberactivated."', 'NULL')";

mysql_query($query) or die('Error updating database');
header("location:menu.php");
echo "Database Updated With: ".$firstname."" - "".$lastname."" - "".$pnumber."" - "".$numberactivated."";
}
else {
echo "Database Error"
{
?>

Here is my problem. I set a one <form> on every form field I have including the submit button. Now whenever I press the submit button it redirects to insertvalues.php which it should be doing. In insertvalues i told it to query the form data and post it into my database's table. Its not doing that and tells me that it has a database error which i set it to tell me if something goes wrong. Anyone can help me? BTW I can manually query in the information using sql with phpmyadmin.

so can someone please review my code for me? thanks big help!

You can see what is happening.
Visit www.chronoserve.com

The username and password are "admin"

Updating Data Not Populating From Database On To Form

Similar Tutorials

View Content

Hi I making some forms that write to mysql database, Im now in the process of making the update form so the user can update there details on the form, I want it to populate the form with existing data but its not doing it at all. Thanks in advance Attached Files delete.php 210bytes 2 downloads modify.php 4.03KB 4 downloads index.php 473bytes 3 downloads

Display Data From Database In Table Form

Similar Tutorials

View Content

how i want to display data from database to look like this :

<table width="633" height="224" border="1">
<tr bgcolor="#999900">
<td width="45">Bil</td>
<td width="121">Course_name</td>
<td width="83">session</td>
<td width="83">start_date</td>
<td width="83">end_date</td>
<td width="83">notes</td>
<td width="89">pre-req</td>
</tr>
<tr bgcolor="#6A7AEA">
<td rowspan="2">1.</td>
<td rowspan="2" bgcolor="#6A7AEA">Math</td>
<td>1st session </td>
<td>1 jan 11 </td>
<td>6 jan 11 </td>
<td rowspan="2"> </td>
<td rowspan="2"><image icon that will link to the oter site> </td>
</tr>
<tr>
<td bgcolor="#6A7AEA">2nd session </td>
<td bgcolor="#6A7AEA">8 jan 11 </td>
<td bgcolor="#6A7AEA">15 jan 11 </td>
</tr>
<tr>
<td bgcolor="#0066CC">2.</td>
<td bgcolor="#0066CC">English</td>
<td bgcolor="#0066CC">1st session </td>
<td bgcolor="#0066CC">1 feb 11 </td>
<td bgcolor="#0066CC">6 feb 11 </td>
<td bgcolor="#0066CC"> </td>
<td bgcolor="#0066CC"><image icon that will link to the oter site></td>
</tr>
<tr>
<td rowspan="2" bgcolor="#6A7AEA">3.</td>
<td rowspan="2" bgcolor="#6A7AEA">Science</td>
<td height="29" bgcolor="#6A7AEA">1st session </td>
<td bgcolor="#6A7AEA">8 march 11 </td>
<td bgcolor="#6A7AEA">15 march 11 </td>
<td rowspan="2" bgcolor="#6A7AEA"> </td>
<td rowspan="2" bgcolor="#6A7AEA"><image icon that will link to the oter site></td>
</tr>
<tr>
<td bgcolor="#6A7AEA">2nd session</td>
<td bgcolor="#6A7AEA">16 march 11 </td>
<td bgcolor="#6A7AEA">21 march 11 </td>
</tr>
</table>

** all the view data is called from database including the icon image
thanks...