PHP - Auto Filling Form Solution ?

Hi all.

I am currently trying to build a site that will allow users to manage a self build house project.  This is my first php MySQL project but I am getting to grips with it ok.

I am currently building this for my own benefit at the moment as I am about to undertake a self build. 

I have a few questions to put to you guys.

This is where I am at the moment

I have a database table named materials which contains a list of materials , quantities, unit of measurement, id.

My site has a user control panel that has separate forms for each stage of the build where the user enters the quantities of the materials, and the data is displayed as an array for each stage.

So, heres question 1.

I want to take the data and use it to generate a form which will be completed by several merchants....

so it will display similar to the array but will be a form with a text box for price where the merchant will insert a price.

i.e

<?php 


mysql_connect ("localhost", "test", "test") or die ('I cannot connect to the database becuase: ' . mysql_error());

mysql_select_db ("matquant");

// query
$query = mysql_query("SELECT * FROM `quantites` ORDER BY `id` ASC"); 



// results
while ($row = mysql_fetch_array($query)) {
   
   echo  "<br />"   .$row ['id'].      "  "  .$row ['material'].       "     "    .$row['quantity'].  "   "    .$row['unit']. "<br />";}
echo mysql_error();
?>



I want to add a text input box form which will allow the merchant to add a price to each item that is added to the array. so there the merchant will be able to give me a price for all the items in my list.  Heres where I get stuck....  as I am constantly adding to the list I have no fixed amount of items so the form for the merchants needs to be built dynamically, ie each time I add a new material, I want the merchants form to get a new input.

I am not very good at describing my problems but I am hoping that someone can help me out from the information given.

Thats the first question.  i like to get issues sorted in small bites. 

the second is the next big bite,  I want to send the form above to several merchants, so I intend to have a user database with a user for each merchant, and link the tables so that each merchant can provide a price for each material, ideally the form would highlight the materials that have not had  a price yet.

I'm looking for advice on the best method of doing this basically but if I can get the first question sorted that would be great..

I have the test site local but can upload it it to the server if it will help you see what im trying to do.

Any help that anyone can give will be greatly appreciated.

Here's my code, whenever I try to fill the form it gives me that error "Oops! Something went wrong. Please try again later"

 

Code: 

<?php
// Include config file
require_once "config.php";
 
// Define variables and initialize with empty values
$CodEntrega = $CodCliente = $Dia = $Pagamento = $Funcionario = "";
$CodEntrega_err = $CodCliente_err = $Dia_err = $Pagamento_err = $Funcionario_err = "";
 
// Processing form data when form is submitted
if($_SERVER["REQUEST_METHOD"] == "POST"){
    // Validate name
    $input_CodEntrega = trim($_POST["CodEntrega"]);
    if(empty($input_CodEntrega)){
        $CodEntrega_err = "Insira o codigo de entrega";
    } else{
        $CodEntrega = $input_CodEntrega;
    }
    
    // Validate address
    $input_CodCliente = trim($_POST["CodCliente"]);
    if(empty($input_CodCliente)){
        $CodCliente_err = "Insira o codigo do cliente";     
    } else{
        $CodCliente = $input_CodCliente;
    }
    
    // Validate salary
    $input_Dia = trim($_POST["Dia"]);
    if(empty($input_Dia)){
        $Dia_err = "Insira a data da entrega"; 
    } else{
        $Dia = $input_Dia;
    }
    
    $input_Pagamento = trim($_POST["Pagamento"]);
    if(empty($input_Pagamento)){
        $Pagamento_err = "Insira o tipo de pagamento"; 
    } else{
        $Pagamento = $input_Pagamento;
    }
    
    $input_Funcionario = trim($_POST["Funcionario"]);
    if(empty($input_Funcionario)){
        $Funcionario_err = "Insira o codigo do funcionario"; 
    } else{
        $Funcionario = $input_Funcionario;
    }
    
    if(empty($CodEntrega_err) && empty($CodCliente_err) && empty($Dia_err) && empty($Pagamento_err) && empty($Funcionario_err)){
       
        $sql = "INSERT INTO entrega(CodEntrega, CodCliente, Dia, Pagamento, Funcionario) VALUES (?, ?, ?, ?, ?)";
         
        if($stmt = mysqli_prepare($link, $sql)){
            // Bind variables to the prepared statement as parameters
            mysqli_stmt_bind_param($stmt, "ssdss", $param_CodEntrega, $param_CodCliente, $param_Dia, $param_Pagamento, $param_Funcionario);
            
            // Set parameters
            $param_CodEntrega= $CodEntrega;
            $param_CodCliente = $CodCliente;
            $param_Dia = $Dia;
            $param_Pagamento = $Pagamento;
            $param_Funcionario = $Funcionario;
            
            if(mysqli_stmt_execute($stmt))
            {
                header("location: home.html");
                exit();
            } 
            else
            {
                echo "Oops! Something went wrong. Please try again later.";
            }
        }
         
        // Close statement
        mysqli_stmt_close($stmt);
    }
    
    // Close connection
    mysqli_close($link);
}
?>
 
<!DOCTYPE html>
<html lang="en">
<head>
<title>Projeto TW</title>
<link rel="stylesheet" href="css/milligram.css">
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
* {
  box-sizing: border-box;
}

body {
  font-family: Arial, Helvetica, sans-serif;
}

/* Style the header */
header {
  background-color: #B0171F;
  padding: 30px;
  text-align: center;
  font-size: 35px;
  color: white;
}

/* Create two columns/boxes that floats next to each other */
nav {
  float: left;
  width: 30%;
  height: 300px; /* only for demonstration, should be removed */
  background: #ccc;
  padding: 20px;
}

/* Style the list inside the menu */
nav ul {
  list-style-type: decimal;
  padding: 0;
}

article {
  float: left;
  padding: 20px;
  width: 70%;
  background-color: #f1f1f1;
  height: 300px; /* only for demonstration, should be removed */
}

/* Clear floats after the columns */
section::after {
  content: "";
  display: table;
  clear: both;
}

/* Style the footer */
footer {
  background-color: #B0171F;
  padding-top: 7px;
  padding-bottom: 7px;
  text-align: middle;
  color: white;
  position: relative;
  bottom: 0;

}

#content-wrap {
  padding-bottom: 2rem;    /* Footer height */
}

#page-container {
  position: relative;
 
}

@media (max-width: 600px) {
  nav, article {
    width: 100%;
    height: auto;
  }
}

.dropbtn {
  background-color: #4CAF50;
  color: white;
  padding: 16px;
  font-size: 16px;
  border: none;
}


.dropdown {
  position: relative;
  display: inline-block;
}


.dropdown-content {
  display: none;
  position: absolute;
  background-color: #f1f1f1;
  min-width: 160px;
  box-shadow: 0px 8px 16px 0px rgba(0,0,0,0.2);
  z-index: 1;
}


.dropdown-content a {
  color: black;
  padding: 12px 16px;
  text-decoration: none;
  display: block;
}


.dropdown-content a:hover {background-color: #ddd;}


.dropdown:hover .dropdown-content {display: block;}


.dropdown:hover .dropbtn {background-color: #3e8e41;}

</style>
</head>
<body>


<header>
  <div class="head1">PROJETO DE TW</div> 
  <div class="head2">Gestão de uma BD</div>
</header>

<div class='container'>
      <div class='navbar'>
        <ul>
          <li><a class="active" href="home.html">Home</a></li>
          <li><a href="#consultar">Consultar</a></li>
          <li><a href="tabela.html">Inserir</a></li>
          <li><a href="#alterar">Alterar</a></li>
          <li><a href="#eliminar">Eliminar</a></li>
        </ul>
      </div> 
   <div class = "body_sec"> 
      <section id="Content"> 
         <h3>INSERIR DADOS DE ENTREGA</h3>
         <button type="button" >ENTREGA</button>         
      </section>
                    <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">
                        <div class="form-group">
                            <label>CodEntrega</label>
                            <input type="text" name="CodEntrega" class="form-control <?php echo (!empty($CodEntrega_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $CodEntrega; ?>">
                            <span class="invalid-feedback"><?php echo $CodEntrega_err;?></span>
                        </div>
                        <div class="form-group">
                            <label>CodCliente</label>
                            <input type="text" name="CodCliente" class="form-control <?php echo (!empty($CodCliente_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $CodCliente; ?>">
                            <span class="invalid-feedback"><?php echo $CodCliente_err;?></span>
                        </div>
                        <div class="form-group">
                            <label>Dia de Entrega</label>
                            <input type="date" name="Dia" class="form-control <?php echo (!empty($Dia_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $Dia; ?>">
                            <span class="invalid-feedback"><?php echo $Dia_err;?></span>
                        </div>
                        <div class="form-group">
                            <label>Pagamento</label>
                            <input type="text" name="Pagamento" class="form-control <?php echo (!empty($Pagamento_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $Pagamento; ?>">
                            <span class="invalid-feedback"><?php echo $Pagamento_err;?></span>
                        </div>
                        <div class="form-group">
                            <label>Codigo do Funcionario</label>
                            <input type="text" name="Funcionario" class="form-control <?php echo (!empty($Funcionario_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $Funcionario; ?>">
                            <span class="invalid-feedback"><?php echo $Funcionario_err;?></span>
                        </div>
                        <input type="submit" class="btn btn-primary" value="Submit">
                        <a href="home.html" class="btn btn-secondary ml-2">Cancel</a>
                    </form>
                </div>
            </div>        
        </div>
    </div>
</body>
</html>

 

 

Edited May 10 by Barand
code tags added

I have read around and can't seem to find the right coding for what I need on this forum and some other other forums.

I have a contact form (as listed below) and I need 2 locations (Print Name and Title) fields to auto-populate on a separate form (can be a doc, pdf, etc. any form of document which is easiest) and this form can be totally back end and the individual using the form never is going to see the form.

It's going on a contract form, that we would like to auto-populate.

Also is there a simple attachment code so individuals can attach documents to the code?


<p style: align="center"><form action="mailtest.php" method="POST">
<?php
$ipi = getenv("REMOTE_ADDR");
$httprefi = getenv ("HTTP_REFERER");
$httpagenti = getenv ("HTTP_USER_AGENT");
?>

<input type="hidden" name="ip" value="<?php echo $ipi ?>" />
<input type="hidden" name="httpref" value="<?php echo $httprefi ?>" />
<input type="hidden" name="httpagent" value="<?php echo $httpagenti ?>" /> 
<div align="center">
<p class="style1">Name</p> 
<input type="text" name="name">
<p class="style1">Address</p> 
<input type="text" name="address">
<p class="style1">Email</p> 
<input type="text" name="email">
<p class="style1">Phone</p> 
<input type="text" name="phone">
<p class="style1">Debtor</p> 
<input type="text" name="debtor">
<p class="style1">Debtor Address</p> 
<input type="text" name="debtora">
<br />
<br />
<a href="authoforms.php" target="_blank" style="color:#ffcb00"  vlink="#ffcb00">Click here to view Assignment Agreement and Contract Agreement</a>

<p class="style1"><input type='checkbox' name='chk' value='I Have read and Agree to the terms.'> I have read and agree to the Assignment and Contract Agreement <br></p>
<p class="style1">Print Name</p> 
<input type="text" name="pname">
<p class="style1">Title</p> 
<input type="text" name="title">


<p class="style1">I hear by agree that the information I have provided is true, accurate and the information I am submitting is <br />
not fraudulent. Please click the agree button that you adhere to Commercial Recovery Authority Inc.'s terms:</p>
<select name="agree" size="1">
<option value="Agree">Agree</option>
<option value="Disagree">Disagree</option>
</select>
<br />
<br />
<p class="style1">Employee ID:</p> 
<input type="text" name="employee">

<br />

<input type="submit" value="Send"><input type="reset" value="Clear">
</div>
</form>
</p>


The mailtest php is this
?php
$ip = $_POST['ip'];
$httpref = $_POST['httpref'];
$httpagent = $_POST['httpagent'];
$name = $_POST['name'];
$address = $_POST['address'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$debtor = $_POST['debtor'];
$debtora = $_POST['debtora'];
$value = $_POST['chk'];
$pname = $_POST['pname'];
$title = $_POST['title'];
$agree = $_POST['agree'];
$employee = $_POST['employee'];
$formcontent=" From: $name \n Address: $address \n Email: $email \n Phone: $phone \n Debtor: $debtor \n Debtor's Address: $debtora \n 'Client' has read Assignment and Contract Agreement: $value \n Print Name: $pname \n Title: $title \n I hear by agree that the information I have provided is true, accurate and the information I am submitting is not fraudulent. Please click the agree button that you adhere to Commercial Recovery Authority Inc.'s terms: $agree \n \n  Employee ID: $employee \n IP: $ip";
$recipient = "mail@crapower.com";
$subject = "Online Authorization Form 33.3%";
$mailheader = "From: $email \r\n";
mail($recipient, $subject, $formcontent, $mailheader) or die("Error!");
echo "Thank You!" . " -" . "<a href='index.php' style='text-decoration:none;color:#ffcb00;'> Return Home</a>";
$ip = $_POST['visitoraddress']
?>

Hi All

Not sure if this is possible, but I spend loads of time filling in the same form on a 3rd party website when people send me their details to check. 

Is there any way I am able to build a php script to read and check their details (can do this bit) and then submit them to a form on another website (can't do this bit)?  The form is a hotel booking form and is spread over 4 pages.

I am creating a simple web application that allows the user to update information in a database. I have a selector that allows the user to select what record they want to update and then a form field to insert the data to be updated. I want the form to to be passed the data from the selected entry "when selected" to auto-complete the default values of the text fields so the user can see the information right in the text fields.

This is the form
Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>

<head>
  <title>Tom's Culture Database</title>
  <meta name="GENERATOR" content="Quanta Plus">
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<style>

body {
  }


h3 {
    color: #585858;
  }


h4 {
    color : #c00000;
  }


th {
    background : #000000;
    border : #ffffff solid 1px;
    color : #ff0000;
    text-align : left;
  }


.form_wrapper {
    background : #000000;
    padding : 10px;
    border : solid 2px;
  }


#form_inner {
    padding : 0 0 0 5px;
    display : inline-block;
  }


td {
    border : #000000 solid 1px;
  }

</style>
<body>

<?php
//CONNECT INCLUDE
require("connect.php");


//SELECT DATABASE
$sql_user_info = mysql_query("SELECT * FROM collections ORDER BY id ASC");

//BEGIN FORM
echo "<h3>Select an entry to update or delete!</h3>
<form action='mysql_update_action.php' method='POST'><select name='name_select'>";


while ($row = mysql_fetch_assoc($sql_user_info))

{
$id =  $row['id'];
$genus = $row['genus'];
$species =  $row['species'];
$strain_name=   $row['strain_name'];




echo "
<option value = '$id'>$id : $genus $species $strain_name</option>
";

}

echo "</select> <br><br><br>
<DIV class='form_wrapper'>
<DIV  id='form_inner' align=\"left\"><h4>Genus Name:</h4><INPUT type=\"text\" name=\"to_change_genus_name\"></DIV>
<DIV  id='form_inner' align=\"left\"><h4>Species Name:</h4><INPUT type=\"text\" name=\"to_change_species_name\"></DIV>
<DIV  id='form_inner' align=\"left\"><h4>Strain Name:</h4><INPUT type=\"text\"name=\"to_change_strain_name\"></DIV>
<DIV  id='form_inner' align=\"left\"><h4>P-Value:</h4><INPUT type=\"text\" name=\"to_change_p_value\"></DIV>
<DIV  id='form_inner' align=\"left\"><h4>Origin:</h4><INPUT type=\"text\" name=\"to_change_origin\"></DIV>
<DIV  id='form_inner' align=\"left\"><h4>Get From:</h4><INPUT type=\"text\" name=\"to_change_get_from\"></DIV>
<DIV  id='form_inner' align=\"left\"><h4>Qty:</h4><INPUT type=\"text\" name=\"to_change_qty\"></DIV>
<DIV  id='form_inner' align=\"left\"><h4>Created:</h4><INPUT type=\"text\" name=\"to_change_date_created\" value=\"M/D/Y\"></DIV><br>
<DIV  id='form_inner' align=\"left\"><h4>Working Collection:</h4><INPUT type=\"checkbox\" name=\"to_change_work_collection\"></DIV>
<DIV  id='form_inner' align=\"left\"><h4>DNA Check:</h4><INPUT type=\"checkbox\" name=\"to_change_dna_check\">
</DIV>



<br><br>


<INPUT type='submit' name='change' value='Update'>
<INPUT type='submit' name='name_delete' value='Delete'>
</form></DIV>";
//END FORM



?>
<?php

//SELECT DATABASE
$sql_user_info = mysql_query("SELECT * FROM collections ORDER BY id");


while ($row = mysql_fetch_assoc($sql_user_info))

{
$id =  $row['id'];
$genus =  $row['genus'];
$species =  $row['species'];
$strain_name = $row['strain_name'];
$p_value = $row['p_value'];
$origin = $row['origin'];
$get_from = $row['get_from'];
$qty = $row['qty'];
$work_collection = $row['work_collection'];
$dna_check = $row['dna_check'];
$date_created = $row['date_created'];
$last_modified = $row['last_modified'];


if  ($work_collection == "0"){
  $work_collection = "no";
}
else {
$work_collection = "yes";
}

// Define $color=1

echo "<br>";
echo "<table width='400' border='1' align='left' cellpadding='2' cellspacing='0'>";
echo "<tr><th>ID</th><th>Genus</th><th>Species</th><th>Strain Name</th><th>P-Value</th></tr>";
$color= 1;

// If $color==1 table row color = #FFC600
if($color==1){
echo "<tr bgcolor='#808080'><td>".$id."</td><td>".$genus."</td><td>".$species."</td></tr>";
// Set $color==2, for switching to other colors
$color=2;
}

// When $color not equal 1, use this table row color
else {
echo "<tr bgcolor='#ffffff'><td>".$id."</td><td>".$genus."</td><td>".$species."</td></tr>";
// Set $color back to 1
$color='1';
}


echo "</table>";

}


?>
</body>
</html>
This is the update actions
Code: [Select]
<?php

//CONNECT INCLUDE
require("connect.php");


//GRAB DATA
$name_select  =  $_POST['name_select'];
$name_delete  =  $_POST['name_delete'];

$to_change_genus_name   =  $_POST['to_change_genus_name'];
$to_change_species_name   =  $_POST['to_change_species_name'];
$to_change_strain_name   =  $_POST['to_change_strain_name'];
$to_change_p_value   =  $_POST['to_change_p_value'];
$to_change_origin   =  $_POST['to_change_origin'];
$to_change_get_from   =  $_POST['to_change_get_from'];
$to_change_qty   =  $_POST['to_change_qty'];
$to_change_work_collection   =  $_POST['to_change_work_collection'];
$to_change_dna_check   =  $_POST['to_change_dna_check'];
$to_change_date_created   =  $_POST['to_change_date_created'];


$date = strtotime("now");
$current_date = date("m/d/y", $date);

if  ($name_select&&$to_change_genus_name&&$_POST['change'])

{

$change = mysql_query("UPDATE collections SET genus='$to_change_genus_name', species='$to_change_species_name' WHERE id='$name_select'");
echo "<br><h2>Data updated</h2><br>";
header( 'Location: http://localhost/sam/Mycelium.eu/mysql_update.php' ) ;
}

 
elseif  ($_POST['name_delete'])

{
$delete = mysql_query("DELETE FROM collections WHERE id='$name_select'");
echo "<br><h2>Data deleted</h2><br>";
header( 'Location: http://localhost/sam/Mycelium.eu/mysql_update.php' ) ;
}


else
echo "Please enter some Information";
header( 'Location: http://localhost/sam/Mycelium.eu/mysql_update.php' ) ;
?>

Greetings,

I am trying to create a basic booking system, for example there may be 3 events that a user can book. If the user clicks 'Book Now' on Event #1

I need it to take them to the HTML/PHP booking form with the information already entered that is relevant to Event #1 (Or whatever event they choose), such as the event name, time, date etc

I know how to create a contact form etc, its just the carrying of the information over to the form I dont know how to do.

Does anyone know if this is possible/ how it could be achieved?

Any help will be much appreciated,
Thanks!

Here goes. I am trying to retrieve info. from mySql database and update 3 textfields. I also have 4 selects on the form that need populating during the running of the program. My problem is using console I can see the info - Customer name - but it does not appear in the text field. The onchange request in the DIV container seems to be where it fails. Here are the files I am using:   1. add_an_order.php   <html>
<head>

<title>Add an Order</title>
     
<link href = "css/style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="include/jquery-1.11.1.min.js"></script>

</head>

<body>
    
<div id="header"><img src="images/logo.png" /></div>

<div id="nav">
    
    <div id="nav_wrapper">
        <ul>
            <li><a href="index.php">Orders</a></li><li>
            <a href="customers.php">Customers</a></li><li>
            <a href="contacts.php">Contacts</a></li><li>
            <a href="batteries.php">Batteries</a></li><li>
            <a href="#">Queries</a>
            </li>
        </ul>
    </div>
    
</div>

<div id="main">

<?php

echo '<h3 id="menOpt">Add an Order</h3><hr>';

// Check for a form submission.
/*
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        
    $errors = array();
    
    $required_fields = array('customer_name', 'customer_address', 'city', 'telephone');
    foreach ($required_fields as $fieldname) {
        if (!isset($_POST[$fieldname]) || empty($_POST[$fieldname])) {
            $errors[] = strtoupper($fieldname);
        }
    }
    
    if (empty($errors)) {
            
        include ('include/dbconnect.php');
        
        $name = mysqli_real_escape_string($con, trim(strip_tags($_POST['customer_name'])));
        $contact = mysqli_real_escape_string($con, trim(strip_tags($_POST['contact'])));
        $address = mysqli_real_escape_string($con, trim(strip_tags($_POST['customer_address'])));
        $city = mysqli_real_escape_string($con, trim(strip_tags($_POST['city'])));
        $telephone = mysqli_real_escape_string($con, trim(strip_tags($_POST['telephone'])));
        $telephone = preg_replace('/[^0-9]/', '', $telephone);
        
        if (isset($_POST['deepc'])) {
            $deepc = 1;
        } else {
            $deepc = 0;
        }
        
        if (isset($_POST['problemc'])) {
            $problemc = 1;
        } else {
            $problemc = 0;
        }
        
        $problem = mysqli_real_escape_string($con, trim(strip_tags($_POST['problem'])));
        
        if (isset($_POST['blacklist'])) {
            $blacklist = 1;
        } else {
            $blacklist = 0;
        }
        
        if (isset($_POST['pickup'])) {
            $pickup = 1;
        } else {
            $pickup = 0;
        }
        
        
        $query = "INSERT INTO customers (
                    customer_name, contact, customer_address, city, telephone, deep_cycle,
                    problem_customer, problem, blacklist, pickup)
                  VALUES ('$name', '$contact', '$address', '$city', '$telephone', $deepc,
                    $problemc, '$problem', $blacklist, $pickup)";
        
        $r = mysqli_query($con, $query);
        
        if (mysqli_affected_rows($con) == 1) {
                
            echo '<p class="success">Customer has been successfully added.</p>';
            
        } else {
                
            $message = "Could not add customer.";
            $message .= "<br />" . mysqli_error($con);
            
        }
        
        mysqli_close($con);
        
    } else {  // We have errors.
        
        $message = count($errors) . " error(s) on the form.";
        
    }
    
} // End: if ($_SERVER['REQUEST_METHOD'] == 'POST').

*/

// Leave PHP and display the form.
?>

<?php if (!empty($message)) {
    echo '<p class="error">' . $message . '</p>';
} ?>
<?php
// Output list of fields that have errors.
if (!empty($errors)) {
    echo '<p class="error">';
    foreach ($errors as $error) {
        echo $error . '<br />';
    }
    echo '</p>';
}

?>

<div class="container">
    <form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
        <fieldset>
            <label>Business: <span class="important"> *</span><select name="customer_name" id="customer_name" onchange="request_fill(this.value)"
                value="<?php if (isset($_POST['customer_name'])) echo $_POST['customer_name']; ?>" ></select></label>
            <label>Address: <input type="text" name="address" id="add_a"
                value="<?php if (isset($_POST['customer_address'])) echo $_POST['customer_address']; ?>" /></label>
            <label>City: <input type="text" name="city" id="city"
                value="<?php if (isset($_POST['city'])) echo $_POST['city']; ?>" /></label>
            <label>Phone: <input type="text" name="telephone"
                value="<?php if (isset($_POST['telephone'])) echo $_POST['telephone']; ?>" /></label>

            <label>Manufacturer: <span class="important"> *</span><select name="manufacturer" id="manufacturer" onchange="request_mod(this.value)"
                value="<?php if (isset($_POST['manufacturer'])) echo $_POST['manufacturer']; ?>" ></select></label>

            <label>Model: <span class="important"> *</span><select name="model" id="model" onchange="form_yr(this.value)"
                value="<?php if (isset($_POST['model'])) echo $_POST['model']; ?>" ></select></label>
            
            <label>Year: <span class="important"> *</span><select name="battery" id="bat_disp"
                value="<?php if (isset($_POST['battery'])) echo $_POST['year'] ?>" ></select></label>

            <label>Quantity: <span class="important"> *</span><input type="text" name="quantity" id="quantity"
                value="<?php if (isset($_POST['quantity'])) echo $_POST['quantity']; ?>" /></label>
            <label>Warranty ? <input type="checkbox" name="warranty"
                <?php if ($_POST['warranty']) echo " checked"; ?> /></label>
            <label>Exchange ? <input type="checkbox" name="exchange"
                <?php if ($_POST['exchange']) echo " checked"; ?> /></label>
            <input type="submit" name="submit" value="Add Order" /> or
                    <a href="index.php">Cancel</a>
        </fieldset>
    </form>
</div>

<script type="text/javascript" src="include/functions.js"></script>

<script>
$(document).ready(function() {

    $('.container').hide();
    $('.container').fadeIn(1000);

    request_cust();
    request_man();

});
</script>

<?php include ('include/footer.php');           2. request_fill       function request_fill() {

    var cust2 = 'customer';
    var ad = document.getElementById("add_a");
    
    var hr = new XMLHttpRequest();
    hr.open("POST", "battery_parser.php", true);
    hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    hr.onreadystatechange = function() {

        if(hr.readyState == 4 && hr.status == 200) {

            var dataArray = hr.responseText;

            ad.innerHTML = dataArray[1];
            
        }
    }

    hr.send("&cust2="+cust2);  
}       3. battery_parser.php       <?php   include_once("include/dbconnect.php");   if (isset($_POST['cust2'])) {
        $cust2 = $_POST['cust2'];
        $sql = "SELECT customer_address FROM customers WHERE customer_id = 2";
        $query = mysqli_query($con, $sql);
        $dataString = '';
        while($row = mysqli_fetch_array($query, MYSQLI_ASSOC)){
            $add = $row["customer_address"];
            $dataString = $add;  
        }
        mysqli_close($con);
    
        echo $dataString;
        exit();

    } else {
        exit();
    }

?>

Hey Everyone,

I'll start by saying that I am a very novice php programmer. But I am working on a file storage website, and I have it working and running properly, what you see here is on a new page called index2.php (Thought you might need to know) and full working version can be found here, http://www.jstpreview.net84.net now want I want the site to do is automatically generate a new .php or .html page once the user presses the "submit" button, I've looked through many tutorials to figure this out but anything I have tried so far didn't work. So anyways, the page generated should be named the name of the file uploaded plus the extension. I also want this page to be generated using a pre-uploaded template but if you look at the code, you will see that I havn't implemented that part yet.

Code: [Select]
<?php 
//Load the settings
require_once("settings.php");


$message = "";
//Has the user uploaded something?
if(isset($_FILES['file']))
{

$target_path = Settings::$uploadFolder;
$target_path = $target_path . time() . '_' . basename( $_FILES['file']['name']); 

//Check the password to verify legal upload
if($_POST['password'] != Settings::$password)
{
$message = "Invalid Password!";
}
else
{
//Try to move the uploaded file into the designated folder
if(move_uploaded_file($_FILES['file']['tmp_name'], $target_path)) {
    $message = "The file ".  basename( $_FILES['file']['name']). 
    " has been uploaded";
} else{
    $message = "There was an error uploading the file, please try again!";
}
}

//Clear the array
unset($_FILES['file']);
}



if(strlen($message) > 0)
{
$message = '<p class="error">' . $message . '</p>';
}

/** LIST UPLOADED FILES **/
$uploaded_files = "";

//Open directory for reading
$dh = opendir(Settings::$uploadFolder);

//LOOP through the files
while (($file = readdir($dh)) !== false) 
{
if($file != '.' && $file != '..')
{
$filename = Settings::$uploadFolder . $file;
$parts = explode("_", $file);
$size = formatBytes(filesize($filename));
$added = date("m/d/Y", $parts[0]);
$origName = $parts[1];
$filetype = getFileType(substr($file, strlen($file) - 3));
        $uploaded_files .= "<li class=\"$filetype\"><a href=\"$filename\">$origName</a> $size - $added</li>\n";
}
}
closedir($dh);

if(strlen($uploaded_files) == 0)
{
$uploaded_files = "<li><em>No files have been uploaded yet!</em></li>";
}

function getFileType($extension)
{
$images = array('jpg', 'gif', 'png', 'bmp');
$docs  = array('txt', 'rtf', 'doc');
$apps  = array('zip', 'rar', 'exe');

if(in_array($extension, $images)) return "Images";
if(in_array($extension, $docs)) return "Documents";
if(in_array($extension, $apps)) return "Applications";
return "";
}

function formatBytes($bytes, $precision = 2) { 
    $units = array('B', 'KB', 'MB', 'GB', 'TB'); 
   
    $bytes = max($bytes, 0); 
    $pow = floor(($bytes ? log($bytes) : 0) / log(1024)); 
    $pow = min($pow, count($units) - 1); 
   
    $bytes /= pow(1024, $pow); 
   
    return round($bytes, $precision) . ' ' . $units[$pow]; 
} 

?>

<!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" />
<style type="text/css" media="all">
@import url("style/style.css");
</style>
<script src="http://code.jquery.com/jquery-latest.js"></script>
<title>JetStorm Technologies | Staff - CloudNet</title>
</head>
<body>

<div id="container">


<h1></h1>

<form method="post" action="index.php" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="15728640" />
<fieldset>
<legend>Add a new file to CloudNet:</legend>
<?php echo $message; ?>
<p><label for="name">Select file:</label><br />
<input type="file" name="files" /></p>
<p><label for="password">Authentication for upload:</label><br />
<input type="password" name="password" /></p>
<p><input type="submit" name="submit" value="Start upload" /></p>


</fieldset>
</form>
<fieldset>

<center>

<?php

if(isset($_FILES['file']));
//else $file=1;
$file = $_POST["$origName"]; // grabbed from the form
$file = fopen("filepages/" . $origName .".php","x"); //(Creates the file)
fwrite($out, "<p> Man this really does not work $origName</p>"); // Generates the contents of file

?>
</center>

</fieldset>

<fieldset>
<legend>Previousely uploaded files</legend>
<ul id="menu">
<li><a href="">All files</a></li>
<li><a href="">Documents</a></li>
<li><a href="">Images</a></li>
<li><a href="">Applications</a></li>
</ul>

<ul id="files">
<?php echo $uploaded_files; ?>
</ul>
</fieldset>

</div>

<script src="js/filestorage.js" />
</body>
</html>
I would greatly appreciate it if someone can point out and fix the errors in this code, but it would be even more appreciated if someone could provide a working source code of auto-generation of pages on form submit.

Thanks in advanced

I have a form which creates a drop down list from data in a MySQL database. I would like to be able to have data from my database automatically populate based upon the selection from the list. How can I do that? Javascript? AJAX? Any help would be appreciated.


Code: [Select]
<?php $query2="SELECT tournament,id FROM 2011_Tournament";
$result2=mysql_query($query2);
echo "<select name=2011_Tournament value='tournament'>Tournament</option>";
while($tournament=mysql_fetch_array($result2)){
echo "<option value='$tournament[tournament]'>$tournament[tournament]</option>";
}
echo "</select>";?>

Can anyone please help me write out a php script exactly as described below?

In the submission form, users are required to filled in two infos,..
Name and email address.

As soon as the 'submit' button is been clicked, the php script should be able to grab the filled infos and stores it on the server in a txt file and at the same time, it should sends out confirmation email to the email address so filled in the submission form.

Also, can anyone devise a method as how to retrieve the message body of the confirmation email from the previous php script and then pass it on again to the display of the next page as when the submission button is clicked?

Thank you so much in advance.

Can someone help me with this.. I cannot figure out why it will not log in..  The actual url and user/pass are valid so feel free to test the live site.



<?php 
// INIT CURL 
$ch = curl_init(); 
 
// SET URL FOR THE POST FORM LOGIN 
curl_setopt($ch, CURLOPT_URL, 'http://www.handy-hanky.com/shirley/homesell_cron.htm'); 
 
// ENABLE HTTP POST 
curl_setopt ($ch, CURLOPT_POST, 1); 
 
// SET POST PARAMETERS : FORM VALUES FOR EACH FIELD 
curl_setopt ($ch, CURLOPT_POSTFIELDS, 'user=tom&pass=test&login_theme=cpanel'); 
 
 
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); 
 
// EXECUTE 1st REQUEST (FORM LOGIN) 
$store = curl_exec ($ch); 
 
echo "STORE = $store<br>";


// CLOSE CURL 
curl_close ($ch);  
 
?>

I am having trouble setting a checkbox to "checked" if the row "published" is set to "1" (0 being not checked). I know this involves an if published==1 then print "checked", but i just cant get it to work. Any help would be greatly apprecatied:


<?php
include "base.php";

$sql="SELECT * FROM project";
$result=mysql_query($sql);

// Count table rows
$count=mysql_num_rows($result);
?>
<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">
<tr>
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">


<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>title</strong></td>
<td align="center"><strong>Published</strong></td>
<td align="center"><strong>Promoted</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){

$pub = $rows['publised'];

?>
<tr>
<td align="center"><? $id[]=$rows['id']; ?><? echo $rows['id']; ?></td>
<td align="center"><? echo $rows['title']; ?></td>
<td align="center"><input name="published[]" type="checkbox" id="published" value="<? echo $rows['published']; ?>"></td>
<td align="center"><input name="promoted[]" type="text" id="promoted" value="<? echo $rows['promoted']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<?php
// Check if button name "Submit" is active, do this
if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE project SET published='$published[$i]', promoted='$promoted[$i]' WHERE id='$id[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1){
header("location:update_multiple.php");
}
mysql_close();
?>

 

Hi all,

I am not sure if this is possible but I am trying to provide people a link to a page (not mine btw) with values already filled in. So for them it's faster to submit the form. Problem is the Form is using method post.

what i tried was the following but it didn't work.
there is an input field:
Code: [Select]
<input type="text" value="" maxlength="255" size="10" id="numpoints" name="numpoints" class="inputbox required">So i thought if I just make an url like : http://godzillaeatsbananas.com/index.php?numpoints=100
it would fill in the field with a value of 100 but it doesn't

Anyone might have an idea on how to accomplish this.
Thanks!

I have developed a form for my website that directs the user to a different site and per-populates the form on the other site with information I want.  I would like to take it one step further and make the below script fill out the form on the other site and then submit the form.  Currently it just fills out the form on the other site but does not submit it.  Is there any way to do this?

Code: [Select]
<form action="http://www.privatedutyhomecare.org/sections/consumers/locator.php" method="POST">
<input name="state" size="25" type="hidden" value="MI" />
<input name="company" size="25" type="hidden" value="Affordable HomeCare" />
<button type="submit" class="imgpx">
<img src="assets/images/logos/npda.png" alt="submit" width="51" class="nothing" height="40" />
</button>
</form>

Hello all, looking for some help here as I seem to be fairly stuck... this yields no results at all and I give up, I need help! The user should be able to select an employee from a select field, and based on their selected we should be able to grab the start time and end time of that empoyee, which resides on the database.   My form:

<form action=".php" name="absence" id="absence" method="post">

Employee:
<select name="empid" class="clockinputs" required> 
<option value=""></option>
<option value='20'>Bob Jones</option>
<option value='13'>Bob Phones</option>
<option value='93'>Bob Lomes</option>
<option value='30'>Bob Somes</option>
<option value='107'>Bob Pomes</option>
<option value='74'>Bob Womes</option>
</select>

Shift Start: <input type="text" name="startshift" id="startshift" class="clockinputs" data-inputmask="'mask': '99:99:99'" required>
Shift End: <input type="text" name="endshift" id="endshift" class="clockinputs" data-inputmask="'mask': '99:99:99'" required>

<input type="hidden" name="eid" value="<?php echo $row{'EID'}; ?>">
<input type="submit" value="Save">
</form>

Javascript:

<script type="text/javascript">
    jQuery(document).ready(function(){
        jQuery('#empid').live('change', function(event) {
            $.ajax({
                url     : 'absence-get.php',
                type    : 'POST',
                dataType: 'json',
                data    : $('#absence').serialize(),
                success: function( data ) {
                       for(var id in data) {        
                              $(id).val( data[id] );
                       }
                }
            });
        });
    });
    </script>

And absence-get.php:

<?php
$e = $_POST['empid'];

$result = mysql_query("SELECT * FROM employees WHERE EID='$e' ");
$row = mysql_fetch_array($result, MYSQL_ASSOC)

$startshift = $row{'startshift'};
$endshift = $row{'endshift'};

$arr = array( 'input#startshift' => $startshift , 'input#endshift' => $endshift );
echo json_encode( $arr );
?>

Anyone spot anything? Thank you!