php code placement in .htm

big-dog

Where do I put the php part of this in the file the php code is a dropdown box getting data from DB. The php part works on a page by itself but when placed in the htm it displays the php code insted of the dropdown

<HTML>
<HEAD>
<TITLE>Class Alias</TITLE>
</HEAD>
<BODY>
<?php


mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
echo "<select name='Cla_Cl_PK'>\n"
."<option>$ClaFName</option>\n";
$query = 'SELECT * FROM Class_Alias_Cla WHERE Cla_F_Name = `Cla_F_Name` LIMIT 0, 100 ';
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result)){
echo "<option>".$row["Cla_F_Name"]."</option>\n";
}
echo "</select>\n";
?>

<h1>Class Alias</h1>
<form enctype='multipart/form-data' action='Class_Alias_process.php' method='post'>
<table width='75%' border=1 cellspacing="0" bordercolor="#0000FF">
<tr><td> Cla Act </td>
<td width="184">
<input type=checkbox name='ClaAct' value="1" checked></td><td width="117"> Cla Cl PK</td>
<td width="152">
<select size="1" name="Cla_Cl_PK">
</select></td></tr>
<tr><td> Cla F Name</td>
<td width="184">
<input type=text name='ClaFName' size="25"></td><td width="117"> &nbsp;</td>
<td width="152">
<input type=text name='ClaClPK0'></td></tr>
</table>
<input type='submit' value='Submit Form'> <input type=reset value='Clear Form'></form>

</BODY>
</HTML>

guhyaraja

If I understand you correctly, then what you need to do is to rename the .htm extension to .php otherwise the php will be treated as html.

There are ways of getting the server to treat .htm or .html as php files if you really have to have a .htm extension. But it's simpler to call your files .php instead.

hope that solves your problem

TheStalker

you need to save the page as a .php file not .htm

so when you goto save as in your editor save the file as "example.php" not "example.htm"

TheStalker

you could also take a look here http://www.w3schools.com/php/php_intro.asp

big-dog

I dont know where to place the code in the .htm or .php file I did change it to .php I didnt think about that. But I get this error I think because I dont know where the php goes
Parse error: syntax error, unexpected '<', expecting '{' in /home/public_html/ClassAliasCla/Class_Alias.php on line 13

<HTML>
<HEAD>
<TITLE>Class Alias</TITLE>
</HEAD>
<BODY>
<?php

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
mysql_query($query);
Class Alias
<form enctype='multipart/form-data' action='Class_Alias_process.php' method='post'>
<table width='75%' border=1 cellspacing="0" bordercolor="#0000FF">
<tr><td> Cla Act </td>
<td width="184">
<input type=checkbox name='ClaAct' value="1" checked></td><td width="117"> Cla Cl PK</td>
<td width="152">
echo "<select name='Cla_Cl_PK'>\n"
."<option>$ClaFName</option>\n";
$query = 'SELECT * FROM Class_Alias_Cla WHERE Cla_F_Name = `Cla_F_Name` LIMIT 0, 100 ';
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result)){
echo "<option>".$row["Cla_F_Name"]."</option>\n";
}
echo "</select>\n";
</td></tr>
<tr><td> Cla F Name</td>
<td width="184">
<input type=text name='ClaFName' size="25"></td><td width="117"> &nbsp;</td>
<td width="152">
<input type=text name='ClaClPK0'></td></tr>
</table>
<input type='submit' value='Submit Form'> <input type=reset value='Clear Form'></form>
?>


</BODY>
</HTML>

djjjozsi

Lets see this video 🙂
http://phptool.extra.hu/tutorials/correct_html_php/correct_html_php.html

big-dog

Hard for me to see video.
Heres what I got now, seems to work. Now I want to select an option from the created dropdown box and have it insert data from the DB into the ClaFName field in the form. the dropdown box contains Cla_Cl_PK which is like ID numbers the ClaFName is the Class full Name.

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
?>
<h1>Class Alias</h1>
<form enctype='multipart/form-data' action='Class_Alias_process.php' method='post'>
<table width='75%' border=1 cellspacing="0" bordercolor="#0000FF">
<tr><td> Cla Act </td>
<td width="184">
<input type=checkbox name='ClaAct' value="1" checked></td><td width="117"> Cla Cl PK</td>
<td width="152">
<?php
echo "<select name='Cla_Cl_PK'>\n"
."<option>$ClaFName</option>\n";
$query = 'SELECT * FROM Class_Alias_Cla WHERE Cla_Cl_PK = `Cla_Cl_PK` LIMIT 0, 100 ';
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result)){
echo "<option>".$row["Cla_Cl_PK"]."</option>\n";
}
echo "</select>\n";
?>
</td></tr>
<tr><td> Cla F Name</td>
<td width="184">
<input type=text name='ClaFName' size="25"></td><td width="117"> &nbsp;</td>
<td width="152">
<input type=text name='ClaClPK0'></td></tr>
</table>
<input type='submit' value='Submit Form'> <input type=reset value='Clear Form'>
</form>

djjjozsi

and did you see a "DOWNLOAD SOURCE CODE" on the top of the page? 🙂

just a few suggestion:

localhost is a string, use "" signs around it

mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

while you don't know its working do not use @ to hide the error reporting, and always use

or die("Cant run:" . mysql_error() . " : $query");

$query = 'SELECT * FROM Class_Alias_Cla WHERE Cla_Cl_PK = `Cla_Cl_PK` LIMIT 0, 100 ';

forget the ` sign in your SQL query while you don't know the right usage. Anyway, if you use apostrofe in your string, and you cover it with apostrofes you have to use \' escaped version.

$query = 'SELECT * FROM Class_Alias_Cla WHERE Cla_Cl_PK = \'Cla_Cl_PK\' LIMIT 0, 100 ';

$result = mysql_query($query);

or die+mysql error...

echo "<option>".$row["Cla_Cl_PK"]."</option>\n";

thats nice, but there is not value added into the dropdown.

echo "<option value=\"".$row["ID_FIELD_NAME"]."\">".$row["Cla_Cl_PK"]."</option>\n";

farius

If you are still wondering why in the first post you made the code has errors because you switch from PHP o HTML without telling the compiler where.

I would reformat to this:

<!-- Start with am HTML section -->
 <HTML> 
<HEAD> 
<TITLE>Class Alias</TITLE> 
</HEAD> 
<BODY> 

<?php 
//With the <? or <?php `tag` you tell the server that I want the next lines of code to be treated as PHP 
mysql_connect(localhost,$username,$password); 
@mysql_select_db($database) or die( "Unable to select database"); 
mysql_query($query); 
?>
<!-- Here we want to treat as HTML so we close the php block with ?> -->


<form enctype='multipart/form-data' action='Class_Alias_process.php' method='post'> 
<table width='75%' border=1 cellspacing="0" bordercolor="#0000FF"> 
<tr><td> Cla Act </td> 
<td width="184"> 
<input type=checkbox name='ClaAct' value="1" checked></td><td width="117"> Cla Cl PK</td> 
<td width="152"> 

<?

//Back to PHP
echo "<select name='Cla_Cl_PK'>\n" 
."<option>$ClaFName</option>\n"; 
$query = 'SELECT * FROM Class_Alias_Cla WHERE Cla_F_Name = `Cla_F_Name` LIMIT 0, 100 '; 
$result = mysql_query($query); 
while($row = mysql_fetch_assoc($result)){ 
echo "<option>".$row["Cla_F_Name"]."</option>\n"; 
} 
echo "</select>\n"; 
?>

<!-- And finally back to HTML -->
</td></tr> 
<tr><td> Cla F Name</td> 
<td width="184"> 
<input type=text name='ClaFName' size="25"></td><td width="117"> &nbsp;</td> 
<td width="152"> 
<input type=text name='ClaClPK0'></td></tr> 
</table> 
<input type='submit' value='Submit Form'> <input type=reset value='Clear Form'></form> 
?> 


</BODY> 
</HTML>

Anyway that is what you would need to fix it too!

big-dog

So with the syntec errors that djjjozsi pointed out is that cridical or just good coding. because it seems to display the data ok with my errors. by not fixing the errors will that affect other code some where down the line or slow my data base down or simply be good for me to know the right way to write code.