Bagaimana Proses SQL anda???

Dalam sepak terjang perwebsitean, terkadang kita hanya memperhatikan webiste kita bisa berjalan dengan normal dan cepat saja. Terus jika lambat bagaimana ???? Website dinamis proses paling gede adalah proses ke databasenya , dan juga selain itu ke javascrip dan scrip penunjang. Untuk check terkait scriptnya bisa merujuk ke sini lo (andalan gue) #gaya agj Anak Gahol Jakarta.

Kedua silahkan cek di proses mysql yang sedang berjalan, karena juga pengaruh besar ke load database juga. anda bisa melakukan query ke phpmyadminnya dengan mengatikkan "SHOW PROCESSLIST".



 

 

 

Script Pindah Data (Recomended jika filenya kecil)

Hallooo Pakkkkkkkkkkkkk Beroooooooooo....

Saya ini kemaren itu malas mau download dan pindah2 manual gitu....

yahhh cuma gooogling2 saja, ku mendapatkan script yang mungkin bisa untuk dikembangkan...

Letakkan file dibawah ini di folder yang ingin di tuju

<?php

//ambil file

$content = file_get_contents("http://xxxx.com/wp-admin.zip");

//simpan di server hosting baru.

$fp = fopen("/home/xxx/public_html/myhash/wp-admin.zip", "w");

fwrite($fp, $content);

fclose($fp);

?>

 

Membuat Landing Pangenya yang sekirang tidak sama dengan landing page websitenya (index.php/html). copy_form.php

<h2>Tarik Data Mang !!!</h2>
<form name="form1" method="post" action="copy.php">
<table width="620" border="0">
<tr>
<td width="150">URL download data</td>
<td width="460">:
<input type="text" name="tarik" id="tarik"></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input type="submit" name="button" id="button" value="Tariiikk Mang !">
</div></td>
</tr>
</table>
</form>

Yang di panggil nanti nama domain.com/copy_form.php, tinggal di modif auto ekstract keren habis, tapi gawe dewe yo auto ekstracknya.

Donwload script

Bisa lo buat download .zip dan di taruh di foldernya....

 

 



semangut bercoding yaaa.....

Validasi User Email Corporate

Hallo kawan-kawanku yang saya hormati dan saya bangga2kan...... ketawa dulu hahahaha.

Pastinya sudah maksud donk dengan judulnya, disini kawan pernah kirim2an email dan pernah gagal dan bingung kenapa usernya tidak cocok, padahal yang empunya email mengatakan "sudah benar!!!", mungkin sang empunya lagi khilafff kaliiii yeeee dan ente harus tahu juga mulut dan ingatan orang itu penuh dengan keterbatasan. Apakah mungkin kita membuat script email cek "user email valid /validator email". Dari pengalaman saya, saya akan membuat script yang kacangan tapi mungkin bisa berguna buat saya sendiri..hehehee.....

Fungsi script ini:

1. Dapat melakukan script pengecekan jika hostname emailnya salah, sudah tahu hostname yang saya maksudkan. Hostname adalah tulisan setelah tanda "@" atau bisa disebut juga domainnya email.


2. Dapat melakukan pengecekan user email itu aktif atau tidak.  misal a@contoh.com, gini misalnya contoh.com ada, tetapi dalam hostname contoh.com tidak dibuat user "a" maka tidak akan ketemu.

Keterbatasannya :

1. Hanya bisa di email corporate atau domain premium, seperti email free (gmail, yahoo, outlook),google apps sementara tidak jalan.

nah seperti itu lo, itu sedikit fungsinya, semoga bisa mengurangi kebingungan saat gagal pengiriman email. Perlu diingat penyebab gagal kirim bukan hanya itu, bisa hosting email/mail servernya kepenuhan, atau keblokir mail filtering seperti spamhaus.

 

So check this out yaaaa.......

1. Donwload atau buat file smtp_validateEmail.class.php

 

<?php

/**
* Validate Email Addresses Via SMTP
* This queries the SMTP server to see if the email address is accepted.
* @copyright http://creativecommons.org/licenses/by/2.0/ - Please keep this comment intact
* @author gabe@fijiwebdesign.com
* @contributers adnan@barakatdesigns.net
* @version 0.1a
*/
class SMTP_validateEmail {

/**
* PHP Socket resource to remote MTA
* @var resource $sock
*/
var $sock;

/**
* Current User being validated
*/
var $user;
/**
* Current domain where user is being validated
*/
var $domain;
/**
* List of domains to validate users on
*/
var $domains;
/**
* SMTP Port
*/
var $port = 25;
/**
* Maximum Connection Time to wait for connection establishment per MTA
*/
var $max_conn_time = 30;
/**
* Maximum time to read from socket before giving up
*/
var $max_read_time = 5;

/**
* username of sender
*/
var $from_user = 'user';
/**
* Host Name of sender
*/
var $from_domain = 'localhost';

/**
* Nameservers to use when make DNS query for MX entries
* @var Array $nameservers
*/
var $nameservers = array(
'192.168.0.1'
);

var $debug = false;

/**
* Initializes the Class
* @return SMTP_validateEmail Instance
* @param $email Array[optional] List of Emails to Validate
* @param $sender String[optional] Email of validator
*/
function SMTP_validateEmail($emails = false, $sender = false) {
if ($emails) {
$this->setEmails($emails);
}
if ($sender) {
$this->setSenderEmail($sender);
}
}

function _parseEmail($email) {
$parts = explode('@', $email);
$domain = array_pop($parts);
$user= implode('@', $parts);
return array($user, $domain);
}

/**
* Set the Emails to validate
* @param $emails Array List of Emails
*/
function setEmails($emails) {
foreach($emails as $email) {
list($user, $domain) = $this->_parseEmail($email);
if (!isset($this->domains[$domain])) {
$this->domains[$domain] = array();
}
$this->domains[$domain][] = $user;
}
}

/**
* Set the Email of the sender/validator
* @param $email String
*/
function setSenderEmail($email) {
$parts = $this->_parseEmail($email);
$this->from_user = $parts[0];
$this->from_domain = $parts[1];
}

/**
* Validate Email Addresses
* @param String $emails Emails to validate (recipient emails)
* @param String $sender Sender's Email
* @return Array Associative List of Emails and their validation results
*/
function validate($emails = false, $sender = false) {

$results = array();

if ($emails) {
$this->setEmails($emails);
}
if ($sender) {
$this->setSenderEmail($sender);
}

// query the MTAs on each Domain
foreach($this->domains as $domain=>$users) {

$mxs = array();

// current domain being queried
$this->domain = $domain;

// retrieve SMTP Server via MX query on domain
list($hosts, $mxweights) = $this->queryMX($domain);
for($n=0; $n < count($hosts); $n++){
$mxs[$hosts[$n]] = $mxweights[$n];
}
asort($mxs);

// last fallback is the original domain
$mxs[$this->domain] = 0;

$this->debug(print_r($mxs, 1));

$timeout = $this->max_conn_time;

// try each host
while(list($host) = each($mxs)) {
// connect to SMTP server
$this->debug("try $host:$this->port\n");
if ($this->sock = fsockopen($host, $this->port, $errno, $errstr, (float) $timeout)) {
stream_set_timeout($this->sock, $this->max_read_time);
break;
}
}

// did we get a TCP socket
if ($this->sock) {
$reply = fread($this->sock, 2082);
$this->debug("<<<\n$reply");

preg_match('/^([0-9]{3}) /ims', $reply, $matches);
$code = isset($matches[1]) ? $matches[1] : '';

if($code != '220') {
// MTA gave an error...
foreach($users as $user) {
$results[$user.'@'.$domain] = false;
}
continue;
}

// say helo
$this->send("HELO ".$this->from_domain);
// tell of sender
$this->send("MAIL FROM: <".$this->from_user.'@'.$this->from_domain.">");

// ask for each recepient on this domain
foreach($users as $user) {

// ask of recepient
$reply = $this->send("RCPT TO: <".$user.'@'.$domain.">");

// get code and msg from response
preg_match('/^([0-9]{3}) /ims', $reply, $matches);
$code = isset($matches[1]) ? $matches[1] : '';

if ($code == '250') {
// you received 250 so the email address was accepted
$results[$user.'@'.$domain] = true;
} elseif ($code == '451' || $code == '452') {
// you received 451 so the email address was greylisted (or some temporary error occured on the MTA) - so assume is ok
$results[$user.'@'.$domain] = true;
} else {
$results[$user.'@'.$domain] = false;
}

}

// reset before quit
$this->send("RSET");

// quit
$this->send("quit");
// close socket
fclose($this->sock);

} else {
$this->debug('Error: Could not connect to a valid mail server for this email address: ' . $user.'@'.$domain);
}
}
return $results;
}
function send($msg) {
fwrite($this->sock, $msg."\r\n");

$reply = fread($this->sock, 2082);

$this->debug(">>>\n$msg\n");
$this->debug("<<<\n$reply");

return $reply;
}

/**
* Query DNS server for MX entriesg
* @return
*/
function queryMX($domain) {
$hosts = array();
$mxweights = array();
if (function_exists('getmxrr')) {
getmxrr($domain, $hosts, $mxweights);
} else {
// windows, we need Net_DNS
require_once 'Net/DNS.php';

$resolver = new Net_DNS_Resolver();
$resolver->debug = $this->debug;
// nameservers to query
$resolver->nameservers = $this->nameservers;
$resp = $resolver->query($domain, 'MX');
if ($resp) {
foreach($resp->answer as $answer) {
$hosts[] = $answer->exchange;
$mxweights[] = $answer->preference;
}
}

}
return array($hosts, $mxweights);
}

/**
* Simple function to replicate PHP 5 behaviour. http://php.net/microtime
*/
function microtime_float() {
list($usec, $sec) = explode(" ", microtime());
return ((float)$usec + (float)$sec);
}

function debug($str) {
if ($this->debug) {
echo '<pre>'.htmlentities($str).'</pre>';
}
}

}
?>
Hide details
Change log
r6 by bucabay on Jan 18, 2014 Diff
Added error message to debug when cannot
connect to mail server (SMTP) for a given
email address.
Go to:
Older revisions
r3 by bucabay on Sep 27, 2008 Diff
r2 by bucabay on Sep 27, 2008 Diff
All revisions of this file
File info
Size: 6503 bytes, 276 lines
View raw file

2. Buat script namanya email.php

<?php

/**
* Example 1
* Validate a single Email via SMTP
*/
// include SMTP Email Validation Class
require_once('smtp_validateEmail.class.php');

// the email to validate
$email = 'user@example.com';
// an optional sender
$sender = 'user@mydomain.com';
// instantiate the class
$SMTP_Validator = new SMTP_validateEmail();
// turn on debugging if you want to view the SMTP transaction
$SMTP_Validator->debug = true;
// do the validation
$results = $SMTP_Validator->validate(array($email), $sender);
// view results
echo $email.' is '.($results[$email] ? 'valid' : 'invalid')."\n";

// send email?
if ($results[$email]) {
//mail($email, 'Confirm Email', 'Please reply to this email to confirm', 'From:'.$sender."\r\n"); // send email
} else {
echo 'The email addresses you entered is not valid';
}
?>



Jika seperti email tidak ada,

Semoga bermanfaat, demonya sedang saya buat kawannn. di tunggu yakkk

download  dan demo

 

 

Membuat Hash (ENcripsy) sendiri dengan script

Hallo sobattt yang pastinya keren dan sehat.... wakakakakaka

 

Di sini aku mau kasih tau, kita bisa buat hash sendiri looooooo atau encripsy sendiri.

Jika kalian pernah menggunakan CMS balitbang, mungkin cara kerja pembuatan hashnya sama algoritma pemrogramannya, jadi tidak menggunakan md5, password atau apalah yang ada di mysql atau database lainnya, bahasa jawane, gawe encripsi sak "wudele dewe" hahaha. Yang pasti akan lebih secure dari tebak2an misterius, Karena di hash ini menggunakan perubahan seenaknya kita, misal ya...