ASP to PHP anbody??

vickriz · August 5th, 2003, 12:25 AM

hello there folks, good day..
sorry but i dont know where im gonna post this issue i have..
i found this script interesting in form of asp. but i want it to translate in php script. can anybody help me?

Code:

Forms - Populating a drop down menu with info from a database
--------------------------------------------------------------------------------
 
Below is an example of a basic drop down menu populated from a database.

<% 
' Not neccesary but a good habit
Dim DataConn
Dim CmdPopulateStates
Dim SQL
%>

<%
Set DataConn = Server.CreateObject("ADODB.Connection")
Set CmdPopulateStates = Server.CreateObject("ADODB.Recordset")
%>

Take away the comment on Sytem DSN version below if you want to use a system DSN instead and add a comment to the DSN-LESS connection version below it

<% 
' DataConn.Open "DSN=System_DSN_Name"

DataConn.Open "DBQ=" & Server.Mappath("_database/zipcodes.mdb") &   ";Driver={Microsoft Access Driver (*.mdb)};"

SQL = "SELECT DISTINCT STATE_NAME FROM STATES"
CmdPopulateStates.Open SQL, DataConn
%>

<form method="POST" action="somepage.asp">
<Select Name="STATE_NAME" size="1">
<%While Not CmdPopulateStates.EOF%>

<option value="<%= CmdPopulateStates("STATE_NAME") %>"><%= CmdPopulateStates("STATE_NAME") %></option>

<%
CmdPopulateStates.MoveNext
Wend
%>

<% 
' Not neccesary but a good habit
CmdPopulateStates.Close
Set CmdPopulateStates = Nothing
DataConn.Close
Set DataConn = Nothing
%>

</Select>
<input type="submit" value="Submit">
</form>

iL populate also similar data from postgresql back-end..
thanks in advance.

Mabuhay!!!

Moharo · August 7th, 2003, 07:23 PM

this is relatively simple... first of all you gonna have to setup database. then do this (code works with mysql database, you can just substitute equivalent postgresql functions):

<?

$conn = mysql_connect('localhost','***','***');
//***, *** username and password to database

mysql_select_db('database_name',$conn);
//selecting database

?>

<form method="POST" action="somepage.php">
    <select name="STATE_NAME" size="1">
    <?

    $sql = "SELECT DISTINCT STATE_NAME FROM STATES";
    $result = mysql_query($sql,$conn);

    while($row = mysql_fetch_object($result)) { ?>

    <option value="<? echo $row->STATE_NAME; ?>"> <? echo $row->STATE_NAME; ?> </option>

    <? } ?>

    </select>
    <input type="submit" value="Submit">
</form>

hope that helped :D:)

:D:D:D

the genuine genius