MySQL Connection for Newbie

millercepbs

I'm creating an online php/mysql form to insert a table. The table has combo boxes for some of the values for the user to choose from and they enter text and numbers for other. IE some boxes are populated when the page loads, and others are not. Then I need to insert that information into the table. One of these fields is the primary key (an asset tracking number). Most other fields are shows as descriptions on the page, but actually correspond to a number in the table. I.e. the department may show as accounting, but the value stored in the table is 1.

Anyway, when i try to run the page, it is just blank so I guess I have an error somewhere. The top portion works fine because it is being used on ever page, but the bottom portion (the actual form) is not working.

Iattached the code in a file.

rincewind456

millercepbs wrote:
I attached the code in a file.

Where?

Houdini

Could you just copy and paste the form code into a post. It is possible that you browsed your hard drive for the attachment but you either failed to follow up by actually uploading it to this site or it was a file type not allowed to be attached. HTML is allowed as is PHP on this site in a post so you could just put it into a post.

millercepbs

Well the code was too long to post in one thread so I'll split it up for you.

Here is the code:
<?php require_once('Connections/phoneinv.php'); ?>
<?php
//initialize the session
session_start();

// Logout the current user.
$logoutAction = $SERVER['PHP_SELF']."?doLogout=true";
if ((isset($SERVER['QUERY_STRING'])) && ($SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($SERVER['QUERY_STRING']);
}

if ((isset($GET['doLogout'])) &&($GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
session_unregister('MM_Username');
session_unregister('MM_UserGroup');

$logoutGoTo = "logout.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
session_start();
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;

// When a visitor has logged into this site, the Session variable MM_Username set equal to their username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}

$MM_restrictGoTo = "login.php";
if (!((isset($SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $SESSION['MM_Username'], $SESSION['MM_UserGroup'])))) {

$MM_qsChar = "?";
$MM_referrer = $SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?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 = $SERVER['PHP_SELF'];
if (isset($SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($POST["MM_insert"])) && ($POST["MM_insert"] == "addRecord")) {
$insertSQL = sprintf("INSERT INTO inventory (assetID, category, location, department, room, model, status) VALUES (%s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($POST['assetID'], "int"),
GetSQLValueString($POST['category'], "int"),
GetSQLValueString($POST['location'], "int"),
GetSQLValueString($POST['department'], "int"),
GetSQLValueString($POST['room'], "text"),
GetSQLValueString($POST['model'], "int"),
GetSQLValueString($_POST['status'], "int"));

mysql_select_db($database_phoneinv, $phoneinv);
$Result1 = mysql_query($insertSQL, $phoneinv) or die(mysql_error());

$insertGoTo = "addRecordConfirm.php";
if (isset($SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}

millercepbs

$colname_phoneinv = "1";
if (isset($POST['assetID'])) {
$colname_phoneinv = (get_magic_quotes_gpc()) ? $POST['assetID'] : addslashes($_POST['assetID']);
}
mysql_select_db($database_phoneinv, $phoneinv);
$query_phoneinv = sprintf("SELECT * FROM inventory WHERE assetID = %s ORDER BY assetID ASC", $colname_phoneinv);
$phoneinv = mysql_query($query_phoneinv, $phoneinv) or die(mysql_error());
$row_phoneinv = mysql_fetch_assoc($phoneinv);
$totalRows_phoneinv = mysql_num_rows($phoneinv);

mysql_select_db($database_phoneinv, $phoneinv);
$query_modelNumbers = "SELECT * FROM model";
$modelNumbers = mysql_query($query_modelNumbers, $phoneinv) or die(mysql_error());
$row_modelNumbers = mysql_fetch_assoc($modelNumbers);
$totalRows_modelNumbers = mysql_num_rows($modelNumbers);

mysql_select_db($database_phoneinv, $phoneinv);
$query_Status = "SELECT * FROM status";
$Status = mysql_query($query_Status, $phoneinv) or die(mysql_error());
$row_Status = mysql_fetch_assoc($Status);
$totalRows_Status = mysql_num_rows($Status);

mysql_select_db($database_phoneinv, $phoneinv);
$query_Category = "SELECT * FROM category";
$Category = mysql_query($query_Category, $phoneinv) or die(mysql_error());
$row_Category = mysql_fetch_assoc($Category);
$totalRows_Category = mysql_num_rows($Category);

mysql_select_db($database_phoneinv, $phoneinv);
$query_Department = "SELECT * FROM department";
$Department = mysql_query($query_Department, $phoneinv) or die(mysql_error());
$row_Department = mysql_fetch_assoc($Department);
$totalRows_Department = mysql_num_rows($Department);

mysql_select_db($database_phoneinv, $phoneinv);
$query_Location = "SELECT * FROM location";
$Location = mysql_query($query_Location, $phoneinv) or die(mysql_error());
$row_Location = mysql_fetch_assoc($Location);
$totalRows_Location = mysql_num_rows($Location);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Track Talk</title>
<style type="text/css">

</style>
<script language="JavaScript" type="text/JavaScript">

</script>
</head>

<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="50%" align="left" valign="bottom"><img src="desktoplogo.jpg" width="216" height="95"></td>
<td width="50%" align="right" valign="middle"><div align="right" class="style1">
<p>Track Talk </p>
<p><span class="style2">version 1.0 </span> </p>
</div></td>
</tr>
<tr>
<td colspan="2"><hr> </td>
</tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0" border="0" bgcolor="#FFFFFF">
<tr>
<td width="13%"><a href="<?php echo $logoutAction ?>">Log out</a></td>
<td width="61%">Manage :
<select name="ManageMenu" onChange="MM_jumpMenu('parent',this,0)">
<option>Select an option</option>
<option value="manageLocations.php">Manage Locations</option>
<option value="manageCategories.php">Manage Categories</option>
<option value="manageModelNumber.php">Manage Model Numbers</option>
<option value="manageDepartment.php">Manage Department</option>
<option value="manageStatus.php">Manage Status</option>
</select>
Records :
<select name="RecordsMenu" onChange="MM_jumpMenu('parent',this,0)">
<option>Select an option</option>
<option value="addRecord.php">Add Record</option>
<option value="deleteRecord.php">Delete Record</option>
<option value="updateRecord.php">Update Record</option>
</select></td>
<td width="26%"><form name="form1" method="post" action="">
<div align="right">Search :
<input type="text" name="textfield">

<input type="submit" name="Submit" value="Go">

</div>
</form>

</td>
</tr>
</table>
<div align="center"></div>
<p> </p>
<p align="center"><span class="style4">Add Record</span>
</p>
<form action="<?php echo $editFormAction; ?>" method="POST" name="addRecord" id="addRecord">
<div align="center">
<table width="auto" border="0">
<tr>
<td><div align="right">Asset Number : </div></td>
<td><input name="assetID" type="text" id="assetID" maxlength="11"></td>
</tr>
<tr>
<td><div align="right">Room Number : </div></td>
<td><div align="right">
<input name="room" type="text" id="room" maxlength="20">
</div></td>
</tr>
<tr>
<td><div align="right">Model Number : </div></td>
<td><select name="model" id="model">
<?php
do {

?>
<option value="<?php echo $row_modelNumbers['modelID']?>"<?php if (!(strcmp($row_modelNumbers['modelID'], $row_Status['statusID']))) {echo "SELECTED";} ?>><?php echo $row_modelNumbers['modelDesc']?></option>
<?php
} while ($row_modelNumbers = mysql_fetch_assoc($modelNumbers));
$rows = mysql_num_rows($modelNumbers);
if($rows > 0) {
mysql_data_seek($modelNumbers, 0);
$row_modelNumbers = mysql_fetch_assoc($modelNumbers);
}
?>
</select></td>
</tr>
<tr>
<td><div align="right">Status : </div></td>
<td><select name="status" id="status">
<?php
do {

?>
<option value="<?php echo $row_Status['statusID']?>"<?php if (!(strcmp($row_Status['statusID'], $row_Status['statusID']))) {echo "SELECTED";} ?>><?php echo $row_Status['statusDesc']?></option>
<?php
} while ($row_Status = mysql_fetch_assoc($Status));
$rows = mysql_num_rows($Status);
if($rows > 0) {
mysql_data_seek($Status, 0);
$row_Status = mysql_fetch_assoc($Status);
}
?>
</select></td>
</tr>
<tr>
<td><div align="right">
<p>Category : </p>
</div></td>
<td><select name="category" id="category">
<?php
do {

?>
<option value="<?php echo $row_Category['categoryID']?>"<?php if (!(strcmp($row_Category['categoryID'], $row_Category['categoryID']))) {echo "SELECTED";} ?>><?php echo $row_Category['categoryDesc']?></option>
<?php
} while ($row_Category = mysql_fetch_assoc($Category));
$rows = mysql_num_rows($Category);
if($rows > 0) {
mysql_data_seek($Category, 0);
$row_Category = mysql_fetch_assoc($Category);
}
?>
</select></td>
</tr>
<tr>
<td><div align="right">Department : </div></td>
<td><select name="department" id="department">
<?php
do {

?>
<option value="<?php echo $row_Department['departmentID']?>"<?php if (!(strcmp($row_Department['departmentID'], $row_Department['departmentID']))) {echo "SELECTED";} ?>><?php echo $row_Department['departmentDesc']?></option>
<?php
} while ($row_Department = mysql_fetch_assoc($Department));
$rows = mysql_num_rows($Department);
if($rows > 0) {
mysql_data_seek($Department, 0);
$row_Department = mysql_fetch_assoc($Department);
}
?>
</select></td>
</tr>
<tr>
<td><div align="right">Location : </div></td>
<td><select name="location" id="location">
<?php
do {

?>
<option value="<?php echo $row_Location['locationID']?>"<?php if (!(strcmp($row_Location['locationID'], $row_Location['locationID']))) {echo "SELECTED";} ?>><?php echo $row_Location['locationDesc']?></option>
<?php
} while ($row_Location = mysql_fetch_assoc($Location));
$rows = mysql_num_rows($Location);
if($rows > 0) {
mysql_data_seek($Location, 0);
$row_Location = mysql_fetch_assoc($Location);
}
?>
</select></td>
</tr>
<tr>
<td><div align="right"></div></td>
<td><div align="right">
<input name="Add" type="submit" id="Add" value="Add Record">
</div></td>
</tr>
</table>
</div>

<input type="hidden" name="MM_insert" value="addRecord">
</form>
<p align="center"> </p>
</body>
</html>
<?php
mysql_free_result($phoneinv);

mysql_free_result($modelNumbers);

mysql_free_result($Status);

mysql_free_result($Category);

mysql_free_result($Department);

mysql_free_result($Location);
?>