Well, I have to chuckle a bit because the article on how to set up a php testing server that you wrote is the exact one I read to set up my testing server! It is very well written and probably the most helpful and straight foreward article on setting up dreamweaver with XAMPP on the web. I followed all of the instructions exactly, so I imagine the problem must be elsewhere? It's pointing to the C drive because that's where XAMPP is installed. This is how is it supposed to be setup, correct? Apache and MySQL are running, or at least it says so on the XAMPP control panel.
Also, I apologize for not posting this in the right forum. That was my first post on the adobe boards and I didn't really consider inserting records to a database to be an "application." So thanks for pointing me in the right direction.
for those who want to see my code, here it is. Except for the exact names of the fields, it's exactly what dreamweaver creates when youc click on the "insert record" button in the insert menu. I don't see any option for pasting the code as "code" like in most code devolpoer forums. I know some poeple get upset if you paste code without doing it right, so I hope I'm not making anybody mad.
the following is inserted in the head:
<?php require_once('Connections/GiftListConnection.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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 = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE ff SET EmailAddress=%s, Relationship=%s WHERE FirstName=%s",
GetSQLValueString($_POST['EmailAddress'], "text"),
GetSQLValueString($_POST['Relationship'], "text"),
GetSQLValueString($_POST['FirstName'], "text"));
mysql_select_db($database_GiftListConnection, $GiftListConnection);
$Result1 = mysql_query($updateSQL, $GiftListConnection) or die(mysql_error());
$updateGoTo = "ManageFF.php";
if (isset($_SERVER['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
$insertSQL = sprintf("INSERT INTO ff (FirstName, EmailAddress, Relationship) VALUES (%s, %s, %s)",
GetSQLValueString($_POST['FirstName'], "text"),
GetSQLValueString($_POST['EmailAddress'], "text"),
GetSQLValueString($_POST['Relationship'], "text"));
mysql_select_db($database_GiftListConnection, $GiftListConnection);
$Result1 = mysql_query($insertSQL, $GiftListConnection) or die(mysql_error());
$insertGoTo = "ManageFF.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_GiftListConnection, $GiftListConnection);
$query_Recordset1 = "SELECT * FROM ff";
$Recordset1 = mysql_query($query_Recordset1, $GiftListConnection) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
and then this is the actual form code in the body:
<p class="Bold">  Add new family member or friend...</p>
<form action="<?php echo $editFormAction; ?>" method="post" name="form2" id="form2">
<table align="left">
<tr valign="baseline">
<td nowrap="nowrap" align="right">FirstName:</td>
<td><input type="text" name="FirstName" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">EmailAddress:</td>
<td><input type="text" name="EmailAddress" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Relationship:</td>
<td><input type="text" name="Relationship" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input type="submit" value="add" /></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form2" />
</form>
Thanks for trying to help out this noob, everybody!
BTW, this is Inkexit posting. For some reason when I logged in this morning, I was made to pick a new screenname, as inkexit was already in use. But I knew that though, as I was the one using it, lol. Kinda bizzarre. Perhaps the Mods should know about this?
8
Replies
AdChoices