Field definitions not activating in php MySql code

PrettyNormlGirl

I have generated this code with a code generator from Sql Maestro, called PHP Generator for MySQL.

I have asked a question before about my SELECT statement. I finally got passed that, but now 3 of the fields in one of the tables can't capture data. I can see the fields on the screen, but no data can be captured in it since the field is too small. Almost as if the field is ignoring the definition I stipulated on the PhpMyAdmin.

In the function showroweditor, is where I think the problem is, but I am not sure. It is in line 371, more or less. I have highlighted it in green.

The problem fields are SoekBoekID, KlientID and SoekStatusID.

Here is most of the code:

<?php session_start(); ......
</head>
<body>
<table class="bd" width="100%"><tr><td class="hr"><h2>PHP Generator</h2></td></tr></table>
<table width="100%">
<tr>

<td width="10%" valign="top">
<li><a href="boeke.php?a=reset">boeke</a>
<li><a href="kliente.php?a=reset">kliente</a>
<li><a href="lu_afslag.php?a=reset">lu_afslag</a>
<li><a href="lu_buiteblad.php?a=reset">lu_buiteblad</a>
<li><a href="lu_kategorie.php?a=reset">lu_kategorie</a>
<li><a href="lu_kondisie.php?a=reset">lu_kondisie</a>
<li><a href="lu_soekstatus.php?a=reset">lu_soekstatus</a>
<li><a href="lu_taalid.php?a=reset">lu_taalid</a>
<li><a href="lu_uitgewers.php?a=reset">lu_uitgewers</a>
<li><a href="users.php?a=reset">users</a>
</td>
<td width="5%">
</td>

............more code ..............

<?php function select()
  {
  global $a;
  global $showrecs;
  global $page;
  global $filter;
  global $filterfield;
  global $wholeonly;
  global $order;
  global $ordtype;

............more code ..............

<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr><td>Table: soekboek</td></tr>
<tr><td>Records shown <?php echo $startrec + 1 ?> - <?php echo $reccount ?> of <?php echo $count ?></td></tr>
</table>
<hr size="1" noshade>
<form action="soekboek.php" method="post">
<table class="bd" border="0" cellspacing="1" cellpadding="4">
<tr>
<td><b>Custom Filter</b>&nbsp;</td>
<td><input type="text" name="filter" value="<?php echo $filter ?>"></td>
<td><select name="filter_field">
<option value="">All Fields</option>
<option value="<?php echo "lp_SoekBoekID" ?>"<?php if ($filterfield == "lp_SoekBoekID") { echo "selected"; } ?>><?php echo htmlspecialchars("SoekBoekID") ?></option>
<option value="<?php echo "lp_KlientID" ?>"<?php if ($filterfield == "lp_KlientID") { echo "selected"; } ?>><?php echo htmlspecialchars("KlientID") ?></option>
<option value="<?php echo "SoekTitel" ?>"<?php if ($filterfield == "SoekTitel") { echo "selected"; } ?>><?php echo htmlspecialchars("SoekTitel") ?></option>
<option value="<?php echo "SoekSkrywer" ?>"<?php if ($filterfield == "SoekSkrywer") { echo "selected"; } ?>><?php echo htmlspecialchars("SoekSkrywer") ?></option>
<option value="<?php echo "SoekISBN" ?>"<?php if ($filterfield == "SoekISBN") { echo "selected"; } ?>><?php echo htmlspecialchars("SoekISBN") ?></option>
<option value="<?php echo "SoekUitgewer" ?>"<?php if ($filterfield == "SoekUitgewer") { echo "selected"; } ?>><?php echo htmlspecialchars("SoekUitgewer") ?></option>
<option value="<?php echo "SoekUitgeeplek" ?>"<?php if ($filterfield == "SoekUitgeeplek") { echo "selected"; } ?>><?php echo htmlspecialchars("SoekUitgeeplek") ?></option>
<option value="<?php echo "SoekUitgeeDatum" ?>"<?php if ($filterfield == "SoekUitgeeDatum") { echo "selected"; } ?>><?php echo htmlspecialchars("SoekUitgeeDatum") ?></option>
<option value="<?php echo "SoekWaarGehoor" ?>"<?php if ($filterfield == "SoekWaarGehoor") { echo "selected"; } ?>><?php echo htmlspecialchars("SoekWaarGehoor") ?></option>
<option value="<?php echo "lp_SoekStatusID" ?>"<?php if ($filterfield == "lp_SoekStatusID") { echo "selected"; } ?>><?php echo htmlspecialchars("SoekStatusID") ?></option>
</select></td>
<td><input type="checkbox" name="wholeonly"<?php echo $checkstr ?>>Whole words only</td>
</td></tr>
<tr>
<td>&nbsp;</td>
<td><input type="submit" name="action" value="Apply Filter"></td>
<td><a href="soekboek.php?a=reset">Reset Filter</a></td>
</tr>
</table>
</form>

............more code ..............

[COLOR="SeaGreen"]<?php function showroweditor($row, $iseditmode)
  {
  global $conn;
?>
<table class="tbl" border="0" cellspacing="1" cellpadding="5"width="50%">
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekBoekID")."&nbsp;" ?></td>
<td class="dr"><select name="SoekBoekID">
<?php
  $sql = "select * from soekboek";
  $res = mysql_query($sql, $conn) or die(mysql_error());

  while ($lp_row = mysql_fetch_assoc($res)){
  $val = $lp_row[""];
  $caption = $lp_row[""];
  if ($row["SoekBoekID"] == $val) {$selstr = " selected"; } else {$selstr = ""; }
 ?><option value="<?php echo $val ?>"<?php echo $selstr ?>><?php echo $caption ?></option>
<?php } ?></select>
</td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("KlientID")."&nbsp;" ?></td>
<td class="dr"><select name="KlientID">
<?php
  $sql = "select * from kliente";
  $res = mysql_query($sql, $conn) or die(mysql_error());

  while ($lp_row = mysql_fetch_assoc($res)){
  $val = $lp_row[""];
  $caption = $lp_row[""];
  if ($row["KlientID"] == $val) {$selstr = " selected"; } else {$selstr = ""; }
 ?><option value="<?php echo $val ?>"<?php echo $selstr ?>><?php echo $caption ?></option>
<?php } ?></select>
</td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekTitel")."&nbsp;" ?></td>
<td class="dr"><textarea cols="35" rows="4" name="SoekTitel" maxlength="100"><?php echo str_replace('"', '&quot;', trim($row["SoekTitel"])) ?></textarea></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekSkrywer")."&nbsp;" ?></td>
<td class="dr"><textarea cols="35" rows="4" name="SoekSkrywer" maxlength="100"><?php echo str_replace('"', '&quot;', trim($row["SoekSkrywer"])) ?></textarea></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekISBN")."&nbsp;" ?></td>
<td class="dr"><input type="text" name="SoekISBN" value="<?php echo str_replace('"', '&quot;', trim($row["SoekISBN"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekUitgewer")."&nbsp;" ?></td>
<td class="dr"><textarea cols="35" rows="4" name="SoekUitgewer" maxlength="60"><?php echo str_replace('"', '&quot;', trim($row["SoekUitgewer"])) ?></textarea></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekUitgeeplek")."&nbsp;" ?></td>
<td class="dr"><input type="text" name="SoekUitgeeplek" maxlength="50" value="<?php echo str_replace('"', '&quot;', trim($row["SoekUitgeeplek"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekUitgeeDatum")."&nbsp;" ?></td>
<td class="dr"><input type="text" name="SoekUitgeeDatum" value="<?php echo str_replace('"', '&quot;', trim($row["SoekUitgeeDatum"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekWaarGehoor")."&nbsp;" ?></td>
<td class="dr"><textarea cols="35" rows="4" name="SoekWaarGehoor" maxlength="65535"><?php echo str_replace('"', '&quot;', trim($row["SoekWaarGehoor"])) ?></textarea></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekStatusID")."&nbsp;" ?></td>
<td class="dr"><select name="SoekStatusID">
<?php
  $sql = "select * from lu_soekstatus";
  $res = mysql_query($sql, $conn) or die(mysql_error());

  while ($lp_row = mysql_fetch_assoc($res)){
  $val = $lp_row[""];
  $caption = $lp_row[""];
  if ($row["SoekStatusID"] == $val) {$selstr = " selected"; } else {$selstr = ""; }
 ?><option value="<?php echo $val ?>"<?php echo $selstr ?>><?php echo $caption ?></option>
<?php } ?></select>
</td>
</tr>
</table>
<?php } ?>[/COLOR]

............more code ..............

function sql_select()
{
  global $conn;
  global $order;
  global $ordtype;
  global $filter;
  global $filterfield;
  global $wholeonly;

  $filterstr = sqlstr($filter);
  if (!$wholeonly && isset($wholeonly) && $filterstr!='') $filterstr = "%" .$filterstr ."%";
  $sql = "SELECT * FROM (SELECT t1.`SoekBoekID`, t1.`KlientID`, t1.`SoekTitel`, t1.`SoekSkrywer`, t1.`SoekISBN`, t1.`SoekUitgewer`, t1.`SoekUitgeeplek`, t1.`SoekUitgeeDatum`, t1.`SoekWaarGehoor`, t1.`SoekStatusID` FROM `soekboek` AS t1) subq";
  if (isset($filterstr) && $filterstr!='' && isset($filterfield) && $filterfield!='') {
    $sql .= " where " .sqlstr($filterfield) ." like '" .$filterstr ."'";
  } elseif (isset($filterstr) && $filterstr!='') {
    $sql .= " where (`lp_SoekBoekID` like '" .$filterstr ."') or (`lp_KlientID` like '" .$filterstr ."') or (`SoekTitel` like '" .$filterstr ."') or (`SoekSkrywer` like '" .$filterstr ."') or (`SoekISBN` like '" .$filterstr ."') or (`SoekUitgewer` like '" .$filterstr ."') or (`SoekUitgeeplek` like '" .$filterstr ."') or (`SoekUitgeeDatum` like '" .$filterstr ."') or (`SoekWaarGehoor` like '" .$filterstr ."') or (`lp_SoekStatusID` like '" .$filterstr ."')";
  }
  if (isset($order) && $order!='') $sql .= " order by `" .sqlstr($order) ."`";
  if (isset($ordtype) && $ordtype!='') $sql .= " " .sqlstr($ordtype);
  $res = mysql_query($sql, $conn) or die(mysql_error());
  return $res;
}

............more code ..............

dagon

PrettyNormlGirl;10918184 wrote:
I can see the fields on the screen, but no data can be captured in it since the field is too small.

Not sure what this means, don't know if your talking about an html\css issue or a php one, could you expand, perhaps showing us the web page would help.

PrettyNormlGirl

dagon;10918186 wrote:
Not sure what this means, don't know if your talking about an html\css issue or a php one, could you expand, perhaps showing us the web page would help.

Sorry, it is a PHP/html and MySql kind of problem. I generated the actual tables using PhpMyAdmin, I then generated the code using the code generator. It seems like a real bad code generator since it even left out fields in the select statement, especially when I used a lookup table.

How do I get a screendump here? The screen where I am capturing isn't on the web yet.....but that is probably obvious.

I also have to unfortunately add that I am not very clued-up on MYSQL or php yet.

dagon

click "go advanced" then there's a paper-clip icon for adding an attachment. If the issue is how the web page is displayed then its a html\css one as php is server side.

PrettyNormlGirl

Thanks.
I have uploaded the screen dump.

dagon

by the looks of it the select boxes are not being populated you can view the page source to confirm

<option value="<?php echo $val ?>"<?php echo $selstr ?>><?php echo $caption ?></option>

should be

echo '<option value="'.$val.'" '.$selstr.'>'.$caption.'</option>';

dagon

 $val = $lp_row[""];
  $caption = $lp_row[""];

should be

  $val = $lp_row["FIELD NAME"];
  $caption = $lp_row["FIELD NAME"];

what ever the appropriate field name from your db is.

PrettyNormlGirl

Dagon, I uploaded the file with the result. It didn't do what we hoped.

dagon

woops ignore the echo ...
i misread your code, but the other still applies.

PrettyNormlGirl

Sorry, the FTP doesn't want to connect every time the first time when I want to connect to it.
I am working on the internet, but it isn't published yet, since it isn't working.

PrettyNormlGirl

I replaced the previous code like you said:
An example:
$val = $lp_row["SoekBoekID"];
$caption = $lp_row["SoekBoekID"];

But there is still no change. The word caption is still in the second and last fields.

dagon

paste your current showroweditor function

PrettyNormlGirl

<?php function showroweditor($row, $iseditmode)
{
global $conn;
?>
<table class="tbl" border="0" cellspacing="1" cellpadding="5"width="50%">
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekBoekID")." " ?></td>
<td class="dr"><select name="SoekBoekID">
<?php
$sql = "select * from soekboek";
$res = mysql_query($sql, $conn) or die(mysql_error());

while ($lp_row = mysql_fetch_assoc($res)){
$val = $lp_row["SoekBoekID"];
$caption = $lp_row["SoekBoekID"];
if ($row["SoekBoekID"] == $val) {$selstr = " selected"; } else {$selstr = ""; }
?>
<option value="'.$val.'" '.$selstr.'>'.$caption.'</option>;

<?php } ?></select>
</td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("KlientID")." " ?></td>
<td class="dr"><select name="KlientID">
<?php
$sql = "select * from kliente";
$res = mysql_query($sql, $conn) or die(mysql_error());

while ($lp_row = mysql_fetch_assoc($res)){
$val = $lp_row["KlientID"];
$caption = $lp_row["KlientID"];
if ($row["KlientID"] == $val) {$selstr = " selected"; } else {$selstr = ""; }
?>
<option value="'.$val.'" '.$selstr.'>'.$caption.'</option>;

<?php } ?></select>
</td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekTitel")." " ?></td>
<td class="dr"><textarea cols="35" rows="4" name="SoekTitel" maxlength="100"><?php echo str_replace('"', '"', trim($row["SoekTitel"])) ?></textarea></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekSkrywer")." " ?></td>
<td class="dr"><textarea cols="35" rows="4" name="SoekSkrywer" maxlength="100"><?php echo str_replace('"', '"', trim($row["SoekSkrywer"])) ?></textarea></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekISBN")." " ?></td>
<td class="dr"><input type="text" name="SoekISBN" value="<?php echo str_replace('"', '"', trim($row["SoekISBN"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekUitgewer")." " ?></td>
<td class="dr"><textarea cols="35" rows="4" name="SoekUitgewer" maxlength="60"><?php echo str_replace('"', '"', trim($row["SoekUitgewer"])) ?></textarea></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekUitgeeplek")." " ?></td>
<td class="dr"><input type="text" name="SoekUitgeeplek" maxlength="50" value="<?php echo str_replace('"', '"', trim($row["SoekUitgeeplek"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekUitgeeDatum")." " ?></td>
<td class="dr"><input type="text" name="SoekUitgeeDatum" value="<?php echo str_replace('"', '"', trim($row["SoekUitgeeDatum"])) ?>"></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekWaarGehoor")." " ?></td>
<td class="dr"><textarea cols="35" rows="4" name="SoekWaarGehoor" maxlength="65535"><?php echo str_replace('"', '"', trim($row["SoekWaarGehoor"])) ?></textarea></td>
</tr>
<tr>
<td class="hr"><?php echo htmlspecialchars("SoekStatusID")." " ?></td>
<td class="dr"><select name="SoekStatusID">
<?php
$sql = "select * from lu_soekstatus";
$res = mysql_query($sql, $conn) or die(mysql_error());

while ($lp_row = mysql_fetch_assoc($res)){
$val = $lp_row["SoekStatusID"];
$caption = $lp_row["SoekStatusID"];
if ($row["SoekStatusID"] == $val) {$selstr = " selected"; } else {$selstr = ""; }
?>
<option value="'.$val.'" '.$selstr.'>'.$caption.'</option>;

<?php } ?></select>
</td>
</tr>
</table>
<?php } ?>

PrettyNormlGirl

Dagon? Please help?

Bjom

Please, please for your own sake (and ours): INDENT your code, so that you make the structure of your code clear to see at one glance.

And do use the [ PHP ] [ /PHP ] tags around PHP code.

Better readable code = better coding = less of a headache.

Bjom

PrettyNormlGirl

Bjom;10918531 wrote:
@:

Please, please for your own sake (and ours): INDENT your code, so that you make the structure of your code clear to see at one glance.

And do use the [ PHP ] [ /PHP ] tags around PHP code.

Better readable code = better coding = less of a headache.

Bjom

Hi Bjom

I can do the

code thing, but I don't know how to edit my message here and I also don't exactly understand what you mean by indenting my code. I thought it was ok, but how can I make it better? (Oh, by the way...like I said before, it was generated by a code generator and I didn't re-indent every line before I posted it here).

dagon

use the "code generator" between the ears from now on.

Try this:

<?php
function showroweditor($row,$iseditmode){
	global $conn;
	?>
<table class="tbl" border="0" cellspacing="1" cellpadding="5"
	width="50%">
	<tr>
		<td class="hr">
<?php
	echo htmlspecialchars("SoekBoekID") . "&nbsp;"?></td>
		<td class="dr"><select name="SoekBoekID">
<?php
	$sql= "select * from soekboek";
	$res= mysql_query($sql,$conn) or die(mysql_error());

while($lp_row= mysql_fetch_assoc($res)){
	$val= $lp_row["SoekBoekID"];
	$caption= $lp_row["SoekBoekID"];
	if($row["SoekBoekID"] == $val){
		$selstr= " selected";
	}else{
		$selstr= "";
	}
	echo '<option value="' . $val . '"' . $selstr . '>' . $caption . '</option>';
}
?></select></td>
</tr>
<tr>
	<td class="hr">
<?php
	echo htmlspecialchars("KlientID") . "&nbsp;"?></td>
		<td class="dr"><select name="KlientID">
<?php
	$sql= "select * from kliente";
	$res= mysql_query($sql,$conn) or die(mysql_error());

while($lp_row= mysql_fetch_assoc($res)){
	$val= $lp_row["KlientID"];
	$caption= $lp_row["KlientID"];
	if($row["KlientID"] == $val){
		$selstr= " selected";
	}else{
		$selstr= "";
	}
	echo '<option value="' . $val . '"' . $selstr . '>' . $caption . '</option>';

}
?></select></td>
</tr>
<tr>
	<td class="hr">
<?php
	echo htmlspecialchars("SoekTitel") . "&nbsp;"?></td>
		<td class="dr"><textarea cols="35" rows="4" name="SoekTitel"
			maxlength="100">
<?php
	echo str_replace('"','&quot;',trim($row["SoekTitel"]))?></textarea></td>
	</tr>
	<tr>
		<td class="hr">
<?php
	echo htmlspecialchars("SoekSkrywer") . "&nbsp;"?></td>
		<td class="dr"><textarea cols="35" rows="4" name="SoekSkrywer"
			maxlength="100">
<?php
	echo str_replace('"','&quot;',trim($row["SoekSkrywer"]))?></textarea></td>
	</tr>
	<tr>
		<td class="hr">
<?php
	echo htmlspecialchars("SoekISBN") . "&nbsp;"?></td>
		<td class="dr"><input type="text" name="SoekISBN"
			value="
<?php
	echo str_replace('"','&quot;',trim($row["SoekISBN"]))?>"></td>
	</tr>
	<tr>
		<td class="hr">
<?php
	echo htmlspecialchars("SoekUitgewer") . "&nbsp;"?></td>
		<td class="dr"><textarea cols="35" rows="4" name="SoekUitgewer"
			maxlength="60">
<?php
	echo str_replace('"','&quot;',trim($row["SoekUitgewer"]))?></textarea></td>
	</tr>
	<tr>
		<td class="hr">
<?php
	echo htmlspecialchars("SoekUitgeeplek") . "&nbsp;"?></td>
		<td class="dr"><input type="text" name="SoekUitgeeplek" maxlength="50"
			value="
<?php
	echo str_replace('"','&quot;',trim($row["SoekUitgeeplek"]))?>"></td>
	</tr>
	<tr>
		<td class="hr">
<?php
	echo htmlspecialchars("SoekUitgeeDatum") . "&nbsp;"?></td>
		<td class="dr"><input type="text" name="SoekUitgeeDatum"
			value="
<?php
	echo str_replace('"','&quot;',trim($row["SoekUitgeeDatum"]))?>"></td>
	</tr>
	<tr>
		<td class="hr">
<?php
	echo htmlspecialchars("SoekWaarGehoor") . "&nbsp;"?></td>
		<td class="dr"><textarea cols="35" rows="4" name="SoekWaarGehoor"
			maxlength="65535">
<?php
	echo str_replace('"','&quot;',trim($row["SoekWaarGehoor"]))?></textarea></td>
	</tr>
	<tr>
		<td class="hr">
<?php
	echo htmlspecialchars("SoekStatusID") . "&nbsp;"?></td>
		<td class="dr"><select name="SoekStatusID">
<?php
	$sql= "select * from lu_soekstatus";
	$res= mysql_query($sql,$conn) or die(mysql_error());

while($lp_row= mysql_fetch_assoc($res)){
	$val= $lp_row["SoekStatusID"];
	$caption= $lp_row["SoekStatusID"];
	if($row["SoekStatusID"] == $val){
		$selstr= " selected ";
	}else{
		$selstr= "";
	}
	echo '<option value="' . $val . '"' . $selstr . '>' . $caption . '</option>';
}
?>
</select></td>
</tr>
</table>
<?php
}
?>

PrettyNormlGirl

Thanks Dagon.

I tried the code and 2 of the fields are ok now. It is only the first field that is not working. Sorry, I really don't know php. I will learn it, but right now I need to get through this.

dagon

follow the format of the working one to get the other to work.

PrettyNormlGirl

dagon;10918606 wrote:
follow the format of the working one to get the other to work.

I did do that before I posted. I can't see any differences. The code for the first field, SoekBoekID, looks the same to me as the code for the other 2 fields.
Am I missing something?