Insert Update Delete using PHP and mysql for Frontaccounting – crud

Insert Update Delete using PHP and mysql for Frontaccounting – crud

Insert Update Delete using PHP and mysql for Frontaccounting – crud

In this Post We Will Explain About is Insert Update Delete using PHP and mysql for Frontaccounting – crud With Example and Demo.Welcome on Pakainfo.com – Examples, The best For Learn web development Tutorials,Demo with Example! Hi Dear Friends here u can know to how to insert update delete record using php and mysql with frontaccountingExample

In this post we will show you Best way to implement php mysql add edit delete same page using frontaccounting, hear for frontaccounting Select Insert Update Delete In Php MySQL Examplewith Download .we will give you demo,Source Code and examples for implement Step By Step Good Luck!.

Read Also:  SQL Remove Numeric Characters in String

Insert function :

function live_stock($custom_table_name, $data_res){
    $sql_query = "INSERT INTO ".TB_PREF.$custom_table_name."(";
    $sql_query = " VALUES (";
    foreach($data_res as $key=>$value){
        $sql_query .= $key.",";
		if(is_array($value)) { 
			if($value[1] == 'date')				
				$sql_query .=  db_escape(date2sql($value[0])).",";
			if($value[1] == 'float')
				$sql_query .= $value.",";
		}else 
			$sql_query .= db_escape($value).",";
    }
    $sql_query = substr($sql_query, 0, -1).")";
    $sql_query = substr($sql_query, 0, -1).")";
    db_query($sql_query.$sql_query, "Could not insert data_res to table {$custom_table_name}");
	return  db_insert_id();
}

Update Functions

function live_update($custom_table_name, $primary_key ,$data_res ){
    $sql_query = "UPDATE ".TB_PREF.$custom_table_name." SET ";
    foreach($data_res as $key=>$value){
		if(is_array($value)) { 
			if($value[1] == 'date')				
				$sql_query .= $key." = ". db_escape(date2sql($value[0])).",";
			if($value[1] == 'float')
				$sql_query .= $key." = ". $value.",";
		}else 
			$sql_query .= $key." = ".db_escape($value).",";
    }
    $sql_query = substr($sql_query, 0, -1);
    $sql_query .= " where ".$primary_key[0]." = ".$primary_key[1];
	return  db_query($sql_query, "Could not update data_res on table {$custom_table_name}");	 
}

Get function:

 
 function kv_get_all($custom_table_name, $li_wh_condition = null){
    $sql_query = "SELECT * FROM ".TB_PREF.$custom_table_name." WHERE 1=1";
    if($li_wh_condition != null) {
		foreach($li_wh_condition as $key=>$value){
			$sql_query .= " AND {$key} = ${value}";
		}
    }
    $data_result = db_query($sql_query, "Could not get data_res from {$custom_table_name}");
    $data_res = array();
    while($row = $data_result->fetch_assoc()) {
        $data_res[] = $row;
    }
    return $data_res;
}

GetRow of Data:function

 
 function kv_get_row($custom_table_name, $li_wh_condition = null){
    $sql_query = "SELECT * FROM ".TB_PREF.$custom_table_name." WHERE 1=1";
    if($li_wh_condition != null) {
		foreach($li_wh_condition as $key=>$value){
			$sql_query .= " AND {$key} = ${value}";
		}
    }
	$sql_query .= ' LIMIT 1'; 
    $data_result = db_query($sql_query, "Could not get data_res from {$custom_table_name}");
	$data_res = db_fetch($data_result);
    
    return $data_res;
}

Get Single Value:function

function kv_get_single_value($tablename, $column_single, $li_wh_condition=null){
	$sql_query = "SELECT ".$column_single." FROM ".TB_PREF.$tablename." WHERE 1=1";
    foreach($li_wh_condition as $key=>$value){
        $sql_query .= " AND {$key} = ${value}";
    }
    return db_get_single_value($sql_query, "Could not get data_res from {$tablename}");
}

Get With two or more Joining Tables :

function kv_get_results_join($main_table, $joins, $columns=array(), $li_wh_condition=null){
    $sql_query = "SELECT ";
    if(count($columns)>0){
        foreach ($columns as $value) {
            $sql_query .= $value.",";
        }
        $sql_query = substr($sql_query, 0, -1);
    }else{
        $sql_query .= " *";
    }
    $sql_query .= " FROM ".TB_PREF."{$main_table} ";
    foreach ($joins as $value) {
        if(isset($value['join'])){
            $sql_query .= " {$value['join']} JOIN ".TB_PREF.$value['custom_table_name'].' ON '.$value['li_wh_condition'];
        }else{
            $sql_query .= " INNER JOIN ".TB_PREF.$value['custom_table_name'].' ON '.$value['li_wh_condition'];
        }
    }
    $sql_query .= " WHERE 1=1 ";
    foreach($li_wh_condition as $key=>$value){
        $sql_query .= " AND {$key} = ${value}";
    }
    //echo $sql_query;
    $data_result = db_query($sql_query, "Could not get data_res!");
    $data_res = array();
    while($row = $data_result->fetch_assoc()) {
        $data_res[] = $row;
    }
    return $data_res;
}

delete function

function kv_delete($custom_table_name, $li_wh_condition){
    $sql_query = "DELETE FROM ".TB_PREF.$custom_table_name." WHERE 1=1";
    foreach ($li_wh_condition as $key=>$value) {
        $sql_query .= " AND ".$key."=".$value;
    }
    $data_result = db_query($sql_query, "Could not your delete data_res from {$custom_table_name}");
    return $data_result;
}

Example

Read Also:  How to Open URL in New Tab using Magento

I hope you have Got What is Frontaccounting common class for Insert, Update, Delete, Get SQL Functions And how it works.I would Like to have FeadBack From My Blog(Pakainfo.com) readers.Your Valuable FeadBack,Any Question,or any Comments abaout This Article(Pakainfo.com) Are Most Always Welcome.

About Pakainfo

I am Jaydeep Gondaliya, a software engineer, the founder and the person running Pakainfo. I'm a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.

View all posts by Pakainfo →

Leave a Reply

Your email address will not be published. Required fields are marked *