Hello guys,
I need a little help with some php and MySQL queries. I have one application made by someone from GitHub that I will like to modify a little for my needs. The aplications is a FIAS-PMS from pbxinaflash with witch you can checkin, checkout and set wakeup call for one extension. The goal is to create a different report for extension used by office and guests. For guests is working perfectly.
The code looks like this :
$dbconnection = mysql_connect($dbhost, $dbuser, $dbpass) or die(“Database connection failed”);
mysql_select_db($dbname) or die(“data base Hotel-Rooms open failed”);
$query = "SELECT `ID`, `Desc` FROM `Rooms` ORDER BY `Desc` ASC";
$result = mysql_query($query) or die ("Couldn't execute SQL query on Hotel-Users table.") ;
mysql_close($dbconnection);
echo " <SELECT ID=\"RoomsComboBox\" NAME=\"RoomsComboBox\">";
echo "<OPTION VALUE=\"ALL\" SELECTED> ".$SecLab22." </OPTION>";
while ($row = mysql_fetch_array($result)) {
echo "<OPTION VALUE=\"$row[0]\">" . $row[1] . "</OPTION>";
}
echo "</SELECT>";
echo “” ;
echo “
<INPUT TYPE=“SUBMIT” NAME=“SearchButton” VALUE=”".$SecLab21.""> | \n" ;
echo “\n” ;
echo “\n”;
echo “\n”;
if(isset($_POST[‘SearchButton’])) :
echo
“
\n” ;
echo “
Id |
”.$SecLab7." |
".$SecLab14." |
".$SecLab15." |
".$SecLab17." |
".$SecLab31." |
".$SecLab1." | " ;
$dbconnection
= mysql_connect($dbhost, $dbuser, $dbpass) or die(“Database connection failed”);
mysql_select_db($dbname) or die(“data base Hotel-Rates open failed”);
$between = '';
$room = '';
$query = "SELECT * FROM `Users`";
$RoomsComboBox = $_POST['RoomsComboBox'];
$FROMD = $_POST['FROMD'] ;
$FROMM = $_POST['FROMM'] ;
$FROMY = $_POST['FROMY'] ;
$TOD = $_POST['TOD'] ;
$TOM = $_POST['TOM'] ;
$TOY = $_POST['TOY'] ;
if ($RoomsComboBox !== 'ALL') {
$room = " `Room` = '" . $RoomsComboBox . "'";
}
if ($FROMD !== '' AND $FROMM !== '' AND $FROMY !== '') {
$from = " `Checkout` >= '" . $FROMY . "-" . $FROMM . "-" . $FROMD . "'";
if ($TOD !== '' AND $TOM !== '' AND $TOY !== '') {
$to = " AND `Checkout` <= '" . $TOY . "-" . $TOM . "-" . $TOD . "'";
}
$between = $from . $to;
}
If ($between !== '' OR $room !== '') {
$query = $query . " WHERE" ;
}
If ($between !== '' AND $room !== '') {
$query = $query . $between . " AND" . $room;
}
If ($between !== '' AND $room == '') {
$query = $query . $between;
}
If ($between == '' AND $room !== '') {
$query = $query . $room;
}
$query = $query . " ORDER BY ID DESC";
//printf($query);
What I did :
From :
$query = “SELECT ID
, Desc
FROM Rooms
ORDER BY Desc
ASC” ;
to
$query = “SELECT ID
, Desc
FROM Rooms
WHERE Desc
= ‘Frontoffice’ OR Desc
= ‘Backoffice’ OR Desc
= ‘Manager’ ORDER BY Desc
ASC” ;
from :
$query = "SELECT * FROM Users
";
to
$query = "SELECT * FROM Users
WHERE Desc
= ‘Frontoffice’ OR Desc
= ‘Backoffice’ OR Desc
= ‘Manager’ " ;
Partial is working, I can see in the combobox only office extensions, i can search if i peek " all " from dropdown , but if i choose something else for exemple Frontoffice and click search the page is replaying with one error.
The date search is not working at all. I have to advice you guys, i don`t know php and MySQL just some very basics Please can someone help me with some syntaxs ? Thanks a lot.