okay, couple of questions in this one... =)
First...
<?=$myData?> is shorthand for <?php echo $myData; ?> if you care.
With a <textarea> there is no "value" attribute.
<TEXTAREA><?=$myData?></TEXTAREA>
Your "UPDATE" call via sprintf() is okay for the parameter passing,
but you're missing single quotes around the text values.
UPDATE test SET (number = 1, name = 'the Name', Desc = 'the Desc');
When dealing with PHP and DBs, the single best thing you can do is
var_dump($your_query) and then cut-n-paste into the command line
utility. It is, hands down, the single easiest (and fastest) way to figure out
why your query doesn't work.
'Luck!
-Mike
----- Original Message -----
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 11:03 AM
Subject: [PHP-DB] Form not working...
> I am working on a "Call Log" application for our SA group. I
> currently have the database back-end configured and working OK. Right now I
> am working with 3 pages, one is to post new entries, the second is a log
> view of all entries, and the last is a page that updates an existing entry.
> I have the first two pages working OK. The problem is the update page does
> not post back into the database.
> I am working in Dreamweaver, and I am still quite new to PHP and web
> page development in general. I am not sure what some of the DreamWeaver PHP
> code is doing, and I cannot figure out why I am not able to get the update
> page to post to the database. The update page is connecting successfully to
> the database, because I have it's fields populated from the database for the
> entry to be updated. One other minor issue I am having, is getting a PHP
> variable to populate a text area on the page. Is this even possible?
> Thanks in advance, and below is the code for the problem page.
>
> <?php require_once('Connections/Test.php'); ?>
> <?php
> function GetSQLValueString($theValue, $theType, $theDefinedValue = "",
> $theNotDefinedValue = "")
> {
> $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
>
> switch ($theType) {
> case "text":
> $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
> break;
> case "long":
> case "int":
> $theValue = ($theValue != "") ? intval($theValue) : "NULL";
> break;
> case "double":
> $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" :
> "NULL";
> break;
> case "date":
> $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
> break;
> case "defined":
> $theValue = ($theValue != "") ? $theDefinedValue :
> $theNotDefinedValue;
> break;
> }
> return $theValue;
> }
>
> $editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
> if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
> $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
> }
>
> if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"]
> == "form1")) {
> $updateSQL = sprintf("UPDATE oncall SET sa=%s, ptime=%s, rtime=%s,
> sbcuid=%s, name=%s, problem=%s, resolution=%s, pass=%s, ctime=%s,
> duration=%s, ttrp=%s, feedback=%s, P1=%s WHERE callid=%s",
> GetSQLValueString($HTTP_POST_VARS['sa'], "text"),
> GetSQLValueString($HTTP_POST_VARS['ptime'], "date"),
> GetSQLValueString($HTTP_POST_VARS['rtime'], "date"),
> GetSQLValueString($HTTP_POST_VARS['sbcuid'], "text"),
> GetSQLValueString($HTTP_POST_VARS['name'], "text"),
> GetSQLValueString($HTTP_POST_VARS['problem'],
> "text"),
> GetSQLValueString($HTTP_POST_VARS['resolution'],
> "text"),
> GetSQLValueString($HTTP_POST_VARS['pass'], "text"),
> GetSQLValueString($HTTP_POST_VARS['ctime'], "date"),
> GetSQLValueString($HTTP_POST_VARS['duration'],
> "date"),
> GetSQLValueString($HTTP_POST_VARS['ttrp'], "date"),
> GetSQLValueString($HTTP_POST_VARS['feedback'],
> "text"),
> GetSQLValueString($HTTP_POST_VARS['P1'], "text"),
> GetSQLValueString($HTTP_POST_VARS['callid'], "int"));
>
> mysql_select_db($database_Test, $Test);
> $Result1 = mysql_query($updateSQL, $Test) or die(mysql_error());
> }
>
> $tmp = $_GET['callid'];
> mysql_select_db($database_Test, $Test);
> $query_Update = "SELECT * FROM oncall WHERE callid='$tmp'";
> $Update = mysql_query($query_Update, $Test) or die(mysql_error());
> $row_Update = mysql_fetch_assoc($Update);
> $totalRows_Update = mysql_num_rows($Update);
> ?>
> <html>
> <head>
> <title>Untitled Document</title>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> </head>
>
> <body>
> <form method="post" name="form1" action="<?php echo $editFormAction; ?>">
> <input type="hidden" name="callid" value="<?php echo
> $row_Update['callid']; ?>">
> <input type="hidden" name="feedback" value="<?php echo
> $row_Update['feedback']; ?>">
> <table width="666" align="center">
> <!--DWLayoutTable-->
> <tr valign="baseline">
> <td width="122" height="24" align="right" nowrap>SA name:</td>
> <td colspan="2"><input type="text" name="sa" value="<?php echo
> $row_Update['sa']; ?>" size="32"></td>
> <td width="39"> </td>
> <td width="124" align="right" valign="top" nowrap>Call passed to:</td>
> <td colspan="2" valign="top"><input type="text" name="pass"
> value="<?php echo $row_Update['pass']; ?>" size="32"></td>
> </tr>
> <tr valign="baseline">
> <td height="24" align="right" nowrap>Time of page:</td>
> <td colspan="2"><input type="text" name="ptime" value="<?php echo
> $row_Update['ptime']; ?>" size="32"></td>
> <td></td>
> <td></td>
> <td width="11"></td>
> <td width="177"></td>
> </tr>
> <tr valign="baseline">
> <td height="24" align="right" nowrap>Time page returned:</td>
> <td colspan="2"><input type="text" name="rtime" value="<?php echo
> $row_Update['rtime']; ?>" size="32"></td>
> <td> </td>
> <td align="right" valign="top" nowrap>Call completion time:</td>
> <td colspan="2" valign="top"><input type="text" name="ctime"
> value="<?php echo $row_Update['ctime']; ?>" size="32"></td>
> </tr>
> <tr valign="baseline">
> <td height="24" align="right" nowrap>SBCUID of client:</td>
> <td colspan="2"><input type="text" name="sbcuid" value="<?php echo
> $row_Update['sbcuid']; ?>" size="32"></td>
> <td> </td>
> <td> </td>
> <td> </td>
> <td> </td>
> </tr>
> <tr valign="baseline">
> <td height="24" align="right" nowrap>Name of client:</td>
> <td colspan="2"><input type="text" name="name" value="<?php echo
> $row_Update['name']; ?>" size="32"></td>
> <td> </td>
> <td align="right" valign="top" nowrap>P1 Vantive ID:</td>
> <td colspan="2" valign="top"><input type="text" name="P1" value="<?php
> echo $row_Update['P1']; ?>" size="32"></td>
> </tr>
> <tr valign="baseline">
> <td height="24" align="right" nowrap>Problem description:</td>
> <td colspan="5" rowspan="3" valign="top"><textarea name="problem"
> value="<?php echo $row_Update['problem']; ?>" cols="40" rows="6"></textarea>
>
> </td>
> <td> </td>
> </tr>
> <tr valign="baseline">
> <td height="46"> </td>
> <td valign="top">Limit of 255 characters.</td>
> </tr>
> <tr valign="baseline">
> <td height="53"> </td>
> <td> </td>
> </tr>
> <tr valign="baseline">
> <td height="24" align="right" valign="top" nowrap>Resolution:</td>
> <td colspan="5" rowspan="3" valign="top"><textarea name="resolution"
> value="<?php echo $row_Update['resolution']; ?>" cols="40"
> rows="6"></textarea></td>
> <td></td>
> </tr>
> <tr valign="baseline">
> <td height="53"> </td>
> <td valign="top">Limit of 255 characters.</td>
> </tr>
> <tr valign="baseline">
> <td height="39"> </td>
> <td> </td>
> </tr>
> <tr valign="baseline">
> <td height="26" align="right" nowrap> </td>
> <td width="91" valign="top"><input type="submit" value="Insert
> Record">
> </td>
> <td width="94"> </td>
> <td> </td>
> <td> </td>
> <td></td>
> <td></td>
> </tr>
> </table>
>
> </form>
> <p> </p>
>
> <p> </p>
> </body>
> </html>
> <?php
> mysql_free_result($Update);
> ?>
>
>
> Scott Nipp
> Phone: (214) 858-1289
> E-mail: [EMAIL PROTECTED]
> Web: http:\\ldsa.sbcld.sbc.com
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
