PHP - Different Error Messages In Connection Mysqli Script.

Hi, I'm trying to write a better PHP code to create and manage my website.   I would like to start a MVC approach with PHP, using OOP. So I can manage the updates in a better way. For example, to begin my project, I would try with the shipping cost of our products, using a Class without merge the PHP and HTML code.   Something like this:

$shippingcost=new ShippingCost();
$shippingcost->state="Italy";
 
$shippingcost->get(); // here I have an array with cost, discount, time ecc.

And If I need it in JSON, I write:

$shippingcost->get("JSON"); // here I have the JSON with cost, discount, time ecc.

I wrote the Class in this way:

class ShippingCost
{
	public $state; 
	private $arrayReturned; 

	public function __construct() {  
		$this->stato="Italy"; // the default state
	}

	public function __destruct() {
	}

	public function get($format="array") {
		$this->arrayReturned=array(
			"cost" => 3.99,
			"costDiscounted" => 7.99,
			"discount" => "50%"
		);

		if (strtolower($formato)=="json")  {
			$this->arrayReturned=json_encode($this->arrayReturned);
		}
		return $this->arrayReturned;
		}
}

It works well, but I need to get the values from a MySQL db. How can pass the MySQL connection to the Class? I'm not able to do this.   Thanks in advance and have a great 2015.   Rob.

Hey Guys, So I am working on implementing zip codes to my database. I found a zip code calculator script, and I am forced to pass the database connection to the class. Although, I realize I use a mysqli connection and the zipcodes class uses mysql...

Appreciate if anyone could assist me in solving my issue. THANKS!

ERRORS...
Quote

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/bleeping/public_html/gregstechservices.com/gregphp/ZipCodesRange.class.php on line 287

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/bleeping/public_html/gregstechservices.com/gregphp/ZipCodesRange.class.php on line 289

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/bleeping/public_html/gregstechservices.com/gregphp/ZipCodesRange.class.php on line 289
MySql Error #:



zip.php
<?php 
require_once("class/mysql_connect.php");
$mysql = New MySQL();
require_once("ZipCodesRange.class.php");
//initialization, pass in DB connection, from zip code, distance in miles.
$zip = new ZipCodesRange($mysql,'98303',50);

//configuration
$zip->setTableName('zipcodes'); //optional, default is zips.
$zip->setZipColumn('ZipCode'); //optional, default is zip.
$zip->setLonColumn('Longitude'); //optional, default is lon.
$zip->setLatColumn('Latitude'); //optional, default is lat.

//do the work
$zip->setZipCodesInRange(); //call to initialize zip array

//zip code output, other processing can be done from this array.
$zipArray = $zip->getZipCodesInRange();

echo '<pre>';
print_r($zipArray);
echo '</pre>';

?>

mysql_connect.php

<?php

require_once ("includes/constants.php");
class MySQL
{

    private $conn;

    /**
     * MySQL::__construct()
     * 
     * @return
     */
    function __construct()
    {
        $this->conn = new mysqli(DB_SERVER, DB_USER, DB_PASS, DB_NAME) or die("Problem connecting to database");
        $dbc = $this->conn;
    }


    /*
    * Query the database
    * Example: $result = $mysql->query($q);
    */
    /**
     * MySQL::query()
     * 
     * @param mixed $q
     * @return
     */
    function query($q)
    {
        return $this->conn->query($q);
    }

...CONTINUED


ZipCodesRange.class.php

<?php
/**
 * Class to find zip codes within an approximate
 * distance of another zip code. This can be useful
 * when trying to find retailers within a certain
 * number of miles to a customer.
 *
 * This class makes some assumptions that I consider
 * pretty safe.  First it assumes there is a database
 * that houses all of the zip code information. 
 * Secondly it assumes there is a way to validate a
 * zip code for a given country.  It makes one bad
 * assumption and that is that the world is flat. See
 * comments below for an explanation.
 *
 * @author  Scott Mattocks
 * @created 2004-05-03
 * @updated 2004-05-14
 * @updated 2006-05-22 - MySQL Conversion by Allan Bogh
 * - Added precisionDistance() function to make calculations
 * more accurate (within 2 miles).
 * - Modified class initialization to make custom database settings
 * more effective.
 * New initialization steps:
 * $zip = new ZipCodesRange($appconf['dbconnection'],'98303',50);
 * $zip->setTableName('zip_codes'); //optional
 * $zip->setZipColumn('zip'); //optional
 * $zip->setLonColumn('longitude'); //optional
 * $zip->setLatColumn('latitude'); //optional
 * $zip->setZipCodesInRange(); //call to initialize zip array
 * echo '<pre>';
 * print_r($zip->getZipCodesInRange());
 * echo '</pre>';
 */

class ZipCodesRange {

  /**
   * The conversion factor to go from miles to degrees.
   * @var float
   */
  var $milesToDegrees = .01445;
  /**
   * The zipcode we are starting from.
   * @var string
   */
  var $zipCode;
  /**
   * The maximum distance in miles to return results for.
   * @var float
   */
  var $range;
  /**
   * The country the zip code is in.
   * @var string Two character ISO code.
   */
  var $country;  
  /**
   * The result of our search.
   * array(zip1 => distance, zip2 =>distance,...)
   * @var array
   */
  var $zipCodes = array ();
  /**
   * The database table to look for zipcodes in.
   * @var string
   */
  var $dbTable = 'zips';
  /**
   * The name of the column containing the zip code.
   * @var string
   */
  var $dbZip = 'zip';
  /**
   * The name of the column containing the longitude.
   * @var string
   */
  var $dbLon = 'lon';
  /**
   * The name of the column containing the latitude.
   * @var string
   */
  var $dbLat = 'lat';
  
  var $db;

  /**
   * Constructor. Calls initialization method.
   *
   * @access private
   * @param  resource $db The link identifier for the database.
   * @param  string  $zipCode
   * @param  float   $range
   * @param  string  $country Optional. Defaults to US.
   * @return object
   */
  function ZipCodesRange($db, $zipCode, $range, $country = 'US') {
    
    $this->_initialize($db, $zipCode, $range, $country);
  }

  /**
   * Initialization method. 
   * Checks data and sets member variables.
   *
   * @access private
   * @param  resource $db The link identifier for the database.
   * @param  string  $zipCode
   * @param  float   $range
   * @param  string  $country Optional. Defaults to US.
   * @return boolean 
   */   
  function _initialize($db, $zipCode, $range, $country) {
    //set up the database connection
$this->db = $db;

    // Check the country.
    if ($this->validateCountry($country)) {
      $this->country = $country;
    } else {
      trigger_error('Invalid country: ' . $country);
      return FALSE;
    }

    // Check the zipcode.
    if ($this->validateZipCode($zipCode, $country)) {
      $this->zipCode = $zipCode;
    } else {
      trigger_error('Invalid zip code: ' . $zipCode);
      return FALSE;
    }

    // We don't need a special method to check the range.
    if (is_numeric($range) && $range >= 0) {
      $this->range = $range;
    } else {
      trigger_error('Invalid range: ' . $range);
      return FALSE;
    }

    // Set up the zip codes.
    //return $this->setZipCodesInRange();
  }

  /**
   * Get all of the zip codes from the database.
   * Currently this method is called on construction but
   * it doesn't have to be.
   *
   * @access public
   * @return boolean
   */
  function setZipCodesInRange() {
    
    // First check that everything is set.
    if (!isset($this->zipCode) || !isset($this->range) || !isset($this->country)) {
      trigger_error('Cannot get zip codes. Class not initialized properly.');
      return FALSE;
    }

    // Get the max longitude and latitude of the starting point.
    $maxCoords = $this->getRangeBox();
    
    // The query.
    $query = 'SELECT ' . $this->dbZip . ', ' . $this->dbLat . ', ';
    $query.=  $this->dbLon . ' ';
    $query.= 'FROM ' . $this->dbTable . ' ';
    $query.= ' WHERE ';
    $query.= '  (' . $this->dbLat . ' <= ' . $maxCoords['max_lat'] . ' ';
    $query.= '    AND ';
    $query.= '   ' . $this->dbLat . ' >= ' . $maxCoords['min_lat'] . ') ';
    $query.= '  AND ';
    $query.= '  (' . $this->dbLon . ' <= ' . $maxCoords['max_lon'] . ' ';
    $query.= '    AND ';
    $query.= '   ' . $this->dbLon . ' >= ' . $maxCoords['min_lon'] . ') ';

    // Query the database.
    $qry = mysql_query($query,$this->db);
    
    // Check for errors.
    if (!$qry) {
      trigger_error('MySQL Error #'.mysql_errno($this->db).': '.mysql_error($this->db), E_USER_ERROR);
    }

    // Process each row.
    while ($result = mysql_fetch_array($qry)) {

      // Get the distance form the origin (imperfect see below).
      $distance = $this->precisionDistance($result[$this->dbLat], $result[$this->dbLon]);
      // Double check that the distance is within the range.
      if ($distance < $this->range) {
// Add the zip to the array
$this->zipCodes[$result[$this->dbZip]] = $distance;
      }
    }
    return TRUE;
  }

  /**
   * Return the array of results.
   *
   * @access public
   * @param  none
   * @return &array
   */
  function &getZipCodesInRange() {
    return $this->zipCodes;
  }

  /**
   * Calculate the distance from the coordinates are from the
   * origin zip code.
   *
   * The method is quite imperfect.  It assumes as flat Earth.
   * The values are quite accurate (depending on the conversion
   * factor used) for zip codes close  to the equator. I found
   * some crazy formula for calulating distance on a sphere
   * but I am not good enough at calculus to convert that into
   * working code.
   *
   * @access public
   * @param  float $lat       The latitude you want to know the distance to.
   * @param  float $lon       The longitude you want to know the distance to.
   * @param  float $zip       The zip code you want to know the distance from.
   * @param  int   $percision The number of decimals places in the distance.
   * @return float            The distance from the zip code to the coordinates.
   */
  function calculateDistance($lat, $lon, $zip = NULL, $percision = 2) {
    
    // Check the zip first.
    if (!isset ($zip)) {
      // Make it default to the origin zip code.
      // Could be used to calculate distances from other points.
      $zip = $this->zipCode;
    }
    // Get the coordinates of our starting zip code.
    list ($starting_lon, $starting_lat) = $this->getLonLat($zip);

    // Get the difference in miles for both coordinates.
    $diffLonMiles = ($starting_lon - $lon) / $this->milesToDegrees;
    $diffLatMiles = ($starting_lat - $lat) / $this->milesToDegrees;
    
    // Calculate the distance between two points.
    $distance = sqrt(($diffLonMiles * $diffLonMiles) + ($diffLatMiles * $diffLatMiles));

    // Return the distance rounded to the defined percision.
    return round($distance, $percision);
  }
  
  /**
   * See the report for calculateDistance function.
   */
  function precisionDistance($lat, $lon, $zip = NULL, $precision = 2){
   $earthsradius = 3963.19;
// Check the zip first.
    if (!isset ($zip)) {
      // Make it default to the origin zip code.
      // Could be used to calculate distances from other points.
      $zip = $this->zipCode;
    }

// Get the coordinates of our starting zip code.
    list ($starting_lon, $starting_lat) = $this->getLonLat($zip);
$pi = pi();
   $c = sin($starting_lat/(180/$pi)) * sin($lat/(180/$pi)) +
     cos($starting_lat/(180/$pi)) * cos($lat/(180/$pi)) *
        cos($lon/(180/$pi) - $starting_lon/(180/$pi));

$distance = $earthsradius * acos($c);
return round($distance,$precision);
  }

  /**
   * Get the longitude and latitude for a single zip code.
   *
   * @access public
   * @param  string $zip  The zipcode to get the coordinates for.
   * @return array  Numerically index with longitude first.
   */
  function getLonLat($zip) {
    
    // Get the longitude and latitude for the zip code.
    $query = 'SELECT ' . $this->dbLon . ', ' . $this->dbLat . ' ';
    $query.= 'FROM ' . $this->dbTable . ' ';
    $query.= 'WHERE ' . $this->dbZip . ' = \'' . addslashes($zip) . '\' ';

$qry = mysql_query($query,$this->db);
if(!$qry){
echo "MySql Error #".mysql_errno($this->db).': '.mysql_error($this->db).'<br>';
die;
}
    return mysql_fetch_array($qry);
  }

  /**
   * Check to see if the country is valid.
   *
   * Not implemented in any useful manner.
   *
   * @access public
   * @param  string  $country The country to check.
   * @return boolean
   */
  function validateCountry($country) {

    return (strlen($country) == 2);
  }

  /**
   * Check to see if a zip code is valid.
   *
   * Not implemented in any useful manner.
   *
   * @access public
   * @param  string $zip     The code to validate.
   * @param  string $country The country the zip code is in.
   * @return boolean
   */
  function validateZipCode($zip, $country = NULL) {
    
    // Set the country if we need to.
    if (!isset($country)) {
      $country = $this->country;
    }
    
    // There should be a way to check the zip code for every
    // acceptabe country.
    return TRUE;
  }

  /**
   * Get the maximum and minimum longitude and latitude values
   * that our zip codes can be in.
   *
   * Not all zipcodes in this box will be with in the range.
   * The closest edge of this box is exactly range miles away
   * from the origin but the corners are sqrt(2(range^2)) miles
   * away. That is why we have to double check the ranges.
   *
   * @access public
   * @param  none
   * @return &array The edges of the box.
   */
  function &getRangeBox() {

    // Calculate the degree range using the mile range
    $degrees = $this->range * $this->milesToDegrees;

    // Get the coords for our starting zip code.
    list($starting_lon, $starting_lat) = $this->getLonLat($this->zipCode);
    
    // Set up an array to return.
    $ret_array = array ();

    // Lat/Lon ranges 
    $ret_array['max_lat'] = $starting_lat + $degrees;
    $ret_array['max_lon'] = $starting_lon + $degrees;
    $ret_array['min_lat'] = $starting_lat - $degrees;
    $ret_array['min_lon'] = $starting_lon - $degrees;

    return $ret_array;
  }

  /**
   * Allow users to set the name of the database table holding
   * the information.
   *
   * @access public
   * @param  string $table The name of the db table.
   * @return void
   */
  function setTableName($table) {
    $this->dbTable = $table;
  }

  /**
   * Allow users to set the name of the column holding the
   * latitude value.
   *
   * @access public
   * @param  string $lat The name of the column.
   * @return void
   */
  function setLatColumn($lat) {
    $this->dbLat = $lat;
  }

  /**
   * Allow users to set the name of the column holding the
   * longitude value.
   *
   * @access public
   * @param  string $lon The name of the column.
   * @return void
   */
  function setLonColumn($lon) {
    $this->dbLon = $lon;
  }

  /**
   * Allow users to set the name of the column holding the
   * zip code value.
   *
   * @access public
   * @param  string $zips The name of the column.
   * @return void
   */
  function setZipColumn($zip) {
    $this->dbZip = $zip;
  }

  /**
   * Set a new origin and re-get the data.
   *
   * @access public
   * @param  string $zip The new origin.
   * @return void
   */
  function setNewOrigin($zip) {
    
    if ($this->validateZipCode($zip)) {
      $this->zipCode = $zip;
      $this->setZipCodesInRange();
    }
  }
  
  /**
   * Set a new range and re-get the data.
   *
   * @access public
   * @param  float  $range The new range.
   * @return void
   */
  function setNewRange($range) {
    
    if (is_numeric($range)) {
      $this->range = $range;
      $this->setZipCodesInRange();
    }
  }

  /**
   * Set a new country but don't re-get the data.
   * 
   * It isn't any good to check a zip code in two 
   * countries cause the rules for zip codes vary from
   * country to country.
   *
   * @access public
   * @param  string $country The new country.
   * @return void
   */
  function setNewCountry($coutry) {

    if ($this->validateCountry($country)) {
      $this->country = $country;
    }
  }

  /**
   * Allow users to set the converstion ratio.
   * Hopefully you are changing the percision
   * and not setting a bad value.
   *
   * @access public
   * @param  float  $rate The new value.
   * @return void
   */
  function setConversionRate($rate) {
    
    if (is_numeric($rate)) {
      $this->milesToDegrees = $rate;
    }
  }
}
/* Debugging lines
$zcr = new ZipCodesRange(10965, 10);
print_r($zcr);
*/
?>

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\mywork\unique.php on line 15


<html>
<head>
<title>

</title>
</head>
<body bgproperties="fixed">
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$con = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'mywork';
mysql_select_db($dbname, $con);
$sql=mysql_query(insert into users (regno,name,gender,date,month,year,emailid,cell,paddress,caddress,incometype,incomeamt,dad,fyes,dadocup,mom,myes,momocup,password) VALUES ('$_POST[regno]','$_POST[name]','$_POST[gender]','$_POST[date]','$_POST[month]','$_POST[year]','$_POST[emailid]','$_POST[cell]','$_POST[paddress]','$_POST[caddress]','$_POST[incometype]','$_POST[incomeamt]','$_POST[dad]','$_POST[fyes]','$_POST[dadocup]','$_POST[mom]','$_POST[myes]','$_POST[momocup]','$_POST[password]')");
$sql1=mysql_fetch_array($sql);
$result = @mysql_query($SQl1);
$result="SELECT * FROM users WHERE regno='$regno'";
while($row = mysql_fetch_array($result))
{
    //echo $row['regno']."regno<br>";
//echo $row['name']."name<br>";
//echo $row['gender']."gender<br>";
//echo $row['date']."date<br>";
//echo $row['month']."month<br>";
//echo $row['year']."year<br>";
//echo $row['emailid']."emailid<br>";
//echo $row['cell']."cell<br>";
//echo $row['paddress']."paddress<br>";
//echo $row['caddress']."caddress<br>";
//echo $row['incometype']."incometype<br>";
//echo $row['incomeamt']."incomeamt<br>";
//echo $row['dad']."dad<br>";
//echo $row['fyes']."fyes<br>";
//echo $row['dadocup']."dadocup<br>";
//echo $row['mom']."mom<br>";
//echo $row['myes']."myes<br>";
//echo $row['momocup']."momocup<br>";
//echo $row['password']."password<br>";

}
echo "Thanks for Register!";
if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";
mysql_close($con);
?>
<form name="security" action="index.php" method="post">

<input type="submit" value="click here to login">
</form>
</body>
</html>

I closed everything down last night and it was all fine, website was working as normal etc, but I've turned on the Xxamp server today and I am getting this error. Seems very random as nothing has changed since it was last on? 

Does anyone know how to sort this out and why I'm now getting this error? Thanks!

Hi,

I am creating a cms using php and my sql for my website. I have managed to create the majority of it but am having trouble added a menu on each page.

It appears on the homepage with the following code:

      <ul id="headlines">

<?php foreach ( $results['articles'] as $article ) { ?>

        <li>
          <h2>
         <a href=".?action=viewArticle&amp;articleId=<?php echo $article->id?>"><?php echo htmlspecialchars( $article->title )?></a>
          </h2>
        </li>

<?php } ?>

      </ul>

Once I click on a selection from the menu it takes me to the correct article but there is no menu now.

If I try to copy and paste the code from homepage into my viewArticle file it gives me the error messages 'undefined index articles on line 6' and 'invalid argument supplied for for each'.

This is the viewArticle code after I pasted in the code from homepage:

      <ul id="headlines">

<?php foreach ( $results['articles'] as $article ) { ?>

        <li>
          <h2>
         <a href=".?action=viewArticle&amp;articleId=<?php echo $article->id?>"><?php echo htmlspecialchars( $article->title )?></a>
          </h2>
        </li>

<?php } ?>

      </ul>

      <h1 style="width: 75%;"><?php echo htmlspecialchars( $results['article']->title )?></h1>
      <div style="width: 75%;"><?php echo $results['article']->content?></div>


I would really appreciate anybody helping me figure out how I can add the menu onto the viewArticle page.

Thanks in advance

I have to get the error messages to appear...but for some reason they're not showing up if I leave the forms blank and click submit.

Code: [Select]
  <?
  $PROVINCES = array( "--" => "--- Please Select Provinces ---",
"nf"=>"Newfoundland",
"pe"=>"Prince Edward Island",
"nb"=>"New Brunswick",
"ns"=>"Nova Scotia",
"qc"=>"Quebec",
"on"=>"Ontario",
"mb"=>"Manitoba",
"sk"=>"Saskatchewan",
"ab"=>"Alberta",
"bc"=>"British Columbia",
"nt"=>"Northwest Territories");
 
  if ($_SERVER['REQUEST_METHOD'] == 'GET')
  {
  $dimwelcomeMsg = TRUE;
  }
 
  if ($_SERVER['REQUEST_METHOD'] == 'POST')
  {
  if ($_POST['uname'] == ''){
$errMsg['uname'] = "Username must not be blank!!!"; 
$unameInError = true;
  }
  if (empty($_POST['year']) == TRUE){
  $errMsg['year'] = "Year must not be blank!!";
  }
  if (count($errMsg) > 0 ):
  $dispErrorMsg = TRUE;
else:

foreach ($_POST as $key => $val):
$key = strtoupper($key);
$successMsg[$key] = $val;
endforeach;

$dispSuccessMsg = TRUE;


endif;
  }
  ?>
<html  >

<head>
<title>Comp10065 - Simple Form Validatioon</title>

 
<style type="text/css">


body { margin: 0; padding: 0; font: 80%/1.5 Arial,Helvetica,sans-serif; color: #111; background-color: green; }
h2 { margin: 0px; padding: 10px; font-family: Georgia, "Times New Roman", Times, serif; font-size: 200%; font-weight: normal; color: #FFF; background-color: #CCC; border-bottom: #BBB 2px solid; }
h1 {color:#006600}
p#copyright { margin: 20px 10px; font-size: 90%; color: #999; }
div.form-container { margin: 10px; padding: 5px; background-color: #FFF; border: #EEE 1px solid; }
p.legend { margin-bottom: 1em; }
p.legend em { color: #C00; font-style: normal; }
div.errors { margin: 0 0 10px 0; padding: 5px 10px; border: #FC6 1px solid; background-color: #FFC; }
div.errors p { margin: 0; }
div.errors p em   { color: #C00; font-style: normal; font-weight: bold; }
div.success { margin: 0 0 10px 0; padding: 5px 10px; border: #FC6 1px solid; background-color: #FFC; }
div.success p { margin: 0; color:#006633}
div.success li {list-style-type: none; }
div.form-container form p { margin: 0; }
div.form-container form p.note { margin-left: 170px; font-size: 90%; color: #333; }
div.form-container form fieldset { margin: 10px 0; padding: 10px; border: #DDD 1px solid; }
div.form-container form legend { font-weight: bold; color: #666; }
div.form-container form fieldset div { padding: 0.25em 0; }
div.form-container label,
div.form-container span.label { margin-right: 10px; padding-right: 10px; width: 150px; display: block; float: left; text-align: right; position: relative; }
div.form-container label.error,
div.form-container span.error { color: #000; }
div.form-container select.error, div.form-container div.error {background-color: #FEF;}
div.form-container label em,
div.form-container span.label em { position: absolute; right: 0; font-size: 120%; font-style: normal; color: #C00; }
div.form-container input.error { border-color: #C00; background-color: #FEF; }
div.form-container input:focus,
div.form-container input.error:focus,
div.form-container textarea:focus { background-color: #FFC; border-color: #FC6; }
div.form-container div.controlset {margin: 3px}
div.form-container div.controlset label,
div.form-container div.controlset input { display: inline; float: none; }
div.form-container div.controlset div { margin-left: 170px; }
div.form-container div.buttonrow { padding-left: 430px; border: 1px solid #CCCCCC }
div#wrapper {width: 700px ; margin-left: auto; margin-right: auto}
pre {color:black; font-size: 10pt; font-weight: bold; margin-left: 30px}
</style>

</head>

<body>

<div id="wrapper">

<h1> Form Validation Lab</h1>

<div class="form-container">
 <? if ($_SERVER['REQUEST_METHOD'] == 'GET') : ?>
 <? if (displayWelcomeMsg) : ?>
 <p>Please fill in the form........</p>
 <? endif; ?>
 
<? endif; ?>

<? if ($displaySuccessMsg): ?>
<div class="success">
<p>Thank you for your submission.</p>
<ol>
<? foreach($successMsgs as $key => $successMsg): ?>
<li><?= $key ?> = <?= $successMsg ?> </li>
<? endforeach; ?>
</ol>
</div>
<? endif; ?>

<? if ($dispErrorMsg) : ?>
<div class="errors">
<p><em>Oops...the following errors were encountered</em></p>
<ul>
<? foreach ($errMsgs as $key => $errMsg): ?>
<li><?= $errMsg ?> </li>
<? endforeach; ?>
</ul>
<p>Please correct the errors and re-submit this form.</p>
</div>
<? endif; ?>




<form action="<?= $_SERVER['PHP_SELF'] ?>" method="post">
<input type="hidden" name="act" value="post">
<div class="buttonrow">
<input type="submit" value="Submit This Form " class="button" />
<a href="<?= $_SERVER['PHP_SELF'] ?>" >Start Again</a>
</div>

<p class="legend"><strong>Note:</strong> Required fields are marked with an asterisk (<em>*</em>)</p>
<fieldset>
<legend>User Details</legend>
<div>
<label for="uname" >User Name <em>*</em></label>
<? if (isset($errMsgs['uname'])) echo 'class = "errors"' ?>
           
<input id="uname" type="text" name="uname"  value="<?=$_POST['uname'] ?>"  />
(must be greater than 5 chars)</div>
<div>
<label for="email">Email Address </label>
<input id="email" type="text" name="email" value="" />
</div>
</fieldset>

<fieldset>

<legend>Submission</legend>
<div>
<label for="year">Year (YYYY) <em>*</em></label>
<input id="year" type="text" name="year"
            <? if (isset($errMsgs['year'])) echo 'class = "errors"' ?>
value="" size="4" maxlength="4"  />
(4 digit number)</div>
<div>
<label for="date">Month (MM)</label>
<input id="date" type="text" name="month" value="" size="4" maxlength="2" />

(number ranging from 1-12)</div>
</fieldset>

<fieldset>
<legend>Preferences</legend>
<div>
<label for="type" >Province (Multiple Select) <em>*</em></label>
<select name = "province[]" multiple size = "12" id="type"  >
                <? foreach ($PROVINCES as $abbreviation => $longname); ?>
                <option value = "<?=$abbreviation ?> "></option>
                <? enfgoreach; ?>
</select>

</div>
<div class= 'controlset'   >
<span class="label">Status (Mult Select)<em>*</em></span>
<input name="status[]" id="approved" value="approved" type="checkbox"  /> <label for="approved">Approved</label>
<input name="status[]" id="pending" value="pending" type="checkbox"  /> <label for="pending">Pending Application</label> <input name="status[]" id="actives" value="actives" type="checkbox"  /> <label for="actives">Active Service</label>

</div>

<div class= 'controlset'>
<span class="label">  Location  <em>*</em></span>
<input name="location" id="radio1" value="Garage" type="radio" /> <label for="radio1">Garage</label>
<input name="location" id="radio2" value="Attic" type="radio" /> <label for="radio2">Attic</label>
<input name="location" id="radio3" value="House" type="radio" /> <label for="radio3">House</label>

</div>
</fieldset>

</form>
<p>This debug info is here to help you. You are only required to display the POST array</p>
<pre><?= print_r($_POST,true) ?> </pre>
</div>

</div>

</body>
</html>

hello  , i have this code:


<?php

function error_table($err){
echo"<p><span class='textborder'>$err</span></p>";
}


?>

in a separate php file and then call it from another php file , like this :


$msg_err='bla bla';
error_table($msg_err);


when i click the button it shows the text with its border(the class has a border ,color and 1px)
but when i have the code inside other if functions it shows it 2 or 3 times...

Hey there

I've adapted the search code from the tutorial on this site here

http://www.phpfreaks.com/tutorial/simple-sql-search

for a project I've been working on but have an error.

The search works just fine but if either of the messages I've included are tripped (zero search characters or nothing found) then I get a blank screen and the error message is not echoed. (The vanilla code works fine - the error has arisen through the changes I needed to make).

I don't know why this is happening and would appreciate some help please.

Thanks in advance for any help.

Code: [Select]
session_start();

// check session variable

if (isset($_SESSION['first_name']))
  {
include ('includes/header_loggedin.html');

//db connection info deleted 

$error = array();

//get search term, strip it

if (isset($_GET['search'])) {
$searchTerms = trim($_GET['search']);
$searchTerms = strip_tags($searchTerms); // remove any html/javascript.

   
   if (strlen($searchTerms) < 1) {
      $error[] = 'Search terms must be longer than 1 character.';
   }else {
      $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
   }
   
//formulate query
   if (count($error) < 1) {
$query = "SELECT * FROM table WHERE row LIKE '%{$searchTermDB}%'";

//make the query

$result = mysql_query($query) or die(mysql_error());

//display the results
 if (mysql_num_rows($result) < 1) {
         $error[] = "Your search term yielded no results.";
      } else {
while ($endresult = mysql_fetch_array($result)) {
  echo '<br />';
  echo 'This is what we found';
  echo '<br />';
      echo '<a href="newpage.php?w=' . $endresult['row'] . '">' . $endresult['row'] . '</a>';
  }
}
}
}
}

I wanna give error messages if the user dont enter their name, email or comments. I trıed to do it but mine didnt work. Please help me do it.



Index.php page

Code: [Select]
<html>

<head>
<title>Guestbook</title>
</head>

<body>

<font color="#CC0000" size="+2">Please sign our guestbook</font> <br \> <br \>

<?php

echo "<form name=\"Guestbook\" action=\"confirm.php\" method=\"post\">\n";
echo "<table bgcolor=\"#DAE5CD\">\n";
echo "  <tr>\n";
echo "    <td valign=\"top\">Name: </td>\n";
echo "    <td><input type=\"text\" name=\"name\" size=\"25\" value=\"Your Name\"></td>\n";
echo "  </tr>\n";
echo "  <tr>\n";
echo "    <td valign=\"top\">E-mail:</td>\n";
echo "    <td><input type=\"text\" name=\"email\" size=\"25\" value=\"example@mail.com\"></td>\n";
echo "  </tr>\n";
echo "  <tr>\n";
echo "    <td valign=\"top\">Comments:</td>\n";
echo "    <td><textarea rows=\"5\" cols=\"30\" name=\"comments\">Comments</textarea></td>\n";
echo "     </tr>\n";
echo "  <tr>\n";
echo "    <td></td>\n";
echo "       <td align=\"right\"><input type=\"submit\" name=\"submit\" value=\"Submit\"> &nbsp;
      <input type=\"reset\" value=\"Clear\"> </td>\n";
echo "  </tr>\n";
echo "</table>\n";
echo "</form> ";

?>
</body>
</html>
confirm.php page

Code: [Select]
<html>
<head>
<title> Submission receieved!  </title>
</head>

<body>
<font size="+2" color="#00B0EB">Your submission has been sent successfully!</font><br /> <br />

<?php

//extract($_REQUEST);

if (!isset($_POST["$submit"]))
{

if (empty($_POST["name"]))
{
    echo "Please enter your name!";
        }
else if (empty($_POST["email"]))
{
    echo "Please enter your E-mail";
        }
else if (empty($_POST["comments"]))
{
    echo "Please enter some text";
        }
}

?>

<table bgcolor="#DAE5CD" width="%50" cellpadding="5">
    <tr>
        <td valign="top" width="75">Name : </td>
        <td> <?php echo $_POST["name"];?> </td>
    </tr>
    <tr>
        <td valign="top">E-Mail : </td>
        <td> <?php echo $_POST["email"]; ?> </td>
    </tr>
    <tr>
        <td valign="top">Comments :</td>
        <td> <?php echo $_POST["comments"]; ?> </td>
    </tr>
</table>

</body>
</html>

I have a process that runs in the background, so I don't get to see its output. What I would like to do, is if a error occurs (mysql or php) send me an email with the error message(s), then end the process. Any way I can do this?

Right now, I am not sure if any errors occur, but I am thinking that they might be happening. So any way for me to get the error would be awesome!

Hello,
I've been working on a search script that call on a function to retrieve info from my database. What I'm trying to do next is to echo various errors e.g. No search results to display. At the moment I have three messages I would like to display based on the user input but it is not working when I try to set up a second functions within the same tags.

I have got it working by using header:location but it would be much faster and easier to just echo the messages on one page I will post the code below.
Code: [Select]
<?php require_once('Connections/price_db.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);
//this is the function I would like to add  
function showErrors($error1 = "", $error2 = "", $error3 = ""){
 $var = $_GET['search'] ;
 $error = false;
 $error1 = "";
 $error2 = "";
 $error3 = "";
 if (strlen ($var) < 3){
     $error = true;
 $error1 = "You Must Enter At Least Three Characters To Search";
 }
  if (strlen ($var) == 0)
  {
     $error = true;
 $error2 = "Please Enter a Search";
  }  
  if ($totalRows_Recordset1 == 0){
      $error = true;
  $error3 = "Your Search Returned No Results";
  }
  if ($error){ 
     showErrors($error1,$error2,error3);
}
//above is where I have come into troubles
   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;
}
}}
$colname_Recordset1 = "-1";
if (isset($_GET ['search'])) {
  $colname_Recordset1 = $_GET['search'];
}
mysql_select_db($database_price_db, $price_db);
$query_Recordset1 = sprintf("SELECT * FROM price_db WHERE tb_name LIKE %s OR tb_desc LIKE %s", GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"));
$Recordset1 = mysql_query($query_Recordset1, $price_db) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

?>

and this is the html for it

Code: [Select]
<div class="bold_14">
<?php echo $error1 ?>
    <?php echo $error2 ?>
    <?php echo $error3 ?>
  </div>

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=348687.0

Im trying to create a page that collects personal info from users and registers them.  I have a page that contains the registration form which i will call page 1.  A second page which I will call page 2, processes the form.   A simplified version of page 2 looks like this Code: [Select]

<?php

if (isset($_POST['submitted'])) {
 
    $errors = array();


// Connect to the database.

        require_once ('config.php');


//Check for errors.


//Check to ensure that the password is long enough and is of the right format.

if (eregi ("^[[:alnum:]]{8,16}$" , $_POST['password'])) {

      $b = TRUE;

    } else {
     
      $b = FALSE;

     $errors[] = 'Please enter a password that consists only of letters and numbers between 8 and 16 characters long.';

    }     


//Check to make sure the password matches the confirmed password.

if ($_POST['password'] == $_POST['password2']) {

     $c = TRUE;

     $password =  $_POST['password']; //Encrypt the password.

    } else {

        $c = FALSE;

     $errors[] = 'The password you entered did not match the confirmed password.';

    }




//Check to make sure they entered their first name and it's of the right format.

if (eregi ("^([[:alpha:]]|-|')+$", $_POST['firstname'])) {

        $d = TRUE;

    } else {

        $d = FALSE;

        $errors[] = 'Please enter a valid first name.';


   }



//Check to make sure they entered their last name and it's of the right format.

if (eregi ("^([[:alpha:]]|-|')+$", $_POST['lastname'])) {

        $e = TRUE;

    } else {

        $e = FALSE;

        $errors[] = 'Please enter a valid last name.';


   }




    

//Insert data into database.

if (empty($errors)) {
//query the database.  for the sake of simplicity, I wont include the code
                                       
 // Show thank you message
            echo "<h3>Thank You!</h3>
            You have been registered";
        } else {
            echo '<font color="red">You could not be registered, please contact us about the problem and we will fix it as soon as we can.</font>';

        }


//Display error messages.


} else {// if errors array is not empty


header("Location: page1.php?message=$errors");//Trying to pass the errors array into the url for page1 

        
    }
}

?>



So the idea is to create an array that contains all the errors.  Upon querying the database, if the user completed the fields as required, a thank you message is printed. If not, he is redirected to the page containing the form (page 1) and the array containing the errors is transferred to page 1. Now I will include the relevant section of page 1 whihc is supposed to print the error messages.
Code: [Select]
<?php   if(isset($_GET['message'])  {
                
echo '<h3>Error!</h3>
         The following error(s) occured:<br />';

       
         foreach ($errors as $msg) {
             echo "$msg<br/>\n";
         }

  }

?>


 I get the following error message when I submit the registration forms with deliberate errors:



Error!

The following error(s) occured:

PHP Error Message

Warning: Invalid argument supplied for foreach() in /home/a4993450/public_html/register_page_content.php on line 66

Free Web Hosting
 
Can anyone point out why this error occurs?

This is what I'm getting...

Notice: Undefined variable: sitetitle in /home/vehiclep/public_html/functions.php on line 121

Notice: Undefined variable: ADcode in /home/vehiclep/public_html/functions.php on line 121

Notice: Undefined variable: email in /home/vehiclep/public_html/functions.php on line 121

Notice: Undefined variable: url in /home/vehiclep/public_html/functions.php on line 121

Notice: Undefined variable: charge in /home/vehiclep/public_html/functions.php on line 121

Notice: Undefined variable: currency in /home/vehiclep/public_html/functions.php on line 121

Notice: Undefined variable: price in /home/vehiclep/public_html/functions.php on line 121

this is functions.php
Code: [Select]
function sitesets() {
 
  $sql = "select * from settings limit 1";
$rs = mysql_query($sql);
$row = @mysql_fetch_array($rs);
extract($row);
 
 $sitesets = array("title"=>$sitetitle, "ADcode"=>$ADcode, "email" => $email, "url" => $url, "charge" => $charge, "currency" => $currency, "price" => $price);
 
 return $sitesets;
 
 }

Ive tried going into phpMyadmin and creating a row and entering the info manualy but it doesnt work.  I don't know much about coding so this may be a dumb question but it has me stumped.  I hope somebody can tell me what I'm missing here.

I'm pretty new to php, and I'm making everything on my web site php-driven.

If a warning or error occurs, I don't want the user to see it. Primarily because some of the messages give away hidden file paths that I don't want anyone to know about.

I would prefer to redirect all warnings and errors to a log file. If that's not possible, I would like to just hide them.

I've googled and can't really find what I'm looking for. PHP.net's manual describes something called display_errors, which doesn't sound bad, but then it says:

"Note:

This is a feature to support your development and should never be used on production systems (e.g. systems connected to the internet). "

http://www.php.net/manual/en/errorfunc.configuration.php#ini.display-errors

And I read you can use the @ before any expressions, which I will do if I must, but I don't like it because it's messy. I'd rather there was one thing I could set to say "send all warnings and errors here".

Any advice?

Thank you!