PHP - Query Issue

I'm very new to php and mysql so this might be a very stupid question and I'm apologizing ahead of time. Anyway I have a page titled Apparel.php that is supposed to show the most recent item uploaded from each of it's subpages. In other word Apparel is the $category and it has 4 $subcategories (Dresses.php, Skirts.php, Coats.php and Shorts.php). I was able to successfully have the right items show but my coding is pretty long, which I think may affect the speed of the page from loading. I'm sure there's a way to shorten it by perhaps using just one query but I can't figure out how. I'm actually using 4 queries but only posted 2 to keep it shorter. Thanks ahead of time!

Code: [Select]
<?php 
// Run a select query to get latest item from each subcategory
$dynamicList = "";
$query1 = mysql_query("SELECT * FROM products WHERE category='Apparel' AND subcategory='Dresses' ORDER BY date_added DESC LIMIT 1");
$query2 = mysql_query("SELECT * FROM products WHERE category='Apparel' AND subcategory='Skirts' ORDER BY date_added DESC LIMIT 1");
$productCount = mysql_num_rows($query1); // count the output amount
   while($row = mysql_fetch_array($query1)){ 
   $id = $row["id"];
   $product_name = $row["product_name"];
   $subcategory = $row["subcategory"];
   $dynamicList .= '
   <ul>
   <li><a href="Apparel/' . $subcategory . '.php"><img src="inventory_images/' . $id . '_1.jpg" alt="' . $product_name . '" width="140" height="210" border="0" /></a>
   <center><h3>' . $subcategory . '</h3></center>
   </li>
   </ul>';
}
$productCount = mysql_num_rows($query2); // count the output amount
   while($row = mysql_fetch_array($query2)){ 
   $id = $row["id"];
   $product_name = $row["product_name"];
   $subcategory = $row["subcategory"];
   $dynamicList .= '
   <ul>
   <li><a href="Apparel/' . $subcategory . '.php"><img src="inventory_images/' . $id . '_1.jpg" alt="' . $product_name . '" width="140" height="210" border="0" /></a>
   <center><h3>' . $subcategory . '</h3></center>
   </li>
   </ul>';
}
mysql_close();
?>

MOD EDIT: [code] . . . [/code] BBCode tags added.

Hello!   I have a php page which shows a list of customers displayed in an html table format, The first column in the table contains a link for the user to select the row which then navigates to another php page, which is the customer order page. On this page, I want to get certain information based on the name of the customer to prepopulate the customer fields on this form, so I have some php code near the top of the page, as per attached document.   I have checked to ensure that the $_GET['business_name'] contains a value. The query runs fine in myssql and returns only one record when I provide a value for the business_name, however when I run the code in php, the $result variable shows 'Resource id ='7' type='mySQL result'.   I am a total newbie on PHP/MySQL and inherited this application. I have tried to find solutions on line through various forums, but no luck. Perhaps I am not asking/looking for the right question.   Anyway, any assistance would be greatly appreciated.           Attached Files  customer_order_php.php   648bytes   1 downloads

Hi everyone...

My script register01.php isnt working as expected, it should take variables from register00.php and insert them into the db. It is currently re-loading itself and not inserting, could you take a look at this for me:

register00.php

Code: [Select]
<form enctype="multipart/form-data" method="post" action="register01.php">
 <table width="316" height="120" border="0">
 <tr><td colspan=2><h1>Register/Sign Up</h1></td></tr>
 <tr><td>Company Name:</td><td>
 <input name="company_name" type="text" id="company_name">
 </td></tr>
 <tr><td>Contact Name:</td><td>
 <input name="contact_name" type="text" id="contact_name">
 </td></tr>
 <tr><td>Contact Number:</td><td>
 <input name="phone" type="number" id="phone" value="incl. area code">
 </td></tr>
 <tr><td>Address line 1:</td><td>
 <input name="street1" type="text" id="street1">
 </td></tr>
 <tr><td>Address line 2:</td><td>
 <input name="street2" type="text" id="street1">
 </td></tr>
 <tr><td>Area:</td><td>
 <input name="location" type="text" id="location">
 </td></tr>
 <tr><td>City:</td><td>
 <input name="city" type="text" id="city">
 </td></tr>
 <tr><td>Postcode:</td><td>
 <input name="postcode" type="text" id="postcode">
 </td></tr>
 <tr><td>Username:</td><td>
 <input name="username" type="text" id="username">
 </td></tr>
 <tr><td>Password:</td><td>
 <input name="password" type="password" class="style7" id="password">
 </td></tr>
 <tr><td>Email:</td><td>
 <input name="email" type="text" class="style7" id="email">
 </td></tr>
 <tr><td>Company Logo:</td><td>
 <input name="upload" type="file" class="style7" id="upload">
 </td></tr>
 <tr><td>Company Description:</td><td>
 <textarea rows="20" cols="50" name="premiumuser_description" id="premiumuser_description"></textarea>
 </td></tr>
 <tr><td>
 <input name="Submit" type="submit" value="Register" />
 </td></tr>
 </table>

register01.php

Code: [Select]
<?PHP
session_start();
include('db.php');
/* set some validation variables */
$error_message = "";

/* DEFINE THE FUNCTION */
/* ============================================== */
/* ============================================== */
/* DO NOT MODIFY THIS FUNCTION */
function Resize_Image($save,$file,$t_w,$t_h,$s_path,$o_path) {
$s_path = trim($s_path);
$o_path = trim($o_path);
$save = $s_path . $save;
$file = $o_path . $file;
$ext = strtolower(end(explode('.',$save)));
list($width, $height) = getimagesize($file) ;
if(($width>$t_w) OR ($height>$t_h)) {
$r1 = $t_w/$width;
$r2 = $t_h/$height;
if($r1<$r2) {
  $size = $t_w/$width;
}else{
  $size = $t_h/$height;
}
}else{
$size=1;
}
$modwidth = $width * $size;
$modheight = $height * $size;
$tn = imagecreatetruecolor($modwidth, $modheight) ;
switch ($ext) {
case 'jpg':
case 'jpeg':
$image = imagecreatefromjpeg($file) ;
break;
case 'gif':
$image = imagecreatefromgif($file) ;
break;
case 'png':
$image = imagecreatefrompng($file) ;
break;
}
imagecopyresampled($tn, $image, 0, 0, 0, 0, $modwidth, $modheight, $width, $height) ;
imagejpeg($tn, $save, 100) ;
return;
}
/* END OF RESIZE FUNCTION */

//This is the directory where images will be saved
$target = "/home/users/web/b109/ipg.removalspacecom/images/COMPANIES/";
$target = $target . basename( $_FILES['upload']['name']);
 
 // Connects to your Database
 session_start();
 include ('db.php');

//This gets all the other information from the form
/* ============================================== */
/* ============================================== */
/* YOU NEED TO DO SOME VALIDATION AND SANITIZING OF YOUR FORM DATA */


if((!isset($_POST['company_name'])) || (strlen(trim($_POST['company_name'])) <5) || (trim($_POST['company_name']) !=
preg_replace("/[^a-zA-Z0-9\s\-\'\,\.\_]/", "",
trim($_POST['company_name'])))) {
/* if username is bad start building the error message */
$error_message = "You must enter a valid company name<br>";
$error_message = $error_message . "Valid names  are min 5 characters and use letters, numbers and underscores only.<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['company_name'] . "</font><hr>";
}
/* END validating company_name */
/* =============================================== */

if((!isset($_POST['contact_name'])) || (strlen(trim($_POST['contact_name'])) <5) || (trim($_POST['contact_name']) !=
preg_replace("/[^a-zA-Z0-9\s\-\'\,\.\_]/", "",
trim($_POST['contact_name'])))) {
/* if username is bad start building the error message */
$error_message = "You must enter a valid contact name<br>";
$error_message = $error_message . "Valid names  are min 5 characters and use letters, numbers and underscores only.<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['contact_name'] . "</font><hr>";
}
/* END validating contact_name */
/* =============================================== */

 

if((!isset($_POST['phone'])) || (strlen(trim($_POST['phone'])) <5) || (trim($_POST['phone']) != preg_replace("/[^0-9\s\-\_]/", "", trim($_POST['phone'])))) {
/* if it is NOT set, then set the error variable and start building the error message */
$error_message = $error_message . "You must enter a valid phone<br>";
$error_message = $error_message . "Valid phones are min 5 characters and use letters, numbers and underscores only.<br>";
$error_message = $error_message . 'Your invalid phone was: <font color="red">' . $_POST['phone'] . "</font><hr>";
}else{
$phone = trim($_POST['phone']);
}

/* END validating phone */
/* =============================================== */

/* =============================================== */
/* validating the email */
/* create a function */
function validateEmailAddress($email) {
return filter_var($email, FILTER_VALIDATE_EMAIL) && preg_match('/@.+\./', $email);
}
if(!isset($_POST['email']) || validateEmailAddress($_POST['email']) !=1) {
$error_message = $error_message . "You must enter a valid email address<br>";
$error_message = $error_message . 'The invalid email was: <font color="red">' . $_POST['email'] . "</font><hr>";
}
/* END validating email */
/* =============================================== */

if((!isset($_POST['street1'])) || (strlen(trim($_POST['street1'])) <5) || (trim($_POST['street1']) !=
preg_replace("/[^a-zA-Z0-9\s\-\'\,\.\_]/", "",
trim($_POST['street1'])))) {
/* if username is bad start building the error message */
$error_message = "You must enter a valid address<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['street1'] . "</font><hr>";
}
/* END validating street1 */
/* =============================================== */

if((!isset($_POST['street2'])) || (strlen(trim($_POST['street2'])) <5) || (trim($_POST['street2']) !=
preg_replace("/[^a-zA-Z0-9\s\-\'\,\.\_]/", "",
trim($_POST['street2'])))) {
/* if username is bad start building the error message */
$error_message = "You must enter a valid address<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['street2'] . "</font><hr>";
}
/* END validating street2 */
/* =============================================== */

if((!isset($_POST['premiumuser_description'])) || (strlen(trim($_POST['premiumuser_description'])) <5) || (trim($_POST['premiumuser_description']) !=
preg_replace("/[^a-zA-Z0-9\s\-\'\,\.\_]/", "",
trim($_POST['premiumuser_description'])))) {
/* if username is bad start building the error message */
$error_message = "You must enter a valid address<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['premiumuser_description'] . "</font><hr>";
}
/* END validating premiumuser_description */
/* =============================================== *


/* =============================================== */
/*
this section of code will set up an error message for the
username if ANY of the conditions occur
1) checks to see if $_POST['username'] is NOT set
2) if length of username is less than 5
3) if username has anything other than letter, numbers or underscores
*/
if((!isset($_POST['username'])) || (strlen(trim($_POST['username'])) <5) || (trim($_POST['username']) != preg_replace("/[^a-zA-Z0-9\_]/", "", trim($_POST['username'])))) {
/* if username is bad start building the error message */
$error_message = "You must enter a valid username<br>";
$error_message = $error_message . "Valid names  are min 5 characters and use letters, numbers and underscores only.<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['username'] . "</font><hr>";
}
/* END validating username */
/* =============================================== */


/* =============================================== */
/*
this section of code will set up an error message for the
password if ANY of the conditions occur
1) checks to see if $_POST['upassword'] is NOT set
2) if length of upassword is less than 5
3) if upassword has anything other than letter, numbers or underscores
*/
if((!isset($_POST['password'])) || (strlen(trim($_POST['password'])) <5) || (trim($_POST['password']) != preg_replace("/[^a-zA-Z0-9\_]/", "", trim($_POST['password'])))) {
/* if it is NOT set, then set the error variable and start building the error message */
$error_message = $error_message . "You must enter a valid password<br>";
$error_message = $error_message . "Valid passwords are min 5 characters and use letters, numbers and underscores only.<br>";
$error_message = $error_message . 'Your invalid password was: <font color="red">' . $_POST['password'] . "</font><hr>";
}else{
$password = trim($_POST['password']);
}
/* END validating password */
/* =============================================== */

/* =============================================== */
/* check to see if username is already taken */
$username = mysql_real_escape_string(trim($_POST['username']));
$query1 = "SELECT username from companies WHERE username = '$username'";
$result1 = mysql_query($query1)  or die(mysql_error());
$count = mysql_num_rows($result1);
if($count>0) {
$error_message = $error_message . 'The username: <font color="red">' . $_POST['username'] . "</font> is taken.<hr>";
}

/* =============================================== */
/* if any of the post variables are invalid */
/* set the session variable and send back to the form page */
if(strlen(trim($error_message))>0) {
$_SESSION['error_message'] =$error_message;
header("Location: register00.php");
exit();
}
/* =============================================== */

$uploadDir = 'images/COMPANIES'; /* main picture folder */
$max_height = 450; /* largest height you allowed; 0 means any */
$max_width = 450; /*  largest width you allowed; 0 means any */
$max_file = 2000000;  /*  set the max file size in bytes */
$image_overwrite = 1; /* 0 means overwite; 1 means new name */
/* add or delete allowed image types */
$allowed_type01 = array( "image/gif", "image/pjpeg", "image/jpeg", "image/png", "image/x-png", "image/jpg");
$do_thumb = 1; /*  1 make thumbnails; 0 means do NOT make */
$thumbDir = "/images/thumbs";  /*  thumbnail folder */
$thumb_prefix = "";  /*  prefix for thumbnails */
$thumb_width = 90; /*  max thumb width */
$thumb_height = 70; // max thumb height
 
 //Writes the photo to the server
if(move_uploaded_file($_FILES['upload']['tmp_name'], $target)) {
/* HERE IS WHERE WE WILL DO THE ACTUAL RESIZING */
/* ============================================== */
/* ============================================== */
/* THESE SIX PARAMETERS MAY BE CHANGED TO SUIT YOUR NEEDS */
$o_path ="images/COMPANIES/";
$s_path = "images/thumbs/";
$file = $upload;
$save = $file;
$t_w = 200;
$t_h = 150;
/* ============================================== */
/* ============================================== */
/* DO NOT CHANGE THIS NEXT LINE */
Resize_Image($save,$file,$t_w,$t_h,$s_path,$o_path);

//Tells you if its all ok
/* ============================================== */
/* ============================================== */
/* PROVIDE A WAY FOR THEM TO GO SOMWHERE */
echo "The file ". $file . " has been uploaded, and your information has been added to the directory";

}else {
//Gives and error if its not
/* ============================================== */
/* ============================================== */
/* PROVIDE A WAY FOR THEM TO GO SOMWHERE */
echo "Sorry, there was a problem uploading your file.";
}




/* =============================================== */
/* PREPARE DATA FOR INSERTION INTO TABLE */
/* FUNCTION TO CREATE SALT */
function createSalt() {
$string = md5(uniqid(rand(), true));
return substr($string, 0, 3);
}
 
 
 //Writes the information to the database
/* ============================================== */
/* ============================================== */
/*
ALWAYS WRITE YOUR QUERIES AS STRINGS
THAT WAY WHEN TESTING, YOU CAN MAKE
SURE THAT THE VALUES CONTAIN WHAT YOU EXPECT
*/

 
$salt = createsalt();
$passwod = trim($_POST['password']);
$hash = hash('sha256', $salt, $password);
$approved = 0;
$username = mysql_real_escape_string(trim($_POST['username']));
$email = mysql_real_escape_string(trim($_POST['email']));
$query ="INSERT INTO `companies` (company_name, contact_name, location, postcode, street1, street2, city, phone, email, basicpackage_description, premiumuser_description, password, salt, approved, upload) VALUES ('$company_name', '$contact_name', '$location', '$postcode', '$street1', '$street2', '$city', '$phone', '$email', '$basicpackage_description', '$premiumuser_description', '$password', '$salt', '$approved', '$upload')";
$result = mysql_query($query) or die(mysql_error());
/* =============================================== */

/*
at this point we can send an email to the admin as well
as the user.
DO NOT send the user's password to ANYONE!!!!
*/
?>
Thank you for registering.<br>;
Your account will be approved and activated within 24 hours.<br><br>
Click here to return to the <a href="index.php">main page</a>.

I've actually ported the query below from something else I've done that works.  Not sure what I'm missing.

 

Here are the errors I'm getting:

Quote

Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home2/csi/public_html/resources/preview1920/functions.php on line 9

Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home2/csi/public_html/resources/preview1920/functions.php on line 11

 

 

	$query = "SELECT id FROM a_sectionals_bkb";

	$results = mysqli_query($con,$query);  //=>  Line 9
	
	echo mysqli_error($results);  //=> Line 11
	
	
	echo '<div class="sectional_select">';
		echo '<form name="Sectionals">';
		echo '<select name="sectional" size="3" onChange="go()">';

				echo '<option value="NULL">Select Sectional</option>';
				while($row = mysqli_fetch_assoc($results)) {
					echo '<option value="/season-preview/19-20/sectional1920/?sectional='. $row['id'] .'">Sectional '. $row['id'].'</option>';
				}

		echo '</select>';
	
	// End Sectional Select
	echo '</div>';

// End of Sectional Select Function

 

Hi Guys,

I'm hoping someone can find what I clearly cant see, I have a page meant to update database records, the page will load and populate with the existing data and allow 5 out of the 7 fields to be edited, however when editing any of those 5, the remaining 2 blank out and can't be filled in again. Im at a bit of loss and have been staring at it for a bit too long i think, hoping a fresh set of eyes can help.

Here's the page (the fields I'm having issues with are inv1/inv2:

<?php

$page_title = 'Edit a Cart';
include ('style.html');

// Check for a valid ID, through GET or POST.
if ( (isset($_GET['id'])) ) { // Accessed through active_search.php
$id = $_GET['id'];
} elseif ( (isset($_POST['id'])) ) { // Form has been submitted.
$id = $_POST['id'];
} else { // No valid ID, kill the script.
echo '<div id="title">Page Error</div>
<p class="error">This page has been accessed in error.</p><p><br /><br /></p>'; 
exit();
}

require_once ('mysql_connect.php'); // Connect to the db.

// Check if the form has been submitted.
if (isset($_POST['submitted'])) {

$errors = array(); // Initialize error array.

// Check for a PO.
{
$po = trim($_POST['po']);
}

// Check for a Master Serial.
{
$sr = trim($_POST['serial']);
}

// Check for a Charger Serial.
{
$ch = trim($_POST['charger']);
}

// Check for a Battery Serial.
{
$bt1 = trim($_POST['battery1']);
}

// Check for a Battery Serial.
{
$bt2 = trim($_POST['battery2']);
}

// Check for a Inverter Serial.
{
$in1 = trim($_POST['inv1']);
}

// Check for a 2nd Inverter Serial.
{
$in2 = trim($_POST['inv2']);
}

// Check for a Radio Serial.
{
$abc = trim($_POST['abc']);
}

if (empty($errors)) { // If everything's OK.

//  Test for unique master serial.
$query = "SELECT serial FROM serials WHERE serial='$id'";
$result = mysql_query($query);
if (mysql_num_rows($result) == 1) {

// Make the query.
$query = "UPDATE serials SET po='$po', serial='$sr', charger='$ch', batt1='$bt1', batt2='$bt2', inv1='$in1', inv2='$in2', abc='$abc' WHERE serial='$id'";
$result = @mysql_query ($query); // Run the query.
if (mysql_affected_rows() == 1) { // If it ran OK.

// Print a message.
echo '<div id="title">Success!</div>
<p>The node has been edited.<a href="javascript:window.close();">Close</a></p><p><br /><br /></p>';

} else { // If it did not run OK.
echo '<div id="title">System Error</div>
<p class="error">The node could not be edited due to a system error. We apologize for any inconvenience.</p>'; // Public message.
echo '<p>' . mysql_error() . '<br /><br />Query: ' . $query . '</p>'; // Debugging message. 
exit();
}

} else { // Already registered.
echo '<div id="title">Error!</div>
<p class="error">The Serial has already been registered.</p>';
}

} else { // Report the errors.

echo '<div id="title">Error!</div>
<p class="error">The following error(s) occurred:<br />';
foreach ($errors as $msg) { // Print each error.
echo " - $msg<br />\n";
}
echo '</p><p>Please try again.</p><p><br /></p>';

} // End of if (empty($errors)) IF.

} // End of submit conditional.

// Always show the form.

// Retrieve the user's information.
$query = "SELECT * FROM serials WHERE serial='$id'";
$result = @mysql_query ($query); // Run the query.

if (mysql_num_rows($result) == 1) { // Valid ID, show the form.

// Get the user's information.
$row = mysql_fetch_array ($result);

// Create the form.
echo '<div id="title">Edit a Cart</div>
<form action="serial_edit.php" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>P.O #:</td><td><input type="text" name="po" size="15" maxlength="15" value="' . $row['po'] . '" /></td>
</tr>
<tr>
<td>Cart Serial:</td><td><input type="text" name="serial" size="15" maxlength="30" value="' . $row['serial'] . '" /></td>
</tr>
<tr>
<td>Charger:</td><td><input type="text" name="charger" size="20" maxlength="40" value="' . $row['charger'] . '"  /> </td>
</tr>
<tr>
<td>Battery 1:</td><td><input type="text" name="battery1" size="20" maxlength="40" value="' . $row['batt1'] . '"  /> </td>
</tr>
<tr>
<td>Battery 2:</td><td><input type="text" name="battery2" size="20" maxlength="40" value="' . $row['batt2'] . '"  /> </td>
</tr>
<tr>
<td>Inverter 1:</td><td><input type="text" name="inverter1" size="20" maxlength="40" value="' . $row['inv1'] . '"  /> </td>
</tr>
<tr>
<td>Inverter 2:</td><td><input type="text" name="inverter2" size="20" maxlength="40" value="' . $row['inv2'] . '"  /> </td>
</tr>
<tr>
<td>ABC:</td><td><input type="text" name="abc" size="20" maxlength="40" value="' . $row['abc'] . '"  /> </td>
</tr>
<tr>
<td><input type="submit" name="submit" value="Submit" /><input type="hidden" name="submitted" value="TRUE" /></td>
<td><input type="hidden" name="id" value="' . $id . '" /></td></tr>
</form>';

} else { // Not a valid ID.
echo '<div id="title">Page Error</div>
<p class="error">This page has been accessed in error.</p><p><br /><br /></p>';
}

mysql_close(); // Close the database connection.

?>