PHP - Form Data Not Appearing In Mysql Database

Hello,

I have been wrestling with the code below for most of this week and cannot see what I have done wrong. I would like the user to be able to "claim" their business by clicking on a link. I can get the correct business uploaded but then the form for changing the details does not populate. (I think it is referring to another database table but do not see why as it is not referenced.
The top half of the code below works showing the required data. Why does this data not replicate in the lower half of the code? Any help greatly appreciated

code:
Code: [Select]

<?php
  
session_start();

  
  ?>

<?php
  
require_once('appvars.php');
  require_once('connectvars1.php');

  



 // Connect to the database
  
$dbc = mysqli_connect(DB_Host, DB_User, DB_Password, DB_Name);

  
if (!isset($_GET['user_id'])) {
    
$query = "SELECT * FROM antique WHERE user_id = '" . $_SESSION['user_id'] . "'";
  
  
}
  else 
{
    $query = "SELECT * FROM antique WHERE user_id = '" . $_GET['user_id'] . "'";
  
}
  $data = mysqli_query($dbc, $query);

  
if (mysqli_num_rows($data) == 1) {
    
// The user row was found so display the user data
    $row = mysqli_fetch_array($data);
    
echo '<table>';
    

if (!empty($row['name'])) {
      echo '<tr><td class="label">Name:</td><td>' . $row['name'] . '</td></tr>';
    

   
}



   if (!empty($row['phone'])) {
      echo '<tr><td class="label">Phone:</td><td>'  . $row['phone'] .
        ' </td></tr>';
    
}
    
   if (!empty($row['address1'])) {
      echo '<tr><td class="label">Address1:</td><td>'  . $row['address1'] .
        ' </td></tr>';
    
}
   if (!empty($row['address2'])) {
      echo '<tr><td class="label">Address2:</td><td>'  . $row['address2'] .
        ' </td></tr>';
    
}
   if (!empty($row['postcode'])) {
      echo '<tr><td class="label">Postcode:</td><td>'  . $row['postcode'] .
        ' </td></tr>';
    
}
   if (!empty($row['webadd'])) {
        echo '<tr><td class="label">Web address:</td><td>'  . $row['webadd'] .
        ' </td></tr>';
    
}
  if (!empty($row['username'])) {
      echo '<tr><td class="label">Username:</td><td>'  . $row['username'] .
        ' </td></tr>';
    
}
echo '</table>';
  
 
echo '<class = "label">USER ID: ' . $row['user_id'] . '';

 if (!isset($_GET['user_id']) || ($_SESSION['user_id'] == $_GET['user_id'])) {
      echo '<p>Would you like to <a href="index5.php">Go to Homepage</a>?</p>';
    } } 

// End of check for a single row of user results
  
else {
    echo '<p class="error">There was a problem accessing your profile.</p>';
  }

 
 
?>

<hr>


<?php





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

// Grab the profile data from the POST
    
$name = mysqli_real_escape_string($dbc, trim($_POST['name']));
    
$phone = mysqli_real_escape_string($dbc, trim($_POST['phone']));

$address1 = mysqli_real_escape_string($dbc, trim($_POST['address1']));
    
$address2 = mysqli_real_escape_string($dbc, trim($_POST['address2']));
    
$postcode = mysqli_real_escape_string($dbc, trim($_POST['postcode']));

$webadd = mysqli_real_escape_string($dbc, trim($_POST['webadd']));

$email = mysqli_real_escape_string($dbc, trim($_POST['email']));
    
$old_picture = mysqli_real_escape_string($dbc, trim($_POST['old_picture']));
    
$new_picture = mysqli_real_escape_string($dbc, trim($_FILES['new_picture']['name']));
    
$new_picture_type = $_FILES['new_picture']['type'];
    $new_picture_size = $_FILES['new_picture']['size']; 


$username = mysqli_real_escape_string($dbc, trim($_POST['username']));

$user_id = mysqli_real_escape_string($dbc, trim($_POST['user_id']));

    
if (!empty($_FILES['new_picture']['tmp_name'])) {list($new_picture_width, $new_picture_height) = getimagesize($_FILES['new_picture']['tmp_name']);

}




//list($new_picture_width, $new_picture_height) = getimagesize($_FILES['new_picture']['tmp_name']);
    
$error = false;

    

// Validate and move the uploaded picture file, if necessary
    
if (!empty($new_picture)) {
      if ((($new_picture_type == 'image/gif') || ($new_picture_type == 'image/jpeg') || ($new_picture_type == 'image/pjpeg') ||
        ($new_picture_type == 'image/png')) && ($new_picture_size > 0) && ($new_picture_size <= MM_MAXFILESIZE) &&
        ($new_picture_width <= MM_MAXIMGWIDTH) && ($new_picture_height <= MM_MAXIMGHEIGHT)) {
        if ($_FILES['new_picture']['error'] == 0) {
          

// Move the file to the target upload folder
          
$target = MM_UPLOADPATH . basename($new_picture);
          
if (move_uploaded_file($_FILES['new_picture']['tmp_name'], $target)) {
            

// The new picture file move was successful, now make sure any old picture is deleted
            
if (!empty($old_picture) && ($old_picture != $new_picture)) {
              
            }
          }
          else {
            

// The new picture file move failed, so delete the temporary file and set the error flag
            
@unlink($_FILES['new_picture']['tmp_name']);
            
$error = true;
            echo '<p class="error">Sorry, there was a problem uploading your picture.</p>';

          }
        }
      }
      
else {
        
// The new picture file is not valid, so delete the temporary file and set the error flag
        
@unlink($_FILES['new_picture']['tmp_name']);

        $error = true;
        
echo '<p class="error">Your picture must be a GIF, JPEG, or PNG image file no greater than ' . (MM_MAXFILESIZE / 1024) .
          ' KB and ' . MM_MAXIMGWIDTH . 'x' . MM_MAXIMGHEIGHT . ' pixels in size.</p>';
      }
    }



$error = false;


// Update the profile data in the database
    
if (!$error) {
      if (!empty($name) && !empty($phone) && !empty($address1) && !empty($address2) && !empty($postcode)) {
        // Only set the picture column if there is a new picture
// Only set the password in there is a new one
        if (!empty($new_picture)) {

// if (!empty($age)) {
          $query = "UPDATE antique SET name = '$name', phone = '$phone', address1 = '$address1', address2 = '$address2', postcode = '$postcode', " .
            " email = '$email', webadd = '$webadd', picture = '$new_picture', username = '$username'  WHERE username = '" .  $_SESSION['username'] .
"'";
        
}}
       
        else {
          
$query = "UPDATE antique SET name = '$name', phone = '$phone', address1 = '$address1', address2 = '$address2', postcode = '$postcode', " .
            " email = '$email', webadd = '$webadd', username = '$username'  WHERE username = '" .  $_SESSION['username'] .
"'";
        }
       // mysqli_query($dbc, $query) or die("<br>Query $query<br>Failed with error: " . mysqli_error($dbc) . '<br>On line: ' . __LINE__); 

        

// Confirm success with the user
        
echo '<p>Your profile has been successfully updated. Would you like to <a href="viewprofile4.php">view your profile</a>?</p>';


        
mysqli_close($dbc);
        exit();
    
  }
      
else {
        echo '<p class="error">You must enter all of the profile data (the picture is optional).</p>';
   
   
    }
  } 

// End of check for form submission
  else {
    

// Grab the profile data from the database
    
$query="SELECT * FROM antique WHERE user_id= '" . $_SESSION['user_id'] . "'";

$data = mysqli_query($dbc, $query);
    
$row = mysqli_fetch_array($data);

    
if ($row != NULL) {
      $name = $row['name'];
      
$phone = $row['phone'];

$address1 = $row['address1'];

$address2 = $row['address2'];

$postcode = $row['postcode'];
      
$email = $row['email'];
      
$webadd = $row['webadd'];

$old_picture = $row['picture'];

$username = $row['username'];

$user_id = $row['user_id'];
    
}
    else {
      echo '<p class="error">There was a problem accessing your profile.</p>';

    }
  }


  mysqli_close($dbc);

?>

 
<form enctype="multipart/form-data" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">

    <input type="hidden" name="MAX_FILE_SIZE" value="<?php echo MM_MAXFILESIZE; ?>" />
   
<fieldset>
      <legend>Personal Information</legend>

      <label for="name">Name:</label>
      <input type="text" id="name" name="name" value="<?php if (!empty($name)) echo $name; ?>" /><br />

      <label for="phone">Phone:</label>
      <input type="text" id="phone" name="phone" value="<?php if (!empty($phone)) echo $phone; ?>" /><br />

<label for="address1">Address1:</label>
      <input type="text" id="address1" name="address1" value="<?php if (!empty($address1)) echo $address1; ?>" /><br />


<label for="address2">Address2:</label>
      <input type="text" id="address2" name="address2" value="<?php if (!empty($address2)) echo $address2; ?>" /><br />

      <label for="postcode">Postcode:</label>
      <input type="text" id="postcode" name="postcode" value="<?php if (!empty($postcode)) echo $postcode; ?>" /><br />

      <label for="email">Email:</label>
      <input type="text" id="email" name="email" value="<?php if (!empty($email)) echo $email; ?>" /><br />

      <label for="webadd">Web address:</label>
      <input type="text" id="webadd" name="webadd" value="<?php if (!empty($email)) echo $webadd; ?>" /><br />


<input type="hidden" name="old_picture" value="<?php if (!empty($old_picture)) echo $old_picture; ?>" />
      <label for="new_picture">Pictu </label>
      <input type="file" id="new_picture" name="new_picture" />
      <?php if (!empty($old_picture)) {
        echo '<img class="profile" src="' . MM_UPLOADPATH . $old_picture . '" alt="Profile Picture"style="max-width:150px; max-height:110px" />';}
  ?> <br />

<label for="username">Username:</label>
      <input type="text" id="username" name="username" value="<?php if (!empty($username)) echo $username; ?>" /><br />

<label for="user_id">User ID:</label>
      <input type="text" id="user_id" name="user_id" value="<?php if (!empty($user_id)) echo $user_id; ?>" /><br />
   
</fieldset>
   
<input type="submit" value="Save Profile" name="submit" />
 
</form>
<?php echo('<p class="login">You are logged in as ' . $_SESSION['username'] . '. <a href="logout3.php">Log out</a>.</p>');
echo '<class = "label">USER ID: ' . $row['user_id'] . '';

 ?>


<p><a href="index.php">Return to homepage</a></p>


<?php require_once('footer.php');
 ?>
</body>

</html>
 

Hello to all,

I have problem figuring out how to properly display data fetched from MySQL database in a HTML table.

In the below example I am using two while loops, where the second one is nested inside first one, that check two different expressions fetching data from tables found in a MySQL database. The second expression compares the two tables IDs and after their match it displays the email of the account holder in each column in the HTML table.

The main problem is that the 'email' row is displayed properly while its while expression is not nested and alone(meaning the other data is omitted or commented out), but either nested or neighbored to the first while loop, it is displayed horizontally and the other data ('validity', 'valid_from', 'valid_to') is not displayed.'

Can someone help me on this, I guess the problem lies in the while loop?
Here is part of the HTML code:

<thead>
 <tr>
 <th data-column-id="id" data-type="numeric">ID</th>
 <th data-column-id="email">Subscriber's Email</th>
 <th data-column-id="validity">Validity</th>
<th data-column-id="valid_from">Valid From</th>
 <th data-column-id="valid_to">Valid To</th>
</tr>
</thead>

Here is part of the PHP code:

 

    <?php
    while($row = $stmt->fetch(PDO::FETCH_ASSOC))
    {
        echo '
            <tr>
                <td>'.$row["id"].'</td>
        ';
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)) {
        echo '
                <td>'.$row1["email"].'</td>
        ';
        }
        if($row["validity"] == 1) {
            echo '<td>'.$row["validity"].' month</td>';
        }else{
            echo '<td>'.$row["validity"].' months</td>';
        }
        echo '  <td>'.$row["valid_from"].'</td>
                <td>'.$row["valid_to"].'</td>
        </tr>';
    }
    ?>

P.S. Please know that I have purposely omitted the connection part and the methods in the class that are used in this code to keep the spot of the problem as clean as possible. If you need me to rephrase the question, please ask.

Thank you.

hi guys, im new to this forum

I'm new also to php, I need help from you guys:

I want to display personal information from a certain person (the data is on the mysql database) using his name as a link:

example:
               (index.php)
               names
                          1. Bill Gates
                          2. Mr. nice Guy
           
i want to click Bill Gates
 
   (output.php)
     Name: Bill Gates
     Country:xxxx
     Age: xx   
                 etc.

How can i make this or how to learn this?
   
                 

             
               

   
       

I need to display the last 30 days entries from database in PHP and here is the code that i am currently using, but its not working.

While entering the data in database, the date format that i am using is this...
Code: [Select]
$subon = date("F j, Y, g:i a");
And to display the code i am using this query...
Code: [Select]
$start_date = date("F j, Y, g:i a", strtotime('-30 days'));
$curr_date = date("F j, Y, g:i a");
$sql = "SELECT * FROM table WHERE status = 'approved' AND subon BETWEEN '$start_date' AND '$curr_date' ORDER BY ID DESC LIMIT 0, 5";
And then i am using the usual stuff to display the data but its not working.

Somebody please help me... Thanks in advance.

hello friends,
actually i am trying to insert data in mysql
database.
here is my code

<?php
	include_once("../includes/database.php");
?>
<!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>Insert Product</title>
</head>

<body>
	<form action="insert_product.php" method="post" enctype="multipart/form-data">
    	<table align="center" width="600">
        <tr align="center">
        	<td colspan="8"><h2> Insert New Post</h2></td>
        </tr>
        <tr>
        	<td align="right"><b>Product Title :</b></td>
            <td><input type="text" name="product_title"  size="50" style="background-color:#06C; color:#FFF"  /></td>
        </tr>
         <tr>
        	<td align="right"><b>Product Category :</b></td>
            <td>
            	<select name="product_cat" style="background-color:#06C; color:#FFF" >
                	<option>Select A Category </option>
                    <?php 
						$get_cats = "SELECT * FROM categories";	
						$run_cats = mysqli_query($con, $get_cats);
						while($row_cats = mysqli_fetch_array($run_cats)){
							$cat_id = $row_cats['cat_id'];
							$cat_title = $row_cats['cat_title'];
							echo "<option value='$cat_id'>$cat_title</option>";
						}
					?>
                </select>
            </td>
        </tr>
         <tr>
        	<td align="right"><b>Product Platform :</b></td>
            <td>
            	<select name="product_brand" style="background-color:#06C; color:#FFF" >
                	<option>Select A Platform </option>
                    <?php 
						$get_brands = "SELECT * FROM brands";	
						$run_brands = mysqli_query($con, $get_brands);
						while($row_brands = mysqli_fetch_array($run_brands)){
							$brand_id = $row_brands['brand_id'];
							$brand_title = $row_brands['brand_title'];
							echo "<option value='$brand_id'>$brand_title</option>";
						}
					?>
                </select>
            </td>
        </tr>
         <tr>
        	<td align="right"><b>Product Image :</b></td>
            <td><input type="file" name="product_image"  /></td>
        </tr>
         <tr>
        	<td align="right"><b>Product Price :</b></td>
            <td><input type="text" name="product_price" style="background-color:#06C; color:#FFF"  /></td>
        </tr>
         <tr>
        	<td align="right" valign="top"><b>Product Description :</b></td>
            <td><textarea name="product_desc" cols="50" rows="10" style="background-color:#06C; color:#FFF"  ></textarea></td>
        </tr>
         <tr>
        	<td align="right"><b>Product Keywords :</b></td>
            <td><input type="text" name="product_keywords" size="50" style="background-color:#06C; color:#FFF" /></td>
        </tr>
         <tr align="center">
            <td colspan="8"><input type="submit" name="insert_post" value="Submit Now" /></td>
        </tr>
        </table>
    </form>
</body>
</html>

<?php
	if(isset($_POST['insert_post'])){
		$product_title = $_POST['product_title'];
		$product_cat = $_POST['product_cat'];
		$product_brand = $_POST['product_brand'];
		$product_price = $_POST['product_price'];
		$product_desc = $_POST['product_desc'];
		$product_keywords = $_POST['product_keywords'];
		$product_image = $_FILES['product_image']['name'];
		$product_image_tmp = $_FILES['product_image']['tmp_name'];
		move_uploaded_file($product_image_tmp,"product_image/$product_image");
		
		$sql = "INSERT INTO products (product_cat,product_brand,product_title,product_price,product_desc,product_image,product_keywords) VALUES ('$product_cat','$product_brand','$product_title','$product_price','$product_desc','$product_image','$product_keywords')";
		$query = mysqli_query($con, $sql);
		if($query){
			echo "<script>alert('Product Has Been Inserted')</script>";	
			echo "<script>windoow.open('insert_product.php','_self')</script>";
			exit();
		}else{
			echo "<script>alert('errror')</script>";	
		}
	}
?> 
 

but somehow its not inserting
data into my table can somebody tell wherre
m i doing mistake.

the categories and brands are displaying from database. But its not inserting data

here is my database script.

 <?php
 $con = mysqli_connect("localhost","root","","sg");
?>    

I am trying to display data from mysql. Each row from the mysql database shows up under rows.

I want the rows of data from mysql  to appear in colums of 4.

can some one help please.

<?php
$sql = 'SELECT * FROM dbtable ORDER BY id';
$result = $db->query($sql);
$output[] = '<ul>';
while ($row = $result->fetch()) {
      $output[] = '<table>';
         $output[] = '<tr>';
         $output[] = '<td class="style10"><strong>'.$row['item'].'</strong></td>';
         $output[] = '</tr>';
         $output[] = '<tr>';
         $output[] = '<td><img src="images/'.$row['pic'].'" width="100" height="150" /></td>';
         $output[] = '</tr>';
         $output[] = '<tr>';
         $output[] = '<td>'.$row['description'].'</td>';
         $output[] = '</tr>';
      $output[] = '</table>';
}
echo join('',$output);
?>

Hi,

I'm having trouble adding data to the database (test) that i created. I just can't see where I'm going wrong. need some other peoples opinions.

I have tried taking the id out of the SQL statement completely as it is an auto increment, but that doesn't seem to work either.

Thanks in advance...


<?php

$fname = $_POST['fname'];
$sname = $_POST['sname'];
$email = $_POST['email'];
$pword = $_POST['password'];
$gender = $_POST['gender'];
   
$user_name = "root";
$password = "";
$database = "test";
$server = "127.0.0.1";

$db_handle = mysql_connect($server, $user_name, $password);

$db_found = mysql_select_db($database, $db_handle);

if ($db_found)
{
$SQL = "INSERT INTO members (id, fname, sname, email, password, gender) VALUES (NULL, $fname, $sname, $email, $pword, $gender);";
$result = mysql_query($SQL);

mysql_close($db_handle);

print "Thanks for joining us ".$fname.".";
print "<br /><br />";
print $fname . "<br />";
print $sname . "<br />";
print $email . "<br />";
print $pword . "<br />";
print $gender . "<br />";
}
else
{
print "Database NOT Found";
mysql_close($db_handle);
}

?>

Ugh. Ive been asking so many questions, betcha already know my name. Hahah.
Anyways, I know I already asked a question like this, but this is different.
One of the values I am trying to insert into a database is simply not working.
Here is the columnes in my mysql database:

c_id   commet       story   user      date_added   star
Every value but 'commet' is getting inserted into database.  NO error, no mysql errror. I have racked my brain trying to figure out what is wrong with the script.
Here is my code:
Code: [Select]
<?php
$idget = $_GET['id'];
mysqlConnect();
//submit story
if(isset($_POST['submit']))
{
   $com_form = mysql_real_escape_string(bb($_POST['commet']));
   $rat_form = $_POST['rat'];
   $story_form =  $idget;
   $user = $_SESSION['user'];
   $date = date("Y-m-d");
   $query1 = "
   INSERT INTO story_commets(star, story, user, date_added, commet)
   VALUES($rat_form, '$story_form', '$user', '$date', '$com_form')
   ";
   mysql_query($query1) or die(mysql_error());


      
      
   //}
}

// desplay reviews


$query3 = "
SELECT * FROM story_commets
WHERE story = '$idget'
ORDER BY date_added
";
$select3 = mysql_query($query3) or die(mysql_error());
//$x=1;
$ratav = array();
//if(mysql_num_rows($select3) == 0)
//{
   echo '<div id="message"> No Reviews Yet.... <>';
   
//}
//else
//{
while($rows3 = mysql_fetch_assoc($select3))
{
   
   
   $commetdb = $rows3['commet'];
   $user_com_db = $rows3['user'];
   $datedb = $rows3['date_added'];
   $stardb = $rows3['star'];
   //get profile picture
   $query4 = "
   SELECT * FROM login_info
   WHERE user = '$user_com_db'
   ";   
   $select4 = mysql_query($query4) or die(mysql_error());
   
   $rows4 = mysql_fetch_assoc($select4) or die(mysql_error());
      $profile_pic = $rows4['profile_picture'];
      $user_id = $rows4['id'];
   echo "
   <div class='rev_cont'>
   <div class='info'>
   <img src='$profile_pic' /> 
   <a href=?p=profile&id=$user_id> $user_com_db </a> 
   

   
   <> <br /> 
   <div class='rev'>
   <strong> $stardb/10 </strong> <br />
   $commetdb
   <> 
   <div id='date'>  <em> Date Added: $datedb </em> <> 
   <>
   <hr />
   
   
     ";
   
   $ratav[]=$stardb; 
   
     
     
}




$sum = array_sum($ratav);

$count = count($ratav);
$av = $sum / $count;
$avf = round($av, 1);
echo"<div id='message'> Rating Avarage: $avf /10 <>";
//}
if (isset($_SESSION['user']))
{
   echo"
   <p> Did you like this story? Did you hate it? Give it a rating and let the author know!</p>
<form action='?p=review&id=$idget' method='post'  target='_self'> 
 
 <label> Your rating is on a scale of 1-10 </label>
 <select name='rat'>
    <option> 1 </option>
    <option> 2 </option>
    <option> 3 </option>
    <option> 4 </option>
    <option> 5 </option>
    <option> 6 </option>
    <option> 7  </option>
    <option> 8 </option>
    <option> 9 </option>
    <option> 10 </option>
 </select>
 <label> Commets: </label>
 
 <textarea name='commet' cols='70' rows='9'></textarea>
 <input name='story' type='hidden' value='$idget' /> <br />
 <input type='submit' value = 'Post' name='submit' />
</form>

   ";
}
else 
{
   echo "<div id='message'> Sign in to post a review! <>";
}

?>



Here are the specifics if you want it.

Here is the response part of the code:
Code: [Select]
<?php
if(isset($_POST['submit']))
{
   $com_form = mysql_real_escape_string(bb($_POST['commet']));
   $rat_form = $_POST['rat'];
   $story_form =  $idget;
   $user = $_SESSION['user'];
   $date = date("Y-m-d");
   $query1 = "
   INSERT INTO story_commets(star, story, user, date_added, commet)
   VALUES($rat_form, '$story_form', '$user', '$date', '$com_form')
   ";
   mysql_query($query1) or die(mysql_error());


      
      
   //}
}
?>
Here is the form part of my code:
Code: [Select]
<?php
if (isset($_SESSION['user']))
{
   echo"
   <p> Did you like this story? Did you hate it? Give it a rating and let the author know!</p>
<form action='?p=review&id=$idget' method='post'  target='_self'> 
 
 <label> Your rating is on a scale of 1-10 </label>
 <select name='rat'>
    <option> 1 </option>
    <option> 2 </option>
    <option> 3 </option>
    <option> 4 </option>
    <option> 5 </option>
    <option> 6 </option>
    <option> 7  </option>
    <option> 8 </option>
    <option> 9 </option>
    <option> 10 </option>
 </select>
 <label> Commets: </label>
 
 <textarea name='commet' cols='70' rows='9'></textarea>
 <input name='story' type='hidden' value='$idget' /> <br />
 <input type='submit' value = 'Post' name='submit' />
</form>

   ";
}
else 
{
   echo "<div id='message'> Sign in to post a review! <>";
}
?>
Its probably something really mundane. HelP!

Hello, I'm new to this forum and I need some help. I'm creating a simple database that it submits data from a user input. Unfortunatly, it's not sending any data to mysql also the form is not validating each field.

Code: [Select]
<?php

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

$fields = array(
'email',
'state',
'district',
'gender',
'age',
'profession',
'survey',
);

foreach($fields as $fieldName) {
if(isset($_POST[$fieldName]) and trim($_POST[$fieldName]) !==''){
$fieldName = trim($_POST[$fieldName]);
}else {

$errors[] = "Please enter your". $fieldName .""; //code to validate fields
}
}
if(isset($errors)){

require_once('Connections/encourage.php');

$query = "INSERT INTO participants (email, state, district, gender, age, profession, survey) 
VALUES ('$email', '$state', '$district', '$gender', '$age', '$profession','$survey')"; //databasse connection
   
$result = mysql_query ($query); 

if ($result){

echo '<h1 id="mainhead">Thanks for submitting</hl>
<p>You are now registered</p>';
exit();

}else{

echo '<h1 id="mainhead">System Error</hl>
<p>Your registration could not be completed due to a system error We apologize for any incovience</p>';//gives system error
echo 'p' . mysql_error(). '<br /><br />Query: ' . $query . '</p>';
exit();

}
mysql_close();

} else { 

echo '<h1 id="mainhead">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>';
}

}
?>
  <form id="form1" name="form1" method="post" action"registration.php">
  <fieldset class="first">
  <label class="lableone" for="email">Email:* </label>
  <input name="email" value="<?php if(isset($_POST['email'])) echo $_POST['name'];?>"/>
 
  <label for="state"/>State:* </label>
  <input name="state" value="<?php if(isset($_POST['state'])) echo $_POST['state'];?>"/>
 
  <label for="schooldistrict"/>School District:* </label>
  <input name="schooldistrict" value="<?php if(isset($_POST['district'])) echo $_POST['district'];?>" />
 
  <label for="gender">Gender:* </label>
 <select name="gender">
   <option>Choose Your Gender</option>
   <option value="male" <?php echo ($form['gender'] == 'male' ? ' selected' : ''); ?>>Male</option>
   <option value="female"<?php echo ($form['gender'] == 'female' ? ' selected' : ''); ?>>Female</option>
 </select>
 
    <label for="age"/>Your Age:* </label>
  <input name="age" type="text" class="age" maxlength="2" value="<?php if(isset($_POST['age'])) echo $_POST['age'];?>"  />
 
  <label for="profession"/>Profession:* </label>
  <input name="profession" value="<?php if(isset($_POST['age'])) echo $_POST['age'];?>" />
 
  <label for="surveys"/>Willingness to participate in future surveys: </label>
  <input name="surveys" type="checkbox" id="surveys" value="yes" <?php echo ($form['survey'] == 'yes' ? 'checked' : '');?>/>
 
  </fieldset>
<fieldset>
  <input class="btn" name="submit" type="submit" value="Submit" />
<input class="btn" name="reset" type="reset" value="Clear Form" />
<input type="hidden" name="submitted" value="TRUE" />
</fieldset>

  </form>


Can someone help me out? Thanks in advanced! 

im making a game and i need to show a users money but i dont know how help?

I'm a beginner to PHP and am stuck as to how I can fetch data from a MYSQL database and output that information in html to the website. Currently I get the information from the database using normal php:

$result = mysql_query("SELECT * FROM truffleProducts");

Then I assign each field from the database to a php variable in a while loop:
 

while ($row = mysql_fetch_array($result)) {
$id = $row{'id'};
$name = $row{'name'};
$price = $row{'Price_per_kg'};
$season = $row{'Season'};
$country = $row{'Country'};
$image = $row{'image'};
$review = $row{'review'};
}

Then I just print each variable in a table using simple html and php. My problem is that it only outputs the latest element or row from my database. I want to output the database within a HTML template so that it is professional and tidy, but i cant figure out how to do that. Any help?
Edited by louiscb, 22 October 2014 - 07:58 AM.

Hi there im not quite sure how to do something and was wondering if anyone can help me, I am going to create a large database with lots of fields and these are going to be displayed on a page i want to limit it to 20 per page and be able to sort them aswell by ID (default) and then a-z or z-a, i dont know how to do this and i also need to know how to create the next previous and last and first links im guessing theres a count++ involved ? im not quite sure but anyway if someone can help it will be great.

Thanks,

Blink359

I have got connection to the the mysql database, how do I get the data from the database to display on the webpage

I used to be good at this but I changed servers and everything is different...  Heres my code so far:

Code: [Select]
<?php
$rated=$_REQUEST['rated'];
echo $rated;
$rating=$_REQUEST['rating'];
echo $rating;

// Make a MySQL Connection
mysql_connect("localhost", "********", "********") or die(mysql_error());
mysql_select_db("*********") or die(mysql_error());

$result = mysql_query("SELECT * FROM main WHERE username = '$rated'")
or die(mysql_error());  

$row = mysql_fetch_array( $result );

$votes = $db_field['$rating'];
$newvotes = $votes + 1;

echo $newvotes;

mysql_query("UPDATE main SET $rating = '$newvotes'
WHERE username = '$rated'");


?>
Whats going on here is the colomb that I want to update comes as a variable $rated (That works) and then the database selects the  row to update with $username (That works) and gets the variable $newvotes by taking the original value of the data its about to update and add 1 to it (That works)  Then it updates the field to $newvotes....

I don't know why the update won't go through... there are no errors....