PHP - Save Alpha

RewriteOptions inherit
RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule ^([a-z0-9-]+)$ /storeNumber.php?storeNumberID=$1 [NC,L]

What is the best way to capture items that someone wants to purchase when they don't have an account yet?

And I prefer not using cookies.

<button onClick="window.print()">Print this page</button> 

$object = new Three;
class Three
{
    public $Panel, $Search, $Filter;
    function save_Three()
    {
        while($Prow = sqli_fetch_array($Panel, MYSQLI_BOTH))
        {
            $PanelName = $Prow ['name'];
        }
        while($Srow = sqli_fetch_array($Search, MYSQLI_BOTH))
        {
            $SearchName = $Srow ['name'];
        }
        while($Frow = sqli_fetch_array($Filter, MYSQLI_BOTH))
        {
            $FilterName = $Frow ['name'];
        }
        $Combined = array_intersect($Panel, $Search, $Filter);
        foreach ($Combined as $item)
            print $item;
    }
}

$Panelsql = "SELECT DISTINCT aID, name from test.article";

if (isset($_GET['pid']))
{
    $pID= $_GET['pid'];
    echo "$pID";

    $Panelsql = "SELECT DISTINCT aID, name from test.a_m, test.platform, test.message, test.article where aid in 
    (SELECT DISTINCT assocAID from test.a_m, test.platform, test.message where assocMID in
    (SELECT mID from test.message, test.platform where pID=$pID and pID = assocPID))";

}
else if (isset($_GET['mid']))
{
    $mID= $_GET['mid'];

    
    $Panelsql = "SELECT DISTINCT aID, name from a_m, message, article where aid in 
    (SELECT DISTINCT assocAID from a_m, message where mID=$mID and mID = assocMID)";
}
else
{   
    $Panelsql = "SELECT DISTINCT aID, name from article";
}

$object->Panel = $Panelsql;

$aRegions = $_POST['RegionSelected'];
$Filtersql = 'SELECT * FROM test.article';
if(isset($aRegions))
{
    $Filtersql .= ' WHERE 1 AND ('; 
    foreach ($aRegions as $word) 
    if($word==$aRegions[count($aRegions)-1])
    {
        $Filtersql .= " Region = '". $word ."')";
    }
    else
    {
        $Filtersql .= " Region = '". $word ."' OR";
    }
}
//Population filtering function
$aPopulations = $_POST['PopulationSelected'];
if(isset($aPopulations))
{
    if(!isset($aRegions)){$Filtersql .= ' WHERE 1 AND ('; }
    else
    {
        $Filtersql .= ' AND (';
    } 
    foreach ($aPopulations as $word) 
    if($word==$aPopulations[count($aPopulations)-1])
    {
        $Filtersql .= " Population = '". $word ."')";
    }
    else
    {
        $Filtersql .= " Population = '". $word ."' OR";
    }       
            
}

$object->Filter = $Filtersql;


$Searchsql="SELECT * FROM test.article";

if (isset($_POST['search'])){
    
    $st= ($_POST['search_box']);
    $Searchsql .= " WHERE name LIKE '%{$st}%' OR abstract LIKE '%{$st}%' OR Summary LIKE '%{$st}%' OR Keyword LIKE '%{$st}%'
    OR population LIKE '%{$st}%'OR region LIKE '%{$st}%'";
}
$object->Search = $Searchsql;

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 Everyone,

i need some help how can i save this jsonfile to the webserver? 

my code

       // Load initial values from JSON 'file'
    jsonfile = '[{"lane 1":"1","lane 2":"1","lane 3":"5","lane 4":"2"}]';
    var initialstate = JSON.parse(jsonfile);
    setLaneState("lane1",initialstate[0]['lane 1'])
    setLaneState("lane2",initialstate[0]['lane 2'])
    setLaneState("lane3",initialstate[0]['lane 3'])
    setLaneState("lane4",initialstate[0]['lane 4'])