PHP - Record Form Data?

Here is video and there is shown how specific this problem is
http://faksx.sytes.net/help/

Solutions Witch doesn't fit in for this time is meta refresh,header(),exit(),die() .

I am trying to set up a item entry page form.png:

Upon submission it shows unsuccessful even though I have checked the fields on mysql table and seem to be good am I missing something?

Code: [Select]
<form action="" method="post" enctype="multipart/form-data" name="Product_Entry">
<TABLE>
<TR>
<TD>Product ID</TD><TD><input name="SKU_ProductID" value="<?php if (isset($_post['SKU_ProductID'])) echo $_POST['SKU_ProductID']; ?>" type="text" size="11" maxlength="11" /></TD>
</TR>
<TR>
<TD>Merchant SKU ID</TD><TD><input name="SKU_MerchSKUID" value="<?php if (isset($_post['SKU_MerchSKUID'])) echo $_POST['SKU_MerchSKUID']; ?>" type="text" size="18" maxlength="30" /></TD>
</TR>
<TR>
<TD>Game Title</TD><TD><input name="Game_Title" value="<?php if (isset($_post['Game_Title'])) echo $_POST['Game_Title']; ?>" type="text" size="40" maxlength="40" /></TD>
</TR>
<TR>
<TD>Platform</TD><TD><input name="Platform" value="<?php if (isset($_post['Platform'])) echo $_POST['Platform']; ?>" type="text" size="20" maxlength="20" /></TD>
</TR>
<TR>
<TD>Genre</TD><TD><input name="Genre" value="<?php if (isset($_post['Genre'])) echo $_POST['Genre']; ?>" type="text" size="11" maxlength="11" /></TD>
</TR>
<TR>
<TD>Weight</TD><TD><input name="Weight" value="<?php if (isset($_post['Weight'])) echo $_POST['Weight']; ?>" type="text" size="7" maxlength="7" /></TD>
</TR>
<TR>
<TD>Supplier</TD><TD><input name="Supplier" Value="<?php if (isset($_post['Supplier'])) echo $_POST['Supplier']; ?>" type="text" size="25" maxlength="25" /></TD>
</TR>
<TR>
<TD>Suppliers Price</TD><TD><input name="Supplier_Price" value="<?php if (isset($_post['Supplier_Price'])) echo $_POST['Supplier_Price']; ?>" type="text" size="10" maxlength="12" /></TD>
</TR>
<TR>
<TD>Cashback</TD><TD><input name="Cashback" value="<?php if (isset($_post['Cashback'])) echo $_POST['Cashback']; ?>" type="text" size="6" maxlength="8" /></TD>
</TR>
<TR>
<TD>Cashback Amount</TD><TD><input name="Cashback_Amount" value="<?php if (isset($_post['Cashback_Amount'])) echo $_POST['Cashback_Amount']; ?>" type="text" size="7" maxlength="11" /></TD>
</TR>
<TR>
<TD><input type="hidden" name="submitted" value="true"/></TD><TD><input name="Submit" type="submit" value="Add_Product" /></TD>
</TR></form></TABLE>

<?php # Product Entry

$page_title = 'Product Entry';

if (isset($_POST['Submit'])) {

$errors = array();

if (empty($_POST['SKU_ProductID'])) {
$errors[] = 'Please enter Product ID.';
} else {
$sid = trim($_POST['SKU_ProductID']);
}

if (empty($_POST['SKU_MerchSKUID'])) {
$errors[] = 'Please enter Merchant SKU.';
} else {
$mid = trim($_POST['SKU_MerchSKUID']);
}

if (empty($_POST['Game_Title'])) {
$errors[] = 'Please enter Game Title.';
} else {
$gt = trim($_POST['Game_Title']);
}

if (empty($_POST['Platform'])) {
$errors[] = 'Please enter Platform.';
} else {
$pl = trim($_POST['Platform']);
}

if (empty($_POST['Genre'])) {
$errors[] = 'Please enter Genre.';
} else {
$ge = trim($_POST['Genre']);
}

if (empty($_POST['Weight'])) {
$errors[] = 'Please enter Weight.';
} else {
$we = trim($_POST['Weight']);
}

if (empty($_POST['Supplier'])) {
$errors[] = 'Please enter Supplier.';
} else {
$sup = trim($_POST['Supplier']);
}

if (empty($_POST['Supplier_Price'])) {
$errors[] = 'Please enter Supplier Price.';
} else {
$sp = trim($_POST['Supplier_Price']);
}

if (empty($_POST['Cashback'])) {
$errors[] = 'Please enter Cashback %.';
} else {
$cb = trim($_POST['Cashback']);
}

if (empty($_POST['Cashback_Amount'])) {
$errors[] = 'Please enter Cashback Amount.';
} else {
$cba = trim($_POST['Cashback_Amount']);
}

if (empty($errors)) {

require_once ('connect.php');

[b]$q = "INSERT INTO `Products` (`SKU_ProductID`, `SKU_MerchSKUID`, `Game_Title`, `Platform`, `Genre`, `Weight`, `Supplier`, `Supplier_Price`, `Cashback`, `Cashback_Amount`) VALUES ('$sid', '$mid', '$gt', '$pl', '$ge', '$we', '$sup', '$sp', '$cb', '$cba')";
$r = @mysql_query ($dbc, $q);

if ($r) { // If it ran OK.

// Print a message:
echo '<h1>Thank you!</h1>
<p>Product Inserted!</p><p><br /></p>';

} else { // If it did not run OK.

// Public message:
echo '<h1>System Error</h1>
<p class="error">You could not be registered due to a system error. We apologize for any inconvenience.</p>'; 

// Debugging message:
echo '<p>' . mysqli_error($dbc) . '<br /><br />Query: ' . $q . '</p>';

} // End of if ($r) IF.

mysqli_close($dbc); // Close the database connection.[/b]
// Include the footer and quit the script:
include ('includes/footer.html'); 
exit();

} else {

echo '<H1>Error!</H1>
<p class="error">The Following error(s) occurred:<br />';

foreach ($errors as $msg) {

echo " - $msg<br />\n";
}

echo '</p><p>Please try again.</p><p><br /></p>';

}

}

?>
If there is anything else needed let me know

Am new here - looks like a great foru!

I would sincerely appreciate any help anyone can give me. I have been
trying to solve my problem for hours and I am not having any luck, so I
thought I would post and see if anyone can help. I am very stuck and am
not making much progress on this project, and I am certain the answer is
very simple.

I am constructing a form to collect data for a specialized purpose. 

The form and program actually work for its intended function, but I am
trying to enhance the user experience by preventing customers from
having to reenter all of their data should there be a problem with any
of the data submitted.

I have been able to do that with the contact form portion, but what I am
having trouble with is the portion which has as many as 400 possible
entries.

So, in a nutshell, if the customers contact data is incomplete or in
error, the form will ask them to return to the page and correct things.
The previous data entered has been saved in the session and the input
value will equal the previous entry.

i.e.

<tr>
  <td align="right" class="infoBox"><?php echo ENTRY_EMAIL_ADDRESS; ?></td>
  <td align=left><?php echo "<input type=text name='cemail' value=\"$cemail\" size=35 maxlength=35>" ?></td>
</tr>

Works perfectly, all well and good there.

On the other 400 more or less entries, I am having a difficult time
tweaking the string concatenation to work to achieve similar results.

There are 4 columns each with $points entries asking for a dimension in
either feet or inches. 

The <input name=>  is one of ptaf,ptai,ptbf,ptbi, appended programatically with the corresponding
row number or data point.  i.e. "ptaf1", "ptai1", etc...  This is produced by the example
below and works perfectly also.

<?php {
$points=100;
$i=1;
while ($i <= $points)
{echo '
  <tr><td align="center" width="6"><b>  ' .$i . '</b></td>
     <td align="right" NOWRAP>A' .$i . ' (ft) <input type="text" name="ptaf'.$i.'" size=4 maxlength=3> </td>
      <td align="right" NOWRAP>A' .$i . ' (in) <input type="text" name="ptai'.$i.'" size=4 maxlength=4> </td>
     <td align="right" NOWRAP>B' .$i . ' (ft) <input type="text" name="ptbf'.$i.'" size=4 maxlength=3> </td>
      <td align="right" NOWRAP>B' .$i . ' (in) <input type="text" name="ptbi'.$i.'" size=4 maxlength=4> </td>

';

     $i++;
}   
}
?>


I am trying to add <input value=$ptai.$i> for each field but as I mentioned I
am not having any luck.  It seems as if I have tried every combination
imagineable, but still no luck. My head is spinning!

The closest I seem to have gotten was with this:

<td align="right" NOWRAP>A' .$i . ' (ft) <input type="text" size=6 maxlength=3 name="ptaf'.$i.'"  value="' . "$ptaf" . $i . '" ></td>

But line 17 for example returns this:

<input type="text" value="17" name="ptaf17" maxlength="3" size="6">

To recap, I am trying to have the value set to whatever the customer may
have entered previously.

Again, I would most appreciate any help anyone can give me. If you need
 clarification on anything please let me know.

Thanks

AJ

 

Say there is a complex opt in process where people start to enter their data but certain questions stop them where they close out of the page. They already entered their data and I feel there is a way to grab it and post it to mysql even though they do not click submit.   How would this be done?   A super simple example (proof of concept) or a link to a tutorial would be very useful.
Edited by brentman, 23 September 2014 - 10:42 AM.

Hello, I have coded a contact form in PHP and I want to know, if according to you, it is secure! I am new in PHP, so I want some feedback from you.

Moreover, I have also two problems based on the contact form. It is a bit complicated to explain, thus, I will break each of my problem one by one.

FIRST:The first thing I want to know, is if my contact form secure according to you:

The HTML with the PHP codes:

Code: [Select]
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {

//Assigning variables to elements
$first = htmlentities($_POST['first']);
$last = htmlentities($_POST['last']);
$sub = htmlentities($_POST['subject']);
$email = htmlentities($_POST['email']);
$web = htmlentities($_POST['website']);
$heard = htmlentities($_POST['heard']);
$comment = htmlentities($_POST['message']);
$cap = htmlentities($_POST['captcha']);

//Declaring the email address with body content
$to = 'alithebestofall2010@gmail.com';
$body ="First name: '$first' \n\n Last name: '$last' \n\n Subject: '$sub' \n\n Email: '$email' \n\n Website: '$web' \n\n Heard from us: '$heard' \n\n Comments: '$comment'";

//Validate the forms
if (empty($first) || empty($last) || empty($sub) || empty($email) || empty($comment) || empty($cap)) {
echo '<p class="error">Required fields must be filled!</p>';
header ('refresh= 3; url= index.php');
return false;

} 
elseif (filter_var($first, FILTER_VALIDATE_INT) || filter_var($last, FILTER_VALIDATE_INT)) {
echo '<p class="error">You cannot enter a number as either the first or last name!</p>';
return false;
} 
elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
echo '<p class="error">Incorrect email address!</p>';
return false;
}
elseif (!($cap === '12')){
echo '<p class="error">Invalid captcha, try again!</p>';
return false;
}
else {
mail ($to, $sub, $body);
echo '<p class="success">Thank you for contacting us!</p>';
}
}
?>
<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
<p>Your first name: <span class="required">*</span></p>
<p><input type="text" name="first" size="40" placeholder="Ex: Paul"/></p>

<p>Your last name: <span class="required">*</span></p>
<p><input type="text" name="last" size="40" placeholder="Ex: Smith"/></p>

<p>Subject: <span class="required">*</span></p>
<p><input type="text" name="subject" size="40" placeholder="Ex: Contact"/></p>

<p>Your email address: <span class="required">*</span></p>
<p><input type="text" name="email" size="40" placeholder="Ex: example@xxx.com"/></p>

<p>Website:</p>
<p><input type="text" name="website" size="40" placeholder="Ex: http//:google.com"/></p>

<p>Where you have heard us?: <span class="required">*</span></p>
<p><select name="heard">
<option>Internet</option>
<option>Newspapers</option>
<option>Friends or relatives</option>
<option>Others</option>
</select></p>

<p>Your message: <span class="required">*</span></p>
<p><textarea cols="75" rows="20" name="message"></textarea></p>

<p>Are you human? Sum this please: 5 + 7 = ?: <span class="required">*</span></p></p>
<p><input type="text" name="captcha" size="10"/></p>

<p><input type="submit" name="submit" value="Send" class="button"/>
<input type="reset" value="Reset" class="button"/></p>
</form>

SECOND PROBLEM:If a user has made a mistake, he gets the error message so that he can correct! However, when a mistake in the form occurs, all the data the user has entered are disappeared! I want the data to keep appearing so that the user does not start over again to fill the form.

THIRD: When the erro message is displayed to notify the user that he made a mistake when submitting the form, the message is displaying on the top of the page. I want it to appear below each respective field. How to do that? In JQuery it is simple, but in PHP, I am confusing!

There are two pieces to this- The HTML Form and the resulting php. I can't seem to make the leap, from the code to having the form produce the php page so others can view it until the form is again submitted overwriting the php, thus generating new content.

The environment I am working in is limited to IIs 5.1 and php 5.2.17 without mySQL or other DB

I'm new to php, this isn't homework,or commercialization,  it's for children.  I am thinking perhaps fwrite / fread but can't get my head around it.

Code snipets below. Any help, please use portions of this code in hopes I can understand it

Thanks

Code snipet from Output.php
Code: [Select]
<?php
$t1image = $_POST["t1image"];
$t1title = $_POST["t1title"];
$t1info = $_POST["t1info"];
$t2image = $_POST["t2image"];
$t2title = $_POST["t2title"];
$t2info = $_POST["t2info"];
?>
...
<tbody>
    <tr><!--Headers-->
      <td style="vertical-align: top; text-align: center; background-color: rgb(204, 255, 255);">Animal</td>
      <td style="vertical-align: top; text-align: center; background-color: rgb(204, 255, 255);">Image thumb<br>
      </td>
      <td style="vertical-align: top; text-align: center; background-color: rgb(204, 255, 255);">Date<br>
      </td>
      <td style="vertical-align: top; text-align: center; background-color: rgb(204, 255, 255);">Information<br>
      </td>
    </tr>
    <tr>
      <td style="vertical-align: top; text-align: center;">Monkey
      </td>
      <td style="vertical-align: top; text-align: center;"><img src="<?php echo $t1image.'.gif'; ?>"><!--single image presented selected from radio buttons-->
      </td>
      <td style="vertical-align: top; text-align: center;"><?php echo date("m/d/Yh:i A"); ?><!--time stamp generated when submitted form populates all fields at once-->
      </td>
      <td style="vertical-align: top; text-align: center;"><a href="#monkey" rel="facebox"><?php echo $t1title ?></a><!--Link name provided by "Title 1", that links to hidden Div generated page with content from "Info1" field-->
  <div id="Monkey" style="display:none">
<?php echo $t1info; ?>
</div>
      </td>
    </tr>
    <tr>
      <td style="vertical-align: top; text-align: center;">Cat<br>
      </td>
      <td style="vertical-align: top; text-align: center;"><img src="<?php echo $t2image.'.gif'?>"></td>
      <td style="vertical-align: top; text-align: center;"><?php echo date("m/d/Yh:i A"); ?></td>
      <td style="vertical-align: top; text-align: center;"><a href="#Cat" rel="facebox"><?php echo $t2title ?></a>
  <div id="Cat" style="display:none">
<?php echo $t2info; ?>
</div>
      </td>
    </tr>
    <tr>

This replicates several times down the page around 15-20 times ( t1### - t20###)


Code Snipet from HTML Form
Code: [Select]
<form action="animals.php" method="post">
<div style="text-align: left;"><big
style="font-family: Garamond; font-weight: bold; color: rgb(51, 51, 255);"><big><big><span>Monkey</span></big></big></big><br>
<table style="text-align: left; width: 110px;" border="0"
cellpadding="2" cellspacing="0">
<tbody><tr>
<td style="vertical-align: top;">Image thumb<br>
<input type="radio" name="t1image" value="No opinion" checked><img src="eh.gif" alt="Eh">
<input type="radio" name="t1image" value="Ok"><img src="ok.gif" alt="ok">
<input type="radio" name="t1image" value="Like"><img src="like.gif" alt="Like">
<input type="radio" name="t1image" value="Dont"><img src="dont.gif" alt="Don't Like">
<input type="radio" name="t1image" value="Hate"><img src="hate.gif" alt="Hate">
<input type="radio" name="t1image" value="Other"><img src="other.gif" alt="Other">
<br>
Why Title:<input type="text" name="t1title" size="45" value="..."/></td>
<td style="vertical-align: top;">
Explain:<br>
<textarea name="t1info" cols=45 rows=3 value="..."></textarea>
</td></tr></table>
<br>
<!--Next-->

How do I get the Form data to save to the php page for others to view?

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=326600.0

i'm trying to access the data he

file.html

Code: [Select]
<html>
<head>
    <title>Online Marketing Calculators</title>
</head>

<body>
    <center>
        <h1>Online Marketing Calculators</h1>
        <h4> ROI Caclulator</h4>
        <form action="calculators.php" method="post">
            <p>Total Cost : <input type="text" name="cost">
            Total Income: <input type="text" name="income"></p>
            <input type="submit" value="submit">
        </form>
    </center>
</body>
</html>



file.php

<?php

if(isset($_REQUEST['cost']))
{
    echo $_REQUEST['cost'];
} else
{
    echo "Please Enter Cost";
}


?>

And it's not working. Any Ideas?

There is a web page that is programmed in ASP and has a simple one field form (drop down list) and a submit button.
After you submit the form by selecting an option (over 150 options), it will take you to the result page using the "Post" method. The variable does not show in the result page URL. The result page has table with multiple columns.
What I want is to have ALL the results in one CSV file.

Here what I really need in details:
1- Import all tables (one table for each option in the drop-down list) into a CSV file.
2- The content of two columns has codes. Replace all the codes in the table to a separate column.
3- Create an additional column that contains the name of the option on the first page form.

I need to have it in a php file so that I can run it via cron job few times a year.

How can I obtain this functionality with PHP?

Hi - I use PHP and CodeIgniter to create a Form which allows the user to amend and then submit the

dates and locations. It looks like this:

Code: [Select]
Pick Up ID Location        Date 1    Date 2    Date 3 Date 4 Remove?


1            Canmore                  1 April           1 May        1 June    1 July      Delete


In order to facilitate easy searches and DB management the Dates Table

looks like this:


Code: [Select]
puid locationid dates
1      1           1331668779
15      1           1383668779
12      1           1311746700
5      1           1321746641
16      2           1381668779
9      2           1331746700

Every date falls within the same DB column.

Using Group_CONCAT in the query and EXPLODE in the view , It all works very

well for pivoting the dates into a horizontal display.

The resulting array which feeds the form looks like this:

Code: [Select]
Array
(
    [0] => Array
        (
            [location] => Banff
            [locationid] => 1
            [TheDates] => 1311746700,1321746641,1331668779,1383668779
        )

    [1] => Array
        (
            [location] => Canmore
            [locationid] => 3
            [TheDates] => 1311746700,1321746641,1331746641,1371668779
        )

    [2] => Array
        (
            [location] => Collingwood
            [locationid] => 4
            [TheDates] => 1311746700,1321746641,1331746641,1371668779
        )



As you can see TheDates for each location is held in a comma delimited

string. They are exploded out such that they can be placed into the view

using this code:

View

Code: [Select]
<?php 
foreach ($pickupdates as $item) {
  $theDates = explode(',', $item['TheDates']);
 ?>
 <tr align="center">
  <td width="100" align="center"><?php echo  $item['locationid'];?></td>
    <td width="100" align="center"><?php $data = array('name'=>$item['location'], 'size'=>20,'value' => $item['location']); echo form_input ($data); ?></td>
    <td width="100"><?php $data = array('name'=>$theDates[0],'size'=>15,'value' =>(strftime("%a %d %b %Y",$theDates[0]))); echo form_input($data); ?></td>
    <td width="100"><?php $data = array('name'=>$theDates[1],'size'=>15,'value' =>(strftime("%a %d %b %Y",$theDates[1]))); echo form_input($data); ?></td>
    <td width="100"><?php $data = array('name'=>$theDates [2],'size'=>15,'value' => (strftime("%a %d %b %Y",$theDates[2]))); echo form_input($data); ?></td>
    <td width="100"><?php $data = array('name'=> $theDates [3],'size'=>15,'value' => (strftime("%a %d %b %Y",$theDates[3]))); echo form_input($data); ?></td>
    <td width="150"> <?php echo anchor ('admin/pickup_detail/deletelocation/'. $item['location'], 'Delete');?

></td>

  </tr>
<?php  ;} ?>

</table>

At this point things stop working properly. The form presents the data fine however my amends to the form do  not update the Database.  I get an error saying invalid argument of the 'Foreach'  in the model code below. I know that my model does not work and is flawed. I am not sure how to properly construct the $Data array in the CI form so that my update controller and update model ( Data Access )  amend the fields correctly bearing in mind the nature of the data structures and the fact that it is being presented in a converted Human readable date yet stored as date stamps. 

Controller:

Code: [Select]
function Updatelocation(){
$this->MPickup->Updatelocation();
redirect('admin/pickup_detail','refresh');
}


Model

Code: [Select]
function Updatelocation(){
if( isset( $_POST['locationid'] ) ) {
  foreach( $_POST['locationid'] as $pickupid=>$location) { // ERROR; "Invalid Arguement provide in Foreach"
   $data = array(
'locationid' => db_clean($_POST['locationid']),
'dates' => db_clean($_POST['$theDates[0]']),
'dates' => db_clean($_POST['$theDates[1]']),
'dates' => db_clean($_POST['$theDates[2]']),
'dates' => db_clean($_POST['$theDates[3]']),
   );
  $this->db->where('locationid', $locationid);
   $this->db->update('pudates',$data);
$this->session->set_flashdata('message', 'Table Updated');
}
}
else echo "Update Failed";

}





If ANY ONE  can provide me a steer in the right direction I will be forever

grateful !!

Many Thanks !!

Sorry if I asked this before in some variant, but I had to put my OOP studies aside for a few weeks, so here I go again?!

I am trying to learn OOP and would like to take the data submitted in a form and put it into an object so I can pass that to other objects and do stuff with said data in OOP terms.

My *limited* understanding of things so far is this...

If I have form "registration.php", when the user clicks 'Submit' then data from the form gets populated immediately in the $_POST array and control would go to the action page...

I would like to take

- email
- password
- name

into a generic object called FormHandler.  (Maybe this isn't how the OOP gurus would do it, but hmor me as I am trying to learn elementary OOP, and use something that works for me.)   

So how would I go about doing that?

All I can think is to have an action page called "form_handler.php" and when the user submits the form in "registration.php" then "form_handler.php" would instantiate FormHandler which would assign the $_POST array into either its own array or into individual variables.

Maybe something like...

class FormHandler{
private $someArray();

// OR

private $email;
private $password;
private $name;

function __construct() {
$this->someArray = $_POST();

// OR

$this->email = $_POST['email'];
$this->password = $_POST['password'];
$this->name = $_POST['name'];
}
}



Feel free to tell me what you think of my code and idea, and please be nice because I have never written any OOP before and it is hard to break my old procedural ways!   



TomTees

Hi People.

I am having a problem with this form and for the life of me can't see where I have made the mistake.

On line 33 I have commented where I get the problem. 

If I remove this line (or comment it out) and remove the insert statements for that line then it all works and I can see the php form on my live site.

However, with this in, as it is, I can't see anything, I get a blank page altogether.  Please, can anyone see my mistake?  I have been going over the code now for ages and it's getting late, and I probably am missing something stupid.
Code: [Select]
<!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=UTF-8" />
<title>Untitled Document</title>
</head>

<body>

<?php

$host = 'localhost';
$usr = "vinny";
$password = 'thepassword';
$db_name = 'logbook';

$date = $_POST['date'];
$type = $_POST['type'];
$reg_01 = $_POST['reg_01'];
$reg_02 = $_POST['reg_02'];
$captain = $_POST['captain'];
$passenger = $_POST['passenger'];
$where_01 = $_POST['where_01'];
$where_02 = $_POST['where_02'];
$takeoff_hr = $_POST['takeoff_hr'];
$takeoff_min = $_POST['takeoff_min'];
$landing_hr = $_POST['landing_hr'];
$landing_min = $_POST['landing_min'];
$ws_captain_hrs = $_POST['ws_captain_hrs'];
$ws_captain_min = $_POST['ws_captain_min'];
$ws_student_hrs = $_POST['ws_student_hrs'];
$ws_student_min = $_POST['ws_student_min'];
$3_captain_hrs = $_POST['3_captain_hrs'];// I have a problem with this line or where it inserts this into the DB??? 
/*$3_captain_min = $_POST['3_captain_min'];
$3_student_hrs = $_POST['3_student_hrs'];
$3_student_min = $_POST['3_student_min'];
*/
$errorstring = ""; // default value of errorstring

if(isset($_POST['save_flight'])) {
// Validate all the code inputs that are required fields
if ($date =="")
$errorstring = $errorstring. "Date<br>";
if ($type =="")
$errorstring = $errorstring. "Aircraft Type<br>";
if ($reg_01 =="")
$errorstring = $errorstring. "Reg Prefix<br>"; 
if ($reg_02 =="")
$errorstring = $errorstring. "Registration Mark<br>";
if ($captain =="")
$errorstring = $errorstring. "Captain<br>";
if ($where_01 =="")
$errorstring = $errorstring. "Flight From<br>";
if ($where_02 =="")
$errorstring = $errorstring. "Flight To<br>";
if ($takeoff_hr =="")
$errorstring = $errorstring. "Takeoff Hours<br>";
if ($takeoff_min =="") 
$errorstring = $errorstring. "Takeoff Minutes<br>";
if ($landing_hr =="")
$errorstring = $errorstring. "Landing Hours<br>";
if ($landing_min =="") 
$errorstring = $errorstring. "Landing Minutes<br>";


// does the errorstring = "nothing"?
if ($errorstring !="")
echo "You have not put anything in the following fields: <br><br> $errorstring";
//echo "If you have nothing to put in the box please type the word \"None\" or \"N\/A\"";
//die ("Please try again, ensuring that you fill out all the fields!");
else 
{
//echo "Your data has been saved";
//connect to database
mysql_connect ("$host","$usr","$password") or die ('Error During Connect:<br>'.mysql_error());
mysql_select_db ("$db_name") or die ('Error Selecting DB:<br>'.mysql_error());

$insert_query = "INSERT INTO pilots_logbook (date, type, reg_01, reg_02, captain, passenger, where_01, where_02, takeoff_hr, takeoff_min, landing_hr, landing_min, ws_captain_hrs, ws_captain_min, ws_student_hrs, ws_student_min, 3_captain_hrs) VALUES ('$date', '$type', '$reg_01', '$reg_02', '$captain', '$passenger', '$where_01', '$where_02', '$takeoff_hr', '$takeoff_min', '$landing_hr', '$landing_min', '$ws_captain_hrs', '$ws_captain_min', '$ws_student_hrs', '$ws_student_min', '$3_captain_hrs')";
$insert_action = mysql_query($insert_query) or die ('Error During Insert :<br>'.mysql_error().'<br><br>Error occured running the following code :<br>'.$insert_query);

$id = mysql_insert_id();

echo "Thank you, Your logbook entry has been saved.";
}
}

?>
<p>Use this form to add an entry to your logbook.</p>
<form name = "form1" method ="post" action="">
<table width="650" border="1" cellspacing="0" cellpadding="5">
  <tr>
    <td>Required *</td>
    <td>&nbsp;</td>
    <td>This Format Only</td>
  </tr>
  <tr>
    <td width="180">Date *</td>
    <td width="300">
      <input type="text" name="date" id="date" size = "25"/>
    </label>
     <input type="submit" name="today" id="today" value="Add Today" /></td>
    <td width="170">YYYY-MM-DD</td>
  </tr>
  <tr>
    <td>Aircraft Type *</td>
    <td><input type="text" name="type" id="type" size = "40" /></td>
    <td>E.G. Quantum</td>
  </tr>
  <tr>
    <td>Reg Number *</td>
    <td><input type="text" name="reg_01" id="reg_01" size = "5" />
      -
      <input type="text" name="reg_02" id="reg_02" size = "15"/></td>
    <td>G - ABCD</td>
  </tr>
  <tr>
    <td>Captain *</td>
    <td><input type="text" name="captain" id="captain" size = "40" /></td>
    <td>Name of Captain</td>
  </tr>
  <tr>
    <td>Passenger or Student</td>
    <td><input type="text" name="passenger" id="passenger" size = "40" /></td>
    <td>Were you? P or S</td>
  </tr>
  <tr>
    <td>Flight From *</td>
    <td><input type="text" name="where_01" id="where_01" size = "40" /></td>
    <td>Take off Airfield</td>
  </tr>
  <tr>
    <td>Flight To *</td>
    <td><input type="text" name="where_02" id="where_02" size = "40" /></td>
    <td>Landing Airfield</td>
  </tr>
  <tr>
    <td>Takeoff GMT *</td>
    <td><label>Hr
        <input type="text" name="takeoff_hr" id="takeoff_hr" size = "10" />
        Min
        <input type="text" name="takeoff_min" id="takeoff_min" size="10"/>
    </label></td>
    <td>24 Hr Format Only</td>
  </tr>
  <tr>
    <td>Landing GMT *</td>
    <td><label>Hr
        <input type="text" name="landing_hr" id="landing_hr" size="10" />
        Min
        <input type="text" name="landing_min" id="landing_min" size="10" />
    </label></td>
    <td>24 Hr Format Only</td>
  </tr>
  <tr>
    <td>Captain Weighshift</td>
    <td><label>Hrs
      <input type="text" name="ws_captain_hrs" id="ws_captain_hrs" size = "10"/></label>
      <label>Min
        <input type="text" name="ws_captain_min" id="ws_captain_min" size = "10" />
        <input type="submit" name="autofill_ws_captain" id="autofill_ws_captain" value="Auto Insert" />
    </label></td>
    <td>Button works it out and inserts it here</td>
  </tr>
  <tr>
    <td>Student Weightshift</td>
    <td><label>Hrs
      <input type="text" name="ws_student_hrs" id="ws_student_hrs" size = "10"/></label>
      <label>Min
        <input type="text" name="ws_student_min" id="ws_student_min" size="10" />
        <input type="submit" name="autofill_ws_student" id="autofill_ws_student" value="Auto Insert" />
      </label></td>
    <td>Button works it out and inserts it here</td>
  </tr>
  <tr>
    <td>Captain 3 Axis</td>
    <td><label>Hrs
      <input type="text" name="3_captain_hrs" id="3_captain_hrs" size = "10"/>
    </label>
      <label>Min
        <input type="text" name="3_captain_min" id="3_captain_min" size = "10" />
        <input type="submit" name="autofill_3_captain" id="autofill_3_captain" value="Auto Insert" />
    </label></td>
    <td>Button works it out and inserts it here</td>
  </tr>
  <tr>
    <td>Student  3 Axis</td>
    <td><label>Hrs
      <input type="text" name="3_student_hrs" id="3_student_hrs" size = "10"/>
    </label>
      <label>Min
        <input type="text" name="3_student_min" id="3_student_min" size = "10" />
        <input type="submit" name="autofill_3_student" id="autofill_3_student" value="Auto Insert" />
    </label></td>
    <td>Button works it out and inserts it here</td>
  </tr>
  <tr>
    <td>Passenger Interest Only</td>
    <td>Hrs
    <input type="text" name="passenger_only_hrs" id="passenger_only_hrs" size="10"/>
    Min
    <input type="text" name="passenger_only_mins" id="passenger_only_mins" size="10"/>
    <input type="submit" name="passenger_button" id="passenger_button" value="Auto Insert" /></td>
    <td>Button works it out and inserts it here</td>
  </tr>
  <tr>
    <td>Remarks</td>
    <td><textarea name="remarks" id="remarks" cols="45" rows="5"></textarea></td>
    <td>Went to get microlight forum cup from XYZ airfield. Maximum 500 characters</td>
  </tr>
  <tr>
    <td><input type="submit" name="save_flight" id="save_flight" value="Save Flight" /></td>
    <td><input type="submit" name="reset" id="reset" value="Reset Form" /></td>
    <td>&nbsp;</td>
  </tr>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>

Hi, I want to get the list of twitter followers in xml form using the url

http://api.twitter.com/1/followers/ids.xml?cursor=-1&screen_name=amodkumargupta

I am using the code

Code: [Select]
<?php
$xml = new SimpleXMLElement('http://api.twitter.com/1/followers/ids.xml?cursor=-1&screen_name=amodkumargupta',NULL,TRUE);
foreach ($xml->ids->id as $id) {

echo "Found $id<br />";
}
?>
But getting the following error:
Quote

Warning: SimpleXMLElement::__construct(http://api.twitter.com/1/followers/ids.xml?cursor=-1&screen_name=amodkumargupta) [simplexmlelement.--construct]: failed to open stream: No connection could be made because the target machine actively refused it. in C:\xampp\htdocs\getids.php on line 2

Warning: SimpleXMLElement::__construct() [simplexmlelement.--construct]: I/O warning : failed to load external entity "http://api.twitter.com/1/followers/ids.xml?cursor=-1&screen_name=amodkumargupta" in C:\xampp\htdocs\getids.php on line 2

Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in C:\xampp\htdocs\getids.php:2 Stack trace: #0 C:\xampp\htdocs\getids.php(2): SimpleXMLElement->__construct('http://api.twit...', 0, true) #1 {main} thrown in C:\xampp\htdocs\getids.php on line 2




Someone please help with the error.

..and its not working (i replaced <textarea> with <div> to apply some html tags inside it )

and this is my form :

Code: [Select]
<form action="proc.php" method="post">
<div id="text" name="question_text" class="text" contenteditable="true"></div>
</form>
but when i submit some text the $_POST['question_text'] is not set !