Posted inProgramming / Mysql / Mysqli / php

Insert Update Delete view function using PHP and mysql – crud function

Insert Update Delete view function using PHP and mysql – crud function

In this Post We Will Explain About is Insert Update Delete view function using PHP and mysql – crud function 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 mysql – how to simplify my php codeinsert, update and delete functionExample

In this post we will show you Best way to implement Insert Update Delete using PHP and mysql Code Example, hear for Basic insert, view, edit, delete and update using PHP and Mysqlwith Download .we will give you demo,Source Code and examples for implement Step By Step Good Luck!.

mysql_fetch_row

function db_fetch_row($data_results)
{

	return mysql_fetch_row($data_results);
}

mysql_fetch_assoc

function db_fetch_assoc($data_results)
{

	return mysql_fetch_assoc($data_results);
}

mysql_fetch_array

function all_db_fetch_data($data_results)
{

	return mysql_fetch_array($data_results);
}

mysql_data_seek

function db_seek_table(&$data_results,$record)
{
	return mysql_data_seek($data_results, $record);
}

mysql_free_data_results

function db_free_data_results($data_results)
{
	if ($data_results)
		mysql_free_data_results($data_results);
}

mysql_num_rows

function all_db_num_rows_toal($data_results)
{
	return mysql_num_rows($data_results);
}

mysql_num_fields

function my_db_num_fields_all($data_results)
{
	return mysql_num_fields($data_results);
}

mysql_query

function all_db_query_data($sql_query, $err_msg=null)
{
	global $databaseselect, $SysPrefs, $sql_query_queries, $Ajax, $databaseselect_db_connections, $get_last_mysql_id;

	// set simple current db prefix
	$datascomp = isset($_SESSION["client_uiser"]->cur_con) ? $_SESSION["client_uiser"]->cur_con : 0;
	$cur_prefix = $databaseselect_db_connections[$datascomp]['tbpref'];
	$sql_query = str_replace(TB_PREF, $cur_prefix, $sql_query);

	if ($SysPrefs->show_sql)
	{
		$Ajax->activate('footer_debug');
		$sql_query_queries .= "
$sql_query

\n


";
}

db_profile(); // mysql profiling

$retry = MAX_DEADLOCK_RETRY;
do {
$data_results = mysql_query($databaseselect, $sql_query);
if (mysql_errno($databaseselect) == 1213) {
sleep(1); $retry--;
} else
$retry = 0;
} while ($retry);

db_profile($sql_query);

if($SysPrefs->sql_trail) {
$get_last_mysql_id = mysql_insert_id($databaseselect);
if ($SysPrefs->select_trail || (strstr($sql_query, 'SELECT') === false)) {
mysql_query(
"INSERT INTO ".$cur_prefix."sql_trail
(`sql`, `data_results`, `msg`)
VALUES(".db_escape($sql_query).",".($data_results ? 1 : 0).",
".db_escape($err_msg).")", $databaseselect);
}
}

if ($err_msg != null || $SysPrefs->go_debug) {
$exit = $err_msg != null;
if (function_exists('xdebug_call_file'))
$err_msg = '
At file '.xdebug_call_file().':'.xdebug_call_line().':
'.$err_msg;
check_db_error($err_msg, $sql_query, $exit);
}
return $data_results;
}

mysql_errno

function db_error_no()
{
	global $databaseselect;
	return mysql_errno($databaseselect);
}

mysql_error

function db_error_msg($conn)
{
	return mysql_error($conn);
}

get_last_mysql_id

function db_insert_id()
{
	global $get_last_mysql_id, $SysPrefs, $databaseselect;

	return $SysPrefs->sql_trail ? $get_last_mysql_id : mysql_insert_id($databaseselect);
}

mysql_select_db

function db_create_db($db_connection)
{
	$databaseselect = mysql_connect($db_connection["host"] ,
		$db_connection["dbuser"], $db_connection["dbpassword"]);

	if (!mysql_select_db($db_connection["dbname"], $databaseselect))
	{
		$sql_query = "CREATE DATABASE IF NOT EXISTS `" . $db_connection["dbname"] . "`"
			. " DEFAULT COLLATE '" . get_mysql_collation($db_connection["collation"]) . "'";

		if (!mysql_query($sql_query) || !mysql_select_db($db_connection["dbname"], $databaseselect))
				return 0;
	} else
		if (!db_set_collation($db_connection["collation"], $databaseselect))
			return 0;

	return $databaseselect;
}

db_drop_db

function db_drop_db($db_connection)
{

	if ($db_connection["tbpref"] == "")
	{
		$sql_query = "DROP DATABASE IF EXISTS " . $db_connection["dbname"] . "";
		return mysql_query($sql_query);
	}
	else
	{
    	$result = all_db_query_data("show table status");
    	$fetch_all_tables = array();
    	while($row = db_fetch($result))
    		$fetch_all_tables[] = $row;
		foreach ($fetch_all_tables as $table)
		{
			if (strpos($table['Name'], $db_connection["tbpref"]) === 0)
				all_db_query_data("DROP TABLE `".$table['Name'] . "`");
		}
		return true;
	}
}

mysql_close

function db_close($databaseselectase = null)
{
	global $databaseselect;
	
	if (!$databaseselectase)
		$databaseselectase = $databaseselect;
	return mysql_close($databaseselectase);
}

function_exists

function data_db_extension_exists()
{
	return function_exists('mysql_connect');
}

Update record activity status.

function update_record_status($id, $status, $table, $key) {
	$sql_query = "UPDATE ".TB_PREF.$table." SET inactive = "
		. ((int)$status)." WHERE $key=".db_escape($id);
		
  	db_query($sql_query, "Can't update record status");
}

Example

I hope you have Got What is php insert update delete example download 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.

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.

Leave a Reply

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

We accept paid guest Posting on our Site : Guest Post Chat with Us On Skype