PHP

php very useful mysql connect function for small project

November 14, 2013 Ning MYSQL, PHP, 0

This class is very useful for small projects, it easy and fast to connect mysql with php script. Thank you Ciprian Mocanu to provide this document. The Class:

<?php
class mysql {
	var $con;
	function __construct($db=array()) {
		$default = array(
			'host' => 'localhost',
			'user' => 'root',
			'pass' => '',
			'db' => 'test'
		);
		$db = array_merge($default,$db);
		$this->con=mysql_connect($db['host'],$db['user'],$db['pass'],true) or die ('Error connecting to MySQL');
		mysql_select_db($db['db'],$this->con) or die('Database '.$db['db'].' does not exist!');
	}
	function __destruct() {
		mysql_close($this->con);
	}
	function query($s='',$rows=false,$organize=true) {
		if (!$q=mysql_query($s,$this->con)) return false;
		if ($rows!==false) $rows = intval($rows);
		$rez=array(); $count=0;
		$type = $organize ? MYSQL_NUM : MYSQL_ASSOC;
		while (($rows===false || $count<$rows) && $line=mysql_fetch_array($q,$type)) {
			if ($organize) {
				foreach ($line as $field_id => $value) {
					$table = mysql_field_table($q, $field_id);
					if ($table==='') $table=0;
					$field = mysql_field_name($q,$field_id);
					$rez[$count][$table][$field]=$value;
				}
			} else {
				$rez[$count] = $line;
			}
			++$count;
		}
		if (!mysql_free_result($q)) return false;
		return $rez;
	}
	function execute($s='') {
		if (mysql_query($s,$this->con)) return true;
		return false;
	}
	function select($options) {
		$default = array (
			'table' => '',
			'fields' => '*',
			'condition' => '1',
			'order' => '1',
			'limit' => 50
		);
		$options = array_merge($default,$options);
		$sql = "SELECT {$options['fields']} FROM {$options['table']} WHERE {$options['condition']} ORDER BY {$options['order']} LIMIT {$options['limit']}";
		return $this->query($sql);
	}
	function row($options) {
		$default = array (
			'table' => '',
			'fields' => '*',
			'condition' => '1',
			'order' => '1'
		);
		$options = array_merge($default,$options);
		$sql = "SELECT {$options['fields']} FROM {$options['table']} WHERE {$options['condition']} ORDER BY {$options['order']}";
		$result = $this->query($sql,1,false);
		if (empty($result[0])) return false;
		return $result[0];
	}
	function get($table=null,$field=null,$conditions='1') {
		if ($table===null || $field===null) return false;
		$result=$this->row(array(
			'table' => $table,
			'condition' => $conditions,
			'fields' => $field
		));
		if (empty($result[$field])) return false;
		return $result[$field];
	}
	function update($table=null,$array_of_values=array(),$conditions='FALSE') {
		if ($table===null || empty($array_of_values)) return false;
		$what_to_set = array();
		foreach ($array_of_values as $field => $value) {
			if (is_array($value) && !empty($value[0])) $what_to_set[]="`$field`='{$value[0]}'";
			else $what_to_set []= "`$field`='".mysql_real_escape_string($value,$this->con)."'";
		}
		$what_to_set_string = implode(',',$what_to_set);
		return $this->execute("UPDATE $table SET $what_to_set_string WHERE $conditions");
	}
	function insert($table=null,$array_of_values=array()) {
		if ($table===null || empty($array_of_values) || !is_array($array_of_values)) return false;
		$fields=array(); $values=array();
		foreach ($array_of_values as $id => $value) {
			$fields[]=$id;
			if (is_array($value) && !empty($value[0])) $values[]=$value[0];
			else $values[]="'".mysql_real_escape_string($value,$this->con)."'";
		}
		$s = "INSERT INTO $table (".implode(',',$fields).') VALUES ('.implode(',',$values).')';
		if (mysql_query($s,$this->con)) return mysql_insert_id($this->con);
		return false;
	}
	function delete($table=null,$conditions='FALSE') {
		if ($table===null) return false;
		return $this->execute("DELETE FROM $table WHERE $conditions");
	}
}

100

101

102

103

104

<?php

class mysql {

var $con;

function __construct($db=array()) {

$default = array(

'host' => 'localhost',

'user' => 'root',

'pass' => '',

'db' => 'test'

);

$db = array_merge($default,$db);

$this->con=mysql_connect($db['host'],$db['user'],$db['pass'],true) or die ('Error connecting to MySQL');

mysql_select_db($db['db'],$this->con) or die('Database '.$db['db'].' does not exist!');

}

function __destruct() {

mysql_close($this->con);

}

function query($s='',$rows=false,$organize=true) {

if (!$q=mysql_query($s,$this->con)) return false;

if ($rows!==false) $rows = intval($rows);

$rez=array(); $count=0;

$type = $organize ? MYSQL_NUM : MYSQL_ASSOC;

while (($rows===false || $count<$rows) && $line=mysql_fetch_array($q,$type)) {

if ($organize) {

foreach ($line as $field_id => $value) {

$table = mysql_field_table($q, $field_id);

if ($table==='') $table=0;

$field = mysql_field_name($q,$field_id);

$rez[$count][$table][$field]=$value;

}

} else {

$rez[$count] = $line;

}

++$count;

}

if (!mysql_free_result($q)) return false;

return $rez;

}

function execute($s='') {

if (mysql_query($s,$this->con)) return true;

return false;

}

function select($options) {

$default = array (

'table' => '',

'fields' => '*',

'condition' => '1',

'order' => '1',

'limit' => 50

);

$options = array_merge($default,$options);

$sql = "SELECT {$options['fields']} FROM {$options['table']} WHERE {$options['condition']} ORDER BY {$options['order']} LIMIT {$options['limit']}";

return $this->query($sql);

}

function row($options) {

$default = array (

'table' => '',

'fields' => '*',

'condition' => '1',

'order' => '1'

);

$options = array_merge($default,$options);

$sql = "SELECT {$options['fields']} FROM {$options['table']} WHERE {$options['condition']} ORDER BY {$options['order']}";

$result = $this->query($sql,1,false);

if (empty($result[0])) return false;

return $result[0];

}

function get($table=null,$field=null,$conditions='1') {

if ($table===null || $field===null) return false;

$result=$this->row(array(

'table' => $table,

'condition' => $conditions,

'fields' => $field

));

if (empty($result[$field])) return false;

return $result[$field];

}

function update($table=null,$array_of_values=array(),$conditions='FALSE') {

if ($table===null || empty($array_of_values)) return false;

$what_to_set = array();

foreach ($array_of_values as $field => $value) {

if (is_array($value) && !empty($value[0])) $what_to_set[]="`$field`='{$value[0]}'";

else $what_to_set []= "`$field`='".mysql_real_escape_string($value,$this->con)."'";

}

$what_to_set_string = implode(',',$what_to_set);

return $this->execute("UPDATE $table SET $what_to_set_string WHERE $conditions");

}

function insert($table=null,$array_of_values=array()) {

if ($table===null || empty($array_of_values) || !is_array($array_of_values)) return false;

$fields=array(); $values=array();

foreach ($array_of_values as $id => $value) {

$fields[]=$id;

if (is_array($value) && !empty($value[0])) $values[]=$value[0];

else $values[]="'".mysql_real_escape_string($value,$this->con)."'";

}

$s = "INSERT INTO $table (".implode(',',$fields).') VALUES ('.implode(',',$values).')';

if (mysql_query($s,$this->con)) return mysql_insert_id($this->con);

return false;

}

function delete($table=null,$conditions='FALSE') {

if ($table===null) return false;

return $this->execute("DELETE FROM $table WHERE $conditions");

}

Example usage:

$connection_information = array(
	'host' => 'localhost',
	'user' => 'root',
	'pass' => '',
	'db' => 'test'
);
$m = new mysql($connection_information);
 
//simple and complex query (I recommend you use the select method of the class rather than this)
$result = $m->query('SELECT * FROM `users`');
var_dump($result);
//this will output an array like this: $array[$count][$table][$field]
 
//simple execute command (I recommend using the delete and the insert and the update methods of the class)
$result = $m->execute('DELETE FROM `pages` WHERE `id`=5');
var_dump($result); //returns true if ok and false if not
 
//method to select (clean and beautiful)
$result = $m->select(array(
	'table' => 'users',
	'condition' => 'active=1 AND type=1'
));
var_dump($result);
// Will output something like this:
/*
array (3) {
	[0] => array (1) {
		['users'] => array (4) {
			['id'] => int (5),
			['name'] => string (7) "ciprian",
			['active'] => int (1),
			['type'] => int (1),
			['email'] => string (14) "ciprian@mbe.ro"
		}
	},
	[1] => ...
}
*/
 
//you can also get only one row (and a simple array like this $array[$table_field])
$result = $m->row(array(
	'table' => 'users',
	'condition' => 'active=1 AND type=1'
));
var_dump($m); //returns only the first row in an array arranged like this $array[$table_field]
 
//or you can get only a field (for example you need the name of the user with id = 5)
$name=$m->get('users','name','id=5');
var_dump($name);
// Will output something like this:
/*
string (7) "ciprian"
*/
 
//you can also insert into the table
$data = array(
	'name' => 'ion',
	'active' => 0,
	'email' => 'ion@mbe.ro'
);
$result = $m->insert('users',$data);
var_dump($result); //returns true if ok and false if not
 
//update the table (let's assume we have a pages table and we need to set the views of the page with + 1
$data = array(
	'views' => array( 'views+1' )
);
$result = $m->update('pages',$data,'id='.$current_page_id);
var_dump($result); //returns true if ok and false if not
//PS: Notice I put the value of the views in another array. You can do that in the update as well as in the insert. If you put it like that, no mysql_real_escape_string will be called for that value when updating / inserting.
 
//deletion is also possible
$result = $m->delete('pages','id=5'); //deletes page with id 5
var_dump($result); //returns true if ok and false if not

$connection_information = array(

'host' => 'localhost',

'user' => 'root',

'pass' => '',

'db' => 'test'

);

$m = new mysql($connection_information);

//simple and complex query (I recommend you use the select method of the class rather than this)

$result = $m->query('SELECT * FROM `users`');

var_dump($result);

//this will output an array like this: $array[$count][$table][$field]

//simple execute command (I recommend using the delete and the insert and the update methods of the class)

$result = $m->execute('DELETE FROM `pages` WHERE `id`=5');

var_dump($result); //returns true if ok and false if not

//method to select (clean and beautiful)

$result = $m->select(array(

'table' => 'users',

'condition' => 'active=1 AND type=1'

));

var_dump($result);

// Will output something like this:

array (3) {

[0] => array (1) {

['users'] => array (4) {

['id'] => int (5),

['name'] => string (7) "ciprian",

['active'] => int (1),

['type'] => int (1),

['email'] => string (14) "ciprian@mbe.ro"

}

[1] => ...

}

//you can also get only one row (and a simple array like this $array[$table_field])

$result = $m->row(array(

'table' => 'users',

'condition' => 'active=1 AND type=1'

));

var_dump($m); //returns only the first row in an array arranged like this $array[$table_field]

//or you can get only a field (for example you need the name of the user with id = 5)

$name=$m->get('users','name','id=5');

var_dump($name);

// Will output something like this:

string (7) "ciprian"

//you can also insert into the table

$data = array(

'name' => 'ion',

'active' => 0,

'email' => 'ion@mbe.ro'

);

$result = $m->insert('users',$data);

var_dump($result); //returns true if ok and false if not

//update the table (let's assume we have a pages table and we need to set the views of the page with + 1

$data = array(

'views' => array( 'views+1' )

);

$result = $m->update('pages',$data,'id='.$current_page_id);

var_dump($result); //returns true if ok and false if not

//PS: Notice I put the value of the views in another array. You can do that in the update as well as in the insert. If you put it like that, no mysql_real_escape_string will be called for that value when updating / inserting.

//deletion is also possible

$result = $m->delete('pages','id=5'); //deletes page with id 5

var_dump($result); //returns true if ok and false if not

Replace Magento blocks, models, helpers and controllers without modify core files

October 25, 2013 Ning PHP, 0

There is no project that uses framework as is. Every now and then there is a need to change something, to add something new or to override something already written. Due to many reasons it’s a bad habit and bad programming if core files are modified and it’s not recommended at all. Therefore Magento brought […]

How to extend Magento core controller?

October 25, 2013 Ning PHP, 0

Hi, today I’ll show you how to edit Magento’s core module without messing with core files themselves, or “the right way of doing things”. First of all, I chose Magento’s Customer module and its Account controller as an example. First, you need to find it in Magento’s Core folder (full path: “app/code/core/Mage/Customer/controllers/AccountController.php“). First step is […]

Good example to security ajax call

October 9, 2013 Ning AJAX, JAVASCRIPT, PHP, 0

Step-1 : Generate Token System For All Web-Service: Generating Token :

<?php
  session_start();
  $token = md5(rand(1000,9999)); //you can use any encryption
  $_SESSION['token'] = $token; //store it as session variable
?>

<?php

session_start();

$token = md5(rand(1000,9999)); //you can use any encryption

$_SESSION['token'] = $token; //store it as session variable

Step-2 : Use it while sending ajax call:

var form_data = {
  data: $("#data").val(), //your data being sent with ajax
  token:'<?php echo $token; ?>', //used token here.
  is_ajax: 1
};

$.ajax({
  type: "POST",
  url: 'yourajax_url_here',
  data: form_data,
  success: function(response)
  {
    //do further
  }
});

var form_data = {

data: $("#data").val(), //your data being sent with ajax

token:'<?php echo $token; ?>', //used token here.

is_ajax: 1

};

$.ajax({

type: "POST",

url: 'yourajax_url_here',

data: form_data,

success: function(response)

{

//do further

}

});

Step-3 : NOW, Let’s secure ajax handler PHP file with,

session_start(); //most of people forget this while copy pasting code ;)
if($_SERVER['HTTP_X_REQUESTED_WITH'] == 'XMLHttpRequest') {
  //Request identified as ajax request

  if(@isset($_SERVER['HTTP_REFERER']) && $_SERVER['HTTP_REFERER']=="http://yourdomain/ajaxurl")
  {
   //HTTP_REFERER verification
    if($_POST['token'] == $_SESSION['token']) {
      //do your ajax task
      //don't forget to use sql injection prevention here.
    }
    else {
      header('Location: http://yourdomain.com');
    }
  }
  else {
    header('Location: http://yourdomain.com');
  }
}
else {
  header('Location: http://yourdomain.com');
}

session_start(); //most of people forget this while copy pasting code ;)

if($_SERVER['HTTP_X_REQUESTED_WITH'] == 'XMLHttpRequest') {

//Request identified as ajax request

if(@isset($_SERVER['HTTP_REFERER']) && $_SERVER['HTTP_REFERER']=="http://yourdomain/ajaxurl")

{

//HTTP_REFERER verification

if($_POST['token'] == $_SESSION['token']) {

//do your ajax task

//don't forget to use sql injection prevention here.

}

else {

header('Location: http://yourdomain.com');

}

else {

header('Location: http://yourdomain.com');

}

else {

header('Location: http://yourdomain.com');

}

Magento how to include a custom phtml

September 27, 2013 Ning PHP, 0

folder/template../sample.phtml

<?php echo $this->getChildHtml('shipping'); ?>

1	<?php echo $this->getChildHtml('shipping'); ?>

create a folder “sample” create a include phtml file shipping.phtml folder/template../sample/shipping.phtml

Magento get shopping cart products

September 4, 2013 Ning PHP, 5

Mage::getSingleton('checkout/session')->getQuote()->getAllVisibleItems();

1	Mage::getSingleton('checkout/session')->getQuote()->getAllVisibleItems();

Magento add a new product from costom module

September 4, 2013 Ning PHP, 1

Hers is sample code:

$new_product    = Mage::getModel('catalog/product');

	$new_product->setWebsiteIds(array(1));
	$new_product->setSku('lu-'.$product['sku']);
	$new_product->setPrice((($product['price'])*$e_rate));
	$new_product->setCategoryIds(array(1152));
	$new_product->setAttributeSetId(4); 
	$new_product->setVisibility(1);             
	$new_product->setType('Simple Product');
	$new_product->setName($product['name']);
	$new_product->setDescription('');
	$new_product->setShortDescription('');
	$new_product->setStatus(2); 
	$new_product->setTaxClassId(2);
	$new_product->setWeight(0);             
	$new_product->setCreatedAt(strtotime('now'));                   


// call save() method to save your product with updated data
$new_product->save();

$new_product = Mage::getModel('catalog/product');

$new_product->setWebsiteIds(array(1));

$new_product->setSku('lu-'.$product['sku']);

$new_product->setPrice((($product['price'])*$e_rate));

$new_product->setCategoryIds(array(1152));

$new_product->setAttributeSetId(4);

$new_product->setVisibility(1);

$new_product->setType('Simple Product');

$new_product->setName($product['name']);

$new_product->setDescription('');

$new_product->setShortDescription('');

$new_product->setStatus(2);

$new_product->setTaxClassId(2);

$new_product->setWeight(0);

$new_product->setCreatedAt(strtotime('now'));

// call save() method to save your product with updated data

$new_product->save();

php quick debug code by error log

August 30, 2013 Ning LINUX, PHP, 0

error_log(print_r($variable, TRUE));

1	error_log(print_r($variable, TRUE));

Magento: Difference between Mage::getSingleton() and Mage::getModel() in Magento

August 19, 2013 Ning PHP, 0

Some people ask about the difference between Mage::getModel() and Mage::getSingleton() in Magento. Here is the difference between these two: Mage::getModel(‘module/model’) will create a new instance of the model object (if such object exists in configuration) So if we write: Mage::getModel(‘catalog/product’), it will create new instance of the object product each time. So, $p1 = Mage::getModel(‘catalog/product’); […]

Magento form validation front/end

August 14, 2013 Ning JAVASCRIPT, LINUX, PHP, 1

Here is an example:

var signupForm = new Validation(\’form-validate\’);
var result = signupForm.validate();
if(result == true) {
$(\’#form-validate\’).submit();
return true;
}
else
return false;

var signupForm = new Validation(\’form-validate\’);

var result = signupForm.validate();

if(result == true) {

$(\’#form-validate\’).submit();

return true;

}

else

return false;

another one

 var signupForm = new VarienForm('signupForm', true);
if (signupForm.validator && signupForm.validator.validate()) {
alert('yes');
} else {
alert('oh no!');
}

var signupForm = new VarienForm('signupForm', true);

if (signupForm.validator && signupForm.validator.validate()) {

alert('yes');

} else {

alert('oh no!');

}

For the backend, we can use zend validator http://files.zend.com/help/Zend-Framework/zend.validate.html#zend.validate.introduction.using

PHP

php very useful mysql connect function for small project

Replace Magento blocks, models, helpers and controllers without modify core files

How to extend Magento core controller?

Good example to security ajax call

Magento how to include a custom phtml

Magento get shopping cart products

Magento add a new product from costom module

php quick debug code by error log

Magento: Difference between Mage::getSingleton() and Mage::getModel() in Magento

Magento form validation front/end

Categories

Tags

LINKS

Meta