PHP - Mysql Filled Dropdownbox Needs To Populate Multiple Textboxes Onchange

Good day, I new to PHP I am having problems with a two dropdowns on a form, can someone please tell me where I'm going wrong.


[attachment deleted by admin]

I don't want to use AI, or a primary key to sort the data, as it could create some problems if the items are visited out of order, but I want to sort it always based upon a single element for speed.   I'm creating a table that will be populated (built), when it's corresponding entry doesn't exist, how do I get it sorted out if someone visits 2, then 7 before they visit 5 to read what's there?  It's not a 2d number line, but a 3d number grid.
Edited by Q695, 09 September 2014 - 11:30 PM.

I need some help with updating the database table with the correct selection from that box.
I have a dropdown box. This is actually a list from the images in a curtain directory.
here the code I used:

<?php
$dhandle = opendir('../images/Vessels/');
$files = array();
if ($dhandle) {
   // loop through all of the files
   while (false !== ($fname = readdir($dhandle))) {
      if (($fname != '.') && ($fname != '..') &&
          ($fname != basename($_SERVER['PHP_SELF']))) {
          $files[] = (is_dir( "./$fname" )) ? "(Dir) {$fname}" : $fname; }
            }
   closedir($dhandle);
}


So when inserting a new record I can use the dropdownbox to populate the correct field.

Database:
Id, Vesselname, Image, more, andmore

There is a section where an authorized user can upload an image to the directory.
This image will then be available in dropdown when the need to add a new vessel (in this case)
The problem that I have is, when I later what to update the vessel, I want that same dropdownbox
to be showing the correct imagename as "selected".
How can I do that?

This is what I have been expirementing with sofar:

<?php require_once('../Connections/bgf_db.php'); ?>
<?php
$dhandle = opendir('../images/Vessels/');
$files = array();
$selectedFile = "mare.jpg";
if ($dhandle) {
   // loop through all of the files
   while (false !== ($fname = readdir($dhandle))) {
      if (($fname != '.') && ($fname != '..') &&
          ($fname != basename($_SERVER['PHP_SELF']))) {
          $files[] = (is_dir( "./$fname" )) ? "(Dir) {$fname}" : $fname; }
      }
   closedir($dhandle);
}
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;
}
}
$MyFile_Recordset1 = "no-picture.jpg";
if (isset($selectedFile)) {
  $MyFile_Recordset1 = $selectedFile;
}
mysql_select_db($database_bgf_db, $bgf_db);
$query_Recordset1 = sprintf("SELECT vessels.Name, vessels.Image FROM vessels WHERE vessels.Image = %s", GetSQLValueString($MyFile_Recordset1, "text"));
$Recordset1 = mysql_query($query_Recordset1, $bgf_db) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
$selectedFile = $row_Recordset1['Image'];
?>
<select name="NameHere">
<option value="<?php echo $selectedFile?>" 
<?php if (!(strcmp($selectedFile, $row_Recordset1['Image']))) {echo "selected=\"selected\"";} ?>><?php echo $selectedFile ?>
</option>
<?php
// Now loop through the files, echoing out a new select option for each one
foreach( $files as $fname )
{
   echo "<option value=\"$fname\">{$fname}</option>\n";
}
echo "</select>\n";
?>


 

Ok I'm trying to insert multiple rows by using a while loop but having problems. At the same time, need to open a new mysql connection while running the insert query, close it then open the previous mysql connection.

I managed to insert multiple queries before using a loop, but for this time, the loop does not work? 
I think it is because I am opening another connection... yh that would make sense actually?

Here is the code:


$users = safe_query("SELECT * FROM ".PREFIX."user");
       while($dp=mysql_fetch_array($users)) { 
          
   $username = $dp['username'];
 $nickname = $dp['nickname'];
 $pwd1 = $dp['password']; 
 $mail = $dp['email'];
 $ip_add = $dp['ip'];
 $wsID = $dp['userID'];
 $registerdate = $dp['registerdate'];
 $birthday = $dp['birthday'];
 $avatar = $dp['avatar'];
 $icq = $dp['icq']; 
 $hp = $dp['homepage'];
 
echo $username." = 1 username only? :(";
      

// ----- Forum Bridge user insert -----

$result = safe_query("SELECT * FROM `".PREFIX."forum`");
$ds=mysql_fetch_array($result);
$forum_prefix = $ds['prefix'];
define(PREFIX_FORUM, $forum_prefix);
define(FORUMREG_DEBUG, 0);

$con = mysql_connect($ds['host'], $ds['user'], $ds['password']) or system_error('ERROR: Can not connect to MySQL-Server');
$condb = mysql_select_db($ds['db'], $con) or system_error('ERROR: Can not connect to database "'.$ds['db'].'"');
                
include('../_phpbb_func.php');
$phpbbpass = phpbb_hash($pwd1);
$phpbbmailhash = phpbb_email_hash($mail);
$phpbbsalt = unique_id();

safe_query("INSERT INTO `".PREFIX_FORUM."users` (`username`, `username_clean`, `user_password`, `user_pass_convert`, `user_email`, `user_email_hash`, `group_id`, `user_type`, `user_regdate`, `user_passchg`, `user_lastvisit`, `user_lastmark`, `user_new`, `user_options`, `user_form_salt`, `user_ip`, `wsID`, `user_birthday`, `user_avatar`, `user_icq`, `user_website`) VALUES ('$username', '$username', '$phpbbpass', '0', '$mail', '$phpbbmailhash', '2', '0', '$registerdate', '$registerdate', '$registerdate', '$registerdate', '1', '230271', '$phpbbsalt', '$ip_add', '$wsID', '$birthday', '$avatar', '$icq', '$hp')");
if (FORUMREG_DEBUG == '1') {
echo "<p><b>-- DEBUG -- : User added: ".mysql_affected_rows($con)."<br />";
       echo "<br />-- DEBUG -- : Query used: ".end($_mysql_querys)."</b></p><br />";
      
       $result = safe_query("SELECT user_id from ".PREFIX_FORUM."users WHERE username = '$username'");
       $phpbbid = mysql_fetch_row($result);
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('2', '$phpbbid[0]', '0', '0')");
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('7', '$phpbbid[0]', '0', '0')");
mysql_close($con);
}

         include('../_mysql.php');        
         mysql_connect($host, $user, $pwd) or system_error('ERROR: Can not connect to MySQL-Server');
mysql_select_db($db) or system_error('ERROR: Can not connect to database "'.$db.'"');
       
       }



So I need to be able to insert these rows using the while loop.. how can I do this?

I really appreciate any help.

Hello,

I am trying to populate the value="" of my form with the data from the mysql database so users can see what is already completed, trial and error have failed me. what am i doing wrong?

<?php
session_start();
include 'english.php';

if (!isset($_SESSION['user']))
   die("<br /><br />You need to login to view this page");
$user = $_SESSION['user'];

echo "<h3>Edit your Profile Search</h3>";

//opend database
$connect = mysql_connect("$dbhost","$dbuser","$dbpass");
mysql_select_db("$dbname"); //select database

// Get all the data from the "housing" table
$result = mysql_query("SELECT * FROM users WHERE user='$user'")
or die(mysql_error());

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result ))
   // Print out the contents of each row into a table

?>
<form action="/includes/insert_profile.php" method="post">
<table border="0" cellspacing="0" cellpadding="3">

</td></tr>
<tr><td>First Name:</td><td><input type="text" name="first" value="$first">

<tr><td>Middle Name:</td><td><input type="text" name="middle" value="$middle">

<tr><td>Last Name:</td><td><input type="text" name="last" value="$last">

<tr><td>Email:</td><td><input type="text" name="email" value="$email">

</td></tr>
<tr><td>Date of Birth:</td><td>
<select id="day" name="day" class="short">
<option value="1" selected="selected">1</option>
<option value="2">2</option>
<option value="3">3</option>

</select>
<select id="month" name="month" class="medium">
<option value="January" selected="selected">January</option>
<option value="February">February</option>

</select>
<select id="year" name="year" class="medium">
<option value="2010" selected="selected">2010</option>
<option value="2009">2009</option>
<option value="2008">2008</option>

</td></tr>
<tr><td>
<input type="Submit" value="Save"/>
</td></tr>
</table>
</form>

Hello there,
I have a problem with a form, as soon as I fill the for using a query. The buttons doesn't work anymore. They work when i open the page, they have somoe js to emable and diable controls. but when i do a search and get the form filled, non of the controls work anymore. Any advise?

I've got a basic form setup on my site that requires the user to fill out the required fields. When one of the fields isn't filled out, the error message for that specific input area is displayed, etc. However, all the information from the form that the user filled out is removed..

I want the user to be able to fill out the form, hit submit, and if any errors, show the specific error but also keep the input boxes populated with the data the user filled out so he/she does not have to re type everything.

if(!empty($_POST['submitFeature']))
{
    // set variables
    $featurename = mysql_real_escape_string($_POST['featurename']);
    $name = mysql_real_escape_string($_POST['name']);
    $email = mysql_real_escape_string($_POST['email']);
    $email2 = mysql_real_escape_string($_POST['email2']);
    $age = mysql_real_escape_string($_POST['age']);
    $city = mysql_real_escape_string($_POST['city']);
    $state = mysql_real_escape_string($_POST['state']);
    $src = $_FILES['featureupload']['tmp_name'];
    $featuresize = $_FILES['featureupload']['size'];
    $limitsize = 3000000;
        


    if(!empty($featurename) && !empty($name) && !empty($email) && !empty($email2) &&  !empty($city) &&  !empty($state) && ($email == $email2) && !empty($_FILES['featureupload']['tmp_name']) && ($featuresize < $limitsize))
    {

    // IF ALL IS CORRECT, SUBMIT INFO 
    
    } else {
        print '
        <ul class="errorlist">
            <li class="alert">Please fill out the required fields.</li>
        ';
    
        if (empty($name))
        {
            echo ' <li>* Full Name</li>' . "\n";
            $errorname = 'TRUE';
        } if (empty($email))
        {
            echo ' <li>* Email</li>' . "\n";
            $erroremail = 'TRUE';
        } 
        print '
        </ul>
        ';
    }
    // 1 - B. END REQUIRED FIELDS ERROR CODES
    
}
?>

<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data">
    <div style="float: left;">
        <span class="copy-answer">Your Information</span>
    
        <div class="formSec"><label for="name" class="required">Full Name: <?php if(isset($errorname)){echo '<span class="error">*<span>';}?></label>
        <input type="text" name="name" id="name" value="" maxlength="25" /></div>
        
        <div class="formSec"><label for="email" class="required">Email: <?php if(isset($erroremail)){echo '<span class="error">*<span>';}?></label>
        <input type="text" name="email" id="email" value="" /></div>
      
    <input class="submit" type="submit" name="submitFeature" value="Submit Your Feature" />
</form>

I am adding line items in my invoice script, while adding i validate the data. if validation fails, it will display error message with entered data filled in the form. If it clears the validation, data gets submitted to database and displays the same . Here i can add many line items, so this process should keep repeating.

Everything is working fine. But when the form submits it should display error in one place and display the submitted data in other place.

Here is my form

 

<form action="" method="post">
                                        <div class="form-row">
                                            <div class="col-md-4 mb-30">
                                                <label for="validationDefault01">Select Customer</label>
                                            <select name="customer" class="form-control" id="validationDefault01" required>
                                            <option value=""></option>
                                            <?php $c1 = mysqli_query($con, "SELECT * FROM customers WHERE status='Active'") or die (mysqli_error($con));
                                            while($c2 = mysqli_fetch_array($c1))
                                            {
                                                ?>
                                           
                                            <option value="<?php echo $c2["cid"]; ?>" <?php if($c2["cid"] == $_POST['customer'] ) { echo "selected"; }  ?> ><?php echo $c2["name"]; ?></option>
                                            <?php } ?>
                                            </select>    
                                            </div>

 
  <div class="col-md-4 mb-30">
  <label for="validationDefault02">Date</label>
 <input type="text" class="form-control" name="edate" id="datepicker" value="<?php echo isset($_POST["edate"]) ? $_POST["edate"] : $today; ?>" required />  
  </div>
  </div>                               
<!-- line item -->                               
                               <div class="table-responsive">
                             <table class="table table-active table-bordered table-sm">
                             <thead class="thead-active">

                              <tr>
                             <th>Name</th>
                            <th>Description</th>
                            <th>UOM</th>    
                            <th>Price</th>
                            <th>Stock</th>
                            <th>Qty</th>  
                            </tr>
                           </thead> 
                            <tr> 
  <td><input type="text"  id="productname" name="productname" value="<?php echo isset($_POST["productname"]) ? $_POST["productname"] : ''; ?>" required ></td> 
                               <input type="hidden"  id="productcode" name="productcode" value="<?php echo isset($_POST["productcode"]) ? $_POST["productcode"] : ''; ?>"  />
                                <td><textarea id="description" name="description"><?php echo isset($_POST["description"]) ? $_POST["description"] : ''; ?></textarea></td>
                                
                           
                                <td><select name="uom" id="uom">
                               
                                <?php $su1 = mysqli_query($con, "select * from uom");  while($su2 = mysqli_fetch_array($su1)) { 
                   
                                ?>
                                <option value="<?php echo $su2["uom_name"]; ?>" <?php if($su2["uom_name"] == $_POST['uom'] ) { echo "selected"; }  ?> ><?php echo $su2["uom_name"]; ?></option>
                                
                                <?php
                                }  
                                ?>
                                </select>
                               
                               </td> 
                               
                             <td><input type="text" required id="price" name="price"   value="<?php echo isset($_POST["price"]) ? $_POST["price"] : ''; ?>" /></td>
                             
              <td><input type="text" readonly id="stock" name="stock" value="<?php echo isset($_POST["stock"]) ? $_POST["stock"] : ''; ?>" /></td>            
                    
                   <td><input type="text"  required id="quantity" name="quantity" value="<?php echo isset($_POST["quantity"]) ? $_POST["quantity"] : ''; ?>" /></td>  
                                                       
</tr>  </table> 

<!-- line item ends--->
 <div class="form-row">
<div class="col-md-4 mb-30">
 <input name="add" class="btn btn-success" type="submit" value="Add" />
</div>
</div>                                            
</form>

form submission

<?php
 if(isset($_POST['add']))
 {
   
   
$customer = $_POST['customer'];
$edate1 = $_POST['edate'];
$edate = date('Y-m-d', strtotime((str_replace('/','-',$edate1))));
	                                            
$pname = $_POST['productname'];
$pcode = $_POST['productcode'];
$uom = $_POST['uom'];
$price = $_POST['price'];
$quantity = $_POST['quantity'];

$pc = mysqli_query($con, "SELECT min_price FROM items WHERE item_id=".$pcode."") or die (mysqli_error($con));
$prow = mysqli_fetch_array($pc);

   // This error part should be displayed inside <div id="error"></div> which is above the form 
if($price<$prow['min_price'])
{
echo  '<div class="alert alert-inv alert-inv-danger alert-wth-icon alert-dismissible fade show" role="alert">
                                        <span class="alert-icon-wrap"><i class="zmdi zmdi-bug"></i></span> Price should not be lesser than minimum price defined.
                                        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                            <span aria-hidden="true">×</span>
                                        </button>
                                    </div>';   
}
else
{
  //data gets inserted into invoice table and displays submited data in table format
  // this part should be displayed below the form inside <div id="success"></div>
  
  
}
                        }

Here i am not getting how to define that displays. 

 

 

 

How do I get LIKE to check multiple values? It works if you type in a single word, but not multiple, which I want it to in order to get an accurate search result. Here is what I am trying to do:

$target = "siemens 6s" ;

$multis = explode(" ", $target) ;

$query = "SELECT parts_table.*, manufacturers.* FROM parts_table, manufacturers WHERE parts_table.ManufacturerID = manufacturers.ManufacturerID AND parts_table.PartNumber LIKE" ;

foreach($multis as $current) {

$queryext .= " '%$current%' OR" ;

} $queryext = substr($queryext, 0, -3) ; // Remove the last 4 charecters i.e. " AND".

$query .= $queryext ;

echo $query .= " OR manufacturers.ManufacturerID = parts_table.ManufacturerID AND manufacturers.ManufacturerName LIKE" . $queryext ;



include("dbconnect.php") ;

$result = mysql_query($query) ;

while($row = mysql_fetch_assoc($result)){

echo $row['ManufacturerName'] ;
echo $row['PartNumber'] ;

}

Ok this has been driving me crazy for days now. I need to update my DB with multiple data parsed from an XML feed. I need some help in putting together the query.

Currently I have:
Code: [Select]
$xml= 'test-feed.xml'; // URL for feed.



try{
  $feed = new SimpleXMLElement($xml, null, true);
}catch(Exception $e){
  echo $e->getMessage();
  exit;
}


$sqlxml = "";
$arr = array();

foreach($feed->property as $property) {

 $propertyid = (string)$property->id;
 
 foreach($property->images->image as $image) {
 $i = 0;
  $url = (string)$image->url;
  $arr[] = "UPDATE property SET url = '$url' WHERE prop_id = '$propertyid', ";
 $i++;
 
 
 }

}

foreach($arr as $result) $sql .= $result;


$sql = rtrim($sql, ",");

echo $sql;


if(!mysql_query($sql)){
  echo '<h1 style="color: red;">Error</h1><p>', mysql_error(), '</p>';
}
else
{

  echo '<h1 style="color: red;">Property data successfully added to database!</h1>';
}

This structures the query correctly for a single update but repeats it which then throws a MYSQL Syntax error. I am not sure of the correct syntax to use for multiple inserts??

What I get returned at the moment is:

Code: [Select]
UPDATE property SET url = 'ImageId=X1000245' WHERE prop_id = 'A1234', UPDATE property SET url = 'ImageId=X1000296' WHERE prop_id = 'A1234', UPDATE property SET url = 'ImageId=P3&ImgId=X1000237' WHERE prop_id = 'ABC1234',
Need some intervention guys

Thanks in advance

GT

Hello.

I'm coding myself an small webpage, In the internet you can see that there is pages like index.php?id=223923 <- for example or index.php?=news.
 So, I'm trying to create similar to that myself. I tried googling and searching youtube how to do this but didn't really find anything.

I figured it out that it needs some database etc.

I tried myself doing some table in my mysql db. And in the table some 'id, title, content' and in the id would be the url, (index.php?='id') the title would be the <title> </title> and the content would be all the code inside the webpage. I got no idea how to link these to an php or whatever it should be done So would anyone kindly tell me howto do this or give some link to an tutorial?

Hi there,

I am working on a PHP form and running a loop to generate textboxes at runtime.

This code output the textboxes:


foreach ($MyTest as $tst)
{
   echo "<input name='testName' type='text'  size='12' maxlength='5' />";
}


I am able to display (or output) 4 or sometimes 6 textboxes depending on the variable $MyTest.

Now after I enter the values in these texboxes. Lets say, it outputs 3 textboxes, I woud like to display the values like:

In Textbox 1 you entered:
In Textbox 2 you entered:
In Textbox 3 you entered:

How can I get (or fetch) values from the textboxes generated through the loop.

Please reply.

All comments and feedbacks are always welcomed!

Thank you

I have two drop down menus in a table side by side being populated exactly the same from a msql database.
The first menu populates fine but  the second one is blank.
They are both supposed to be identical, the same info from the same table so I assume that's my problem.
I tried moving the while loop so it encapsulates both drop downs but then it messes up the table structure.
I tried changing the name of some of the variables by adding "2" on the end  & that didn't work either.
Is it because once a while loop is executed it can't be used again on the same instance?
Heres my code so far:

      <tr>
        <td >   <select name="wall_type" size="1" style="width: 175px;" >      
<?php
while ($walls_row=mysql_fetch_array($result_walls))
 {
$type_name=$walls_row["type"];   
$type_id=$walls_row["id"];    
 ?>
  <option value="<?php echo $type_id; ?>"><?php echo $type_name; ?>   </option>
<?php
}
?>
 </select>
   </td>
 <td >
 <select name="wall_type2" size="1"  style="width: 175px;">
<?php
while ($walls_row2=mysql_fetch_array($result_walls))
 {
$type_name2=$walls_row2["type"];   
$type_id2=$walls_row2["id"]; 
 
 ?>
 <option value="<?php echo $type_id2; ?>"><?php echo $type_name2; ?>   </option>
 <?php
}
?>
 </select>
 </td>
 </tr>