Hello guys, i am new to PHP and finding it interesting difficult at the same time. I need to connect to an access database depending on the selected menus in the drop down box and printing the selected field in a table.
Here is my code

    $ch1 = 'unchecked';
	$ch2 = 'unchecked';
	$ch3 = 'unchecked';
	$ch4 = 'unchecked';
	$ch5 = 'unchecked';
	$myform = $_POST['myform'];
  $bandwith = $_POST['bandwith'];
  $webspace = $_POST['webspace'];
  $payment =$_POST['payment'];	
			$dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq= E:\\wwwroot\php\hosting.mdb;Uid=;Pwd=;";
			if (!$conn )
			  {exit("Connection Failed: " . $conn);}
			  if ($webspace === '200 mb' && $bandwith === '3000 mb' $payment === '£22.90 per year' ){
			$sql="SELECT * FROM data"}
			if (!$rs)
			  {exit("Error in SQL");}
echo "<table><tr>"; 
echo "<th>Features</th>"; 
echo "<th>Bronze</th></tr>"; 
while (odbc_fetch_row($rs)) 
echo "<tr><td>$feat</td>"; 
echo "<td>$br</td></tr>"; 
echo "</table>"; 

7 Years
Discussion Span
Last Post by diafol

What is the error ?
And, instead of

$webspace === '200 mb' && $bandwith === '3000 mb' $payment === '£22.90 per year'

I would suggest you to use only numbers. For example,

$webspace === '200' && $bandwith === '3000' && $payment === '22.90'

Also note that there is no && operator in your statement for $payment.
This query,

$sql="SELECT * FROM data"

isn't terminated with a semi colon.
One more, odbc_fetch_row returns records with numeric indices. You can't use $feat=odbc_result($rs,"Features"); use odbc_fetch_array instead. I guess thats it.

Edit: Oh and please, use [/code ] tags to wrap your codes.[code= php] [/code ] tags to wrap your codes.


Hi i have an example on dropdown + ms access + php


<font face="Verdana" color="#CC0000">
	$strConn = new COM("ADODB.Connection") or die("Cannot start ADO");
	$strConn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("db/dbExam.mdb")); 
	$strSQL = "SELECT * FROM tblKursus";
	$objRec = $strConn->Execute($strSQL);
                                                                                                                                              <form name="form1" method="post" action="process.php">
<select name="pilihankursus">
While (!$objRec->EOF)
<option value=<?php print $objRec->Fields(2)->Value;?>><?php print $objRec->Fields(1)->Value;?></option>
   <input type="submit" name="Submit" value="Submit"/>


page2 process.php:

	$strConn = new COM("ADODB.Connection") or die("Cannot start ADO");
	$strConn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("db/dbExam.mdb")); 
$strVar .= "KodKursus = '".$_POST["pilihankursus"]."' ";
      $SKursus = $_POST['pilihankursus'];
      echo "Variable yang dipost dari page lalu(default.php) ialah";
      echo "<p style=\"color:#FF8000\"> $SKursus</p>";
      echo "pembolehubah ini(variable)";
      echo "<p style=\"color:#0080ff\">$strVar</p>";
      echo "akan menentukan table yang akan dipilih untuk dipapar dan seterusnya untuk disimpan data-data ke dalamnya";

$db_conn = new COM("ADODB.Connection");  
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("db/dbExam.mdb").";";  
$rS = $db_conn->execute("SELECT  * from $SKursus");  

$f1 =  $rS->Fields(0); 
$f2 =  $rS->Fields(1);
$f3 =  $rS->Fields(2);
$f4 =  $rS->Fields(3);
$f5 =  $rS->Fields(4);
$f6 =  $rS->Fields(5);
$f7 =  $rS->Fields(6);
$f8 =  $rS->Fields(7);
$f9 =  $rS->Fields(8);
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
<form name="form1" method="post" action="update.php">
    <input name="txtKursus"   type="text" id="txtKursus" value="<?php print $SKursus;   ?>">
<table width="100%" border="0" cellspacing="0" cellpadding="0">

<td  align="center"><strong>Id</strong></td>
<td align="center"><strong>NoPendaftaran</strong></td>
<td align="center"><strong>S1</strong></td>
<td align="center"><strong>S2</strong></td>
<td align="center"><strong>S3</strong></td>
<td align="center"><strong>S4</strong></td>
<td align="center"><strong>S5</strong></td>
<td align="center"><strong>S6</strong></td>
<td align="center"><strong>S7</strong></td>

while (!$rS->EOF)  
{  ?>
    <td  align="center"><input name="id[]" type="hidden"  type="text" id="id" value="<?php print $f1->value;   ?>"><?php $id[] = $f1->value;?> <?php echo $f1->value;?></td>
    <td align="center"><input  name="NoPendaftaran[]" type="text" STYLE="color: #FFFFFF; font-family: Arial;   font-size: 12px; background-color: #72A4D2;" size="10" maxlength="30" id="NoPendaftaran" value="<?php print $f2->value;  ; ?>"></td>
<td align="center"><input name="S1[]" size="4"  type="text" id="S1" value="<?php print $f3->value;   ?>"></td>
    <td align="center"><input  name="S2[]" size="4" type="text" id="S2" value="<?php print $f4->value;   ?>"></td>
    <td align="center"><input  name="S3[]" size="4" type="text" id="S3" value="<?php print $f5->value;   ?>"></td>
    <td align="center"><input  name="S4[]" size="4" type="text" id="S4" value="<?php print $f6->value;   ?>"></td>
    <td align="center"><input   name="S5[]"size="4" type="text" id="S5" value="<?php print $f7->value;   ?>"></td>
    <td align="center"><input  name="S6[]" size="4" type="text" id="S6" value="<?php print $f8->value;   ?>"></td>
    <td align="center"><input  name="S7[]" size="4" type="text" id="S7" value="<?php print $f9->value;   $rS->MoveNext();  ?>"></td>

<td colspan="9" align="center"><input type="submit" name="Submit" value="Submit"></td>

I think this guy has probably found a solution after almost 3 years. :(
Necroposting to this thread has done nothing but clutter up the forum another dead post.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.