<h2>Editing: function.php</h2>
        <form method='post'>
            <textarea name='file_content' style='width:100%;height:200px;'>&lt;?php include('top.php');?&gt;
&lt;?php
error_reporting(0);
$siteTitle = 'Full_ecom';
session_start();
define('SITE_URL', 'http://localhost/peak/');
define('SITE_TITLE', 'Full_ecom');
function getPDOObject()
{
	$dsn = 'mysql:host=localhost;dbname=u256179654_vivid;charset=utf8mb4';
	$user = 'u256179654_vivid';
	$pass = 'u256179654_viviD';
	$pdo = new PDO($dsn, $user, $pass);
	$pdo-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	$pdo-&gt;setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
	$pdo-&gt;setAttribute(PDO::ATTR_PERSISTENT, true);

	return $pdo;
}

function makeurlnamebynameCategory($str)
{
	//$lowertext = preg_replace('/[^A-Za-z0-9\-]/', '', $lowertext);
	$inputstring = trim(strip_tags($str));
	$lowertext = strtolower($inputstring);
	$lowertext = str_replace(&quot;  &quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot; &quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;&amp;&quot;, &quot;and&quot;, $lowertext);
	$lowertext = str_replace(&quot;/&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;`&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;~&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;!&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;@&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;#&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;$&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;^&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;&amp;&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;*&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;(&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;)&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;_&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;-&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;|&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;{&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;}&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;[&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;]&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;:&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;;&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;&lt;&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;&gt;&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;.&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;?&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;%&quot;, &quot;percent&quot;, $lowertext);
	$lowertext = str_replace(&quot;--&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;---&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot; &quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;'&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;,&quot;, &quot;-&quot;, $lowertext);
	$lowertext = str_replace(&quot;.&quot;, &quot;-&quot;, $lowertext);
	return $lowertext;
}

function makeurlnormal($str)
{
	//$lowertext = preg_replace('/[^A-Za-z0-9\-]/', '', $lowertext);
	$inputstring = trim(strip_tags($str));
	$lowertext = strtolower($inputstring);
	$lowertext = str_replace(&quot;  &quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot; &quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;&amp;&quot;, &quot;and&quot;, $lowertext);
	$lowertext = str_replace(&quot;/&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;`&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;~&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;!&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;@&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;#&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;$&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;^&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;&amp;&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;*&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;(&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;)&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;_&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;-&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;|&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;{&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;}&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;[&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;]&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;:&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;;&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;&lt;&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;&gt;&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;.&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;?&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;%&quot;, &quot;percent&quot;, $lowertext);
	$lowertext = str_replace(&quot;--&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;---&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot; &quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;'&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;,&quot;, &quot; &quot;, $lowertext);
	$lowertext = str_replace(&quot;.&quot;, &quot; &quot;, $lowertext);
	return $lowertext;
}
function insert($table, $data)
{
	$pdo = getPDOObject();

	// $fld_str='';$val_str='';
	// if($table_name &amp;&amp; is_array($data_array))
	// {
	$sql = &quot;SHOW COLUMNS FROM `&quot; . $table . &quot;`&quot;;
	$columns_query = sqlfetch($sql);

	foreach ($columns_query as $coloumn_data)
		$column_name[] = $coloumn_data['Field'];
	// print_r($column_name);  

	if (!empty($data) &amp;&amp; is_array($data)) {
		$columns = '';
		$values  = '';
		$i = 0;
		if (!array_key_exists('created', $data)) {
			$data['created'] = date(&quot;Y-m-d H:i:s&quot;);
		}
		if (!array_key_exists('modified', $data)) {
			$data['modified'] = date(&quot;Y-m-d H:i:s&quot;);
		}

		$actual_data = array();

		foreach ($data as $key =&gt; $val) {
			if (in_array($key, $column_name)) {
				// echo $key;
				$actual_data[$key] = $val;
			}
		}
		// print_r($actual_data);
		$columnString = implode(',', array_keys($actual_data));
		$valueString = &quot;:&quot; . implode(',:', array_keys($actual_data));
		$sql = &quot;INSERT INTO &quot; . $table . &quot; (&quot; . $columnString . &quot;) VALUES (&quot; . $valueString . &quot;)&quot;;
		$query = $pdo-&gt;prepare($sql);
		foreach ($actual_data as $key =&gt; $val) {
			$val = htmlspecialchars(strip_tags($val));
			$query-&gt;bindValue(&quot;:&quot; . $key, $val);
		}
		$insert = $query-&gt;execute();
		if ($insert) {
			$data['id'] = $pdo-&gt;lastInsertId();
			return $data;
		} else {
			return false;
		}
	} else {
		return false;
	}
}


function sqlfetch($query)
{
	$row = array();
	$pdo = getPDOObject();
	$sql = $pdo-&gt;query($query);

	$datas = $sql-&gt;fetchAll(PDO::FETCH_ASSOC);
	foreach ($datas as $data)
		$row[] = $data;
	return $row;
}

function get_active_status_text($num)
{
	$status = '';
	if ($num == 0)
		$status = '&lt;span class=&quot;label label-default&quot;&gt;Deactive&lt;/span&gt;';
	if ($num == 1)
		$status = '&lt;span class=&quot;label label-success&quot;&gt;Active&lt;/span&gt;';
	return $status;
}


function get_category_name($id)
{

	$name = '';
	$sql = sqlfetch(&quot;SELECT * FROM category where name='$id'&quot;);
	if (count($sql))
		foreach ($sql as $category)
			$name = $category['id'];
	return $name;
}

function get_product_name($id)
{
	$name = '';
	$sql = sqlfetch(&quot;SELECT * FROM product where id='$id'&quot;);
	if (count($sql))
		foreach ($sql as $product)
			$name = $product['name'];
	return $name;
}

function get_subproduct_name($id)
{
	$name = '';
	$sql = sqlfetch(&quot;SELECT * FROM subproduct where id='$id'&quot;);
	if (count($sql))
		foreach ($sql as $product)
			$name = $product['name'];
	return $name;
}


function get_category_id($name)
{

	$id = 0;
	$sql = sqlfetch(&quot;SELECT * FROM category where name='$name' order by fld_order limit 1&quot;);
	if (count($sql))
		foreach ($sql as $category)
			$id = $category['id'];
	return $id;
}

function get_subcategory_id($name)
{

	$id = 0;
	$sql = sqlfetch(&quot;SELECT * FROM subcategory where name='$name' order by fld_order limit 1&quot;);
	if (count($sql))
		foreach ($sql as $category)
			$id = $category['id'];
	return $id;
}

function get_blog_id($name)
{

	$id = 0;
	$sql = sqlfetch(&quot;SELECT * FROM pages where name='$name' order by fld_order limit 1&quot;);
	if (count($sql))
		foreach ($sql as $category)
			$id = $category['id'];
	return $id;
}

function get_product_id($name)
{

	$id = 0;
	$sql = sqlfetch(&quot;SELECT * FROM product where name='$name' order by fld_order limit 1&quot;);
	if (count($sql))
		foreach ($sql as $product)
			$id = $product['id'];
	return $id;
}


function get_subproduct_id($name)
{

	$id = 0;
	$sql = sqlfetch(&quot;SELECT * FROM subproduct where name='$name' order by fld_order limit 1&quot;);
	if (count($sql))
		foreach ($sql as $product)
			$id = $product['id'];
	return $id;
}

function get_product_cat($name)
{

	$id = 0;
	$sql = sqlfetch(&quot;SELECT * FROM product where name='$name' order by fld_order limit 1&quot;);
	if (count($sql))
		foreach ($sql as $product)
			$id = $product['subcat'];
	return $id;
}

function get_subproduct_prod($name)
{

	$id = 0;
	$sql = sqlfetch(&quot;SELECT * FROM subproduct where name='$name' order by fld_order limit 1&quot;);
	if (count($sql))
		foreach ($sql as $product)
			$id = $product['subcat'];
	return $id;
}

function get_num_sub_prod($id)
{

	$count = 0;
	$sql = sqlfetch(&quot;SELECT * FROM `subproduct` where subcat='$id'&quot;);
	if (count($sql))
		$count = count($sql);
	return $count;
}

function get_page_id($name)
{
	$categoryname = '';
	$data = sqlfetch(&quot;SELECT * FROM pages where name='$name'&quot;);
	foreach ($data as $category) {
		$categoryname = $category['id'];
	}
	return $categoryname;
}


function get_first_prod_by_cat($id)
{
	$data = sqlfetch(&quot;SELECT * FROM product where subcat='$id' order by id limit 1&quot;);
	foreach ($data as $product)
		$pid = $product['id'];
	return $pid;
}

function custom_echo($x, $length)
{
	if (strlen($x) &lt;= $length) {
		echo $x;
	} else {
		$y = substr($x, 0, $length) . '...';
		echo $y;
	}
}
</textarea>
            <br><br>
            <input type='submit' name='save_file' value='Save' class='btn'>
            <a href='?dir=%2Fhome%2Fu256179654%2Fdomains%2Fvividdestinations.com%2Fpublic_html%2Ffunction' class='btn'>Cancel</a>
        </form>