PHP - Dynamic Form From Array. Or Better Solution ????

I have users in my database with many stored points ie age, gender, interests etc. about 20 points in all.   I have a table of products that I want to recommend only applicable products. They each have saved like minage, maxage, gender, interest etc for the ideal consumer. ie dress gender=f   This is the bare bones of what I have so far:

$result = mysql_query("SELECT * FROM user_table WHERE hash='$session_id'");
$rowuser = mysql_fetch_array($result);

$result = mysql_query("SELECT * FROM products");
$rowproducts = mysql_fetch_array($result);

So now I have $rowuser['gender'] = m , how do I remove all from $rowproducts where gender = f?   Is there a best way to do this knowing I have about 20 points to go through before I am left with an array with just the best selection of products for this user in it?

i want to make a forum that nobody can fill that through any software automatically
i make this one with java script authentications but some one also make a break of this and and he fill this software only in one click with automatic way
this one which i make
http://www.ebs-ads.com/advertising/forms.php?id=4&name=Abel

any better solutions using php or any other function that users must have to post every input field separately manually ..if yes Please suggest me thanks

Hello all,

I have yet again trouble finding a logical solution to my problem.
I'm fetching an array which can hold 1 or more values.
The problem is, I want these values to ouput in my json_encode function, but this also needs to happen dynamically depending on the amount of values.

I can't explain it further, so here's the code so far:

Code: (php) [Select]
$files = mysql_fetch_array($get_files);

$a = count($files);

$i = 1;
while ($files) {
$variablename = 'fileName' . $i;
$$variablename = $files['fileName'];
$i++;
}

$output =  array( OTHER VALUES , 'fileName1' => $fileName1, 'fileName2' => $fileName2, 'fileName3' => $fileName3, ............); // How do I add the fileNames dynamically depending on how many there are?


This got me thinking, I also need to dynamically GET the values with jQuery. How would I do that, when the above eventually works?

Thank you.

Hi,

Is there any way to pass dynamic arguments to array_multisort. Below is my idea of what the code should look like. First it has the data then its builds an array of array indexes with the sort direction. This array is then passed to the array_multisort function with the original data.

Code: [Select]

$data[] = array([0] => 67, [1] => 2, [3]' => 2001);
$data[] = array([0] => 86, [1] => 4, [3]' => 2002);
$data[] = array([0] => 98, [1] => 5, [3]' => 2002);
$data[] = array([0] => 86, [1] => 6, [3]' => 2003);
$data[] = array([0] => 67, [1] => 1, [3]' => 2004);

$arg = array(1 => SORT_ASC, 3 => SORT_DESC);

array_multisort($arg, $data);


I have got this working with hardcoded values, for example...

Code: [Select]
array_multisort($sort1, SORT_ASC, $sort3, SORT_DESC, $data);

but in my code instead of just 2 sorts there could be 'x' amounts.

I hope ive made this clear.

Any response would be much appreciated.

Thanks in advance.

Hi !

I'd like to count all occurences in "$thiscodestring" into a "dynamic?" array and print it out after the end of the loop, how do I assign the variablenames dynamically ?

$query = "SELECT codes, status FROM table";

while ($row = mysql_fetch_assoc($result)) {
  $thiscodestring = $row[codes];  // looks like "a1 c2 d3 10 15 1 a1 a1";
  $singlecodes = explode(" ", $thiscodestring);
    foreach($singlecodes as $thiscode) {
      $$thiscode[count] = $$thiscode[count] + 1;
    }
}

After all Mysql-Stuff is done I'd like to print out the counted codes, for example the code "a1" was found 100 times in all querys then $$a1[count] should be 100, c2 was found 15 times, then $$c2[count] should be 15 and so on.

Question:
How do I tell php to assign a "dynamic" variable with the name of the found string which was exploded (in this example a1, c2, d3... ) before ?!

$$ does not seem to work.

And how can I then print_r() the value if I dont know the name ?

Thanks !

How can  I use php to update a dynamic amount of input fields and tell mysql which ones to update respectively?  Essentially I have a list of occupations and if someone wants to update one of them I don't know how to tell php which one they've changed in a dynamic way.

Code: [Select]
<?php

if(!empty($occupations))
{

?>
<h3 id="job_function">Job Functions</h3>
<?php

$i = 0;

foreach($occupations as $occupation)
{

?>
<div class="formElement">
<div class="formFieldLabel ">
<label for="occupation_<?php echo $i; ?>"><?php echo $occupation['companyname']; ?></label>
</div>
<div class="formField">
<input id="occupation_<?php echo $i; ?>" type="text" name="occupation_<?php echo $i; ?>" value="<?php echo $occupation['function']; ?>" />
</div>
</div>
<?php

$i++;

}
}

?>

I'm scraping a housing website with html source:
Code: [Select]
         <tr><td>&nbsp;</td><td> Bedrooms       </td><td>&nbsp;</td><td >3</td><td>&nbsp;</td></tr>
         <tr><td>&nbsp;</td><td> Full Baths     </td><td>&nbsp;</td><td >1</td><td>&nbsp;</td></tr>
         <tr><td>&nbsp;</td><td> Partial Baths  </td><td>&nbsp;</td><td >1</td><td>&nbsp;</td></tr>
         <tr><td>&nbsp;</td><td> Interior Sq Ft </td><td>&nbsp;</td><td >1,356</td><td>&nbsp;</td></tr>
         <tr><td>&nbsp;</td><td> Acres          </td><td>&nbsp;</td><td >0.16</td><td>&nbsp;</td></tr>
What i'm trying to do is create an associative array with only the details I  want from the above. I've already got a function that steps through the HTML and creates an array element for each row with the contents of each <td> statement as follows:

Code: [Select]
$repl = array(" ", "(", ")");
$repl_with = array("", "", "");
foreach ($rows_feat as $id2 => $row2){
$features_raw = $scrape->fetchAllBetween('<td','</td>',$row2,true);
//$features_data[str_replace($repl,$repl_with,strtolower(trim($features_raw[1])))] = trim($features_raw[3]);
$countid=$countid+1;

}
The array produced by this would look like:

features_raw[1] = Bedrooms
features_raw[3] = 1



Basically, I want to take data like this:

Beds       1
Baths      1
Garage    Yes

and create an array on the fly:
House[beds]=1
House[baths]=1
House[garage]="yes"


The problem is that the order of Beds, Baths and Garage changes. So on some house pages the order would be Baths, Garage, Beds.. etc.

Any pointers out there?

Thanks,
Brett

Okay, so I have a page with a heap of fields and buttons on it (and want to keep it like that really) inside one form.

Layout
Box 1 Button 1
Box 2 Button 2
Box 3 Button 3
Box 4 Button 4
etc...

Box 1 is called 'amount1$id'
Box 2 is called 'amount.$id' where $id is the $id of the data being displayed etc

So a sample form may look like
Box: "amount22" Button: "Pay22"
Box: "amount25" Button: "Pay25"
Box: "amount32" Button: "Pay32"
Box: "amount39" Button: "Pay39"
Box: "amount420" Button: "Pay420"

Its working fine up to that point.

My problem now is that I can't work out how to get that id number from the form once submitted. If I could get the button name somehow I could do it, although I don't know the button or box names when writing the processing script. I could use a loop and check if button1 to buttonX was posted etc, although if there is a large number of entries in the database, then that starts to become a problem. Thoughts?

Hi all, it's been a while since I wrote in PHP but a University project has forced me to touch up on my knowledge of it. I'm trying to re-create an old form making system I made a few years ago from memory. But it's not working. I know it's something very obvious but I just need another eye to take a look for me.

I get the following error message: Warning: Invalid argument supplied for foreach() in /home/birdneto/public_html/rebelfrogv2/p_createaccount.php on line 169

So I know it's do with my show_form(); function. Can anyone help?

Code: [Select]
<div id="page-body-special">
<?php

// List page details
$page_header = "Create your account";
$page_desc = "Enter your details below to create an account. Creating an account comes with great benefits! You can create a wishlist, sign up for our mailing list and purchase items. Make sure you enter all your information correctly.";

// List form details
$form_name = "createaccount";

// List all the field names here
$field_email_address = "email_address";
$field_email_address_confirm = "confirm_email_address";
$field_password = "password";
$field_password_confirm = "confirm_password";

$field_house_number = "house_number";
$field_street_name = "street_name";
$field_city = "city";
$field_county = "county";
$field_postcode = "postcode";
$field_phone_number = "phone_number";

$field_newsletter = "newsletter";

$field_submit = "submit";

// Define all the field meta data (field name, maxlength, minlength, field type, [field options], [field description])
$fields = array(
array($field_email_address, 80, 8, "text", $_POST[$field_email_address]),
array($field_email_address_confirm, 80, 8, "text", $_POST[$field_email_address_confirm]),
array($field_password, 16, 8, "password", $_POST[$field_password]),
array($field_password_confirm, 16, 8, "password", $_POST[$field_password_confirm]),

array($field_house_number, 2, 4, "password", $_POST[$field_house_number]),
array($field_street_name, 16, 8, "password", $_POST[$field_street_name]),
array($field_city, 16, 8, "password", $_POST[$field_city]),
array($field_county, 16, 8, "password", $_POST[$field_county]),
array($field_postcode, 16, 8, "password", $_POST[$field_postcode]),
array($field_phone_number, 16, 8, "password", $_POST[$field_phone_number]),

array($field_newsletter, 0, 0, "checkbox", $_POST[$field_newsletter], 0, "Would you like to sign up to our newsletter?"),

array($field_submit, 0, 0, "submit", "Create Account")
);

// Check if form has been submitted or not. All fields must be declared here with an if statement
if($_POST['submit'])
{
// Set no_errors and show_form to inital 0
$no_errors = 1;

function show_errors($field)
{
if($field == $field_email_address)
{
if(strlen($_POST[$field_email_address]) < $fields[0][2] and strlen($_POST[$field_email_address]) > $fields[0][1])
{
$no_errors = 0;
$error = "Your email address must be between " . $fields[0][2] . " and " . $fields[0][1] . " characters";
}
}

if($field == $field_email_address_confirm)
{
if($_POST[$field_email_address_confirm] != $_POST[$field_email_address])
{
$no_errors = 0;
$error = "Your emails do not match each other";
}
}

if($field == $field_password)
{
if(strlen($_POST[$field_password]) < $fields[2][2] and strlen($_POST[$field_password]) > $fields[2][1])
{
$no_errors = 0;
$error = "Your password must be between " . $fields[2][2] . " and " . $fields[2][1] . " characters";
}
}

if($field == $field_password_confirm)
{
if($_POST[$field_password_confirm] != $_POST[$field_password_confirm])
{
$no_errors = 0;
$error = "Your passwords do not match";
}
}

if($field == $field_house_number)
{
if(strlen($_POST[$field_house_number]) < $fields[4][2] and strlen($_POST[$field_house_number]) > $fields[4][1])
{
$no_errors = 0;
$error = "Your house number must be between " . $fields[4][2] . " and " . $fields[4][1] . " numbers";
}
}

if($field == $field_street_name)
{
if(strlen($_POST[$field_street_name]) < $fields[5][2] and strlen($_POST[$field_street_name]) > $fields[5][1])
{
$no_errors = 0;
$error = "Your street name must be between " . $fields[5][2] . " and " . $fields[5][1] . " characters";
}
}

if($field == $field_city)
{
if(strlen($_POST[$field_city]) < $fields[6][2] and strlen($_POST[$field_city]) > $fields[6][1])
{
$no_errors = 0;
$error = "Your city must be between " . $fields[6][2] . " and " . $fields[6][1] . " characters";
}
}

if($field == $field_county)
{
if(strlen($_POST[$field_county]) < $fields[7][2] and strlen($_POST[$field_county]) > $fields[7][1])
{
$no_errors = 0;
$error = "Your county must be between " . $fields[7][2] . " and " . $fields[7][1] . " characters";
}
}

if($field == $field_postcode)
{
if(strlen($_POST[$field_postcode]) < $fields[8][2] and strlen($_POST[$field_postcode]) > $fields[8][1])
{
$no_errors = 0;
$error = "Your postcode must be between " . $fields[8][2] . " and " . $fields[8][1] . " characters";
}
}

if($field == $field_phone_number)
{
if(strlen($_POST[$field_phone_number]) < $fields[7][2])
{
$no_errors = 0;
$error = "Your phone number must be under " . $fields[7][2] . " numbers";
}
}

return $error;
}

if($no_errors == 0)
{
show_form();
}
else
{
echo "<p>Form posted</p>"; echo $br . $br;
}
}
else
{
show_form();
}

function show_form()
{
// Show the page header
echo $br . '<form method="post" action="./?p=' . $page . '" name="' . $form_name . '">'; echo $br . $br;
echo '<table id="form-' . $form_name . '">'; echo $br;

// List all fields in form format
foreach($fields as $meta)
{
// Explode the array and implode it, changes commas to spaces, then makes all words have capital letters
$label_exp = explode("_", $meta[0]);
$label_imp = ucwords(implode(" ", $label_exp));

// Is the field type a submission?
if($meta[3] == "submit")
{
echo ' <tr><td colspan="2"><input type="' . $meta[3] . '" name="' . $meta[0] . '" class="' . $meta[0] . '" value="' . $meta[4] . '" /></td></tr>'; echo $br;
}
// Is the field type a select?
elseif($meta[3] == "select")
{
$options = explode(",", $meta[5]);

echo ' <tr><td><label>' . $label_imp . '</label></td><td><select type="' . $meta[3] . '" name="' . $meta[0] . '" class="' . $meta[0] . '">'; echo $br;

foreach($options as $option)
{
function is_selected()
{
if($option == $_POST[$meta[0]])
{
echo 'selected="selected"';
}
}

echo(' <option ' . is_selected($option) . '>' . $option . '</option>'); echo $br;
}

echo ' </select></td></tr>'; echo $br;
}
// Is the field type a checkbox?
elseif($meta[3] == "checkbox")
{
echo ' <tr><td><label>' . $meta[6] . '</label></td><td><input type="' . $meta[3] . '" name="' . $meta[0] . '" class="' . $meta[0] . '" /></td></tr>'; echo $br;
}
// Is the field type anything else?
else
{
echo ' <tr><td><label>' . $label_imp . '</label></td><td><input type="' . $meta[3] . '" name="' . $meta[0] . '" class="' . $meta[0] . '" maxlength="' . $meta[1] . '" value="' . $meta[4] . '" /></td></tr>'; echo $br;
}
}

// Show the page footer
echo '</table>'; echo $br . $br;
echo '</form>'; echo $br . $br;
}

echo $br . "<h1>" . $page_header . "</h1>"; echo $br . $br;
echo "<p>" . $page_desc . "</p>"; echo $br . $br;

echo '<div class="clear"></div>'; echo $br . $br;

?>
</div>

hi i am trying to make a payroll calculator script that takes employee info, calculates pay, displays submitted info in a table, stores info in an array, and updates the array when new info is submitted. i have most of these accomplished, i am having trouble with the "store into an array, and update the array when new info is submitted" parts of the project. i am still not very fluent in php so there may be easier ways to achieve what i have so far. any pointers would be a great help, this part has got me stumped.

Hi All,

Come a little stuck with an issue and hoping someone can shed some light on it.

Basically, I have a form that pulls down the list of users and then pulls down a list of jobs that can be assigned to them. I can get the form to pull all this down, but when I post the data, I am unsure of how to process this for each user and insert into the database.

I have tried adding the [] onto the field name, but this doesn't work as one of the dropdowns that you choose the position for, populates another dropdown of site addresses you are allocating too.

I have attached the Script to see if anyone is able to assist with any guidance.

$userClient = "VARIABLE OF WHO IS LOGGED IN";  
<form action="actions/assign.php" method="post">
	  <?php 
	  $sql = "SELECT * FROM Engineers where Engineer_Company = '".addslashes($userClient)."' and userType = '5'";
	  $result = mysqli_query($db, $sql);
	  
	  while($row = mysqli_fetch_assoc($result)) {
		  		$userSID = $row["userID"];
		  echo '<tr>
		  			<td>'.$row["userName"].'    
					
					<input type="hidden" class="form-control"  id="usersID[]" name="usersID'.$row["userID"].'" value="'.$row["userID"].'">
					<input type="hidden" class="form-control"  id="date" name="date" value="'.date('d-m-Y').'">
</td>
					<td>';
		  
		  			$sql1 = "SELECT * FROM job_orders where companyID = '".addslashes($userClient)."'";
					$result1 = mysqli_query($db, $sql1);
	  				echo "<select style='width: 250px;' id='job$userSID' name='job$userSID'>";
		  			echo '<option value="">-- Please Select --</option>';

	  				while($row1 = mysqli_fetch_assoc($result1)) {
		  				echo '<option value="'.$row1["jobID"].'">'.$row1["jobtitle"].'</option>';
					}
	  
	  	  echo "</select>";	  
		  echo '</td>
		  
		  
		  <td>'; 
				  
	
		  
    $query = $db->query("SELECT * FROM Engineer_Company WHERE Company_ID = '".addslashes($userClient)."'");
    $rowCount = $query->num_rows;

        if($rowCount > 0){
			echo '    <select name="company'.$userSID.'" id="company'.$userSID.'" style="width: 250px;">
        <option value="">-- Select Company --</option>';
            while($row = $query->fetch_assoc()){ 
                echo '<option value="'.$row['Engineer_Company_ID'].'" class="form-control form-control-sm">'.$row['Engineer_Company_Name'].'</option>';
            }
			echo '</select>';
        }
   
		  
		  
		  echo'</td>
		  
		    <td>
			
			<div class="form-group">


    <select id="site'.$userSID.'" name="site'.$userSID.'"  style="width: 250px;">
        <option value="">-- Select Site --</option>
                              </select>
           
	
	
	
    </div>
			'; 
				  
	echo'</td>
    </tr>';

		  
		  echo '    <script type="text/javascript">
$(document).ready(function(){
    $("#company'.$userSID.'").on("change",function(){
        var diag_id = $(this).val();
        if(diag_id){
            $.ajax({
                type:"POST",
                url:"ajax-client-side.php",
                data:"diag_id="+diag_id,
                success:function(html){
                    $("#site'.$userSID.'").html(html);
                }
            }); 
        }
    });
    

});
</script>';
	  }
	  ?>

  </tbody>
</table>
	
			<input class="btn btn-dark float-right" type="submit" value="Allocate">

			  </form>
			

Cheers!

Hi,

i am creating a web application, and i would like some help/advise on how to tackle a problem. I need to make an image i have into a contact form, with four fields, which basically posts information into a database. I am not sure how i would go about doing this as i will need to make each of the fields dynamic to post the data. I have attached the image to make my point a bit clearer.

thanks

So I know a little about PHP but I am no expert by any means. But I have a project that I am working on for a fantasy football league and need some help. My users pick players from a list and then their selections are put into a database. So more than one user is likely to pick the same player. Then I need to score the players based off their games for the week. So I have code that gets the Distinct PlayerID and creates a form to update the player score (see code below), but I have no idea how to process the form. It's a little more complicated then the forms I've used before because the MySQL query would need to UPDATE all the rows for each individual PlayerID. Am I making any sense?

Anyway, here is the code. If anyone has suggestions on how to process this form or a better way of doing it then please let me know.

<?
print '<form id="form1" name="form1" method="post" action="update_player.php">';
// Connecting, selecting database
$link = mysql_connect('localhost','user','pass');
if (!$link) {
die('Could not connect: ' . mysql_error());
}

//Query
$query=mysql_query("select DISTINCT(PlayerID), PlayerName, Team From fantasy4.temp ORDER BY Team;") or die ('Could not connect: ' . mysql_error());
print'
<center>
<table align=center border=0 cellpadding=0 cellspacing=2 width=350>
<tr align=center>
<td width=50 align=center><b>Player ID </b></td>
<td width=50 align=center><b>Team</b></td>
<td width=200 align=center><b>Player Name</b></td>
<td width=50 align=center><b>Score</b></td>
<tr><td colspan="10" bgcolor="black" height="1"></td></tr>
';

while($row=mysql_fetch_array($query)){
if($color == 1)
{
print '<tr bgcolor=#dDdDdD>
<td align=center> ' . $row['PlayerID'] . ' </td>
<td align=center> ' . $row['Team'] . ' </td>
<td align=center> ' . $row['PlayerName'] . ' </td>
<td align=center> <input name="' . $row['PlayerID'] . '" type="text" id="' . $row['PlayerID'] . '" size="5" maxlength="5" /> </td>
</tr>';
$color=0;
}
else
{
print '<tr>
<td align=center> ' . $row['PlayerID'] . ' </td>
<td align=center> ' . $row['Team'] . ' </td>
<td align=center> ' . $row['PlayerName'] . ' </td>
<td align=center> <input name="' . $row['PlayerID'] . '" type="text" id="' . $row['PlayerID'] . '" size="5" maxlength="5" /> </td>
</tr>';
$color=1;

}
}
print '</table>';
print '<input type="submit" name="button" id="button" value="Update Player Scores" /></form>';
?>

This is what I tried that did not work

<?

// Connecting, selecting database
$link = mysql_connect('localhost','user','pass');
if (!$link) {
die('Could not connect: ' . mysql_error());
}

//Query
$query=mysql_query("select DISTINCT(PlayerID) From fantasy4.temp;") or die ('Could not connect: ' . mysql_error());


while($row=mysql_fetch_array($query)){
$PlayerID = $_POST[$row['PlayerID']];
}

while($score = array($_POST['$PlayerID'])){


//Insert Query

$query2=mysql_query("UPDATE fantasy4.temp set Score='$score' where PlayerID='$PlayerID'") or die ('Yikes could not connect: ' .mysql_error());

$result = @mysql_query($query2);
}
//Check whether the query was successful or not
if($result) {
header("location: register-success.php");
exit();
}else {
die("Query failed - " .mysql_error());
}

?>

First off thank you for opening my issue and taking the time out to try and help.

I have created a php page that will display a list of people from a mysql database. What i would like to do is have a button that will update a field in the database when pressed. My question is if i make the fields into a form will it only update that one person?

Hi - I have a form which is populated with values from a DB. This is done by looping through the DB values using a foreach. It works fine. I populate my form with those values. However, I want to be able to amend those values, and then submit the new values back to the DB with 1 single submit button. I don't want a separate submit button for each row of my form.

The problem is that because the form is built with a foreach, as the it loops through the variables on each pass of the DB, only the final row of DB are present in the form variables.

Question: My 'foreach' approach must be faulty. What is the mechanism or approach I need to use to update the values from the whole form  ??

MANY THANKS for all your help !!