Hello I have already

Makara — Fri, 06 Mar 2015 08:38:40 +0000

Hello
I have already displayed my sql table in my HTML form. I want to update the same sql table with the same html form after every submit. How do I go about this.The attached is a screenshot of what I want to update

These are really needed as in

solarlight — Sat, 25 Feb 2012 16:36:26 +0000

These are really needed as in your database you need to assign a set length. So for name I'm presuming you use "VARCHAR" and you need to assign a length you allow for that.
If the VARCHAR for name in your DB is say 10 chars, and I enter my name with 12 chars, without the above check it will be inserted into the DB, but the last two letters of my name wont be stored.

Hi I cant make The php code

armen — Sat, 28 Jan 2012 11:12:18 +0000

Hi
I cant make The php code ....
i got site with a form like this
(checkblox)action
(checkblox)science
(checkblox)drama
(checkblox)thriler.....
I have 4 tables in database and in action table is action movies ,in thriler table is thriler movies etc
if u can help me with php code to show each time the rigth table ....
i' ve make the form with Post ....thank you and sorry for my english

That error message usually

pr0gr4mm3r — Fri, 26 Nov 2010 23:31:49 +0000

That error message usually happens when the SQL password is incorrect.

Hi When i tried to create a

broadwaythink — Fri, 26 Nov 2010 13:32:10 +0000

Hi
When i tried to create a database it is throwing a error like "Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'Bala'@'localhost' (using password: YES) in C:\xampp\htdocs\Database.php on line 7
Could not connect: Access denied for user 'Bala'@'localhost' (using password: YES)"

I am using the code

<?php
$host = "localhost";
$user = "Bala";
$db_name= "Bala_db";
$pass= "PASSWORD";
    $con = mysql_connect($host, $user, $pass);
   if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("Bala_db", $con); //Replace with your MySQL DB Name
$name=mysql_real_escape_string($_POST['name']); //This value has to be the same as in the HTML form file
$email=mysql_real_escape_string($_POST['email']); //This value has to be the same as in the HTML form file
$sql="INSERT INTO Mailing_list (name,email) VALUES ('$name','$email')"; /*form_data is the name of the MySQL table where the form data will be saved.
name and email are the respective table fields*/
if (!mysql_query($sql,$con)) {
die('Error: ' . mysql_error());
}
echo "The form data was successfully added to your database.";
mysql_close($con);
?>

Can anyone help me?

- Bala

Hi When i tried to create a

broadwaythink — Fri, 26 Nov 2010 13:31:14 +0000

Can anyone help me?

- Bala

I'll give you a basic example

sandeep Kumar — Thu, 01 Jul 2010 09:45:38 +0000

I'll give you a basic example to you, firstly you try that, here i create a simple lo-gin form as well as registration form that help you for understanding the Database concept completely

index_dir.php

<?php
if(isset($_POST['posted']))
                {
                   $name=$_POST['dir_username'];
                   $pass=$_POST['dir_password'];
                   $connect=mysql_connect('localhost','root','');
                $db=mysql_select_db('dir_db',$connect);
                $query=mysql_query('SELECT * FROM dir_login',$connect);
                while($row=mysql_fetch_array($query))
                {
                    $column1=$row['username'];
                    $column2=$row['password'];
                    if($column1 == $name && $column2 == $pass)
                    {
                        header('location:registration_dir.php');
                    }
                    else
                    {
                        echo('Sorry Username and password is mismatch');
                        exit();
                    }
                }
                }
             
?>

USERNAME

PASSWORD

*************************************************
registration_dir.php
**********************************************************

<?php
if(isset($_POST['posted'])=='true')
{
$connect=mysql_connect('localhost','root','');
$db=mysql_select_db('dir_db',$connect);

$name=$_POST['dir_name'];
$title=$_POST['dir_title'];
$company=$_POST['dir_company'];
$email=$_POST['dir_email'];
$phone=$_POST['dir_phone'];
$address=$_POST['dir_address'];
$website=$_POST['dir_website'];
$notes=$_POST['dir_notes'];
$search_conent=$_POST['dir_search_content'];
            
// Now, We Perform Saving Operation.
                if(isset($_POST['dir_save']) == 'Save')
                  {
                    $query=mysql_query("INSERT INTO dir_registration(name,title,company,email,phone,address,website,notes)                           VALUES('$name','$title','$company','$email','$phone','$address','$website','$notes')",$connect);
                  }
                  
//Now We Perform Cancel operation.
               if(isset($_POST['dir_cancel']) == 'Cancel')
                {
                    exit();
                }
// Now We Perform Reset operation.
                if(isset($_POST['dir_reset']) == 'Reset')
                {
                    $name       = '' ;
                    $title      = '' ;
                    $company    = '' ;
                    $email      = '' ;
                    $phone      = '' ;
                    $address    = '' ;
                    $website    = '' ;
                    $notes      = '' ;
                    echo 'Sai Ram, Sucessfully record Reset';
                }
// Now We Perform Search Operation.        
               
                if(isset($_POST['dir_search'])=='Search')
                {
                    $query=mysql_query("SELECT * FROM dir_registration WHERE name LIKE '%$search_conent%'",$connect);
                    while($row = mysql_fetch_array($query))
                    {
                        $column1=$row['name'];
                        $column2=$row['title'];
                        $column3=$row['company'];
                        $column4=$row['email'];
                        $column5=$row['phone'];
                        $column6=$row['address'];
                        $column7=$row['website'];
                        $column8=$row['notes'];
                    }
                    
                }
//Now We Perform Deletion Operation
                
                if(isset($_POST['dir_delete']) == 'Delete')
                {
                    echo "Hiii";
                    $query = mysql_query("DELETE FROM dir_registration WHERE name= '$name' ",$connect);
}
}
?>

Name :

Title :
Company :

Phone

Address

<?php
 echo $column6; 
?>

Website

Birthday

Notes

<?php
 echo $column8; 
?>

Hello Dave0585, I saw your

Midas — Sun, 31 May 2009 00:34:55 +0000

Hello Dave0585, I saw your forum post a few days ago when I was looking for a script to send form data to a database. The script I used was similar to the one you're using and it just wouldn't work...anyway, I found something else that adds form data to a txt/csv file - easy to access and (and I'm new to all this so I could be wrong) it isn't likely to suffer sql exploits (because it isn't an sql database) although the created text file will be readable by browsers who know where to look for it (I hope someone here could offer advice to protect it).

Here's the code I'm using:

<?php

// Give your form's <input> tags name attributes equal to
// the variables set here e.g name="fieldone" or name="fieldtwo"
// Change fieldone, fieldtwo...to suit you.
// If you change these, remember to also
// change their corresponding parts below
// eg change every occurrence of $fieldone and fieldone
// to whatever you change them.
// Likewise, these can be increased or decreased
// just remove or add below as needed.

if(isset($_POST['Submit'])){
    $fieldone = $_POST['fieldone']; 
    $fieldtwo = $_POST['fieldtwo']; 
    $fieldthree = $_POST['fieldthree']; 
    $fieldfour = $_POST['threefour']; 
    $fieldfive = $_POST['fieldfive']; 
    $fieldsix = $_POST['fieldsix']; 
    $fieldseven = $_POST['fieldseven']; 
   $err = '';
   
//This bit checks the fields have been filled.
//Remove for non-essential fields (from "if.." to "}"

   if(trim($fieldone)==''){
      $err .= '-Please enter whatever goes into fieldone<br />';
   }
   if(empty($fieldtwo)){
      $err .= '-Please enter whatever goes into fieldtwo<br />';
   }
   if(empty($fieldthree)){
      $err .= '-Please enter whatever goes into fieldthree<br />';
   }
   if(empty($fieldfour)){
      $err .= '-Please enter whatever goes into fieldfour<br />';
   }
   if(empty($fieldfive)){
      $err .= '-Please enter whatever goes into fieldfive<br />';
   }
   if(strlen($fieldsix)==0){
      $err .= '-Please enter whatever goes into fieldsix<br>';
   }
   if(strlen($fieldseven)==0){
      $err .= '-Please enter whatever goes into fieldseven<br>';
   }
   
   if($err!=''){
      echo $err;
   }

// This bit writes data to "datafile.csv". You can call it whatever
// you want; even change it to a .txt if preferred.
// Whatever you put between ',' (in this case a coma) will also be 
// written to the file. I use it to format data ready for use.

   else{
      $filename = 'linksubmissions.csv';
      $somecontent = $fieldone . ',' . $fieldtwo . ',' . $fieldthree . ',' . $fieldfour . ',' . $fieldfive . ',' . $fieldsix . ',' . $fieldseven . "\n";
      
      $checkfile = 'datafile.csv'; //Changethstothe name of the file you want written

      // Let's make sure the main file exists and is writable.
      if (is_writable($filename)) {
      
         // In our example we're opening $filename in append mode.
         // The file pointer is at the bottom of the file hence
         // that's where $somecontent will go when we fwrite() it.
         if (!$handle = fopen($filename, 'a')) {
             echo "Cannot open file ($filename)";
             exit;
         }
      
         // Write $somecontent to our opened file.
         if (fwrite($handle, $somecontent) === FALSE) {
            echo "Cannot write to file ($filename)";
            exit;
         }
         

         echo "You detailshve been successfully recorded, thank you.   Details sent were,<br /><br />$somecontent.";
         
         fclose($handle);
      
      } else {
         echo "Either the file $filename or $checkfile is not writable";
      }
   }
}
?> 

I've annotated the script, I got the main part of it from another website (forgotten which). If you need to write separate field data to different files then I can help you do that.

Hope this has proved helpful to you 'cause it's taken me two days to re-find this forum to post this script for you

Now I need to add to it to ensure people fill out the form fields with correct data e.g their email in my email field, and URL in my URL field. I'm going to try the code written by Greg.

Hey Greg, sorry I went to

Dave0585 — Fri, 15 May 2009 09:51:44 +0000

Hey Greg, sorry I went to bed after one million hours of PHP fun. I agree totally that I should no being trying all of this online. But I think it is now protected. I just put an exit at the end of the validation code to stop it running the POST script stuff unless it is valid input.

Thanks for all of your help greg, it is greatly appreciated indeed.

Here is the code I have now for anyone who might have the same problem:

<?php
require_once "formvalidator.php";
$validator = new FormValidator();
$validator->addValidation("Name","req","Please fill in Name");
$validator->addValidation("Email","email","The input for Email should be a valid email value");
$validator->addValidation("email","req","Please fill in Email");
 if(!$validator->ValidateForm())
{
    echo "<B>Validation Errors:</B>";

    $error_hash = $validator->GetErrors();
    foreach($error_hash as $inpname => $inp_err)
    {
        echo "<p>$inpname : $inp_err</p>\n";
    }       
exit;}
?>

The exit(header('Location =

greg — Fri, 15 May 2009 01:33:59 +0000

The exit(header('Location = contact.html')); sends them to whatever page you put in there. But it will return a PHP error if you have already sent headers on the page. That is outputted ANYTHING, such as echoing something.
So only use it if you haven't echoed anything out.

So you could redirect the user upon a certain clause

<?php
if (something = whatever){
exit(header('Location = contact.html'));
}
?>

Perhaps INSTEAD of echo "<B>Validation Errors:</B>"; use the redirect to send them to the contact form.

Another note: You shouldn't use "or die" when the code is public. It's ok for development, but you don't want visitors to see your errors such as database xy was incorrect, or db_table xy could not be accessed.
Apart from being a "potential" security risk, it's ugly to visitors.

Dave0585 wrote:

i agree i shouldn't be doing it in reach of the public.
....there is no data on the server fot the bots to take just my test data (made up addresses etc.

It wasn't bots that concerned me, humans could hack into your DB.
Of course, if there's nothing of use there nothing is lost, and the chances are highly unlikely. I just don't like the idea.

It's easy enough to make a testing area. Make a new folder and use your control panel to password protect it.
Then anything you do in there is 99% secure from bots and humans.

Or there is the option of LAMP on your home PC. You can install linux, apache, php and mysql and get phpmyadmin with it.
Is great for developing and learning as there is not FTPing files all the time. Just save them and refresh the browser each time you try something.