PHP - Moved: Hook For Forms

ok i have a questions i making a form so when users sign up to my website they we have an account page and in the account page the will have some more fields they need to filll in which i would use INSERT to put the things inside my db but what if they want to update there account should i use  UPDATE

Hi there,

I'm new to php/MySQL.

Just wondering how to create a multipage form with a back, save and submit button. Also, how do you stored the form data into the datebase and how do you display a list of submitted forms by the user to the user.

I am starting to build out a class to handle forms. I want to be able to add and edit data in some cases and just add data in other cases. Also want to do some ajax stuff to prevent from having to reload the pages in certain cases. I would like to view how some other form classes work so I can model mine to what I like about others but suit my needs. I was wondering if anyone has worked with any preexisting form classes that they could recommend. I know libraries like zend and so on have these built in and wasnt sure if anyone liked any one specifically and why.

I need someone that is really good with php forms, looking for major help.

I am attempting to create a login page, but my script is giving errors in relation to the forms.

Involved PHP:
Code: [Select]
$username = mysql_real_escape_string($_POST['username']);

if ($_POST['submit']=='Login')
{
$md5pass = md5($_POST['password']);
$sql = "SELECT id,username FROM members WHERE
            username = '$username' AND
            password = '$md5pass'";

//etc etc...

Involved HTML:
Code: [Select]
<form id="f6" action="" method="post" onsubmit="return weCheckForm(this)">
<fieldset id="e6" class="cc32">
<label id="e5" class="cc33" for="e4">
Username
</label>
<input id="e4" class="cc34" type="text" name="username" title="username" size="23"><br>
<label id="e3" class="cc33" for="e2">
Password
</label>
<input id="e2" class="cc34" type="password" name="password" title="password" size="23"><br>
<input id="e1" class="cc35" type="submit" title="submit" value="Login">
</fieldset>
</form>

Errors received:
Notice: Undefined index: username in C:\(etc etc...) on line 4
Notice: Undefined index: submit in C:\(etc etc...) on line 6

Now I know that the problem is username and submit are undefined. However, I do not know how to define them in relation to the forms.

We have this form that customers can make their own contact forms, and then it gets inserted to the database.
We can show the forms with no problems, the problem lies when someone hits submit, how do I echo out the values of the form when I'm not sure what the input name or id is going to be?

This sample form generated this code
Code: [Select]
<div class="element">
<label id="label-element-3" class="label" style="color:#4DBCE9;font-family:Trebuchet MS;font-size:1.2em;font-weight:normal;">
<span class="labelelementvalue">Email</span>
<span class="required">*</span></label>
<div class="errormessage" id="errormessage-element-3"></div>
<div class="option-container">
<input class="af-inputtext af-email af-formvalue  " type="text" name="element-3" id="element-3" value="" style="color:#000000;font-family:Verdana;font-size:0.8em;font-weight:normal;width:260px;border-style:solid; border-color:#dcdcdc;-moz-border-radius:5px;-khtml-border-radius:5px;-webkit-border-radius:5px;border-radius:5px;border-width:1px;padding:5px;"></div>
</div>
<div class="element">
<label id="label-element-4" class="label" style="color:#4DBCE9;font-family:Trebuchet MS;font-size:1.2em;font-weight:normal;">
<span class="labelelementvalue">Textarea</span></label>
<div class="errormessage" id="errormessage-element-4"></div>
<div class="option-container">
<textarea class="af-textarea af-formvalue  " name="element-4" id="element-4" style="color:#000000;font-family:Verdana;font-size:0.8em;font-weight:normal;width:300px;border-style:solid; border-color:#dcdcdc;-moz-border-radius:5px;-khtml-border-radius:5px;-webkit-border-radius:5px;border-radius:5px;border-width:1px;padding:5px;" rows="6"></textarea></div>
</div>
<div class="element">
</div>

If you notice, each input type is named "element-" with a number afterwards.

So each input could be like "element-4", "element-21", and so forth.

How would I post those values of the input fields when they are automatically named?

Thanks in advance

i need a form that is hidden until the user clicks a button on a calendar only Then the form will be visible and have a field for the day that way pressed on submit the form would go back to being invisible. not sure how to implement this can anyone help

Hello,

I just assembly a form and for styling it I am using CSS in an external file. Problem is that IE8 and I don't know about 7  (in IE9 is ok) it doesn't show the styling inside the form... My structure is something like this:
(in any other situation my css styling is displayed normally)
Code: [Select]
<form>
<span class="myclass">

</span>
</form>Is there any fix for it?

Thank you

I am quite new to this and am working on a site of my own. I am wanting to input data into a database based on the values of two textboxes. I have the general engine set up but there are some problems.

For example when I do the INSERT with values such as:

mysql_query("INSERT INTO PageTable (uniqueid, ImageLink, ImageLink2, IP)
VALUES ('3434343',
'http://www.example.com/1.jpg',
'http://www.example.com/1.jpg',
'94.123.123.9')");

This will go into the database perfectly. However if I do this:

mysql_query("INSERT INTO PageTable (uniqueid, ImageLink, ImageLink2, IP)
VALUES ($random2,
$img1,
$img2,
$ip)");

Where random2 is rand() and img1 and img2 are the values of the text boes and ip is the ip of the user.

When I do this there is no insert into the database.

Another thing I noticed was that if I put in '111111111111111111' into the textbox the value in the database is something like 111111111111111.0904039 or something like that, however if I put '111111111111111111' into the INSERT statement it goes into the database perfectly. Also if I put '1' into the textbox it goes in fine but putting 'a' into the textbox and it doesn't! I am sure I am missing something very very basic but I just can't get my head round this! Any help would be much appreciated.

Info: When Customer clicks the "Add More Stuff" button on "/merchandise.php" to add more stuff, modify quantities, etc., the page submits to itself.

Desired: I want a "FINISHED"  button on the bottom of the page. When clicked on, Customer lands on a Thank You, "/FINISHED.php" page.

Problem: The <form action="FINISHED.php"....>  does not have access to the variables in the first form <form action="$_SERVER['PHP_SELF']">.

Question: Using Sessions, javascript, or fancy PHP, is there a way the 2nd form can capture all the data from the first form, so when Customer clicks the FINISHED button, all the variables are sent to the FINISHED.php page?

Like:
function populate_second_form(){
on-Clicking-FINISHED-button {
populate Finished-Form with all data from First-Form;
Then-submit-all-this-data-to-Finished.php page;
}
}

Reasons: There are too many PHP and Javascript variables created in the first form,  many of which I don't understand, it would take me the rest of year 2019 to go line by line and rewrite all of the code.

Requisite whining: Some code is beyond my skill level. For example, when the customer increases a quantity from "1" to "2" javascript will instantly change the displayed dollar-amount from $1.00 to $2.00 without actually "submitting/refreshing" the entire page. Though the displayed amount changes visually, the PHP $variable remains what it was until the page submits to itself. That means I cannot use $_SESSION to capture the newly-displayed amount until the page resubmits to itself.

I've tried everything I can think of.... the closest solution I've found is the new HTML5 "formaction" tag, but I'm looking for a more universal solution (doesn't work in all  browsers).

Thank you!!

 

 

Edited February 28, 2019 by StevenOliver

So I made the code as simple as possible to avoid any confusing crap:

scripttest.php:
Code: [Select]
<?php 
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'root';
$dbname = 'aosdb';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error connecting to mysql');
$idcol=7;
$j=0;
$b=1;
mysql_select_db($dbname);
$queryj = "SELECT name FROM IMPrints";
$resultj = mysql_query($queryj);
$num=mysql_num_rows($resultj);
while($j<$num){
$Column = mysql_result($resultj, $j);
echo $Column;
$queryb = "SELECT * FROM IMBuilt WHERE idcol=$idcol";
$resultb = mysql_query($queryb);
$built = mysql_fetch_row($resultb);
include("mysqltest.php");
$j++;
$b++;
}
?>

mysqltest.php:
Code: [Select]
<?php
if($_POST) {
$povar = $built[$b]+$_POST["built"][$j];
$queryi="UPDATE IMBuilt SET $Column = $povar WHERE idcol = $idcol";
mysql_query($queryi);
}
echo $povar;
?>
<form class="bd" method="post" action="scripttest.php"><input type="text" name="built[]"><input type="submit" value="Build"></form>

Everything mostly looks fine except one thing:
If I set name="built"
than no matter what form i enter the value to be added in, it affects all the values.
If I set name="built[]"
then no matter what form i enter the value to be added in, it only affects the first value.

Currently in the table there are 4 columns. Each form is supposed to edit the column value where idcol=6.
So the first one edits column Basic in the row where idcol is 6.
A value input in the second for should be added to the current value for Column Advanced where idcol=6.
But I can't get the forms, which are produced by the loop, to edit the column they are paired with.

In the display in the broswer it lists the column value correctly over each form and also the current value in the table. next to the column.
But it doesn't change the right columns.

Ok here are two of my form codes: Basically I like to use if/elseif, can someone please explain to me how these two form here can combine together so it will only have one form but do two different function (create and modify form). Then after these form being edit or create - it will go to another different page which is the confirmation page using sessions.

modify form code

<?php

    require 'includes/application.php';    
    //Define
    $name = "";
    $surname = "";
    $add = "";
    $dept= "";
    $mobile = "";
    
    if (!isset($_POST['goSubmit']))
    {
    
        $q = "SELECT * FROM persons WHERE ID = $_GET[id]";
       
        $result = mysql_query($q) or die (mysql_error());
        $row = mysql_fetch_array($result);
        
        $name = $row['name'];
        $surname = $row['surname'];
        $address = $row['address'];
        $dept = $row['dept_id'];
        $mobile = $row['mobile'];
    
        }
        
        $errormsg = "";
        
        if($name == "")
            $errormsg = $errormsg. "Name<br/ >";
            
        if ($surname == "")
            $errormsg = $errormsg. "Surname Please <br/ >";
            
        if ($mobile != "" && !is_numeric ($mobile))
            $errormsg = $errormsg. "Mobile No? <br/ >";
            
         if ($errormsg != "")
            echo "Please fill the blank info: <br/ > $errormsg";
            
            else
            {
                $input_field = "";
                
                
                foreach ($_POST as $key => $val)
                {
                    if ($key != 'goSubmit')
                    {
                    $_SESSION[$key] = $val;
                    }
                }
                
                 header("Location: confirmPage.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=iso-8859-1" />
<title>Modify Document</title>
</head>

<body>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
  <div align="center">
  <table width="300" border="1">
    <h1> Modifying A User </h1>
    
      <tr>
        <th scope="row">Name</th>
        <td><input type="text" name="name" value="<?php echo $name;?>" /></td>
      </tr>
    
    <tr>
      <th scope="row">Surname</th>
        <td>
        <input type="text" name="surname" value="<?php echo $surname; ?>" /></td>
      </tr>
    
    <tr>
      <th scope="row">Address</th>
        <td><input type="text" name="address" value="<?php echo $address; ?>" /></td>
    </tr>
      
        
    <tr>
      <th scope="row">Department</th>
        <td>
        
        <select name="dept">
            <option value="">Select..</option>

        <?php
        $data = mysql_query ("SELECT * FROM dept ORDER BY `id` DESC") or die (mysql_error());
      
          echo $data;
      
            while($row_dept = mysql_fetch_array( $data ))
        {
        ?>
        <option value="<?php echo $row_dept['id'] ;?>" <?php if($row_dept['id']==$dept){echo ' selected="selected"';}?>>
        <?php echo $row_dept['dept_name'] ;?>
        </option>
    
    <?php
    }
    ?>
        </select>
        </td>
    </tr>
    
    <tr>
      <th scope="row">Mobile</th>
        <td><input type="text" name="mobile" value="<?php echo $mobile; ?>" /></td>
      </tr>
  
  </table>
  <br/>
  
  <a href="indexPage.php">
    <input type="button" name="back" value="Back" /></a>
    
    <input type="hidden" name="id" value="<?php echo $_GET['id']; ?>">
    
    <input type="submit" name="goSubmit" value="Modify"/>
    
  </div>
</form>

</body>
</html>


create form page

<?php

    require 'includes/application.php';    
    //Define
    $name = "";
    $surname = "";
    $address = "";
    $dept= "";
    $mobile = "";

    // isset determine if a varaible is set
    
    
        
    if (isset($_POST['goSubmit']))
    {
        $name = $_POST['name'];
        $surname = $_POST['surname'];
        $address = $_POST['address'];
        $dept = $_POST['dept'];
        $mobile = $_POST['mobile'];
        
    print_r($_POST);

        $errormsg = "";
        
        if($name == "")
            $errormsg = $errormsg. "Name<br/ >";
            
        if ($surname == "")
            $errormsg = $errormsg. "Surname Please <br/ >";
            
        if ($mobile != "" && !is_numeric ($mobile))
            $errormsg = $errormsg. "Mobile No? <br/ >";
            
         if ($errormsg != "")
            echo "Please fill the blank info: <br/ > $errormsg";
            
            else
            {
                $input_field = "";
                
                
                foreach ($_POST as $key => $val)
                {
                    if ($key != 'goSubmit')
                    {
                    $_SESSION[$key] = $val;
                    
                    }
                }
                
                 header("Location: confirmPage.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=iso-8859-1" />
<title>Modify Document</title>
</head>

<body>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
  <div align="center">
  <table width="300" border="1">
    <h1> Modifying A User </h1>
    
      <tr>
        <th scope="row">Name</th>
        <td><input type="text" name="name" value="<?php echo $name;?>" /></td>
      </tr>
    
    <tr>
      <th scope="row">Surname</th>
        <td>
        <input type="text" name="surname" value="<?php echo $surname; ?>" /></td>
      </tr>
    
    <tr>
      <th scope="row">Address</th>
        <td><input type="text" name="address" value="<?php echo $address; ?>" /></td>
    </tr>
      
        
    <tr>
      <th scope="row">Department</th>
        <td>
        
        <select name="dept">
            <option value="">Select..</option>

        <?php
        $data = mysql_query ("SELECT * FROM dept ORDER BY `id` DESC") or die (mysql_error());
      
          echo $data;
      
            while($row_dept = mysql_fetch_array( $data ))
        {
        ?>
        <option value="<?php echo $row_dept['id'] ;?>" <?php if($row_dept['id']==$dept){echo ' selected="selected"';}?>>
        <?php echo $row_dept['dept_name'] ;?>
        </option>
    
    <?php
    }
    ?>
        </select>
        </td>
    </tr>
    
    <tr>
      <th scope="row">Mobile</th>
        <td><input type="text" name="mobile" value="<?php echo $mobile; ?>" /></td>
      </tr>
  
  </table>
  <br/>
  
  <a href="indexPage.php">
    <input type="button" name="back" value="Back" /></a>
    
    <input type="hidden" name="id" value="<?php echo $_GET['id']; ?>">
    
    <input type="submit" name="goSubmit" value="Modify"/>
    
  </div>
</form>
</body>
</html>


I was thinking something like these condition to do the forms but I am not exactly sure... - But after this page another confirmation page will appear once the button submitted is click.

if (isset($_GET['id']) == $id) {
  //do the modify query
  //display the modify form
} else if (isset ($_GET ['id'] == NULL) {
  //display the form where user can fill up the form
} 


OR, can I do like this instead:

if (isset ($_GET['id'])) {
  $_SESSION ['page'] = 'modify';
  //perform the modify form
} else if (isset($_GET['id'])) {
  $_SESSION ['page'] = 'create';
//perform the create form
} 


Any inputs would be appreciated...

Is it worthwhile to create an object to generate my HTML forms? 

Starting out it would appear to be worthwhile but I'm not sure how things might change later down the line when I'm doing more with my forms and introducing javascript to it.  It's a bunch of coding to change all my forms now so I wanted to hear some input before I started.  Would this be just a complete waste of server side processing?

TIA! 

Hi,

I have an HTML form created using Dreamweaver and now I need a script to handle the form processing. Basically what I need is for the form data received from the webpage to be organized in an email and then sent to me. I would also like to display a thank you message in the browser so the user knows it was received. I was planning to do this using CGI but a colleague suggested that CGI is old school and nowadays a developer would use PHP for this task. Is PHP the right solution for this project?

The examples I have found so far always include the HTML for the form and the script needed to handle it in one file. In my case, I have an HTML form already in place and need it to work with a script to perform the email function. I know I need to set "Action=" on my webpage to point to the PHP script but what would the code look like if no HTML is needed? I hope this makes sense...

Thanks for your help!
Rob

Hi everyone,

I need a little help on making forms that automatically update as you select stuff, For example if you was to select something from a drop down menu, The page will update, And show a new drop down box that will list products compatible with the fiirst product, I could easily add these to arrays, Then the script could just pull from each array.

Also I don't know if this will need any javascript... I am no good at that so please warn me if it does!

Any kind of help would be highly appreciated,
Thanks,
Gergy.