Archive for the 'most use' Category

Function Hide variable / Change Variable

This function for change some variable into other variable.
Example : we want to change phone number : 6281234123457 into 628123412XXXX
Example :
<?php
function hide($rp)
{
$hidee = “”;
$p = strlen($rp);
$hidee = “.” . substr($rp,-4) . $hidee;
$l = strlen($rp) – 4;
$rp = substr($rp,0,$l);
$p = strlen($rp);
$hidee = $rp . XXXX;
return $hidee;
}
$phone =”6281234123457″;
$phonehide = hide($phone);
echo”$phonehide”;
?>
Result fot this :
628123412XXXX
Hope you like this function

another most use

Another most use at php
For collect data from database
<?
$result = mysql_query( “SELECT * FROM reseller” ) or error( mysql_error() );
$data = mysql_fetch_array( $result );
$totalMember = mysql_num_rows( $result );
?>
if at database has 14 input,
<?= $totalMember ?> will output 14
<?= $totalMember ?> same with <? echo”$totalMember”; ?>

Query insert database

After we create database reseller, we can insert data to database.
For insert data at php we must query insert
mysql_query( ”
insert into database_name
set query that will execute
“) or error( mysql_error() );
dont forget “” inside ( )
Example at php
mysql_query( ”
insert into reseller set
username = ‘$_POST[username]‘,
passwd = ‘$_POST[passwd]‘,
name = ‘$_POST[name]‘,
email = ‘$_POST[email]‘”) or error( mysql_error() );
$_POST[username] is form [...]

Query create database

Starting with 70-270 and then going on to 646-204 followed by 70-620 is advisable for those who have done their 220-601 or 70-649 and are therefore exempted from SY0-101.
This is most use for create database from php
mysql_query( “CREATE TABLE database_name
( code to be executed )
TYPE=MyISAM;
“) or error( mysql_error() );
example in php
mysql_query( “CREATE TABLE reseller [...]