PHP - How To Get Multiple Select Values Through Post On Php.

I have dropdown populated from mysql and now I want to add ID of selected value into other table, it doesn't get the ID.

here's the code I have
if (isset($_REQUEST['subcat']))
{
$id_main = $_GET['categoriesID'];
$DB-> Query('INSERT INTO subcat(id_main_cat,name_subcat) VALUES ("'.$id_main.'","'.$newSub.'")');
}
?>
<br />
<?php
$result = mysql_query("SELECT id,name_cat FROM category") 
                                or die(mysql_error());   
echo "Pick main:";
echo "<select name='categoriesID'>";
             //reads from table 'categories'
             while($row = mysql_fetch_array( $result )) {
             // display them in dropdown
 echo '<option value="'.$row['id'].'">';
             echo $row['id'],$row['name_cat'] . '</option>'."\n";
                                } 
                                echo "</select><br />";
$_POST['categoriesID'];

?>
<form method="post" action="">
<b>Add new:</b>
<input type="text" name="newSubCat">
<input type="submit" name="addSubCat" value="Add">
</form>

Table is populated only with $newSub but not with $id_main...

Hello,

I'm using a dynamically created select menu for a user to make a choice which will then be put in my database with the following code:

<select>
      <?php foreach ($course_number as $row) {
    echo "<option value = '{$row['course_id']}'";
    if ($errors && $_POST["course_id"] == $row['course_id']) {echo 'selected = "selected"';
    }
    echo ">{$row['course_number']}</option>";
    } ?>
Unfortunately, I'm having some problems figuring out how to pull off the selected value.  Right now my database portion looks like this:

$data = array('assignment_name' => $_POST['assignment_name'],

  'due_date' => $_POST['due_date'],

  'course_id' =>  $_POST["row['course_id']"]);

$inserted = $dbWrite->insert('assignments_instructors',$data)

While the assignment_name and due_dates work (they come from text fields), my course_id gives me an Undefined index: row['course_id'] error.  Any help would be appreciated.

Thank you.

i have this select box in a form

Code: [Select]
<select name='theoptions' style='color: #000000;text-align:center;background-color:#DEDEDE;border: 1px solid #D99C29;width:163px;padding:5px;' onchange='optionChanged(this);ChgBox(this.value);'>

   <option value='1' >Your comment on</option>
  <option value='3' >Your question on</option>
  <option value='4' >Your expertise on</option>
  <option value='2' >Your image about</option>
  <option value='5' >Your website about</option>
  <option value='0' >Comparison</option>

</select>

on the page where the form directs to i have

  Code: [Select]
$options = $_POST['theoptions'];
I want to get option 5 specificially, how do i do that?

Hi, During post of my form I am trying to send some table values.  The three field values (DATE, SITE, PRICE) that I want to send are attached to the id field (RID) in the daterange table.  The variable $FTGRID is attached to the RID field.  Here is the structure of the daterange table and the code from the php page related to the email is below.  Do I need to pre-define variables for these three field values?

daterange Table:
RID
DEND
MONTH
DATE
SITE
PRICE
STATUS

Code: [Select]
if ( $validationFailed === false ) {

 # Email to Form Owner
 
 $emailSubject = FilterCChars("Your Reservation");
 
 $emailBody = "Reservation Date : \n"
  . "Site : \n"
  . "Price : \n"
  . "Fname : $FTGFNAME\n"
  . "Lname : $FTGLNAME\n"
  . "Addr1 : $FTGADDR1\n"
  . "Addr2 : $FTGADDR2\n"
  . "City :  $FTGCITY\n"
  . "State : $FTGSTATE\n"
  . "Zip : $FTGZIP\n"
  . "Phone : $FTGPHONE1"
  . "- $FTGPHONE2"
  . "- $FTGPHONE3\n"
  . "Email : $FTGEMAIL\n"
  . "Payment Method : $FTGPM\n"
  . "Last Four CC : $FTGC4\n"
  . "";
  $emailTo = 'u@yahoo.com';
   
  $emailFrom = FilterCChars("inquiry@c.com");
   
  $emailHeader = "From: $emailFrom\n"
   . "MIME-Version: 1.0\n"
   . "Content-type: text/plain; charset=\"UTF-8\"\n"
   . "Content-transfer-encoding: 8bit\n";
   
  mail($emailTo, $emailSubject, $emailBody, $emailHeader);
 
 
 # Confirmation Email to User
 
 $confEmailTo = FilterCChars($FTGEMAIL);
 
 $confEmailSubject = FilterCChars("Confirmation of Reservation");
 
 $confEmailBody = "Reservation Date : \n"
  . "Site : \n"
  . "Price : \n"
  . "Fname : $FTGLNAME\n"
  . "Lname : $FTGLNAME\n"
  . "Addr1 : $FTGADDR1\n"
  . "Addr2 : $FTGADDR2\n"
  . "City : $FTGCITY\n"
  . "State : $FTGSTATE\n"
  . "Zip : $FTGZIP\n"
  . "Phone : $FTGPHONE1"
  . "- $FTGPHONE2"
  . "- $FTGPHONE3\n"
  . "Email : $FTGEMAIL\n"
  . "Payment Method : $FTGPM\n"
  . "Last Four CC : $FTGC4\n"
  . "";
 
 $confEmailHeader = "From: inquiry@c.com\n"
  . "MIME-Version: 1.0\n"
  . "Content-type: text/plain; charset=\"UTF-8\"\n"
  . "Content-transfer-encoding: 8bit\n";
 
 mail($confEmailTo, $confEmailSubject, $confEmailBody, $confEmailHeader);

Hi,

I am fairly new to PHP and I have built a page which accepts values from dynamically added rows so there is a combination of HTML,Javascript and PHP in the process. I am caught up with a problem

HTML section
In my form I have a table with a column as below and a dynamic "Add Row" which would increment the row in javascript  and assign a new value to the input name as txtRow2,txtRow3,txtRow4 and so on based on the number of iteration
" <tr><td><input type="text" name="txtRow1" id="txtRow1" size="40" /></td></tr>
<input type="button" value="Add Row" onclick="addRow();" />"   

Javascript section
The below code generates the new row in js

var cellRight2 = row.insertCell(1);
      var e1 = document.createElement('input');
      e1.type = 'text';
        e1.name = 'txtRow1' + iteration;
         e1.id = 'txtRow1' + iteration;
          e1.size = 20;
          cellRight1.appendChild(e1);
I hope you have understood what I have done till above..

Now comes the problematic part
PHP section( I love PHP  )
I have to insert the column values into mysql and i will do this using a for loop within which I will have my insert statement

INSERT INTO test values($txtRow)
Lets say I added 4 rows dynamically with values held in $txtRow1,$txtRow2,$txtRow3,$txtRow4(See the java script section)

how would I use these values in my PHP insert statement as I don't want to write 4 different insert scripts and the following  "$txtRow.i"   won't work


for ($i = 1; $i <= 10; $i++) {
   
INSERT INTO test values($txtRow.i)
}



Any suggestions are welcome...If you think you still need to see the whole code i can post it too.

Jay

Is there a quick an easy way to test my php scripts without creating an html form and specifying values that I post to my php script? Maybe a firefox plugin or some tool that can be used to do it quicker?

In the long haul, quicker, not just one time

I am currently using a javascript to redirect the page using a select tag and the onchange property. Each page calls a different function.

I want to be able to pass the <select> value to a variable that I can use within a php condition statement on the same page. This will generate the required output based on the <select> value. This way I dont require a seperate page for each query.

So onchange.... $select_value == this.value?

Then within my page:
Code: [Select]
if ($select_value == 'alpha') {
    get_query_alpha();
}
if ($select_value == 'bravo') {
    get_query_bravo();
}

This is my current set up...
Code: [Select]
<p>Order by:
<select name="query" id="query" onchange="gotourl(this.value)">
<option value="query1.php" >Sort by A</option>
<option value="query2.php" >Sort by B</option>
<option value="query3.php" >Sort by C</option>
<option value="query4.php" >Sort by D</option>
</select></p>

<table> <?php get_query_1();?> </table>

and js...
Code: [Select]
function gotourl(url){
window.location= url;
}
function selectsubject(){
alert("Please select a subject!");
}

Is there a simple way to do this? Thanks.

Hi, I have a form for news articles.  It has a title and a body which is fine.  I also have a search box that allows the user to search for a memeber and click their name when it appears.  This moves a div with a data-id into another div.  The purpose of this is to tag them in the article.

I am able to post all of the simple stuff but how would i post these value.  I am assuming that i would need to create an array of said values but i am struggling to get them showing in post at all.

Here is the code i have so far

<?php

function searchForPeople($searchVal, $exclude = '0'){

	$sv1 = $searchVal;
	$sv2 = $searchVal;

	include 'includes/dbconn.php';
	$out ="";

	$stmt = $conn -> prepare("
	                         SELECT fname, lname, id
	                         FROM person 
	                         WHERE id NOT IN (".implode(',', array_map('intval', $exclude)).") 
	                         AND (fname LIKE CONCAT('%',?,'%') OR lname LIKE CONCAT('%',?,'%'))
	                         ");
	$stmt -> bind_param('ss', $sv1, $sv2);
	$stmt -> execute();
	$stmt -> bind_result($fn, $ln, $pid);

	while($stmt -> fetch()){
		$out .= "<div class='btn btn-primary m-1 tagInArticle' name='taggedPerson[]' data-id='$pid'>$fn $ln</div>";
	}

	return $out;
}

?>

		......
							<div id="searchResultsHere">
								<!-- ajax content here -->
							</div>
							<hr>
							<div id="taggedInArticleContainer">
								<!-- ajax content here -->
							</div>
		.......


						<div class="col-lg-2">
							<button type="submit" name="PublishNewNews" class="btn btn-primary w-100 mb-3">Publish</button>
							<button class="btn btn-primary w-100">Save</button>
							<hr>
							<div class="btn btn-warning w-100 mb-3">Private</div>
							<input type="hidden" name="howVisible" value="Private">
							<hr>
							<p class="text-justify">Private news articles will only be avilable to logged in users</p>
						</div>

		.......



<script>

	$('#searchResultsHere').on('click', '.tagInArticle', function tagInArticle(){
		var tagButton = $(this);
		tagButton.appendTo('#taggedInArticleContainer')
	});

	$('#searchForPeopleBox').keyup(function(){
		var searchVal = $(this).val()
		var tagged = '0'
		var tagged = $('#taggedInArticleContainer').find('.tagInArticle').map(function(){
		 return $(this).data('id');
  		}).get();
		$.ajax({
			type: 'post',
			data: {"ajax" : 'one', "val" : searchVal, "exclude" : tagged},
			success: function(resp){
				$('#searchResultsHere').html(resp)
			}
		})
	});

	


</script>

I hope this is enough to go on.

I am sure it is simple but i just cant get it.

Thanks all in advance.

Hi

I have a form that is to input data from input fields to a table.
The form is as follows:

                            $query = $DB->query("SELECT country_code, country_id, IF(country_code = '".$country_code."', '', '') AS sel FROM exp_sme_countries WHERE site_id='".$this->settings['site_id']."' ORDER BY country_name ASC");
                            foreach ($query->result as $row)
                            {
                               $options .= '<label>' . 'Phrase for ' . $this->settings['countries'][$row['country_code']] . '</label>' . '<br />';
                               $options .= '<input style="width: 100%; height: 5%;" id="country_data" type="text"  name="country_id[]"  />' . '<br /><br />';
                               $options .= '<input type="hidden"  name="country_data[' . $row['country_id'] . ']" value="'.$row['country_id'].'"  />';
                            }


This outputs:
Code: [Select]
<input style="width: 100%; height: 5%;" id="country_data" type="text"  name="country_id[]"  />
<input type="hidden"  name="country_data[68]" value="68"  />

<input style="width: 100%; height: 5%;" id="country_data" type="text"  name="country_id[]"  />
<input type="hidden"  name="country_data[28]" value="28"  />

What I need to do, is get the values from the input fields and then match them with the correct hidden field value

So if in the first input field, I typed in 'Test data' and the second input, i typed 'This is great'

On the POST, I need to find the the value ('Test data') and also the value from the hidden field.

So something like:
Quote

The text you entered is: Test data with hidden value of 68
The text you entered is: This is great with hidden value of 28


I'd rather not use $_GET as this is a form that inserts data into a database.

Could someone point my in the right direction or provide an example?

I am having trouble with passing values with a POST to another php file.  I am getting the error :  undefined index : productID and undefined index: filename.  I have also tried :  <form   method = \"POST?pdib=$processID&filename=$filename\" action = \"upload2.php\"  >  When I look at the array of superglobals, they are both defined.  Thank you! 

 Here is the code :

drawfirsttwoforms:

$sql = "SELECT ProductFilename, ProductName, ProductID, ProductDescription,ProductCost,ProductQuantity, ProductCatTitle FROM products 
INNER JOIN customers ON customers.CustomerID = products.CustomerID 
WHERE ((products.ProductKeyWord1 = ?) 
OR (products.ProductKeyWord2 = ?) OR (products.ProductKeyWord3 = ? ))  AND (products.ProductCatTitle = ?) ";

$stmt = $dbo->prepare($sql);
$stmt->bindParam(1, $keyword1);
$stmt->bindParam(2, $keyword1);
$stmt->bindParam(3, $keyword1);
$stmt->bindParam(4, $titleOfSelectedDropDown);

$stmt->execute();

while ($row = $stmt->fetch()) {

//these variables do have values here
$productID = $row['ProductID'];
$filename = $row['ProductFilename'];

$string1 .=  "  
<div  class = \"A\" id = \"$mainDiv\">
<p id = \"link1\">product id   :$productID</p>
<p>category id  :$category</p>
<div class = \"A\" id = \"endz\"></div>
<div class = \"A\" id = \"startz\"></div>
<div class=\"container\">
<div id = \"testing\" >testing <div>
<div id = \"$displayID\" >  </div>
<div class=\"row\" >
<div class=\"col\">
	
	<form   method = \"POST\" action = \"upload2.php\"  >
      
      
    
	<input type=hidden id='$productID' name= '$productID' value=\"A\">
	<input type=hidden id=\"$filename\" name=$filename value=\"B\">
	
      
      
      <button value = \"Submit\" type = \"submit\"  >submit it</button>
	</form>
	<iframe id=\"upload_target\" name=\"upload_target\"  style=\"width:0;height:0;border:0px solid #fff;\"></iframe> 
	<img width=\"120\" height =\"120\"  id = \"$imageID\"  src=\"../php proj/uploads/$filename?<?php echo filemtime($filename)?>\">
	<button    onclick = \"imageRefresh( '{$filename}', '{$imageID}', '{$_SESSION["msg"]}' )\" >Display</button>
	</div>


AFTER:
  

if (!isset($myObj) && isset($string1))
{
$myObj = new stdClass();
$myObj->htmlstuff = $string1;


//Encode the data as a JSON string
$jsonStr = json_encode($myObj);
echo $jsonStr;
}

 

function printHTML1(keyword){ 
	
	
	const element = document.getElementById("dropDown1");
		
	//const checkValue = element.options[element.selectedIndex].value;
	const checkText = element.options[element.selectedIndex].text;
	
	var val1 = checkText;

	var xmlhttp = new XMLHttpRequest();
	
	
	var keyword1 = keyword;
	var url = "drawfirsttwoforms.php?keyword=" + keyword.value + "&" + "val1=" + val1;
	


	xmlhttp.onreadystatechange = function() {
		
	if (this.readyState == 4 && this.status == 200) {
		
		
		var jsonData = JSON.parse(this.responseText);
		var answerHtml = jsonData.htmlstuff;
		document.getElementById("codehere").innerHTML = answerHtml;

		createAndModifyDivs();


		}
	};
	
	xmlhttp.open("GET", url , true);
	
	xmlhttp.send();
	
	
}

 

upload2.php


<?php
session_start();
$productID = $_POST['productID'];
$filename = $_POST['filename'];

 

When i click my submit button i am posting the following.

		Array
(
    [submitStaffOrder] => 
    [staffMember] => Array
        (
            [0] => 2
            [1] => ANYCHEF1
        )

    [date] => Array
        (
            [0] => 2020-02-18
            [1] => 2020-02-18
        )

    [startTime] => Array
        (
            [0] => 11:01
            [1] => 10:10
        )

    [finishTime] => Array
        (
            [0] => 11:01
            [1] => 10:01
        )

    [delExisting] => Array
        (
            [0] => 
            [1] => toDel
        )

)

I would like to update/insert if delExisting is blank and delete if it has toDel in there.

I have the following but i am pretty sure the if is not working.

$date = $_POST['date'];
	$stime = $_POST['startTime'];
	$ftime = $_POST['finishTime'];
	$del = $_POST['delExisting'];
	$staff = $_POST['staffMember'];

$stmt = $conn -> prepare("
	                         INSERT IGNORE INTO ssm_staff_order (job_id, staff_id, staff_start_time, staff_finish_time, staff_start_date, staff_finish_date) 
	                         VALUES (?,?,?,?,?,?)
	                         ON DUPLICATE KEY 
	                         UPDATE 
	                         staff_start_time = VALUES(staff_start_time),
	                         staff_finish_time = VALUES(staff_finish_time);
	                         ");

	$delstmt = $conn -> prepare("
		                         DELETE FROM ssm_staff_order
		                         WHERE staff_id = ?
		                         AND job_id = ?
		                         AND staff_start_date = ?
		                         ");

	foreach ($staff as $key => $staffId) {
		if ($del == '') {
			$start = $date[$key].' '.$stime[$key];
			$finish = $date[$key].' '.$ftime[$key];
			$stmt -> bind_param('isssss', $jid, $staffId, $start, $finish, $date[$key], $date[$key]);
			$stmt -> execute();
		}
		

		
		if ($del == 'toDel') {
			$delstmt -> bind_param('sis', $staffId, $jid, $date[$key]);
			$delstmt -> execute();
		}
	}
	
}

Can i do what i am trying to do or am i way off here?

 

I struggle with arrays

Edited February 24, 2020 by Adamhumbug

I have a photo album style gallery to build
and
i'm finding it dificult to list all the table names (these are names of photo albums) and then enter the data into a seperate query for each album name (these will change often so i cant keep updating the file as normal. this will then post all the data to the xml file and show the set of photos in the individual albums in a flash file.
can anyone help me where im going wrong at all?



<?php
$dbname = 'cablard';

if (!mysql_connect('localhost', 'cablard', '')) {
    echo 'Could not connect to mysql';
    exit;
}

$sql = "SHOW TABLES FROM $dbname";
$result = mysql_query($sql);

if (!$result) {
    echo "DB Error, could not list tables\n";
    echo 'MySQL Error: ' . mysql_error();
    exit;
}

while ($row = mysql_fetch_row($result)) {
    echo "Table: {$row[0]}\n";
}

mysql_free_result($result);



$query = "SELECT * FROM photo ORDER BY id DESC"; 
$result2 = mysql_query ($query)  or die ("Error in query: $query. ".mysql_error());

   
   while ($row = mysql_fetch_array($result2))  
   {                                       
         echo  "
<image>
<date>".$row['date']."</date>
<title>".$row['title']."</title>
<desc>".$row['description']."</desc>
<thumb>".$row['thumb']."</thumb>
<img>".$row['image']."</img>
</image>

";


   }                      
?>


Thanks
James

I'm using the following script: http://jsfiddle.net/VzVy6/8/

It give a alert message that slide in/out when a required field is still empty on submit.
The script works fine, and in this example its only one field.

When the field is empty I see the fade in alert message, and when the field has been filled in I see a normal popup alert message:  alert("Would be submitting form");

I can't get it to work to change this alert message to a page POST submit. I was looking online, and I see Ajax examples that I don't get to work.

What I want is that when all fields are filled in, that the form POST submit to another page including the values in the textboxes ofcourse.

Maybe its something really easy, but I have already a headache because tried to get it to work for more then 5 hours in a row.

Thank you for your time.

Hi all i have 2 small questions and maybe someone could help me out.
Say I have a database with a table 'users'.
This table has fields: email, name and year.

What I want to do is show at the front-end all users, by selecting them from the table, and arrange them by year in column 1 and show them as individuals in column 2. But here is the thing; if someone selects for instance year 1970 and also someone from 1970 individually, someone will be selected twice. (edit:As a side note the selecting is aimed and emailing the users, that's why selecting someone twice is not good
First question is: does anyone know how to remove doubles (maybe even triples if there is a select all button, maybe turn this around and say select only 1 instance of a user).

Second question: is this a wise way to let someone select. Right now all users are fetched, and if the table users grows this could be tricky because of the large number of users.

If someone could point me in the right direction of thinking I would be very happy, been thinking about this and scalability for quite a while now 

I have a Prepared Statement that runs a SELECT statement and returns 2 records, and I would like to store the Field Value for each Record into an Array.

Here is the code I usually use for queries that return just a single value...

// ******************
// Populate Form. *
// ******************

// Build query.
$q2 = "SELECT response
FROM bio_answer
WHERE member_id=?";

// Prepare statement.
$stmt2 = mysqli_prepare($dbc, $q2);

// Bind variable to query.
mysqli_stmt_bind_param($stmt2, 'i', $memberID);

// Execute query.
mysqli_stmt_execute($stmt2);

// Store results.
mysqli_stmt_store_result($stmt2);

// Check # of Records Returned.
if (mysqli_stmt_num_rows($stmt2)>0){
// Details Found.

// Bind result-set to variable.
mysqli_stmt_bind_result($stmt2, $response);

// Fetch record.
mysqli_stmt_fetch($stmt2);

// Close prepared statement.
mysqli_stmt_close($stmt2);

}else{
// Details Not Found.
$_SESSION['resultsCode'] = 'DETAILS_NOT_FOUND_2133';

// Close prepared statement.
mysqli_stmt_close($stmt2);

// Set Error Source.
$_SESSION['errorPage'] = $_SERVER['SCRIPT_NAME'];

// Redirect to Display Outcome.
header("Location: " . BASE_URL . "/members/results.php");

// End script.
exit();
}//End of POPULATE FORM



Can someone help me out with the syntax so that I get an end result like this...

$answerArray[0] = 'I want to be my own boss!!'
$answerArray[1] = 'Don't waste your time trying to do your own Taxes!'


Thanks,


Debbie