PHP
php very useful mysql connect function for small project
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:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 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:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 |
$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
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?
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
Step-1 : Generate Token System For All Web-Service: Generating Token :
|
1 2 3 4 5 |
<?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:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
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,
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
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
folder/template../sample.phtml
|
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
|
1 |
Mage::getSingleton('checkout/session')->getQuote()->getAllVisibleItems(); |
Magento add a new product from costom module
Hers is sample code:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
$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(); |
Magento: Difference between Mage::getSingleton() and Mage::getModel() in Magento
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
Here is an example:
|
1 2 3 4 5 6 7 8 |
var signupForm = new Validation(\’form-validate\’);
var result = signupForm.validate();
if(result == true) {
$(\’#form-validate\’).submit();
return true;
}
else
return false; |
another one
|
1 2 3 4 5 6 |
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