PHP - Form Wont Write To Mysql

Ok, i really need help with my registration page for my website. I've been working on this for 2 days now and i can't seem to get it to work propertly. This problem is that whenever i'm trying to register myself as a new user at my localhost website i get "Could Not Process Form" error that i've put into the code myself. I beleive this has something to do with the connection to my MySQL but i've put in "membership" as the database "root" as the username and then my password. If anyone has the time to read through my coding, i have marked the line where the error message is placed in the code.. yeah see for your self. Really need help with this!

<?php

class Register
{
  private $username;
  private $firstname;
  private $lastname;
  private $password;
  private $passmd5;
  private $email;
  private $gender;
  private $birthday;

  private $errors;
  private $token;

  public function __construct()
  {
    $this->errors = array();

    $this->username  = $this->filter($_POST['username']);
$this->firstname = $this->filter($_POST['first_name']);
$this->lastname  = $this->filter($_POST['last_name']);
    $this->password  = $this->filter($_POST['password']);
    $this->email     = $this->filter($_POST['email']);
$this->gender    = $this->filter($_POST['gender']);
$this->birthday  = $this->filter($_POST['birth_day']);
    $this->token     = $_POST['token'];

    $this->passmd5   = md5($this->password);
  }

  public function process()
  {
    if($this->valid_token() && $this->valid_data())
         $this->register();

    return count($this->errors)? 0 : 1;
  }

  public function filter($var)
  {
    return preg_replace('/[^a-zA-Z0-9@.]/','',$var);
  }

  public function register()
  {
   mysql_connect("localhost","root","") or die(mysql_error());
   mysql_select_db("membership") or die (mysql_error());

   mysql_query("INSERT INTO users(username,password) VALUES ('{$this->username}','{$this->passmd5}')");

   if(mysql_affected_rows()< 1)
     $this->errors[] = 'Could Not Process Form';    <------------------ HERE IS THE ERROR MESSAGE I'VE PUT IN THE CODE TO SPIT OUT IF SOMETHING GOES WRONG
  }

  public function user_exists()
  {
    mysql_connect("localhost","root","") or die(mysql_error());
    mysql_select_db("membership") or die (mysql_error());

    $data = mysql_query("SELECT username FROM users WHERE username = '{$this->username}'");

    return mysql_num_rows($data) > 0 ? 1 : 0;
  }

  public function show_errors()
  {
    echo "<h3>Errors</h3>";

    foreach($this->errors as $key=>$value)
      echo $value."<br>";
  }

  public function valid_data()
  {
    if($this->user_exists())
      $this->errors[] = 'Username Already Taken';
    if(empty($this->username))
      $this->errors[] = 'Invalid Username';
if(empty($this->firstname))
      $this->errors[] = 'Invalid First Name';
if(empty($this->lastname))
      $this->errors[] = 'Invalid Last Name';
    if(empty($this->password))
      $this->errors[] = 'Invalid Password';
    if(empty($this->email) || !preg_match('/^[a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]{2,4}$/',$this->email))
      $this->errors[] = 'Invalid Email';
if(empty($this->gender))
      $this->errors[] = 'Invalid Gender';
if(empty($this->birthday))
      $this->errors[] = 'Invalid Birthday';

  return count($this->errors)? 0 : 1;
  }


  public function valid_token()
  {
   if(!isset($_SESSION['token']) || $this->token != $_SESSION['token'])
     $this->errors[] = 'Invalid Submission';

   return count($this->errors)? 0 : 1;
  }
}

?>

Here is the code:
Code: [Select]
<?php
$db = mysql_query("
SELECT story_id
FROM story_info
WHERE story='$story_form' AND user='$username'
")or die(mysql_error());
$rows = mysql_fetch_assoc($db);

$id = $rows['story_id'];
?>
All of the variables are defined earlier in the code.

Hey php gods!

I recently watched a tutorial on how to make a membership system, it all turned out fine n stuff.
 So i wanted to expand and i found out a way to make a email activation "thingie", by making 2 new rows. 1 called email_code and a second called email_a(a for activate).
When the person then registered, he woulld get a email where he should go to a link and write a code that was generate with a rand fuction and placed in the email_code row in the database.
Then when the person wrote his username and the code in a form from the link in the email, the email_a would change from 0 to 1 if the username matched to the code he got. (sry for bad english).
anyway here is the code:

<!DOCTYPE html>
<html>
    <head>
        <link href="style.css" type="text/css">
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Activate email</title>
    </head>
    <body>
       
        <form action="" method="POST">
            Username:<input type="text" name="username">
            Code:<input type="text" name="activate">
            <input type="submit" name="submit" value="aktiver">       
        </form>
        <?php
       
        include 'connect.php';
       
   

        $username = $_POST('username');
        $activate = $_POST('activate');
        $submit = $_POST('submit');
       
        $query = mysql_query("SELECT username AND email_code FROM user");

        while ($row = mysql_fetch_assoc($query)){
   $dbusername = $row['username'];
   $dbcode = $row['email_code'];
   }
       
        if ($_POST['submit']){
       
        if ($username==$dbusername&&$code==$dbcode){
            mysql_query("UPDATE users SET email_a = '1'
            WHERE username = '$username' AND email_code = '$activate'");
            echo "Du er blevet aktiveret";
        }
        else
            echo "Forkert data";
        }
      else
      
        ?>
    </body>
</html>

Hope you can help me

MinG

Hey all,

I am in a situation where database management system needs to be up and running very quickly, which would store records of addresses possibly from all the properties in a particular US state. But it would only be 1 US state, not all. These records need to be updated and retrieved for particular campaigns. The programming solution (e.g. PHP) would need to be able to import csv files generated from excel and match the records in the database in order to know which fields to update. It seems like a lot of work to do this from scratch using PHP in the short-term, given time limitations. Hence, I was considering using Microsoft Access as a front end in the interim and then when time is available writing a web-based PHP/MySql application using HTML, CSS, and JavaScript front end to allow users to easily perform data entry. Does anyone think this is a smart course of action? Ideally a web PHP app would be more robust, but considering it needs to be done from scratch, it would be time consuming.

There's no right or wrong answer for this. I'm just looking for opinions. Thanks for any response.

I have a MySQL database with each record of a person who has registered for an event, I am displaying the information on a web page for a user, but he wants to be able to print out all the records in alphabetical order by last name, first name later on so he will have a hard copy of each person who has registered at the table when they arrive.  How can I write each record to a Txt file that he can print out later that will be formated with the record contents along with each fields definition (Ex. Last Name - Smith, First Name - John, etc)?

I have the code echoing into the next page where it says your mail was sent successfully but it wont email me all the variables here is the code:
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<title>Submitted Form</title>
</head>

<body>
 <?php
 session_start();
  echo "<html>
        <head><title>Posted Variables</title></head>
        <body>";
 $to = "artdept@calmktg.com";
 $subject = "SCE SONGS ORDER FORM";
 $email = $_REQUEST['email'];
  foreach ($_POST as $field => $value)
  {
     echo "$field = $value<br>";
  }
 $headers = "From: $email";
 $sent = mail($to, $subject, $message, $headers) ;
 if($sent)
 {print "Your mail was sent successfully"; }
 else
 {print "We encountered an error sending your mail"; }
 ?>
</body>
</html>

please help me out if you need anything else just ask....my email is artdept@calmktg.com

How would i begin to start php coding to work for this form shown in the image? could anyone point me to useful tutorials, i would appreciate it, thanx

I HAVE TRIED looking at it  but i am new to php so i can't figure out what i did wrong  help please !!!!!!!!!!!!




Fatal error: Call to undefined method modernCMS::update_form() in C:\wamp\www\test\inc\update-content.php on line 4

----
Page that's accessing code
-----
<?php

include '../test/inc/admin/nav.php';
echo $obj->update_form($_GET['id']);

?>

------
function
------

<?php

class modernCMS {

var $host;
var $username;
var $password;
var $db;

function connect() {
$con = mysql_connect($this->host, $this->username, $this->password) or die(mysql_error());
mysql_select_db($this->db, $con) or die(mysql_error());

} //end connect

function get_content($id = '') {

if($id != ""):
$id = mysql_real_escape_string($id);
$sql = "SELECT * FROM cms_content WHERE id = '$id'";

// $return = "<p><a href=../test/inc/admin/nav.php>Go Back To Content</a></p>";

else:
$sql = "SELECT * FROM cms_content ORDER BY id DESC";
endif;

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

if(mysql_num_rows($res) != 0):
while($row = mysql_fetch_assoc($res)) {
echo '<table bgcolor="#975627" width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td height="25" background="images/menu.gif"><center><strong>' . $row['title'] . '</strong></center></td>

</tr>
<tr bgcolor="975627"><td height="0"></td></tr>

<tr>
<td bgcolor="#181818">
';
echo '<br>
<div align="center">' . $row['body'] . ' <br><br>
</td>

</tr>

<tr>
<td height="25" background="images/menu.gif">
</td>

</tr>

</table><br><br>
';
}
else:
echo '<p>Uh Oh!!! </p>';
endif;

// echo $return;


} //end get_content

function add_content($p) {
$title = mysql_real_escape_string($p['title']);
$body = mysql_real_escape_string($p['body']);

if(!$title || !$body):

if(!$title):
echo "<p>The title is required!</p>";
endif;
if(!$body):
echo "<p>The body is required!</p>";
endif;

echo '<p><a href="add-content.php">Try Again!!!</a></p>';

else:
$sql = "INSERT INTO cms_content VALUES (null, '$title', '$body')";
$res = mysql_query($sql) or die(mysql_error());
echo "Added Successfully!";
endif;
} //end add_content

function manage_content() {
$sql = "SELECT * FROM cms_content ORDER BY id DESC";
$res = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_assoc($res)):

?>

<div>
<h2 class="title"><?php echo $row['title']; ?></h2>
<span class="actions"<a href="../test/update-content.php?id=<?php echo $row['id']?>">Edit</a> | <a href="?delete=

<?php

echo $row['id']

?>

">Delete</a></span>
</div>

<?php
endwhile;
echo '</div>'; //Class Manage Div

} //end manage_content

function delete_content($id) {
if(!$id) {
return false;
}else {
$id = mysql_real_escape_string($id);
$sql = "DELETE FROM cms_content WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
echo "Content Deleted Successfully!";
}
}
} //end delete_content

function update_form($id) {
$id = mysql_real_escape_string($id);
$sql = "SELECT * FROM cms_content WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($res);

?>

<form method="post" action="./post-added.php">

<input type="hidden" name="update" value="true" />
<input type="hidden" name="id" value="<?php $row['id'] ?>" />

<div>
<label for="title">Title:</label>
<input type="text" name="title" id="title" value="<?php echo $row['title'] ?>" />
</div>

<div>
<label for="body">Body:</label>
<textarea name="body" id="body" rows="8" cols="40" /><?php echo $row['body'] ?></textarea>
</div>

<input type="submit" name="submit" value="Update Content" />

</form>
<?php

} //end update_content_form

function update_content($p) {
$title = mysql_real_escape_string($p['title']);
$body = mysql_real_escape_string($p['body']);
$id = mysql_real_escape_string($p['id']);

if(!$title || !$body):

if(!$title):
echo "<p>The title is required!</p>";
endif;
if(!$body):
echo "<p>The body is required!</p>";
endif;

echo '<p><a href="update-content.php?id=' . $id . '">Try Again!!!</a></p>';

else:
$sql = "UPDATE cms_content SET title = '$title', body = '$body' WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
echo "Updated Successfully!";
endif;
} //end update_content($p)



?>

Can anyone explain... (note this is first time using PHP , dont have a clue, only using it as FLash CS5 wont send emails forms directly) so add all the details and explain it all please.)

why my yahoo email is not detecting this at all. Also I managed some success earlier with earlier attempts but eveythign was surrounded with html tags even though I set them to off in Flash on the property tabs on the input text.

In the Flash file . swf  the send button has this code

Code: [Select]
on(release){

form.loadVariables("email_send.php", "POST");
}
and the movie containing the input text fields has this code

Code: [Select]
onClipEvent(data){
_root.nextFrame();
}
the next page is a thank you screen

The variables in the input text boxes in the Flash file are

name, dept, phone, email and message




Code: [Select]
<?php

$sendTo = "chris.bruneluni@yahoo.co.uk";
$subject = "Message from chriscreativity.com";

$headers = "From: ". $_POST("name");

$headers = "Postion: ". $_POST["dept"];

$headers =  "<". $_POST["email"] .">". "\r\n";

$headers =  "Reply-To: " . $_POST["email"] . "\r\n";

$headers =  "Return-Path: ". $_POST["email"] ;

$headers =  $_POST["phone"];

$message = $_POST["message"];

$message = wordwrap($message, 70);

mail($sendTo, $subject, $headers, $message);

?><\Strong>


Please can you help to


A) get it to email my yahoo email

B) make an email that looks like


Name: Micky
Dept : Disney
Emial : Mick @mouse.com

etc not

<TEXTFORMAT LEADING="2"><P ALIGN="LEFT"><FONT FACE="Comic Sans MS" SIZE="16" COLOR="#000000" LETTERSPACING="0" KERNING="0">Micky</FONT></P></TEXTFORMAT><TEXTFORMAT LEADING="2"><P ALIGN="LEFT"><FONT FACE="Comic Sans MS" SIZE="16" COLOR="#000000" LETTERSPACING="0" KERNING="0">


please

[attachment deleted by admin]

Hi all,

I'm using a gateway for CC, when they payment is made and then users are redirected back to my site, I grab the order number and echo it as $info so I can display on the user's receipt.

Code: [Select]
<?php
$info=$_POST['OrderNo']; 
echo "$info";
?>

Is it possible to use PHP to either to automatically (onload) submit a form or somehow write $info to a text file so I can reconcile the books later?  I can do the former successfully with JavaScript... but I'd rather make it server-side.

Thanks.

 

I am pretty new to php and trying to teach myself.  I can't get the values from this form to write to my flat file called orders.txt:

browse_index.php

<?php 
include("includes/menu_members.php")
?>
<div id="content">

<h1>SHOPPING CART</h1>
<a href="browse_index.php">CLICK HERE TO CONTINUE SHOPPING</a>
  

<?php 

echo '
  <table border="0">
  <tr>
  <td><form id="f2" method="post"name="f2"><input type="submit" action="order_summary.php" name="submit2" value="submit order"></td>
  ';

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

  $itemname = $_POST['h1'];

  //echo $_SESSION['itemname'][$itemname];
  unset($_SESSION['itemqty'][$itemname]);
  unset($_SESSION['itemprice'][$itemname]);
  unset($_SESSION['itemname'][$itemname]);
  }

  echo "<br/><br/>";
  echo "<table border='8' bgcolor='#efefef'>";
  echo "<tr><th>Name</th><th>Quantity</th><th>Price</th><th>Subtotal</th></tr>";
  foreach($_SESSION['itemname'] as $key=>$value)
{

echo
'<tr><td><b>'.$_SESSION['itemname'][$key].'</b></td>
<td>'.$_SESSION['itemqty'][$key].'</td>
<td>$'.$_SESSION['itemprice'][$key].'</td>
<td name="subtotal">$'.($_SESSION['itemqty'][$key] * $_SESSION['itemprice'][$key]).'</td>
<td><form id="f1" method="post" name="f1"><input type="submit" name="submit" value =
"delete"><input type="hidden" name="h1" value='.$key.'></td></tr>'
;

}
  
?>


order_summary.php:

<?php
session_start ();

$date = date ("H:i jS F");

$outputstring = $date."/t"

.$_POST['h1']. ":"

.$_SESSION['itemqty'][$key]. ":"

.$_SESSION['subtotal'][$key]. ":"

."\n";

$fp = fopen("orders.txt","a");

fwrite($fp, $outputstring);

fclose($fp);
?>

Can someone direct me where I am going wrong???

I have an existing GET form that I use and want to write to a MYSQL table everytime a user uses that form.
Code: [Select]
<FORM ACTION="https://someurl.com" METHOD=GET>
Would the easiest to be a javascript function that uses the onclick event?

What would be the best way to continue to pass the user along while capturing data and writing that to a MYSQL table.

Thanks!

ok..ive done this a million times..i have a working example here and i copied it and amended it for this new project but for some reason i cant get a form to post data to another page.

this is the error message i get

Notice: Undefined index: username in C:\wamp\www\uni\fyp\site\mobile\login.php on line 16

Notice: Undefined index: password in C:\wamp\www\uni\fyp\site\mobile\login.php on line 17

here is my form code:

                    <form method="post" action="login.php">
                        <table align="center" cellpadding="0" cellspacing="0">
                        <tr>
                            <td style="vertical-align:top;">Username:&nbsp; </td><td><input type="text" name="username" value="" /></td>
                        </tr>
                        <tr>
                            <td style="vertical-align:top;">Password:&nbsp; </td><td><input type="password" name="password" value="" /><br /><input type="submit" id="submit" value="Login" /></td>
                        </tr>
                        </table>
                    </form>


and here is the code within the login.php where the form should post to

$username = $_POST['username'];

$password = $_POST['password'];

// Help protect against MySQL injection

$username = stripslashes($username);

$password = stripslashes($password);

$username = mysql_real_escape_string($username);

$password = mysql_real_escape_string($password);

// Selecting data from database where correct username and password are found

$sql="SELECT * FROM customer WHERE username='$username' and password='$password'";

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



i cant see anything wrong..been looking for hours...please please help me

Hi-
the code below lets me upload a CSV file to my database if I have 1 field in my database and 1 column in my CSV.
I need to add to my db "player_id" from the CVS file and "event_name" and "event_type" from the form... any ideas???

here's the code:
Code: [Select]
<?php
$hoststring =""; 
$database = "";
$username = "";
$password = "";
$makeconnection = mysql_pconnect($hoststring, $username, $password);
?>
<?php
ob_start();
mysql_select_db($database, $makeconnection);
$sql_get_players="
SELECT * 
FROM tabel 
ORDER BY player_id ASC";
//
$get_players = mysql_query($sql_get_players, $makeconnection) or die(mysql_error());
$row_get_players = mysql_fetch_assoc($get_players);
//
$message = null;
$allowed_extensions = array('csv');
$upload_path = '.'; //same directory

if (!empty($_FILES['file'])) {

if ($_FILES['file']['error'] == 0) {
// check extension
$file = explode(".", $_FILES['file']['name']);
$extension = array_pop($file);

if (in_array($extension, $allowed_extensions)) {

if (move_uploaded_file($_FILES['file']['tmp_name'], $upload_path.'/'.$_FILES['file']['name'])) {

if (($handle = fopen($upload_path.'/'.$_FILES['file']['name'], "r")) !== false) {
$keys = array();
$out = array();
$insert = array();
$line = 1;

while (($row = fgetcsv($handle, 0, ',', '"')) !== FALSE) {

foreach($row as $key => $value) {    

if ($line === 1) {
$keys[$key] = $value;       
} else {       
$out[$line][$key] = $value;              
}       
}                
$line++;          
}        

fclose($handle);            

if (!empty($keys) && !empty($out)) {        
$db = new PDO(
'mysql:host=host;dbname=db', 
'user', 
'pw');   

$db->exec("SET CHARACTER SET utf8");        

foreach($out as $key => $value) {        
$sql  = "INSERT INTO `table` (`";
$sql .= implode("`player_id`", $keys);    
$sql .= "`) VALUES (";    
$sql .= implode(", ", array_fill(0, count($keys), "?"));    
$sql .= ")";    
$statement = $db->prepare($sql);    
$statement->execute($value);       
}      

$message = '<span>File has been uploaded successfully</span>';      
}
}
}
} else {
$message = '<span>Only .csv file format is allowed</span>';
}
} else {
$message = '<span>There was a problem with your file</span>';
}
}
ob_flush();?>
<!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>CSV File Upload</title>
</head>
<body>

<form class="form" action="" method="post" enctype="multipart/form-data">
<h3>Select Your File</h3>
<p><?php echo $message; ?></p>
<input type="file" name="file" id="file" size="30" />
<br/>
<label>Event Name:</label><input name="event_name" type="text" value="" />
<br/>
<label>Event Type:</label><input name="event_type" type="text" value="" />
<br/>
<input type="submit" id="btn" class="button" value="Submit" />
</form>

<br/>
<h3>Results:</h3>
<?php do { ?>
<p><?php echo $row_get_players['player_id'];?></p>
<?php } while ($row_get_players = mysql_fetch_assoc($get_players)); ?>
</body>
</html>