PHP - Php / Mssql Query From Html Drop Down

I have had nothing but great luck with these forums and I am hoping that I am not pressing said luck by asking another question.

I have a drop down list populated by information in a database:

<?php
include_once('../other/functions.php');   
$con = mysql_connect($hostname, $username, $password)
   OR DIE ('Unable to connect to database! Please try again later.');
   $db = mysql_select_db($dbname, $con);
$sql="SELECT owner_id, teamname FROM owners WHERE active = 1 ORDER BY division, teamname";
$result=mysql_query($sql);
$options="";
while ($row=mysql_fetch_array($result)) {
    $id=$row["owner_id"];
    $thing=$row["teamname"];
    $options.="<OPTION VALUE=\"$id\">".$thing.'</option>';
    }
mysql_close($con);
?>
<SELECT NAME=thing>
<OPTION VALUE=0>Choose One
<?=$options?>
</OPTION>
</SELECT>

I have a query that will get the information I want into a table:

<?php
$con = mysql_connect($hostname, $username, $password)
   OR DIE ('Unable to connect to database! Please try again later.');
   $db = mysql_select_db($dbname, $con);
$query = "SELECT * FROM standings, owners, divisions WHERE owners.owner_id = standings.owner_id AND owners.division = divisions.division AND standings.owner_id = 1 ORDER BY year";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
if (!$result) {
    die('Invalid query: ' . mysql_error());
}
mysql_data_seek($result, 0);
echo "<table CELLPADDING=5 border =1>";
echo "<tr>";
echo "<th align=center colspan = 2> Team Name </th>";
echo "<th align=center> Team Owner </th>";
echo "<th align=center> Conference </th>";
echo "<th align=center> Division </th>";
echo "</tr>";
echo "<tr>";
echo "<td align=center colspan = 2>".$row['teamname']."</td>";
echo "<td align=center>".$row['firstname']."</td>";
echo "<td align=center>".$row['conference']."</td>";
echo "<td align=center>".$row['division']."</td>";
echo "</tr>";
echo "<tr>";
echo "<th align=center> Year </th>";
echo "<th align=center> Wins </th>";
echo "<th align=center> Losses </th>";
echo "<th align=center> Points For </th>";
echo "<th align=center> Points Against </th>";
echo "</tr>";
$row = mysql_fetch_array($result);
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td align=center>".$row['year']."</td>";
echo "<td align=center>".$row['win']."</td>";
echo "<td align=center>".$row['loss']."</td>";
echo "<td align=center>".$row['points_for']."</td>";
echo "<td align=center>".$row['points_against']."</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>

How do I make it so a user can use the drop down list, select a team name, and the query will then display the info??

Thank you very much

Hi,

Can anyone point me in the right direction please? I want to have a drop down box which when a user clicks on a category the results on the page have changed to show only the data which is relative to the category chosen by the user. I also need a way so that when they click view all they are able to see all the results again.

Not really sure what to look for or even how hard this might be.

Lee   

Hello,

I need help filtering an SQL query based on the combination of drop down menus. I have tried using this code found in another thread but I am still getting all rows selected. Any ideas?? Thank you.

Here is my html
Code: [Select]
<form name="xml.php" method="POST">
            <input type="button" id="showmarkers" value="Show Markers" />&nbsp;&nbsp;
                <select name="meetingType">
                <option value="All Types" selected="All Types">All Types</option>           
                <option value="fun">fun</option>
                <option value="work">work</option>
                </select>&nbsp;&nbsp;
                <select name="meetingDay">
                <option value="All Days" selected="All Days">All Days</option>
                <option value="Monday">Monday</option>
                <option value="Tuesday">Tuesday</option>
                <option value="Wednesday">Wednesday</option>
                <option value="Thursday">Thursday</option>
                <option value="Friday">Friday</option>
                <option value="Saturday">Saturday</option>
                <option value="Sunday">Sunday</option>
                </select>&nbsp;&nbsp;
                <select name="meetingTime">
                <option value="All Times" selected="All Times">All Times</option>
                <option value="Early">Early</option>
                <option value="Noon">Noon</option>
                <option value="Late">Late</option>
                </select>
</form>

And the PHP:
Code: [Select]
$whereClauses = array();
if (! empty($_POST['meetingType'])) $whereClauses[] ="meetingType='".mysql_real_escape_string($_POST['meetingType'])."'";
if (! empty($_POST['meetingDay'])) $whereClauses[] ="meetingDay='".mysql_real_escape_string($_POST['meetingDay'])."'";
if (! empty($_POST['meetingTime'])) $whereClauses[] ="meetingTime='".mysql_real_escape_string($_POST['meetingTime'])."'";
$where = '';
if (count($whereClauses) > 0) { $where = ' WHERE '.implode(' AND ',$whereClauses); }
$resultID = mysql_query("SELECT * FROM meetings".$where);

I've got a HTML drop down box as similar to this:

<select name="dropdown">
<option>Option 1</option>
<option>Option 2</option>
<option>Option 3</option>
</select>

If I run a mysql query and get a result of "Option 3", is there anyway using PHP to give Option 3 the selected value?

Hi there.

Im a noob to sql and php not sure if this is right place to post,

Im trying to get a dynamic drop down menu to show the 1st column in my sql database the column is called cat and holds category info ie audio, internet, music ect. ( i have no idea how to do lol )

it has taken me 2 days to find and edit this  the bold and underline'd bit is what im trying to change with the dropdown menu.

Or thinking bout it is there a way to do it with the URL. IE.. page name.php?cat=audio ?
would that be easer ? is there any security issues with doing it that way ?


Code==================================
$db_host = '*******';
$db_user = '******';
$db_pwd = '*****;

$database = 'nbbcj_co_uk';
$table = 'penapps';

if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// sending query
$result = mysql_query("SELECT * FROM {$table} WHERE `cat` = 'audio' LIMIT 10 ");
if (!$result) {
    die("Query to show fields from table failed");
}

$fields_num = mysql_num_fields($result);

//echo "<h1>Table: {$table}</h1>";
echo "<table border='1' width='100%'><tr>";
// printing table headers
for($i=0; $i<$fields_num; $i++)
{
    $field = mysql_fetch_field($result);
    //echo "<td>{$field->name}</td>";
}
echo "</tr>\n";
// printing table rows
while($row = mysql_fetch_row($result))
{
    echo "<tr>";

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row as $cell)
        echo "<td>$cell</td>";

    echo "</tr>\n";
}
mysql_free_result($result);
?>
code end ======================

the test page can been seen here http://www.nbbcj.co.uk/testd/1/test1.php

Any more questions let me know

Thanks for any help you can give, a we all have to start some ware lol

thanks kaine.

Hello,

am having problem with connection to mssql server and database. Am using Xampp and i think there is some problem about his configuration.
All the time am getting error : missing driver php_mssql.dll in xampp/php/ext/  ....and file php_mssql.dll is there (same problem with php_pdo_mssql.dll).
Also am getting this error: "Fatal error: Call to undefined function mssql_connect() "
I tried everything i could find on forums, blogs, and php documentation...but always same.

btw... i removed ";"  in php.ini from necessary lines and i copy ntwdblib.dll in necessary folders.
This is my connection code:
Code: [Select]
   $dbHost = 'Workstation:<port>';
   $dbUser = 'user';
   $dbPass = 'pass';
   $dbName = 'database';
$con = mssql_connect ($dbHost, $dbUser, $dbPass) or die ('MsSQL connect failed. ' . mssql_error());
mssql_select_db($dbName) or die('Cannot select database. ' . mssql_error());
I also tried with:
Code: [Select]
$connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server;Database=$database;", $user, $password);but always same....


Can anybody please provide me some working solution ?


Thanks.

I'm having problems with enabling the sort functions of jqgrid.  I think I've narrowed the problem down to the way MSSQL is returning the data to the SQL query.

In an effort to troubleshoot, I've drastically simplified the problem.  The query I'm using is below.

Code: [Select]
SELECT * FROM dbo.test ORDER BY locationName
When I run the query directly in MSSQL Management Studio, the top 5 ID entries are 132, 1309, 1295, 1281, 1267.

When I run the corresponding code in PHP, the top 5 ID entries are 1266, 1267, 1268, 1269, 1270 - it seems to be ignoring my order by clause.  Is there something I need to do to force it to honor the ORDER BY locationName?

Code: [Select]
$kpiQuery = "SELECT * FROM dbo.test ORDER BY locationName";
$result = mssql_query($kpiQuery);
while($kpiRow = mssql_fetch_array($kpiResult)) {
echo $kpiRow[plDataID]."<br>";
}

HI,

I've upgraded from PHP version 5.2 to PHP version 5.4 and are not able to load / find mssql extension ?

How do I use MSSQL in version 5.4 ??

Is MSSQL not supported in this version or am I (hopingly) missing something ???

Regards
Dieter

I'm running: Windows Server 2003 IIS 6.0 Microsoft SQL 2005 PHP 5.3.28       Everything that i have read says, "5.3 got rid of mssql and now uses sqlsrv" so i added extension=php_sqlsrv_53_nts_vc9.dll  to my php.ini (and yes it is in the ext folder)   and when i run the script  

$serverName = "localhost\phonebook"; //serverName\instanceName
// Since UID and PWD are not specified in the $connectionInfo array,
// The connection will be attempted using Windows Authentication.
$connectionInfo = array( "Database"=>"XXXXX", "UID"=>"XXXXX", "PWD"=>'XXXXXXXX');
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
 

  i get  
Connection could not be established.
Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49 [code=auto:0] => -49 [2] => This extension requires either the Microsoft SQL Server 2008 Native Client (SP1 or later) or the Microsoft SQL Server 2008 R2 Native Client ODBC Driver to communicate with SQL Server. Neither of those ODBC Drivers are currently installed. Access the following URL to download the Microsoft SQL Server 2008 R2 Native Client ODBC driver for x86: http://go.microsoft..../?LinkId=163712 [message] => This extension requires either the Microsoft SQL Server 2008 Native Client (SP1 or later) or the Microsoft SQL Server 2008 R2 Native Client ODBC Driver to communicate with SQL Server. Neither of those ODBC Drivers are currently installed. Access the following URL to download the Microsoft SQL Server 2008 R2 Native Client ODBC driver for x86: http://go.microsoft..../?LinkId=163712 ) [1] => Array ( [0] => IM002 [SQLSTATE] => IM002 [1] => 0 [code=auto:0] => 0 [2] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) ) What can i do to fix this? I assume use an older .dll?

Hi,

I have been working with inserting unicode characters into mssql database from a php application.

My php web application displays the chinese characters as i entered and retrieves from database properly. But when I take a look at the database the fields are populated with some other values other than the characters i inserted.

When i developed the same application in ASP.net the database has correct values inserted into it.

Here is my code in php:

Code: [Select]
<?php

// direct insert
$var = mssql_connect('RAL-DEV-SQL01','TestDBSa','TestDB$@');

$selected = mssql_select_db('TestDB', $var);


$myVar="&#26085;&#24120;&#29983;&#27963;";


$myChineseVar=$myVar;
echo $myChineseVar;


$query = "insert into TestChinese (TestName) values (N'{$myChineseVar}')"; 

$result = mssql_query($query,$var);

echo "Inserted<br>";
echo $query;


echo "<br>Result<br>";
$result2 = mssql_query("SELECT TOP 10 * FROM [TestChinese] order by SeqNum desc",$var);
while($nt=mssql_fetch_array($result2)){
echo "$nt[SeqNum] - "."$nt[TestName] -";

echo "<br>";

} 

mssql_close($var);

?>
Can someone help me with this problem

Thanks

Hi every one,
i am trying to connect with a remote SQL server on window platform.
i have hostname, username, password and database name, but when i try t connect using mssql_connect($server,$username,$password)

i got this Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server:

Thanks

Hi,
I knew the way to connect to mysql but i don't know how to connect mssql.
Is it the same?

here's an example for mysql.
please teach me the mssql.

$con = new mysqli(DB_HOST,DB_USER,DB_PASS,DB_NAME);

$sql = "SELECT COUNT(*) FROM numbers";
$result = $con->query($sql);
$r = $result->fetch_row();



thanks

I've got some PHP code that accesses SQL on an Amazon cloud server. Other machines running Unix and Windows can perform accesses fine using the server name (IP for Windows, label for Unix), database name (string) and a password (string).  However, the same code FAILS on OSX (my Macbook Pro).

SQL managers on my MBP have no problem accessing it, since I've made the proper exceptions on the AWS firewall.  But PHP can't do any MS SQL reads of this database.

Is there something else I don't know?  Is there some other key information being exchanged that my MBP needs to send that I can't see?

TIA!!