Learn VBA & Macros in 1 Week!

PHP - Which Mysqli Connection Error Format To Use ?

Full Excel VBA Course - Beginner to Expert

Which Mysqli Connection Error Format To Use ?	View Content

Hi,

3 different tutorials teach 3 different ways on how to get php mysqli echo connection errors.

Which one should I memorise out of these 3 you advise ?
I'd like your rankings on these 3 atleast ....

1.
https://www.php.net/manual/en/function.mysqli-connect.php

$link = mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db");
	if (!$link) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;
}
mysqli_close($link);

2.
https://www.tutorialrepublic.com/php-tutorial/php-mysql-connect.php

$link = mysqli_connect("localhost", "root", "");
 
// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}
 
// Print host information
echo "Connect Successfully. Host info: " . mysqli_get_host_info($link);
 
// Close connection
mysqli_close($link);

3.
https://www.geeksforgeeks.org/php-mysqli_connect-function/

    mysqli_connect("localhost", "root", "", "GFG");
 
    if(mysqli_connect_error())
        echo "Connection Error.";
    else
        echo "Database Connection Successfully.";

Q2. On the connection point check, you give your rankings on these following 3 based on your preference.
I ranked like this:

 if(mysqli_connect_error())

if($link === false){

if (!$link) {

Q3. On the connection error reporting point (error message echoing point), you give your rankings on these following 3 based on your preference.
I ranked like this:

die("ERROR: Could not connect. " . mysqli_connect_error());

echo "Connection Error.";

    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;

Briefly, let me know:

A). Which connection error checking point to use and which error message echoing point to use.

B). If you got your own that is better and more helpful then explain why it is better over these 3 and any others.

Full Excel VBA Course - Beginner to Expert

Different Error Messages In Connection Mysqli Script.

Similar Tutorials

View Content

Sets up a mysqli connection script which I retrieve with included. If a user enters the wrong password or username then the connection to the database will be interrupted, and a message will be given about this.

I want to do this in a different way. I want the .php connection script to work so that the script lets me or the ser know if it is the password that is incorrect or the username that is not authenticated. This way the user can find out if he / she has entered the wrong password or username. If both are incorrect, notice of this will be given. connection file is a fairly standard script. I have no clue about how to solve this problem. Is it posible at all? Do you know how to do it?

<?
$servername = "localhost";
$username = "username";
$password = "password";

// Oppretter tilkobling.
$conn = new mysqli($servername, $username, $password);

// Kontrollerer tilkoblingen.
if ($conn->connect_error) {
die("Tilkoblingen feilet: " . $conn->connect_error);
}
echo "Tilkoblingen var vellykket";
?>

"couldn't Fetch Mysqli" Error, But Connection Isn't Closed

Similar Tutorials

View Content

Hello all, I'm an amateur at PHP coding, and am currently enrolled in a PHP and MySQL class that uses the PHP Programming with MySQL textbook, by Don Gosselin. I'm trying to get this simple Shopping Cart script to work, because it's the step-by-step example script for Chapter 11, but I keep getting the following errors on ShowCart.php when I try to add an item to the cart. Quote

Warning: mysqli_query() [function.mysqli-query]: Couldn't fetch mysqli in C:\xampplite\htdocs\ShoppingCart.php on line 78

Warning: mysqli_errno() [function.mysqli-errno]: Couldn't fetch mysqli in C:\xampplite\htdocs\ShoppingCart.php on line 80

Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch mysqli in C:\xampplite\htdocs\ShoppingCart.php on line 81

Line 78:        $QueryResult = mysqli_query($this->DBConnect, $SQLstring)

Line 80 and 81:             . "<p>Error code " . mysqli_errno($this->DBConnect)
            . ": " . mysqli_error($this->DBConnect)) . "</p>";

I've read "Couldn't fetch mysqli" errors are because the connection was closed prior to those lines, but I don't see any indication of a connection closure. I have no idea what to do, as all the code was given to me in the book, I merely copied it down.

Here's the ShoppingCart.php code:<?php
class ShoppingCart {
    private $DBConnect = "";
    private $DBName = "";
    private $TableName = "";
    private $Orders = array();
    private $OrderTables = array();
function construct() {
    $this->DBConnect = mysqli_connect("localhost", "root", "passHere");
    if (mysqli_connecT_errno())
        die("<p>Unable to connect to the database server.</p>"
        . "<p>Error code " . mysqli_connect_errno()
        . ": " . mysqli_connect_error()) . "</p>";
}

public function setDatabase($Database) {
    $this->DBName = $Database;
    $this->DBConnect->select_db($this->DBName)
        Or die("<p>Unable to select the databbase.</p>"
        . "<p>Error code " . mysqli_errno($this->DBConnect)
        . ": " . mysqli_error($this->DBConnect)) . "</p>";
}
public function setTable($Table) {echo $table."<br />";
    $this->TableName = $Table;
}
public function getProductList() {
    $SQLstring = "SELECT * FROM $this->TableName";
    $QueryResult = $this->DBConnect->query($SQLstring)
        Or die("<p>Error code " . mysqli_errno($this->DBConnect)
        . ": " . mysqli_error($DBConnect)) . "</p>";
    echo "<table width='100%' border='1'>";
    echo "<tr><th>Product</th><th>Description</th><th>Price Each</th><th>Select Item</th></tr>";
    $Row = $QueryResult->fetch_row();
    do {
        echo "<tr><td>{$Row[1]}</td>";
        echo "<td>{$Row[2]}</td>";
        printf("<td align='center'>$%.2f</td>", $Row[3]);
        echo "<td align ='center'>
              <a href='ShowCart.php?PHPSESSID=" . session_id()
              . "&operation=addItem&productID=" . $Row[0]
              . "'>Add</a></td></tr>";
        $Row = $QueryResult->fetch_row();
    } while ($Row);
    echo "</table>";
}
public function addItem() {
    $ProdID = $_GET['productID'];
    if (array_key_exists($ProdID, $this->Orders))
        exit("<p>You already selected that item! Click your
             browser's back button to return to the
             previous page.</p>");
    $this->Orders[$ProdID] = 1;
    $this->OrderTable[$ProdID] = $this->TableName;
}
function _wakeup() {
    $this->DBConnect = new mysqli("localhost", "staticlo_shane", "shinfoosh");
    if (mysqli_connect_errno())
        die("<p>Unable to connect to the database server.</p>"
        . "<p>Error code " . mysqli_connect_errno()
        . ": " . mysqli_connect_error()) . "</p>";
    $this->DBConnect->Select_db($this->DBName)
        Or die("<p>Unable to select the database.</p>"
        . "<p>Error code " . mysqli_errno($$this->DBConnect)
        . ": " . mysqli_error($this->DBConnect)) . "</p>";
}
public function showCart() {
    if (empty($this->Orders))
        echo "<p>Your shopping cart is empty!</p>";
    else {
        echo "<table width='100%' border='1'>";
        echo "<tr><th>Remove Item</th><th>Product</th><th>Quantity</th><th>
              Price Each</th></tr>";
        $Total = 0;
    foreach($this->Orders as $Order) {
        $SQLstring = "SELECT * FROM "
            . $this->OrderTable[key($this->Orders)] . "
            WHERE productID='" . key($this->Orders) . "'";
        $QueryResult = mysqli_query($this->DBConnect, $SQLstring)
            Or die("<p>Unable to perform the query.</p>"
            . "<p>Error code " . mysqli_errno($this->DBConnect)
            . ": " . mysqli_error($this->DBConnect)) . "</p>";
        $Row = mysqli_fetch_row($QueryResult);
        echo "<td align='center'>";
        echo "<a href='ShowCart.php?PHPSESSID=" . session_id()
              . "&operation=removeItem&productID=" . $Row[0]
              . "'>Remove</a></td>";
        echo "<td>{$Row[1]}</td>";
        echo "<td align='center''>$Order ";
echo "<a href='ShowCart.php?PHPSESSID=" . session_id() . "&operation=addOne&productID=" . $Row[0] . "'>Add</a>";
echo "<a href='ShowCart.php?PHPSESSID=" . session_id() . "&operation=removeOne&productID=" . $Row[0] . "'>Remove</a>";
        echo "</td>";
        printf("<td align='center'>$%.2f</td></tr>", $Row[3]);
        $Total += $Row[3] * $Order;
        next($this->Orders);

        echo "<td align='center' colspan='2'><strong>Your shopping
              cart contains " . count($this->Orders)
              . " product(s).</strong></td>";
        printf("<td align='center'><strong>Total: $%.2f</stong>
               </td>", $Total);
        echo "</table>";
    }
    echo "<tr><td align='center'><a href='ShowCart.php?PHPSESSID="
          . session_id() . "&operation=emptyCart'><strong>
          Empty Cart</strong></a></td>";
    }
}
public function removeItem() {
    $ProdID = $_GET['productID'];
    unset($this->Orders[$ProdID]);
    unset($this->OrderTable[$ProdID]);
}
function emptyCart() {
    $this->Orders = array();
    $this->OrderTale = array();
}
function _destruct() {
    $this->DBConnect->close();
}

public function addOne() {
$ProdID = $_GET['productID'];
$this->Orders[$ProdID] += 1;
}

public function removeOne() {
$ProdID = $_GET['productID'];
$this->Orders[$ProdID] -= 1;
if ($this->Orders[$ProdID] == 0)
$this->removeItem();
}

}
?>

Here is the ShowCart.php code:<?php
session_start();
require_once("ShoppingCart.php");
if (!isset($_SESSION['curCart']))
header("location:GosselinGourmetGoods.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="Robots" content="nofollow, noindex" />
<link rel="stylesheet" type="text/css" media="screen" href="php_styles.css" />
</head>
<body>
<h1>Gosselin Gourmet Goods</h1>
<h2>Shop by Category</h2>
<p><a href="GosselinGourmetCoffees.php">Gourmet Coffees</a><br />
<a href="GosselinGourmetOlives.php">Specialty Olives</a><br />
<a href="GosselinGourmetSpices.php">Gourmet Spices</a></p>

<?php
$Cart = unserialize($_SESSION['curCart']);
if (isset($_GET['operation'])) {
if ($_GET['operation'] == "addItem")
$Cart->addItem();
if ($_GET['operation'] == "removeItem")
$Cart->removeItem();
if ($_GET['operation'] == "emptyCart")
$Cart->emptyCart();
if ($_GET['operation'] == "addOne")
$Cart->addOne();
if ($_GET['operation'] == "removeOne")
$Cart->removeOne();
}
$Cart->showCart();
$_SESSION['curCart'] = serialize($Cart);
?>
</body>
</html>

Here is the product page for "Specialty Olives" which is identical to the Coffees and Spices pages, save for the Table name changed to their respective products: <?php
session_start();
require_once("ShoppingCart.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Gosselin Gourmet Goods</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="Robots" content="nofollow, noindex" />
<link rel="stylesheet" type="text/css" media="screen" href="php_styles.css" />
</head>
<body>
<h1>Gosselin Gourmet Goods</h1>
<h2>Shop by Category</h2>
<p><a href="GosselinGourmetCoffees.php">Gourmet Coffees</a><br />
<a href="GosselinGourmetOlives.php">Specialty Olives</a><br />
<a href="GosselinGourmetSpices.php">Gourmet Spices</a></p>

<h2>Speciality Olives</h2>
<?php

$Database = "gosselin_gourmet";
$Table = "olives";

$Cart=!empty($_SESSION['curCart'])?unserialize($_SESSION['curCart']):new ShoppingCart();
$Cart->construct();
$Cart->setDatabase($Database);
$Cart->setTable($Table);
$Cart->getProductList();
$_SESSION['curCart'] = serialize($Cart);
?>
<p><a href='<?php echo "ShowCart.php?PHPSESSID=" . session_id() ?>'>Show Shopping Cart</a></p>
</body>
</html>

Oop In Php Using Mysqli Connection

Similar Tutorials

View Content

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.

Passing Mysqli Connection To A Class.

Similar Tutorials

View Content

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);
*/
?>

Mysqli Display Field Name / Conditionally Format Table

Similar Tutorials

View Content

Alright, I looked though the read me's, went over the FAQ's... Think it is time to post... So, this lump is what I got from going though google and piecing together the bits that looked good.

<?php
$db_host = "****";
$db_user = "****";
$db_pwd = "****";
$database = "****";
$table = "****";
$query = "SELECT * FROM {$table}";
$conn = mysqli_connect($db_host, $db_user, $db_pwd, $database);
$result = mysqli_query($conn,$query) or trigger_error($query . ' - has encountered an error at:<br />' . mysqli_error($conn));
$fields = mysqli_fetch_fields($conn);
$field_count = mysqli_num_fields($conn);
echo '<table border="1" style="width:100%">' . "\n" . '<tr>';
$i = 0;
foreach($fields as $field)
{
	if(++$i == 1) {
		echo '<th colspan="' . $field_count . '">' . $field->table . '</th></tr><tr>';
	}
echo "\n" . '<th>' . $field->name . '</th>';
}
echo '</tr>';
while($row = mysqli_fetch_row($result)) {
	echo '<tr><td>' . implode('</td><td>' , $row) . '</td></tr>';
}
echo '</table>';





?>

The goal is to display the table and conditionally format the contents. Let's forget about the conditional part (thinking if/than but don't know how I'm going to do that yet) and focus on the key problem: displaying the table. I have tested this code. It works...to a point. it displays the table and its contents but no headers. I know my issue is in line 20 and 22 but I can not for the life of me figure it out. If it is stupidly easy (for you) please remember that I am not a coder. At best I am a scripter when it comes to linux. I am over my head on this stuff. Thank you all for any help you can give me
Edited by TheAlmightyOS, 18 November 2014 - 03:30 PM.

Error In Db Connection : Parse Error: Syntax Error, Unexpected T_string

Similar Tutorials

View Content

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>

Getting 'fatal Error: Uncaught Error: Class 'mysqli' Not Found In'

Similar Tutorials

View Content

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!

Error In Mysqli

Similar Tutorials

View Content

hi guys

i get an error in this code (comment in the code):

I

Code: [Select]
if (checkBd ($sql, $db, $valor, $codePass)){

($sql = $db->prepare("UPDATE users SET activation = ? WHERE activationLink=?"));

$valor="1";
$sql->bind_param('is', $valor, $codePass);

$sql->execute();

$sql->bind_result($valor, $codePass); //Warning: mysqli_stmt::bind_result() [mysqli-stmt.bind-result]: Number of bind variables doesn't match number of fields in prepared statement

if ($sql->fetch()) {
header("location: index.php");
return true;
}
else {
echo "no";
return false;
}
$sql->close();
$db->close();
}

what is the possible problem in the script? an another question, is this way correct to update a boolean?

thanks

Error Converting Mysqli To Pdo

Similar Tutorials

View Content

hello i tried to switch from mysqli to pdo but somehow i made a mistake

MYSQLI

  $qry = "SELECT * FROM con where id= '$user'";  
                                    $result = mysqli_query($conn, $qry);
                                    while ($row = mysqli_fetch_assoc($result)) {
                        
                                    print_r($row["convoy_cars"], true);
                                    if($row["convoy_cars"] == 1){
                                    echo '<div class="dashtext-3">Autos f&uuml;r Spieler erlaubt:   <a class="btn btn-sm primary rounded"><i class="fa fa-check-square"></div></i> </a>';
                                    
                                    }
                                    elseif($row["convoy_cars"] == 2){
                                    echo '<div class="dashtext-3">Autos f&uuml;r Spieler erlaubt:   <a class="btn btn-sm danger rounded"><i class="fa fa-times"></i></div> </a>';
                                  
                                    }
                                    print_r($row["convoy_hct"], true);
                                    if($row["convoy_hct"] == 1){
                                    echo '<div class="dashtext-3">HCT-Trailer erlaubt:   <a class="btn btn-sm primary rounded"><i class="fa fa-check-square"></i> </div></a>';
                                    
                                    }
                                    elseif($row["convoy_hct"] == 2){
                                    echo '<div class="dashtext-3">HCT-Trailer erlaubt: <a class="btn btn-sm danger rounded"><i class="fa fa-times"></i></div> </a>';
                                    print_r($row["convoy_absicherung"], true);
                                    }
                                    if($row["convoy_absicherung"] == 1){
                                    echo '<div class="dashtext-3">Absicherung:   <a class="btn btn-sm primary rounded"><i class="fa fa-check-square"></i> </div></a>';
                                    
                                    }
                                    elseif($row["convoy_absicherung"] == 2){
                                    echo '<div class="dashtext-3">Absicherung: <a class="btn btn-sm danger rounded"><i class="fa fa-times"></i></div> </a>';
                                  
                                    
                                    }
                                   }

my try in pdo

 $qry = "SELECT * FROM con where id= '$user'";  
                                    $result = $pdo->prepare($qry);
                                    while ($row = $qry->fetch(PDO::FETCH_ASSOC)){
                        
                                    print_r($row["convoy_cars"], true);
                                    if($row["convoy_cars"] == 1){
                                    echo '<div class="dashtext-3">Autos f&uuml;r Spieler erlaubt:   <a class="btn btn-sm primary rounded"><i class="fa fa-check-square"></div></i> </a>';
                                    
                                    }
                                    elseif($row["convoy_cars"] == 2){
                                    echo '<div class="dashtext-3">Autos f&uuml;r Spieler erlaubt:   <a class="btn btn-sm danger rounded"><i class="fa fa-times"></i></div> </a>';
                                  
                                    }
                                    print_r($row["convoy_hct"], true);
                                    if($row["convoy_hct"] == 1){
                                    echo '<div class="dashtext-3">HCT-Trailer erlaubt:   <a class="btn btn-sm primary rounded"><i class="fa fa-check-square"></i> </div></a>';
                                    
                                    }
                                    elseif($row["convoy_hct"] == 2){
                                    echo '<div class="dashtext-3">HCT-Trailer erlaubt: <a class="btn btn-sm danger rounded"><i class="fa fa-times"></i></div> </a>';
                                    print_r($row["convoy_absicherung"], true);
                                    }
                                    if($row["convoy_absicherung"] == 1){
                                    echo '<div class="dashtext-3">Absicherung:   <a class="btn btn-sm primary rounded"><i class="fa fa-check-square"></i> </div></a>';
                                    
                                    }
                                    elseif($row["convoy_absicherung"] == 2){
                                    echo '<div class="dashtext-3">Absicherung: <a class="btn btn-sm danger rounded"><i class="fa fa-times"></i></div> </a>';
                                  
                                    
                                    }
                                   }

I'm Getting This Error From A Pdo Connection

Similar Tutorials

View Content

Hi I have been following a youtube tutorial trying to update my php knowledge and they use pdo to create the DB wrapper class and once i load my index.php through WAMP server i get the following on screen error:

Quote

SQLSTATE[HY000] [1049] Unknown database 'lr'

THIS IS THE DB CLASS FILE,

<?php
class DB {
   private static $_instance = null;
   private $_pdo,
   $_query,
   $_error = false,
   $_results,
   $_count = 0;

   private function __construct() {
       try {
           $this->_pdo = new PDO('mysql:host=' . Config::get('mysql/host') . ';dbname=' . Config::get('mysql/db'), Config::get('mysql/username'), Config::get('mysql/password'));
       } catch(PDOException $e) {
           die($e->getMessage());
       }
   }

   public static function getInstance() {
       if(!isset(self::$_instance)) {
           self::$_instance = new DB();
       }
       return self::$_instance;
   }

   public function query($sql, $params = array()) {
       $this->_error = false;
       if($this->_query = $this->_pdo->prepare($sql)) {
           $x = 1;
           if(count($params)) {
               foreach($params as $param) {
                   $this-> _query->bindValue($x, $param);
                   $x++;
               }
           }

           if($this->_query->execute()) {
               $this->_results = $this->_query->fetchAll(PDO::FETCH_OBJ);
               $this->count = $this->_query->rowCount();
           } else {
               $this->_error = true;
           }
       }

       return $this;
   }

   public function action($action, $table, $where = array()) {
       if(count($where) === 3) {
           $operators = array('=', '>', '<', '>=', '<=');

           $field = $where[0];
           $operator = $where[1];
           $value = $where[2];

           if(in_array($operator, $operators)) {
               $sql = "{$action} FROM {$table} WHERE {$field} {$operator} ?'";

               if(!$this->query($sql,array($value))->error()) {
                   return $this;
               }
           }
       }
       return false;
   }

   public function get($table, $where) {
       return $this->action('SELECT *', $table, $where);
   }

   public function delete($table, $where) {
       return $this->action('DELETE', $table, $where);
   }

   public function insert($table, $fields = array()) {
       if(count($fields)) {
           $keys = array_keys($fields);
           $values = '';
           $x = 1;

           foreach($field as $field) {
               $values .= '?';
               if($x < count($fields)) {
                   $values .= ', ';
               }
               $x++;
           }

           $sql = "INSERT INTO users (`" . implode('`,`', $keys) . "`) VALUES ({$values})";

           if(!$this->query($sql, $fields)->error()) {
               return true;
           }
       }
       return false;
   }

   public function results() {
       return $this->_results;
   }

   public function first() {
       return $this->results()[0];
   }

   public function error() {
       return $this->_error;
   }

   public function count() {
       return $this->_count;
   }

}

THIS IS THE INIT.PHP FILE

<?php
session_start();

$GLOBALS['config'] = array (
   'mysql' => array(
       'host' => '127.0.0.1',
       'username' => 'root',
       'password' => '',
       'db' => 'lr'
   ),
   'remember' => array(
       'cookie_name' => 'hash',
       'cookie_expiry' => 604800
   ),
   'session' => array(
       'session_name' => 'user'
   )
);

spl_autoload_register(function ($class) {
require_once 'classes/' . $class . '.php';
});

require_once 'functions/sanitize.php';

and this is the index.php file

<?php
require_once 'core/init.php';

$user = DB::getInstance()->query("SELECT username FROM users WHERE username = ?", array('alex'));

   if(!$user->count()) {
       echo 'No user';
   } else {
       echo 'OK';
   }

Edited January 17, 2020 by Michael_Baxter

Php Mysqli Register Script Error

Similar Tutorials

View Content

Hi, I have taken the step of writing my site in MySQLi instead of MYSQL as advised. However, I had a script that I got off the internet, the original file works great and registers the user to the database. However the edited version of the script, where I have added more information such as the users address etc, no longer works. I have compared the two files and can't seem to find the problem. When the script is run, it skips all the registration part and jumps to the last error in the script saying 'You Could Not Be Registered Because Of Missing Data.'. All the variables match the column names in the database. Here is the original working script

<?php

error_reporting(E_ALL);
ini_set('display_errors', '1');

// some error checking
/*
if($_POST['reg']){
echo "form submitted";
}else{ echo "form not submitted"; }
*/

if( isset( $_POST['user'] ) && isset( $_POST['pass'] ) && isset( $_POST['email'] ) ){
    // echo $_POST['user']." - ".$_POST['pass']." - ".$_POST['email'];
     
    if( strlen( $_POST['user'] ) < 5 )
    {
        include('header.inc');
        echo "Username Must Be 5 or More Characters.";
        include('footer.inc');
    }
    elseif( strlen( $_POST['pass'] ) < 5 )
    {
        include('header.inc');
        echo "Password Must Be 5 or More Characters.";
        include('footer.inc');
    }
    elseif( $_POST['pass'] == $_POST['user'] )
    {
        include('header.inc');
        echo "Username And Password Can Not Be The Same.";
        include('footer.inc');
    }
  elseif( $_POST['email'] == "" )
    {
        //More secure to use a regular expression to check that the user is entering a valid email
        // versus just checking to see if the field is empty
        include('header.inc');
        echo "Email must be valid.";
        include('footer.inc');
    }
    else
    {
    	
        require( 'database.php' );

        $username = mysqli_real_escape_string($con, $_POST['user']);

        //Remove md5() function if not using encryption i.e. $password = $_POST['pass'];
        $password = mysqli_real_escape_string($con, md5( $_POST['pass']));

        $email = mysqli_real_escape_string($con, $_POST['email'] );

        $sqlCheckForDuplicate = "SELECT username FROM user WHERE username = '". $username ."'";
         //echo "$sqlCheckForDuplicate<br/>";

        $result = mysqli_query($con, $sqlCheckForDuplicate);

        if(mysqli_num_rows($result) == 0){
        	
        	//echo "No Duplicates<br/>";
        	
        	$sqlRegUser = "INSERT INTO user( username, password, email ) VALUES (
                        '". $username ."',
                        '". $password ."',
                        '". $email."'
                        )";
          //echo "$sqlRegUser<br/>";
          
        	if( !mysqli_query($con, $sqlRegUser ) )
            {
                include('header.inc');
                echo "You Could Not Register Because Of An Unexpected Error.";
                include('footer.inc');
            }
            
            else
            {
/* Note: When using the header function, you cannot send output to the browser
 * before the header function is called. IF you want to echo a message to the
 * user before going back to your login page then you should use the HTML
 * Meta Refresh tag. */

 //echo "You Are Registered And Can Now Login";
 //echo " $username";  //this is for error checking

   header ('location: login.php');

// if using echo then use meta refresh
/*
 *?>
 *<meta http-equiv="refresh" content="2;url= login.php/">
 *<? 
 */

            }
        mysqli_free_result($result);  
                    
        }	
        else
        {
            include('header.inc');
            echo "The Username You Have Chosen Is Already Being Used By Another User. Please Try Another One.";
            //echo " $username;"  //this is for error checking
            include('footer.inc');
        }
            /* close connection */
            mysqli_close($con);          	        
        }      
    }
else
{
    include('header.inc');
    echo "You Could Not Be Registered Because Of Missing Data.";
    include('footer.inc');
}
?>

and here is my version

<?php

error_reporting(E_ALL);
ini_set('display_errors', '1');

if( isset( $_POST['user'] ) && isset( $_POST['pass'] ) && isset( $_POST['pass_again'] ) && isset( $_POST['firstname'] ) && isset( $_POST['lastname'] ) && isset( $_POST['email'] ) && isset( $_POST['email_again'] )  && isset( $_POST['address1'] ) && isset( $_POST['address2'] ) && isset( $_POST['town'] ) && isset( $_POST['county'] ) && isset( $_POST['postcode'] ) && isset( $_POST['business'] ) && isset( $_POST['vat_registered'] ) && isset( $_POST['vat_number'] )) {
     
    if( strlen( $_POST['user'] ) < 5 )
    {
        include('includes/overall/header.php');
        echo "Username Must Be 5 or More Characters.";
        include('includes/overall/footer.php');
    }
    elseif( strlen( $_POST['pass'] ) < 5 )
    {
        include('includes/overall/header.php');
        echo "Password Must Be 5 or More Characters.";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['pass'] == $_POST['user'] )
    {
        include('includes/overall/header.php');
        echo "Username And Password Can Not Be The Same.";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['pass_again'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "Passwords must match";
        include('includes/overall/footer.php');
    }
    
// CREATE  BETTER EMAIL CHECK

  elseif( $_POST['email'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "Email must be valid.";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['email_again'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "Emails must match.";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['address_1'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "Address cannot be empty";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['address_2'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "Address cannot be empty";
        include('includes/overall/footer.php');
    }
     elseif( $_POST['town'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "Town cannot be empty";
        include('includes/overall/footer.php');
    }
     elseif( $_POST['county'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "County cannot be empty";
        include('includes/overall/footer.php');
    }
     elseif( $_POST['postcode'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "Postcode cannot be empty";
        include('includes/overall/footer.php');
    }
     elseif( $_POST['business'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "Business cannot be empty";
        include('includes/overall/footer.php');
    }
     elseif( $_POST['vat_registered'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "VAT Registered cannot be empty";
        include('includes/overall/footer.php');
    }
     elseif( $_POST['vat_number'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "VAT number cannot be empty, please enter N/A if not VAT registered.";
        include('includes/overall/footer.php');
    }
    else
    {
    	
        require( 'database.php' );

        $username = mysqli_real_escape_string($con, $_POST['user']);
        

        //Remove md5() function if not using encryption i.e. $password = $_POST['pass'];
        $password = mysqli_real_escape_string($con, md5( $_POST['pass']));
        $password_again = mysqli_real_escape_string($con, md5( $_POST['pass_again']));
		
        $firstname = mysqli_real_escape_string($con, $_POST['firstname']);
        $lastname = mysqli_real_escape_string($con, $_POST['lastname']);
        
        $email = mysqli_real_escape_string($con, $_POST['email'] );
		$email_again = mysqli_real_escape_string($con, $_POST['email_again']);
		
        $address_1 = mysqli_real_escape_string($con, $_POST['address_1']);
        $address_2 = mysqli_real_escape_string($con, $_POST['address_2']);
        $town = mysqli_real_escape_string($con, $_POST['town']);
        $county = mysqli_real_escape_string($con, $_POST['county']);
        $postcode = mysqli_real_escape_string($con, $_POST['postcode']);
        $business = mysqli_real_escape_string($con, $_POST['business']);
        $vat_registered = mysqli_real_escape_string($con, $_POST['vat_registered']);
        $vat_number = mysqli_real_escape_string($con, $_POST['vat_number']);
                        
        $sqlCheckForDuplicate = "SELECT username FROM user WHERE username = '". $username ."'";
         //echo "$sqlCheckForDuplicate<br/>";

        $result = mysqli_query($con, $sqlCheckForDuplicate);

        if(mysqli_num_rows($result) == 0){
        	
        	//echo "No Duplicates<br/>";
        	
        	$sqlRegUser = "INSERT INTO user( username, password, password_again, firstname, lastname, email, email_again, address_1, address_2, town, county, postcode, business, vat_registered, vat_number ) VALUES (
                        '". $username ."',
                        '". $password ."',
                        '". $password_again ."',
                        '". $firstname ."',
                        '". $lastname ."',
                        '". $email ."',
                        '". $email_again ."',
                        '". $address_1 ."',
                        '". $address_2 ."',
                        '". $town ."',
                        '". $county ."',
                        '". $postcode ."',
                        '". $business ."',
                        '". $vat_registered ."',
                        '". $vat_number."'
                        )";
          //echo "$sqlRegUser<br/>";
          
        	if( !mysqli_query($con, $sqlRegUser ) )
            {
                include('includes/overall/header.php');
                echo "You Could Not Register Because Of An Unexpected Error.";
                include('includes/overall/footer.php');
            }
            
            else
            {

   header ('location: login.php');


 

            }
        mysqli_free_result($result);  
                    
        }	
        else
        {
            include('includes/overall/header.php');
            echo "The Username You Have Chosen Is Already Being Used By Another User. Please Try Another One.";
            //echo " $username;"  //this is for error checking
            include('includes/overall/footer.php');
        }
            /* close connection */
            mysqli_close($con);          	        
        }      
    }
else
{
    include('includes/overall/header.php');
    echo "You Could Not Be Registered Because Of Missing Data.";
    include('includes/overall/footer.php');
}

?>

Error reporting is switched on, I just cant see the problem. Any help is much appreciated :)

Having Trouble Debugging A Mysqli Error

Similar Tutorials

View Content

Hey all,
I'm having some trouble running some mysql statements through mysqli. I've tried to debug them various ways, but to no avail. This is the offending code:
class DBOPS {
protected $config, $mysqli;

public function __construct () {
$this->config = array (...snip...);
$this->mysqli = new mysqli ($this->config['server'], $this->config['username'], $this->config['password'], $this->config['database']);
session_start();
}

public function Login ($username, $password) {
$toreturn = NULL;

//Problem area is from here...

$encryptedpassword = hash(...snip...);

print_r(array(
$this->config['usertable']['username'],
$username,
$this->config['usertable']['password'],
$encryptedpassword));

$statement = $this->mysqli->stmt_init();
$statement->prepare('SELECT * FROM users WHERE ? = ? AND ? = ?');
$statement->bind_param(
'ssss',
$this->config['usertable']['username'],
$username,
$this->config['usertable']['password'],
$encryptedpassword);

$statement->execute();

print_r($statement->affected_rows);

//To here.

if ($statement->affected_rows == 1) {
$_SESSION[$this->config['sessiondata']['username']] = $username;
$_SESSION[$this->config['sessiondata']['lastactivity']] = time();

$toreturn = TRUE;
} else {
$toreturn = FALSE;
}

$statement->close();

return $toreturn;
}

The print_r($statement->affected_rows); statement always returns -1, which means a query error. Is there a problem with the syntax of the predefined query in $statement->prepare('SELECT * FROM users WHERE ? = ? AND ? = ?') ? I really can't seem to find the problem in this code. There are no errors returned. The output from the print_r() statements are
Code: [Select]
Array ( [0] => Name [1] => Trey [2] => Password [3] => ...snip... )from the first print_r and
Code: [Select]
-1from the second.

And lastly, I know that DIY login systems are generally discouraged, but this is more of a research project. I would greatly appreciate any help with this.

Thanks.

Database Connection Error

Similar Tutorials

View Content

I get the following error when trying to connect

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '72.18.129.104' (10061) in C:\Domains\crysvis.com\wwwroot\include\dbConnectAndSelect.php on line 8

Here's the code

$host = "72.18.129.104";
$user = "deltron";
$pass = "masterconn";
$db = "customers";

$conn = mysql_connect("$host","$user","$pass");
if(!$conn)
errorHandler("Msg 10:\nCould not connect to database with $host,$user,$pass in ". $_SERVER["PHP_SELF"]."\nCustId = $CustId\nmysql_error() =
".mysql_error());

if(!mysql_select_db("$db",$conn))
errorHandler("Msg 11:\nCould not select db=$db in ". $_SERVER["PHP_SELF"]."\nCustId=$CustId\nmysql_error() = ".mysql_error());
?>

What am I doing wrong?

Any help will be appreciated

Mysqli Prepared Update Syntax Error

Similar Tutorials

View Content

<?php

//COOKIE CHECKER
if (isset($_COOKIE["person"])){

if (filter_var($_COOKIE["person"], FILTER_VALIDATE_INT)){
$user_id = $_COOKIE["person"];

//DATABASE CONNECTION VARIABLES
$myserver ="localhost";
$myname = "username";
$mypassword = "password";
$mydb ="dbname";

/*SQL CONNECTION*/
// Create connection
$conn = new mysqli($myserver, $myname, $mypassword, $mydb);

// Check connection
if ($conn->connect_error) {
echo '<!DOCTYPE HTML>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BODY>
<H1>Decline of the Han - Three Kingdoms</H1>';
die("Connection failed: " . $conn->connect_error);
echo '</BODY>
</HTML>';
}
else {

//COUNT USER
$cquery = "SELECT COUNT(*) AS usercheck FROM Players WHERE ID = ?";
$cid = $conn->prepare($cquery);
$cid->bind_param('i', $user_id);
$cid->execute();
$cid->bind_result($usercheck);
$cid->fetch();

if ($usercheck ==1){

if (isset($_POST["profile"])){

if(!filter_var($_POST["profile"], FILTER_SANITIZE_STRING)){
echo '<!DOCTYPE HTML>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BODY>';
echo '<P class="error">Unable to filter bio <a href="biography.php">return</a></P>';
echo '</BODY>
</HTML>';
}
else {

$profile = $_POST["profile"];

$sql = "UPDATE Player_Data SET Bio =? WHERE ID=?";
$q = $conn->prepare($sql);
$q->bind_param("si", $profile, $user_id);
$q->execute();

echo '<P>Biography altered <a href="biography.php">return</a></P>';

//close connection
$conn->close();

}

}

}
else {
echo '<!DOCTYPE HTML>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BODY>';
echo '<P class="error">'.$usercheck.' '.$user_id.'</P>';
echo '<P class="error">No such user found!</P>';
//close connection
$conn->close();
//foot
echo '</BODY>
</HTML>';
}

//end connection check
}

}
else {
echo '<!DOCTYPE HTML>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BODY>';
echo '<P class="error">ERROR invalid cookie!</P>';
echo '</BODY>
</HTML>';
}

}
else {
echo '<!DOCTYPE HTML>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BODY>';
echo '<P class="error">No cookie detected!<br><a href="login.php">login</a></P>';
echo '</BODY>
</HTML>';
}

?>

I have an error in the update, but I am not seeing where I made it. Its annoying because the update won't execute and anything beyond the update isn't visible in the html source code in the browser, so it is likely to be a syntax error, but where?

Mysqli Prepared Update Syntax Error

Similar Tutorials

View Content

<?php

//COOKIE CHECKER
if (isset($_COOKIE["person"])){

if (filter_var($_COOKIE["person"], FILTER_VALIDATE_INT)){
$user_id = $_COOKIE["person"];

//DATABASE CONNECTION VARIABLES
$myserver ="localhost";
$myname = "username";
$mypassword = "password";
$mydb ="dbname";

/*SQL CONNECTION*/
// Create connection
$conn = new mysqli($myserver, $myname, $mypassword, $mydb);

// Check connection
if ($conn->connect_error) {
echo '<!DOCTYPE HTML>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BODY>
<H1>Decline of the Han - Three Kingdoms</H1>';
die("Connection failed: " . $conn->connect_error);
echo '</BODY>
</HTML>';
}
else {

//COUNT USER
$cquery = "SELECT COUNT(*) AS usercheck FROM Players WHERE ID = ?";
$cid = $conn->prepare($cquery);
$cid->bind_param('i', $user_id);
$cid->execute();
$cid->bind_result($usercheck);
$cid->fetch();

if ($usercheck ==1){

if (isset($_POST["profile"])){

if(!filter_var($_POST["profile"], FILTER_SANITIZE_STRING)){
echo '<!DOCTYPE HTML>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BODY>';
echo '<P class="error">Unable to filter bio <a href="biography.php">return</a></P>';
echo '</BODY>
</HTML>';
}
else {

$profile = $_POST["profile"];

$sql = "UPDATE Player_Data SET Bio =? WHERE ID=?";
$q = $conn->prepare($sql);
$q->bind_param("si", $profile, $user_id);
$q->execute();

echo '<P>Biography altered <a href="biography.php">return</a></P>';

//close connection
$conn->close();

}

}

}
else {
echo '<!DOCTYPE HTML>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BODY>';
echo '<P class="error">'.$usercheck.' '.$user_id.'</P>';
echo '<P class="error">No such user found!</P>';
//close connection
$conn->close();
//foot
echo '</BODY>
</HTML>';
}

//end connection check
}

}
else {
echo '<!DOCTYPE HTML>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BODY>';
echo '<P class="error">ERROR invalid cookie!</P>';
echo '</BODY>
</HTML>';
}

}
else {
echo '<!DOCTYPE HTML>
<HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BODY>';
echo '<P class="error">No cookie detected!<br><a href="login.php">login</a></P>';
echo '</BODY>
</HTML>';
}

?>

Mysql_query Syntax Error Database Connection

Similar Tutorials

View Content

Mysqli Error 1062 (dealing With Multiple Duplicate Key Entries)

Similar Tutorials

View Content

MySQL returns an error in the form of a number, a state, and a message. Without parsing the message you will not be able to determine what column is duplicated.While parsing the error code, I have also notice that, if you have multiple unique fields as duplicates, only the first duplicate encountered will be returned in the message. This is not very helpful to the end user. Is there any way to parse the returned error code to reflect all duplicate fields, please see sample code below?

$error=array();
$sql = 'INSERT INTO staff(username, email, phone)
VALUES (?, ?, ?)';
$stmt = $conn->stmt_init();
$stmt = $conn->prepare($sql);
// bind parameters and insert the details into the database
$stmt->bind_param('sss', $username, $email, $phone);
$stmt->execute();
if ($stmt->errno == 1062) {
$errors[] = "One of the fields is already in use.";
}

Https Shopping Cart And Connection Interrupted Error

Similar Tutorials

View Content

OK, so as I mentioned in my earlier thread, that problem has been solved. So I've been going around the test site our new host has set up and determining if everything is in working order. A lot of it is, except I have now found a new problem.

If I were to try and buy a product, I put it in the cart, then select Check Out, which goes to an HTTPS page called cart_checkout.php. Only instead of actually going to that page, it stops and gives me a Connection Interrupted error through Firefox. This is consistent no matter what's in the cart, even nothing. I Googled a bit to see if anyone else had a similar problem, and I did find something about someone having problems with Zen Cart (which we're not using). He had the same problem, and someone suggested that the solution is to basically turn off HTTPS. I don't think that that is what I want to do, because the cart is supposed to be secure, and simply turning it off so it will work doesn't seem like the safest thing to do.

Is there perhaps something else that can be done in this case?

Strange <pre> Format Error

Similar Tutorials

View Content

Im creating a function for executing a system command. The idea is to show the command return. I use pre to show it, so i created a general function iPre that echos a string with that tag.

The problem is that this code dont work.

function compComando($com) {

return escapeshellcmd($com);
}

function ejecComando($com) {

$return = passthru(compComando($com));

if ($return) {

return $return;

}

else {

pe();

}
}

function iPre($txt) {

echo '<pre>';

echo $txt;

echo '</pre>';
}

iPre(ejecComando('dir C:'));

But if i call this simple code it works. Why?

echo '<pre>';
echo ejecComando('dir C:');
echo '</pre>';

Here its shown well formatted, in the other no. I suppose thats something relating passing the string to the function...?

Date_create - Fatal Error: Call To A Member Function Format() On A Non-object In

Similar Tutorials

View Content

Hey guys,

I have spent the last 36 hours trying to figure this out.

I keep getting the following error:

Fatal error: Call to a member function format() on a non-object in /var/www/vhosts/xxxxx.com/httpdocs/admin/defaults.php on line 51

The reason I am not using the standard date and strtotime functions is because some of my dates exceed 2038.

What I have done is created an array with price and days from today within the array.

You can see below where I am trying to get the timestamp for 14000 days from today. I then turn that into a date using the newdate function.

I can see that this actually works on other pages on my server, I just can't figure out why it won't work here. BTW, I am using php 5.2.3.

$csv .= "Payment,".newdate("m/d/Y",newstrtotime("+".$periodic[0][0]." days")).",".$row['amount'].",".count($periodic).",".$row['frequency'].",".newdate("m/d/Y",newstrtotime("+".$periodic[$perCt][0]." days"))."\n";
function newstrtotime($strtotime){
$datetime = date_create($strtotime);
return $datetime->format("U");
}
function newdate($format,$timestamp){
$datetime = date_create("@$timestamp");
return $datetime->format($format);
}

Let me know what you think.