PHP - 2 Multi List Selection Boxes Assistance

if a user were to select multiple items in a selection list I would like to concatenate those items into a list and assign that into a variable. I know I should loop through the list but i'm not sure how I would continue to add those values to a variable.

I'm trying to get this drop down menu to be sticky once the user clicks submit. 

Here's my entry code:
Code: [Select]
if (isset($_POST['guess']))
{
    if ($_POST['guess'] == $_SESSION['number'])
    {
        $response = "You Win!";
        unset($_SESSION['number']);
    }
    else
    {
        $_SESSION['tries']++;
       
        if ($_SESSION['tries'] < 3)
        {
            $response = "Try #{$_SESSION['tries']}<br /><br />";
        }
        else
        {
            $response = "You Lose";
            unset($_SESSION['number']);
        }
    }
}

if (empty($_SESSION['number']))
{
    $_SESSION['tries'] = 0;
    $_SESSION['number'] = rand(1, 10);
}
And in my body:

Code: [Select]
<select name="guess" id="guess">
                <?php
                
                for ($i = 1; $i < 11; $i++)
                {
                    echo "<option value='{$i}'>{$i}</option>";
                }
                
                ?>
            </select>

Quote

I have this code here. i wanted to know how i can be able to make multiple selections from the returned data from the database and how to save them

Quote

 

 <select name="troom"  multiple class="form-control" required>
                                    <option  selected="true" disabled="disabled">--Select a room--</option>
                                    


                                        
                                        $records =mysqli_query($con, "select * from room where TRoom not in (select TRoom from roombook where cin <= '$checkout' and cout >= '$checkin');");
                                        
                                        while ($data = mysqli_fetch_array($records)) {
                                            echo "<option value='" . $data['TRoom'] . "'>" . $data['TRoom'] . "</option>"; //displaying data in option menu
                                        }
                                    }

                                    ?>

                                </select>

 

 

could anyone please help me with the code which is i have already displayed data as a multi select list but now i need to select one or more from them and insert into another database table. would be appreciate your help. thanx

Hi, I'm new to PHP/MySQL and need some help getting my query to work for my selection list:

The selection list is built with:
<form action='processformmissing.php' method='POST'>
<fieldset>
<legend>Choose Department</legend>
<select name='depart'>
<option value=''></option>

<?php
while ($row = mysqli_fetch_array($result))
{
extract($row);
echo "<option value='$department'>$department</option>\n";
}
?>
</select>
<p><input type='submit' value='Select Department' /></p>
</fieldset>

</form>

The data is then sent to:

$depart = $_POST['depart'];
$deptlike = "%".$depart."%";

echo "<p>$depart</p>";
echo "<p>$deptlike</p>";

$query = "SELECT * FROM lifecerts INNER JOIN employees ON lifecerts.cid = employees.cid WHERE department LIKE '$deptlike' ORDER BY employees.name";



Hitting the submit button from my selection list form seems to be working fine because when I echo my data ($depart and $deptlike) it is giving me the correct value, but the query doesn't give me any results. However, if my post data comes from a text box instead of a selection list, my query works fine. Any thoughts on what I'm doing wrong???

Many thanks!

ok... I'm still struggling with PHP syntax, my editor's linting keeps flagging a line as incorrect. it's supposed to read as " when d1 minus 1 is less than or equal to d2 with d2 being less than or equal to d1 plus 1" so in other words its supposed to be true if d2 is between d1 minus 1 and d1 plus 1, inclusive. I don't want d2 being the previous number, the same number or the next number relative to d1. The same goes for d3, d4, and d5 (4 and 5 are un coded because why code in errors).

That being said... This isn't exactly my correct goal but I'm not sure how to code what I really want...
Rules
a 3 - 5 digit combo (0 - 99 per digit) whe
1. the numbers are not in order. (1,2,3,4 or 55,56,57,58,59 or 4,3,2,1 or 59,58,57,56,55)
2. no more than 2 numbers in the combo may be the same. (45,12,67,12,78 is ok 17,35,17,24,17 is not)
3. repeat numbers may not occur next to each other (45,12,67,12,78 = valid 45,67,12,12,78 = invalid)

I can't seem to find a good way to test this without the commands I know from other languages like CountIf, Iffn and RandSamp. (those are Ti-Basic commands)

I know "please do it for me" is frowned upon, and hate saying it (I'd rather learn to do it myself), but if anyone can explain how to do this I'd really appreciate it.

Edited March 23, 2019 by Karaethon

EDIT: It would seem i placed this in the wrong section. Can we have a mod move this?
I'm gonna go ahead and admit that this is a task that my school left me for my course in PHP and mySQL but i won't just ask for someone to construct the code for me but just to give me advice and assistance in my code.
What i'm trying to do is request a number from a user and generate random integers between 1 to 100 as many as the user specified.
The task told me to place all the numbers in an array and that i can use a foreach loop to go through and indicate what numbers are lower than 50 and what is higher than 50.

The output should be similar to this:

All your numbers:
45
23
14
79
99
22
56

Numbers lower than 50:
45
23
14
22

Numbers higher than 50:
79
99
56


This is my code:
Code: [Select]
<!DOCTYPE html PUBLIC "-//w3c//DTD XHTMLm 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmnlns="http://www.w3.org/1999/xhtml" xml:lang="sv" lang="sv">
<head>
<meta http-equiv="Content-Type" content="text/html; charset="utf-8" />
<title>Task</title>
</head>

<body>


<?php
$Nummer=$_REQUEST['nummer'];
 for ($count=1;$count <= $Nummer; $count++){
$testSlump = rand(1, 100);
echo $testSlump . "</br>";
}

$testArray = array($testSlump);
foreach ($testArray as $n) {
if ($testArray > 50){
echo $testArray . echo 'this number is lesser than 50';
}
}
?>

</body>
</html>


I've googled, read through the litterature but none seem to help me. I thought to myself that one solution might be placing all values generated in a for loop in an array and then using the foreach loop to confirm what is what. Class notes and our schools PHP help site doesnt have anything that would help me finish this task.

How do you place for loop values in an array? (if i'm on the right track)

Any help etc is greatly appreciated.

I have a html/php i am creating but getting the following error:

[10-May-2019 09:42:13 UTC] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in C:\inetpub\wwwroot\SupportDesk\php\Add_New_Engineer.php:88
Stack trace:
#0 C:\inetpub\wwwroot\SupportDesk\php\Add_New_Engineer.php(5): create_eng()
#1 {main}
  thrown in C:\inetpub\wwwroot\SupportDesk\php\Add_New_Engineer.php on line 88

Here is my code:

<?php
$server = htmlentities($_SERVER['PHP_SELF']); 
 	if (isset($_POST['submit'])) {
        $result = create_eng();
 }
?>
<!DOCTYPE html>
<html lang="en">
   <head>
      <title>Add A New Engineer | DDS Dashboard</title>
      <meta charset="utf-8"  />
      <link rel="icon" type="image/png" href="../images/favicon-16x16.png"/>
   </head>
   <body>
      <?php 
         include('nav.php');
         include('ConnectionDB.php');
         
         ?>
      <div class="jumbotron">
         <div class="container">
            <h1><br><img src="../images/clipboard-customer.png"/> Add New Engineer:</br></h1>
         </div>
      </div>
      <form class="form-horizontal" role="form" id="add_eng" action="<?php $server ?>" method = "post">
         <div class="form-group">
		 <!--<?php //display_msg($msg);?>-->
            <label for="EngineerName" class="col-sm-2 control-label">Engineer Name:</label>
            <div class="col-sm-6">
               <input type="text" class="form-control" id="EngName" name="EngineersName" placeholder="Enter Engineer's Name"></input>
               <small class="form-text text-muted">
               Enter the new engineer's name above to enter them into the database.
               </small>
            </div>
            <input name="submit" type="submit" value="Create Engineer" class="btn btn-primary default"></input>
            <input name="reset" type="Reset" value="Reset Form" class="btn btn-primary default"></input>
         </div>
      </form>
      <br><br>
   </body>
</html>
	<?php
	$sql = "Select * from [Engineers] where [Engineer] not like '%\_%' Escape '\' order by [Engineer] asc";
			$stmt = $conn->prepare($sql);
			$stmt->execute();
			$results=$stmt->fetchAll(PDO::FETCH_ASSOC);
			?>
			<div class="containerenglist">
			<div class="col-sm-5">
			<table id="alleng" class="table table-bordered">
			<tr>
			<th>Active Engineer's Names:</th>
			</tr>
			<?php
			foreach ($results as $row) {
				echo "<tr><td>";
				echo $row['Engineer'];
				echo "</td>";
				echo "</tr>";
			}
			?>
			</table>
			</div>
			</div>
	
</body>
</html>		

<?php

Function create_eng(){
	global $msgID;
	global $msg, $conn;
	include('ConnectionDB.php');
	$conn = null;
	$msgID = 0;
	//Get POST from submit
	$eng_name = $_POST['EngineersName'];
	//SQL Query
	$sql_count = "select count(*) as num from [Engineers] where [Engineer] = :eng_name";
	//Query SQL Statement
	//echo $eng_name;
	$stmt = $conn->prepare($sql_count);
	$stmt->bindValue(':eng_name', $eng_name);
	//Execute SQL Statement
	$stmt->execute();
	$results=$stmt->fetchAll(PDO::FETCH_ASSOC);
	If($results['num'] > 0){
		echo $msg = "Engineer $eng_name exist's in the database";
		$msgID = 1;
	}else{
		$sql_insert = "insert into [Engineers](Engineer) values '$eng_name'";
		//Prepare SQL Statement
		$stmt = $conn->Prepare($sql_insert);
		//Execute SQL Statement
		$stmt->execute();
	    $results=$stmt->fetchAll(PDO::FETCH_ASSOC);
		echo $msg = "Engineer $eng_name added to the database";
		$msgID  = 2;
	}

}	
?>

Everything works correctly until i try submitting a name to the DB the line that is being pulled is $stmt = $conn->prepare($sql_count);

 

 

So I have the following and for some reason or another it's not wanting to work with me. If I do the query directly in phpmyadmin it will return the number, however for some reason when I throw it into a variable it won't return anything. I have a feeling it's because of the text string? How do you properly represent a string of text that has a space between it?

1st query get's the name from another table:

$query = "SELECT name FROM info WHERE userdid = 4";
$data = mysqli_query($dbc, $query);
$row = mysqli_fetch_array($data);

$tname = $row['name'];


Table: testing
rows: number name
data: 4      Testing This

$query1 = "SELECT number FROM testing WHERE name = '" . $tname . "'";
$data1 = mysqli_query($dbc, $query1);
$row1 = mysqli_query($data1);

$numreturn = $row1['number'];

// Do stuff

Hello all,
I wrote a script that will upload an avatar to a users profile and to do this the user has to get a randomly generated pin that is stored to thier profile info in a MySQL db what i am trying to accomplish with this code is once the form is submitted this code checks the database to see if the ID is there and that the pin matches if so then it continues to upload the file if not it stops displays an error and the upload form. For some reason the script continues to upload even when i input fake values that are not in the DB .... i know its something simple that im jsut over looking so perhaps a fresh set of eyes will help...


<?php

include './config.php';

include './access.php';
// Receiving variables
@$steamid = addslashes($_POST['steamid']);
@$pin = addslashes($_POST['pin']);
@$avatar_Name1 = $_FILES['avatar']['name'];
@$avatar_Size = $_FILES['avatar']['size'];
@$avatar_Temp = $_FILES['avatar']['tmp_name'];
@$avatar_Mime_Type = $_FILES['avatar']['type'];

@$ava_strQuery1 = "SELECT * FROM $member_table WHERE authid='$steamid' AND private_pin='$pin'";
@$ava_host1 = "$hostname";
@$ava_user1 = "$username";
@$ava_pw1 = "$password";
@$ava_db1 = "$database";
$ava_link1 = mysql_connect($ava_host1, $ava_user1, $ava_pw1);
if (!$ava_link1) {
 die('Could not connect: ' . mysql_error());
}
$ava_db_selected1 = mysql_select_db($ava_db1, $ava_link1);
if (!$ava_db_selected1) {
die ('Can not use $ava_db1 : ' . mysql_error());
}
//upload file and insert new record if ID and PIN match
$ava_result1 = mysql_query($ava_strQuery1);
if (!$ava_result1) {

function findexts ($avatar_Name1) 
{ 
$filename = strtolower($avatar_Name1) ; 
$exts = split("[/\\.]", $avatar_Name1) ; 
$n = count($exts)-1; 
$exts = $exts[$n]; 
return $exts; 
}
$ext = findexts ($_FILES['avatar']['name']) ;
$ran = rand () ;
$ran2 = $ran.".";
$avatar_Name = $ran2.$ext;

//Checking/Making Folder
function RecursiveMkdir($path)
 {
   if (!file_exists($path)) 
   { 
      RecursiveMkdir(dirname($path));
      mkdir($path, 0777);
    }
  }


// Validation
if (strlen($steamid) <15)
{
die("<p align='center'><font face='Arial' size='3' color='#66CCFF'>Please enter a valid steamid <br>(ex: STEAM_0:0:00000)</font></p><p align='center'><a href='avatar.php'>BACK</a></p>");
}
if (strlen($steamid) >20)
{
die("<p align='center'><font face='Arial' size='3' color='#66CCFF'>Please enter a valid steamid <br>(ex: STEAM_0:0:00000)</font></p><p align='center'><a href='avatar.php'>BACK</a></p>");
}

if (strlen($steamid) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#66CCFF'>Please enter a valid steamid <br>(ex: STEAM_0:0:00000)</font></p><p align='center'><a href='avatar.php'>BACK</a></p>");
}

if (strlen($pin) !=12)
{
die("<p align='center'><font face='Arial' size='3' color='#66CCFF'>Please enter a valid pin<br>Dont have a pin? click <a href='#'>here</a></font></p><p align='center'><a href='avatar.php'>BACK</a></p>");
}

if (strlen($pin) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#66CCFF'>Please enter a valid pin<br>Dont have a pin? click <a href='#'>here</a></font></p><p align='center'><a href='avatar.php'>BACK</a></p>");
}

if( $avatar_Size == 0)
{
die("<p align='center'><font face='Arial' size='3' color='#66CCFF'>Please select an image that is 50KB or less in size and its type is .jpg, .gif, or .png</font></p><p align='center'><a href='avatar_upload.php'>BACK</a></p>");
}
if( $avatar_Size >51200)
{

//delete file 
unlink($avatar_Temp);
die("<p align='center'><font face='Arial' size='3' color='#66CCFF'>Please select an image that is 50KB or less in size and its type is .jpg, .gif, or .png</font></p><p align='center'><a href='avatar_upload.php'>BACK</a></p>");
}
if( $avatar_Mime_Type != "image/gif" AND $avatar_Mime_Type != "image/jpeg" AND $avatar_Mime_Type != "image/pjpeg" AND $avatar_Mime_Type != "image/png" AND $avatar_Mime_Type != "image/x-png")
{
unlink($avatar_Temp);
die("<p align='center'><font face='Arial' size='3' color='#66CCFF'>Please select an image that is 50KB or less in size and its type is .jpg, .gif, or .png</font></p><p align='center'><a href='avatar_upload.php'>BACK</a></p>");
}
$uploadFile = "avatars/".$avatar_Name ;
if (!is_dir(dirname($uploadFile)))
  {
    @RecursiveMkdir(dirname($uploadFile)); 
  }
else
  {
  @chmod(dirname($uploadFile), 0777);
  }
@move_uploaded_file( $avatar_Temp , $uploadFile); 
chmod($uploadFile, 0644);
$avatar_URL = "*************/".$avatar_Name ;

//saving record to MySQL database
@$ava_strQuery = "UPDATE $member_table SET avatar ='$avatar_Name' WHERE authid='$steamid' AND private_pin='$pin'";
@$ava_host = "$hostname";
@$ava_user = "$username";
@$ava_pw = "$password";
@$ava_db = "$database";
$ava_link = mysql_connect($ava_host, $ava_user, $ava_pw);
if (!$ava_link) {
 die('Could not connect: ' . mysql_error());
}
$ava_db_selected = mysql_select_db($ava_db, $ava_link);
if (!$ava_db_selected) {
die ('Can not use $ava_db : ' . mysql_error());
}

//insert new record
$ava_result = mysql_query($ava_strQuery);
if (!$ava_result) {
 die('Invalid query: ' . mysql_error());
}
mysql_close($ava_link);

 echo("<p align='center'><font face='Arial' size='3' color='#66CCFF'>Image uploaded OK!</font></p><p align='center'></p>");
 echo "<div align='center'>";
 echo "<p><img src=$avatar_URL></p>";
 include ('./includes/avatar_upload.php');
 echo "</div>";
}else{ //if ID and PIN dont match display error and form

echo "Wrong SteamID/Pin Please Try Again...";

echo "<br />";

include ('./includes/avatar_upload.php');
}
mysql_close($ava_link1);
?>

I have an array here that looks like this:

Code: [Select]
Array
(
    [server_info] => Array
        (
            [up] => 1
            [up_since] => Sun, 23 Oct 2011 04:04:01 -0600
            [up_for] => 2588
            [version] => Beta 1.9 Prerelease 4
        )

    [players] => Array
        (
            [0] => Pyr3x
        )

    [server_settings] => Array
        (
            [map] => Underworld
            [pvp] => 1
            [pve] => 1
            [max] => 50
        )

    [admins] =>
    [ops] => Array
        (
        )

)

How would I for example print the contents of the players array without having to be specific on which object within it that I wish to print, it's dynamic so it's always going to change.

Example of the output I'd like is:

Players: Pyr3x, SomeGuy, AnotherGuy

Thank you for any help you may be able to provide.

-Pyr3x

I'm trying to dissect a string using preg_match but I'm having a hard time understanding the tutorials (and the php manual).  This is as far as I've gotten:
Code: [Select]
<?php

$message = "EASTRIVANN RES STRUCTURE FIRE AD: 4966 TURKEY SAG RD CTY: AC LOC: ATAC4 FIRE IN STRUCTURE/ALARM CO CONFIRMED W/HOMEOWNER XST: 2751 BELL ACRES XST2: 2312 PETERS MTN RD";

$typepattern = ('/^EASTRIVANN /');

preg_match($typepattern, $message, $matches);
if ($matches) {
echo $matches[0];
}else{
echo 'No matches.';
}


?>
My goal is to pull the following out of the string:

Code: [Select]
$alarmtype = "RES STRUCTURE FIRE";
$address = "4966 TURKEY SAG RD";
$county = "AC";
$location = "ATAC4 FIRE IN STRUCTURE/ALARM CO CONFIRMED W/HOMEOWNER";
$xst = "2751 BELL ACRES";
$xst2 = "2312 PETERS MTN RD";

I am them storing the values into a database for later retrieval.  I've gotten as far as Matching EASTRIVANN but i'm not sure how to pull out the actual text between my anchors.  Any help would greatly be appreciated


Thanks

Jason

Hey all, I'm currently working on a website/database system. What i'm trying to achieve atm is for a user to be able to edit current data in a database table, submit it, and for it to display the new data in the webpage. The table i'm reading from has 6 records and the fields ID(which is just auto_incremented) and courseName.

Ideally, I would like the user to be able to delete a record too. The code I have written displays the courseName's in a table along with textareas and a submit button for each row. It seems to be doing nothing at the minute, so I was hoping someone could enlighten me as to what I've done wrong and if someone could provide what code i'm missing if any, i would be ever so grateful  I think I might have structured it all wrong, I hope this isn't the case! My current code is below, hope to hear some feedback soon, many thanks, Aaron

PS: feel free to ask any more question in case I've forgot to mention something

Code: [Select]
<?php
session_start();
$hostname_logon = "***.*.*.*" ;   
$database_logon = "aal9" ;  
$username_logon = "root" ;  
$password_logon = "" ;

$coursenametext = '';
$id = '';
//error_reporting (E_ALL ^ E_NOTICE);

$connections = mysql_connect($hostname_logon, $username_logon, $password_logon) or die ( "Unable to connect to the database" );
mysql_select_db($database_logon) or die ( "Unable to select database!" );
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Edit Courses</title>
<link href="Aaron.css" rel="stylesheet" type="text/css" />
</head>
<div class="container">
<h1><img src="logo.gif" alt="Logo" width="224" height="62" id="logo" align="left"/></a>Update Courses</h1>
</div>
<div class="sidebar1">
    <ul class="nav">
      <li><a href="homepage.php">Homepage</a></li>
      <li><a href="modules.php">My Modules</a></li>
      <li><a href="update.php">Update Database</a></li>
      <li><a href="googles1.php">Sem 1 Google</a></li>
      <li><a href="timetable2.php">Sem 2 Timetable</a></li>
      <li><a href="googles2.php">Sem 2 Google</a></li>
      <li><a href="logout.php">Logout</a></li>
    </ul>
    <p><a href="javascript:window.print()">Print This Page</a></p>
    <p> Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum. Praesent mauris. Fusce nec tellus sed augue semper porta. Mauris massa. Vestibulum lacinia arcu eget nulla. </p>
    <p>Welcome To Timetable Management. Please Find All Necessary Links Above.</p>
</div>
<div class="content">
<form action="editcourses.php" method="post">
<table border="1" cellspacing="1" align="center" bordercolor="#FFFFFF">
<tr>
<td>Course Name</td>
<td>Edit</td>
<td>Submit</td>
<td>Delete</td>
</tr>
<?php
$query = "SELECT * FROM Courses ";
$result = mysql_query ($query);
if(mysql_num_rows($result)>0){
                while($row = mysql_fetch_array($result)) {
                echo('<tr>' .
                '<td>' . $row['CourseName'] . '</td>' .
                '<td><input type="hidden" name="id" value="' . $row['ID'] . '"/><textarea name="coursenametext" rows="2"></textarea>' . '</td>' .
                '<td>' . '<input type="Submit" name="Submit" value="Submit">' . '</td>' .
                '</tr>');
        }
}
if(isset($_POST['Submit']))
{
$query1 = "UPDATE courses SET courseName = '".$_POST['coursenametext']."' WHERE ID = '".$_POST['id']."'";
$result1 = mysql_query ($query1);
}
?>
</table>   
</form>
<br>
</div>
<div class="footer">
<p><a href="mailto:***@**.**.**" class="Email">Click Here To Email For Help With Faults</a></p>
</div>
</div>
</body>
</html>

Alright, so I've been building code in my computer science class (no prior PHP experience before approx. this past week).  We're just importing the first array from a MySQL database, and it's not working for me.  Our teacher included a broken-linked image that apparently tells us how to close the connection, but being unable to see it....I can't.

I'm not sure exactly what's not working, but here's my current code:

Code: [Select]

<html>
<body>
<?php

echo "<h1>This is a test. Does this script insert values?</h1>";

// Connect to the database
$dbc = mysqli_connect('localhost', 'root', 'root', 'myrent-a-movie-final') or die('Error connecting to MySQL server.');

// Build the query
$query = "SELECT * FROM customers";

$result = mysqli_query($dbc, $query) or die('Error querying database.');

//Display Results through Array Loop
While ($row = mysqli_fetch_array($result)) {
echo $row['surname'];
echo $row['given_name'];
echo $row['address'];
echo $row['city'];
echo $row['province'];
echo $row['postal_code'];
echo $row['phone_number'];
echo $row['email'];

// Close the database connection
mysqli_close($dbc);


?>
</body>
</html>




And here is my accompanying error message: "Parse error: syntax error, unexpected $end in Z:\www\mysql_basics\view_data.php on line 32"

I'm pretty new to php... I need a short script that I can place at the top of my web page that does the following:

In theory, a person only be able to access page2.php unless they come directly from page1.php (The message that appear should say you are not authorized to access this page)

I do not want to create login of any kind... Can you help?

thanx in advance!