PHP - Need Help With Php Forms And Mysql

Hi,

I am trying to write an input form for a table that the fields contains codes of records from other tables. Is there a way that after each field I can retrieve (validate) the value of the fields that contain a code from a table and display them on the screen when the use move to the next field?

The table is a customers order and I want to validate and display the customer name after they key in the customer code and the same for the product's code.

Thank!

James

Hi all

I am trying to take the data from a form and add into a mySQL table.

I have multiple forms on one page that uses a loop:

Code: [Select]
<?php

$textqty = $showbasket['qty'];
for ($i = 1; $i <= $textqty ; $i++) { ?>
           
<form id="texts" name="texts" method="post" action="">
             <input name="mainqty" type="hidden" value="<?php echo $textqty; ?>" />
             <input name="productid" type="hidden" value="<?php echo $showbasket['productid']; ?>" />
             <input name="productqtyid" type="hidden" value="<?php echo $i; ?>" />
              <input name="productsize" type="hidden" value="<?php echo $showbasket['size']; ?>" />
                Text:
                  <input name="text_<?php echo $i; ?>" type="text" value="<?php echo $showtext['text']; ?>" size="35" maxlength="250" />
                Colour:
                <select name="colour">
                  <?php $getcolours = mysql_query(" SELECT * FROM text_colours ORDER BY id ASC");
                   while($showcolours = mysql_fetch_array($getcolours)) { ?>
                  <option value="<?php echo $showcolours['colour']; ?>"><?php echo $showcolours['colour']; ?></option>
                  <?php  } ?>
                </select>
                 No. Characters:
<br />
<?php } ?>
               
               <input name="update" type="submit" id="update" value="Update" />
              </form>

This data is then inserted into the mySQL:

Code: [Select]
<?php

if(isset($_POST['update'])) {
$mqty = $_POST['mainqty'];
for ($i = 1; $i <= $mqty ; $i++) {
$productid = $_POST['productid'];
$productqtyid = $_POST['productqtyid'];
$productsize = $_POST['productsize'];
$colour = $_POST['colour'];
$producttext = $_POST['text_$i'];

mysql_query (" INSERT INTO emb_texts SET sessionid = '".$sessionid."', productid = '".$productid."', qtyid = '".$productqtyid."', size = '".$productsize."', colour = '".$colour."', text = '".$producttext."'") or die(mysql_error());
}
}
?>

This almost works but it adds the $productqtyid the same very time. I'm not sure if I am going about the the right way?

Each form needs to add its own values into the mySQL.

Many thanks for your help

Hello everyone,

I'm a newbie with PHP and mySQL and need some assistance with writing a php script that searches a mySQL database using a form.   The form has five fields that I want to search from and one is a required field (State).  I need to filter or narrow down the search by either two or more fields.  The problem I am having is if I used multiple WHERE clauses using the AND condition I have to enter valid information in all five fields and if I use the OR condition then my search does not produce the desired outcome (too many results).  I "think" I need to use the AND condition but I need to be able to leave some of the fields blank (except for the State field) and narrow my search with using anywhere from 2-5 search fields.

Also, another requirement is to be able to enter partial information in the search field "without" having to enter a wildcard in the search field.  Any assistance is very much appreciated and thanks in advance for your help.

Form Fields:
State                  SELECT FIELD
Lease                 TEXT FIELD
Operator Name   TEXT FIELD
County or Parish TEXT FIELD
Well No               TEXT FIELD

I have a table called well_permits and it is structure is as follows:

date            DATE
state           TEXT
county        VARCHAR
api              VARCHAR
permit_no   VARCHAR
operator      VARCHAR
phone         VARCHAR
contact       VARCHAR
lease           VARCHAR
well_no       VARCHAR
permit_for  VARCHAR
welltype      VARCHAR
wellspot      VARCHAR
lat              FLOAT
lon             FLOAT
depth         VARCHAR

This is what I have for the connecting to my database and selecting the fields:

<?php require_once('../../../Connections/Wldatabase.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$currentPage = $_SERVER["PHP_SELF"];

//Variable to store Unique_ID aka API which will be passed to the well-search-results.php page
$var_api_rs_search = $_Get['api'];

$maxRows_rs_search = 20;
$pageNum_rs_search = 0;
if (isset($_GET['pageNum_rs_search'])) {
  $pageNum_rs_search = $_GET['pageNum_rs_search'];
}
$startRow_rs_search = $pageNum_rs_search * $maxRows_rs_search;

$var_state_rs_search = "%";
if (isset($_GET['state'])) {
  $var_state_rs_search = $_GET['state'];
}
$var_lease_rs_search = "%";
if (isset($_GET['lease'])) {
  $var_lease_rs_search = $_GET['lease'];
}
$var_well_no_rs_search = "%";
if (isset($_GET['well_no'])) {
  $var_well_no_rs_search = $_GET['well_no'];
}
$var_operator_rs_search = "%";
if (isset($_GET['operator'])) {
  $var_operator_rs_search = $_GET['operator'];
}
$var_county_rs_search = "%";
if (isset($_GET['County'])) {
  $var_county_rs_search = $_GET['County'];
}
mysql_select_db($database_Wldatabase, $Wldatabase);
$query_rs_search = sprintf("SELECT DISTINCT * FROM well_permits WHERE (well_permits.`state` LIKE %s AND well_permits.county LIKE %s) OR (well_permits.lease LIKE %s) OR (well_permits.operator LIKE %s) OR (well_permits.well_no LIKE %s) ORDER BY well_permits.county", GetSQLValueString($var_state_rs_search, "text"),GetSQLValueString($var_county_rs_search, "text"),GetSQLValueString($var_lease_rs_search, "text"),GetSQLValueString($var_operator_rs_search, "text"),GetSQLValueString($var_well_no_rs_search, "text"));
$query_limit_rs_search = sprintf("%s LIMIT %d, %d", $query_rs_search, $startRow_rs_search, $maxRows_rs_search);
$rs_search = mysql_query($query_limit_rs_search, $Wldatabase) or die(mysql_error());
$row_rs_search = mysql_fetch_assoc($rs_search);
?>

This is my form:

<form action="search.php" method="GET" name="frmsearch" target="_self">

<input name="api" type="hidden" value="" />
<div>

<table width="900" border="0" align="center" cellpadding="2" cellspacing="2">
    <tr>
       <td colspan="6">
           <p style="text-align:left">Select a State then enter at least one search criteria.  State is a required field.</p>
          * Denotes a required field.<br>
   </td>
    </tr>
    <tr>
       <td align="right">* State: </td>
       <td>
          <select name="state" size="1" dir="ltr" lang="en">
     <option value="AL">AL</option>
          <option value="AR">AR</option>
          <option value="CA">CA</option>
          <option value="CO">CO</option>
          <option value="IL">IL</option>
          <option value="IN">IN</option>
          <option value="KS">KS</option>
          <option value="KY">KY</option>
          <option value="LA">LA</option>
          <option value="MI">MI</option>
          <option value="MS">MS</option>
          <option value="MT">MT</option>
          <option value="ND">ND</option>
          <option value="NE">NE</option>
          <option value="NM">NM</option>
          <option value="NY">NY</option>
          <option value="OH">OH</option>
          <option value="OK">OK</option>
          <option value="OS">OS</option>
          <option value="PA">PA</option>
          <option value="SD">SD</option>
          <option value="TX">TX</option>
          <option value="UT">UT</option>
          <option value="WV">WV</option>
          <option value="WY">WY</option>
          &nbsp;</select>
      </td>
      <td align="right">County or Parish: </td>
      <td align="left"><input name="County" type="text" value="" size="35" maxlength="40" /></td>
    </tr>
    <tr>
      <td width="63" align="right">Lease: </td>
      <td width="239"><input name="lease" type="text" value="" /></td>
      <td align="right">Well No: </td>
      <td><input name="well_no" type="text" value="" /></td>
    </tr>
    <tr>
      <td width="111" align="right">Operator Name: </td>
      <td width="261"><input name="operator" type="text" value="" /></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td align="left"><input name="search" type="submit" value="Search" /></td>
  </tr>
</table>
</form>


My Repeat Region starts here


<table width="100%" border="1" align="center" cellpadding="2" cellspacing="2">
  <tr>
    <td align="right">&nbsp;</td>
    <th align="center">Operator</th>
    <th align="center">Lease</th>
    <th align="center">Well Number</th>
    <th align="center">County</th>
    <th align="center">State</th>
  </tr>
  <tr> 
  <?php do { ?>
    <td align="center"><a href="results.php?recordID=<?php echo $row_rs_search['api']; ?>">Select</a></td>
    <td align="left"><?php echo $row_rs_search['operator']; ?></td>
    <td align="left"><?php echo $row_rs_search['lease']; ?></td>
    <td align="center"><?php echo $row_rs_search['well_no']; ?></td>
    <td align="center"><?php echo $row_rs_search['county']; ?></td>
    <td align="center"><?php echo $row_rs_search['state']; ?></td>
  </tr>
  <?php } while ($row_rs_search = mysql_fetch_assoc($rs_search)); ?>
</table>


<p align="center">Number of Wells Located: <?php echo ($startRow_rs_search + 1) ?> to <?php echo min($startRow_rs_search + $maxRows_rs_search, $totalRows_rs_search) ?> of <?php echo $totalRows_rs_search ?></p>


<table border="0" align="center">
  <tr>
    <td align="center"><?php if ($pageNum_rs_search > 0) { // Show if not first page ?>
        <a href="<?php printf("%s?pageNum_rs_search=%d%s", $currentPage, 0, $queryString_rs_search); ?>">First</a>
        <?php } // Show if not first page ?></td>
    <td align="center"><?php if ($pageNum_rs_search > 0) { // Show if not first page ?>
        <a href="<?php printf("%s?pageNum_rs_search=%d%s", $currentPage, max(0, $pageNum_rs_search - 1), $queryString_rs_search); ?>">Previous</a>
        <?php } // Show if not first page ?></td>
    <td align="center"><?php if ($pageNum_rs_search < $totalPages_rs_search) { // Show if not last page ?>
        <a href="<?php printf("%s?pageNum_rs_search=%d%s", $currentPage, min($totalPages_rs_search, $pageNum_rs_search + 1), $queryString_rs_search); ?>">Next</a>
        <?php } // Show if not last page ?></td>
    <td align="center"><?php if ($pageNum_rs_search < $totalPages_rs_search) { // Show if not last page ?>
        <a href="<?php printf("%s?pageNum_rs_search=%d%s", $currentPage, $totalPages_rs_search, $queryString_rs_search); ?>">Last</a>
        <?php } // Show if not last page ?></td>
  </tr>
</table>

I have the following code, (I'm sorry it's so long an it does more that the question asks.)

It's ment to edit, delete and make new links in a mysql database, by also using a link header to home all the links (Like a dropdown menu) And thig manages the links. However then the update, or when the new form is submitted it leaves then titlereg field blank. (The titlereg is the id of the main link, it's called reg in the title_reg database) I know this is complicated and i'm not too good at explaining the problem but any help would be great. I have commented on anything that could help.

<?php
include "../includes/mysql_connect.php";
include "../includes/info_files.php";

echo "<strong>Links</strong><br />";
echo "Currect links:<br /><br />";

if($_POST['submit']){

$name = mysql_real_escape_string($_POST['name']);
$titlereg = mysql_real_escape_string($_POST['titlereg']);
$url = mysql_real_escape_string($_POST['url']);
$id = mysql_real_escape_string($_POST['id']);

mysql_query("UPDATE nav_sub SET name='$name', SET titlereg='$titlereg', SET url='$url' WHERE reg='$id'"); ////////////////////////////////// Here will help, the update MY SQL thingie
echo "Link Changed.<br /><br />";
}
elseif($_POST['remove']){

$id = mysql_real_escape_string($_POST['id']);

mysql_query("DELETE FROM nav_sub WHERE reg='$id'");
echo "Link deleted.<br /><br />";
}
else{
$result = mysql_query("SELECT * FROM nav_sub");

while($row = mysql_fetch_array($result))
  {
echo '<strong>' . $row['name'] . '</strong>';
echo '<form action="" method="post">';
echo 'Name: <input type="text" name="name" value="' . $row['name'] . '" /><br />';
echo 'Link: <input type="text" name="text" value="' . $row['url'] . '" /><br />';
echo 'Navigation title: <select name="titlereg">';

$resultabc = mysql_query("SELECT * FROM nav_title");

while($rowabc = mysql_fetch_array($resultabc))
  {

echo '<option value="' . $rowabc['reg'] . '">' . $rowabc['name'] . '</option>'; ////////////////////////////////// Here is the option
  
  }
echo '</select>';
echo '<input type="hidden" name="id" value="' . $row['reg'] . '" />';
echo '<input type="submit" name="submit" value="Change" /> <input type="submit" name="remove" value="Remove" /><br />';
echo '</form>';
  }
}

echo "New link:<br /><br />";

if($_POST['new_submit']){ ////////////////////////////////// Here!!!!!!!!!!!!!!!
$result = mysql_query("SELECT * FROM nav_sub");

$new_titlereg = $_POST['new_titlereg'];
$new_name = mysql_real_escape_string($_POST['new_name']);
$new_url = mysql_real_escape_string($_POST['new_url']);

mysql_query("INSERT INTO `nav_sub` (`titlereg` ,`reg` ,`name` ,`url`)VALUES ('$new_titlereg', '', '$new_name', '$new_url')"); ////////////////////////////////// here is the MY SQL statement...
echo "Link added.<br /><br />";
}

echo '<form action="" method="post">';
echo 'Name: <input type="text" name="new_name" value="" /><br />';
echo 'Url: <input type="text" name="new_url" value="" /> \\\\ If your linking to a page you made, then the url is index.php?catt=(The categrory you put)&page=(The page you put)<br />';
echo 'Navigation title: <select name="new_titlereg">';

$resultab = mysql_query("SELECT * FROM nav_title");

while($rowab = mysql_fetch_array($resultab))
  {

echo '<option value="' . $rowab['reg'] . '">' . $rowab['name'] . '</option>'; ////////////////////////////////// Here isn't submitting the value in the option
  
  }
echo '</select>';
echo '<input type="submit" name="new_submit" value="Insert" /><br />';
echo '</form>';
?>

By the way, explain simply as I'm only 13

I have two webpages, login_success.php and formentered.php
login_success.php is a page where i am entering new information and enteredvalues.php is supposed to be a script to enter the information into mysql. So far I got the login_success page to redirect to enteredvalues.php when submit is clicked but the information in the fields isn't transferring to mysql and neither is the page redirecting back to login_success. Here are both my codes

Login_success.php
<?
session_start();
if(!session_is_registered(myusername)){
header("location:main_login.php");
}
?>

<html><title>ChronoServe - Saving Time</title>
<link href="style.css" rel="stylesheet" type="text/css">
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="container">
  <tr>
    <td><form name="form2" method="post" action="entervalues.php">
    <table width="335px" height="50%" border="1" align="center" cellpadding="0" cellspacing="0" class="centered">
      <tr>
        <td><table width="100%" border="0" align="center" cellpadding="3" cellspacing="10">
      <tr>
        <td colspan="2"><div align="center" class="font2">Activation Information</div></td>
      </tr>
      <tr>
        <td colspan="2"></td>
      </tr>
      <tr>
        <td width="40%" class="font3">First Name :</td>
        <td width="60%">          <div align="center">
            <input name="firstname" type="text" class="font3" id="firstname" />
            </div></td>
      </tr>
      <tr>
        <td class="font3">Last Name :</td>
        <td>          <div align="center">
            <input name="lastname" type="text" class="font3" id="lastname" />
            </div></td>
      </tr>
      <tr>
        <td height="28" class="font3">Phone Number :</td>
        <td>          <div align="center">
            <input name="pnumber" type="text" class="font3" id="pnumber" />
            </div></td>
      </tr>
      <tr>
        <td class="font3">Personnel Activated :</td>
        <td>          <div align="center">
            <input name="numbactivated" type="text" class="font3" id="numbactivated" />
            </div></td>
      </tr>
      <tr>
        <td height="37" colspan="2"></td>
      </tr>
      <tr>
        <td colspan="2"><div align="center">
          <input name="insert" type="submit" class="font3" value="Submit" />
        </div></td>
      </tr>
    </table></td>
      </tr>
      </form>
    </table>
    </td>
  </tr>
</table>
</body>
</html>
 

Here is enteredvalues.php
<?php
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Define $myusername and $mypassword
$firstname=$_POST['firstname'];
$lastname=$_POST['lastname'];
$pnumber=$_POST['pnumber'];
$numberactivated=$_POST['numberactivated'];

// To protect MySQL injection (more detail about MySQL injection)
$firstname = stripslashes($firstname);
$lastname = stripslashes($firstname);
$firstname = mysql_real_escape_string($firstname);
$lastname = mysql_real_escape_string($lastname);
$pnumber = stripslashes($pnumber);
$numberactivated = stripslashes($numberactivated);
$pnumber = mysql_real_escape_string($pnumber);
$numberactivated = mysql_real_escape_string($numberactivated);

$sql="INSERT INTO $tbl_name (firstname, lastname, pnumber, numberactivated,) VALUES ('$firstname','$lastname','$pnumber','$numberactivated')")or die(mysql_error());  
$r = mysql_query($sql);
if(!$r) {

    $err=mysql_error();

    print $err;
header("location:login_success.php");
    exit();
}
?>