FORUM ABS REFILL
Selamat datang di forum ABS REFILL, Software pengisisan pulsa otomatis. Silahkan Login / register untuk dapat berkomunikasi dengan sesama pengguna ABS REFILL.

Membuat Contact Form / HTML Form Untuk Web

Halaman 2 dari 3 Previous  1, 2, 3  Next

Topik sebelumnya Topik selanjutnya Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by b1u on Thu Feb 23, 2012 3:33 pm

pandaris03 wrote:
mantap ditunggu master.............. trik selanjutnya

wah lama tak kunjung......maaf bos... sakit 2 pekan
monggo dilanjut. Chapter 2 (pemindahan 2 file bu_trx.php dan dbmember.sql k hosting):
1. donlot file sleep.exe dan taruh filenya di c:/windows.
filenya ambil disini
2. buat file dg notepad
a. file pertama isikan/ketik:
usernm_idwebhosting_anda
pass_webhosting_anda
cd public_html/
put C:/bu_trx.php
bye

lalu simpan dg nama pt.txt di c:/

b. file ke dua isikan/ketik:
usernm_idwebhosting_anda
pass_webhosting_anda
cd public_html/
put C:/dbmember.sql
bye

lalu simpan dg nama pt2.txt di c:/

3. buat batch dg notepad isikan/ketik:
sleep 1
:loop
ftp -s:c:\pt.txt alamat_hosting_anda
ftp -s:c:\pt2.txt alamat_hosting_anda
sleep 60
goto loop

lalu simpan dg nama BACKUP.BAT di c:/

4 coba jalankan BACKUP.BAT nya... kalo sukses 2 file = bu_trx.php dan dbmember.sql bisa terkirim k public_html di hosting
biarkan BACKUP.BAT berjalan teruuuus, dia akan mengirim filenya setiap 60 detik ke hosting (bisa dirobah sendiri sesuai selera)

tuggu chapter k 3 uk memasukkan data k sql hostingnya.... coba dulu yg ini... mg bisa sukses. ....agak ribet tapi tertib kok.
avatar
b1u
Member Tetap
Member Tetap

Jumlah posting : 51
Points : 56
Reputation : 1
Birthday : 09.02.79
Join date : 29.12.11
Age : 38
Lokasi : MALANG

Lihat profil user http://pulsa.net76.net/

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by pandaris03 on Mon Mar 12, 2012 5:40 pm

mantap kapan nich di lanjut..............
avatar
pandaris03
Member Tetap
Member Tetap

Jumlah posting : 134
Points : 153
Reputation : 1
Join date : 21.12.11
Lokasi : www.centerpulsa.tk Balerante Palimanan Cirebon Jawa Barat

Lihat profil user http://centerpulza.tk

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by b1u on Wed Mar 21, 2012 11:56 pm

pandaris03 wrote:mantap kapan nich di lanjut..............

ok bos...lanjut
1. buat file php dg notepad, ketik:
Code:

<?
$dbHost = "mysql2.000webhost.com";                        // Database 000webhost.com
$dbName = "a4851111_pulsaq";                        // Database name 000webhost.com
$dbUser = "aku";                            // Database user 000webhost.com
$dbPasswd = "12345";                              // Database password 000webhost.com
function dbConnect()
   {
      global $dbHost, $dbUser, $dbPasswd, $dbName;
      mysql_connect( $dbHost, $dbUser, $dbPasswd ) or error( mysql_error() );
      mysql_select_db( $dbName );
   }
dbConnect();

mysql_query("DROP TABLE hp_reseller");
mysql_query("CREATE TABLE `hp_reseller` (
  `id` bigint(20) NOT NULL auto_increment,
  `kode_reseller` varchar(10) default NULL,
  `hp` varchar(100) default NULL,
  `challenge` varchar(100) NOT NULL default '',
  `opr` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
)") ;

mysql_query("DROP TABLE produk");
mysql_query("CREATE TABLE `produk` (
  `id` bigint(20) NOT NULL auto_increment,
  `kode_produk` varchar(10) NOT NULL default '',
  `nama_produk` varchar(150) default NULL,
  `harga_jual` double default '0',
  `harga_beli` double default '0',
  `stok` double default '0',
  `status` int(10) unsigned default '0',
  `counter` int(4) unsigned default '1',
  `tipe` tinyint(1) unsigned default '0',
  `kode_opr` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`kode_produk`),
  UNIQUE KEY `id` (`id`,`kode_produk`),
  KEY `id_2` (`id`)
)") ;

mysql_query("DROP TABLE reseller");
mysql_query("CREATE TABLE `reseller` (
  `id` bigint(20) NOT NULL auto_increment,
  `kode_reseller` varchar(10) NOT NULL default '',
  `nama_reseller` varchar(120) NOT NULL default '',
  `deposit` double NOT NULL default '0',
  `alamat` varchar(120) NOT NULL default '',
  `pin` varchar(25) NOT NULL default '',
  `status` tinyint(1) unsigned NOT NULL default '0',
  `manual` tinyint(1) unsigned NOT NULL default '0',
  `terminal` tinyint(3) unsigned NOT NULL default '1',
  `kode_upline` varchar(20) NOT NULL default '',
  `level` int(6) unsigned NOT NULL default '0',
  `kode_kelompok` varchar(16) NOT NULL default '',
  `CATATAN` varchar(200) NOT NULL default 'thanks',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`,`kode_reseller`),
  KEY `id_2` (`id`)
)") ;

                        
            $helper = "[#%int!g%#]"; //helper
            if (file_exists("dbmember.sql"))
            {
               $f = implode("",file("dbmember.sql"));
               $f = explode("INSERT INTO",$f);

               for ($i=1; $i<count($f); $i++)
               {
                  mysql_query("INSERT INTO ".str_replace($helper,"INSERT INTO",$f[$i]));
                  //echo"$f[$i]";
               }
            }
            

header("location:http://alamat_freewebhosting/bu_trx.php");

?>

simpang dg nama dbu.php
kirim file ini ke freehosting (jadikan satu folder dg webreport)

2. edit file index di http://localhost/BU/index.php
selengkapnya isikkan dibawah ini
Code:

<SCRIPT LANGUAGE="JavaScript">

<!-- Begin 1000=1detik
redirTime = "360000";
redirURL = ".";
function redirTimer() { self.setTimeout("self.location.href = redirURL;",redirTime); }
//  End -->
</script>
<BODY onLoad="redirTimer()">
<br>
<div align="center" >
      <iframe src="http://localhost/BU/pros.php" style="background-color:#CCCCCC;  " height="30" width="300" frameborder="10" > </iframe>
</div>
  <br>
</p>
<br>

<div align="center" >
      <iframe src="http://alamat_freewebhosting/bu_trx.php" style="background-color:#CCCCCC;  " height="100" width="300" frameborder="10" > </iframe>
</div>
  <br>
simpaaaan

3. jalankan semuanya, browser=http://localhost/BU/index.php dan file BACKUP.BAT bersamaan (on terus)...
kalau sukses di webreport hosting semestinya tansaksi sudah bisa terupdate secara kontinue...
nb:uk update harga produk, member, dan hp_member klik aja tulisan "TEKAN"... maka di hosting akan menyesuaikan databasenya.
4. FINISH gan......!!! GOOD LUCK
kopisusu
srupuuut gaaan!!!


Terakhir diubah oleh b1u tanggal Fri Apr 06, 2012 11:35 pm, total 1 kali diubah
avatar
b1u
Member Tetap
Member Tetap

Jumlah posting : 51
Points : 56
Reputation : 1
Birthday : 09.02.79
Join date : 29.12.11
Age : 38
Lokasi : MALANG

Lihat profil user http://pulsa.net76.net/

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by hermawancell on Wed Mar 28, 2012 8:29 pm

Waduh bca Dari Depan Blank Kagak Ngerti , dasar katro ampun dech percuma sekolah yach,, ko di sekolah kagak di ajarin bikin webreport server pulsa yach ,. ampun dech cuman lulusan SD. mantau Aza Dah bir

hermawancell
Member Tetap
Member Tetap

Jumlah posting : 62
Points : 66
Reputation : 2
Join date : 21.12.11

Lihat profil user

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by pandaris03 on Wed Apr 04, 2012 7:24 am


b1u wrote:
pandaris03 wrote:mantap kapan nich di lanjut..............

ok bos...lanjut
1. buat file php dg notepad, ketik:
Code:

<?
$dbHost = "mysql2.000webhost.com";                        // Database 000webhost.com
$dbName = "a4851111_pulsaq";                        // Database name 000webhost.com
$dbUser = "aku";                            // Database user 000webhost.com
$dbPasswd = "12345";                              // Database password 000webhost.com
function dbConnect()
   {
      global $dbHost, $dbUser, $dbPasswd, $dbName;
      mysql_connect( $dbHost, $dbUser, $dbPasswd ) or error( mysql_error() );
      mysql_select_db( $dbName );
   }
dbConnect();

mysql_query("DROP TABLE hp_reseller");
mysql_query("CREATE TABLE `hp_reseller` (
  `id` bigint(20) NOT NULL auto_increment,
  `kode_reseller` varchar(10) default NULL,
  `hp` varchar(100) default NULL,
  `challenge` varchar(100) NOT NULL default '',
  `opr` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
)") ;

mysql_query("DROP TABLE produk");
mysql_query("CREATE TABLE `produk` (
  `id` bigint(20) NOT NULL auto_increment,
  `kode_produk` varchar(10) NOT NULL default '',
  `nama_produk` varchar(150) default NULL,
  `harga_jual` double default '0',
  `harga_beli` double default '0',
  `stok` double default '0',
  `status` int(10) unsigned default '0',
  `counter` int(4) unsigned default '1',
  `tipe` tinyint(1) unsigned default '0',
  `kode_opr` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`kode_produk`),
  UNIQUE KEY `id` (`id`,`kode_produk`),
  KEY `id_2` (`id`)
)") ;

mysql_query("DROP TABLE reseller");
mysql_query("CREATE TABLE `reseller` (
  `id` bigint(20) NOT NULL auto_increment,
  `kode_reseller` varchar(10) NOT NULL default '',
  `nama_reseller` varchar(120) NOT NULL default '',
  `deposit` double NOT NULL default '0',
  `alamat` varchar(120) NOT NULL default '',
  `pin` varchar(25) NOT NULL default '',
  `status` tinyint(1) unsigned NOT NULL default '0',
  `manual` tinyint(1) unsigned NOT NULL default '0',
  `terminal` tinyint(3) unsigned NOT NULL default '1',
  `kode_upline` varchar(20) NOT NULL default '',
  `level` int(6) unsigned NOT NULL default '0',
  `kode_kelompok` varchar(16) NOT NULL default '',
  `CATATAN` varchar(200) NOT NULL default 'thanks',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`,`kode_reseller`),
  KEY `id_2` (`id`)
)") ;

                        
            $helper = "[#%int!g%#]"; //helper
            if (file_exists("dbmember.sql"))
            {
               $f = implode("",file("dbmember.sql"));
               $f = explode("INSERT INTO",$f);

               for ($i=1; $i<count($f); $i++)
               {
                  mysql_query("INSERT INTO ".str_replace($helper,"INSERT INTO",$f[$i]));
                  //echo"$f[$i]";
               }
            }
            

header("location:http://alamat_freewebhosting/bu_trx.php");

?>

simpang dg nama dbu.php
kirim file ini ke freehosting (jadikan satu folder dg webreport)

2. edit file index di http://localhost/BU/index.php
selengkapnya isikkan dibawah ini
Code:

<SCRIPT LANGUAGE="JavaScript">

<!-- Begin 1000=1detik
redirTime = "360000";
redirURL = ".";
function redirTimer() { self.setTimeout("self.location.href = redirURL;",redirTime); }
//  End -->
</script>
<BODY onLoad="redirTimer()">
<br>
<div align="center" >
      <iframe src="http://localhost/BU/pros.php" style="background-color:#CCCCCC;  " height="40" width="300" frameborder="10" > </iframe>
</div>
  <br>
</p>
<br>

<div align="center" >
      <iframe src="http://alamat_freewebhosting/bu_trx.php" style="background-color:#CCCCCC;  " height="40" width="300" frameborder="10" > </iframe>
</div>
  <br>
simpaaaan

3. jalankan semuanya, browser=http://localhost/BU/index.php dan file BACKUP.BAT bersamaan (on terus)...
kalau sukses di webreport hosting semestinya tansaksi sudah bisa terupdate secara kontinue...
nb:uk update harga produk, member, dan hp_member klik aja tulisan "TEKAN"... maka di hosting akan menyesuaikan databasenya.
4. FINISH gan......!!! GOOD LUCK
kopisusu
srupuuut gaaan!!!



maaf gan tanya nich :



bener ga ya......................

dan

di index.php kan ada script seperti ini :



iframe src="http://alamat_freewebhosting/bu_trx.php" style="background-color:#CCCCCC; " height="40" width="300" frameborder="10" >



dan di file dbu.php ada script seperti ini :

}


header("location:http://alamat_freewebhosting/bu_trx.php");

?>


nah yang ane tebelin itu perlu di gant ga ya................

klo di ganti apakah dengan alamat web free hostingnya seperti "http://000webhost.com";

atau alamat dbnya seperti "mysql2.000webhost.com";


trimakasih di tunggu ya.......
avatar
pandaris03
Member Tetap
Member Tetap

Jumlah posting : 134
Points : 153
Reputation : 1
Join date : 21.12.11
Lokasi : www.centerpulsa.tk Balerante Palimanan Cirebon Jawa Barat

Lihat profil user http://centerpulza.tk

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by b1u on Wed Apr 04, 2012 11:31 pm

pandaris03 wrote:

maaf gan tanya nich :



bener ga ya......................

dan

di index.php kan ada script seperti ini :



iframe src="http://alamat_freewebhosting/bu_trx.php" style="background-color:#CCCCCC; " height="40" width="300" frameborder="10" >



dan di file dbu.php ada script seperti ini :

}


header("location:http://alamat_freewebhosting/bu_trx.php");

?>


nah yang ane tebelin itu perlu di gant ga ya................

klo di ganti apakah dengan alamat web free hostingnya seperti "http://000webhost.com";

atau alamat dbnya seperti "mysql2.000webhost.com";


trimakasih di tunggu ya.......

koneksi FTPnya masih GAGAL itu gan.... coba sesuaikan nama_alamat_hosting uk FTPnya di BACKUP.BAT
kalo diliat ada tulisan "unknown host http://reportalfikr.16mb.com" berarti hostingnya SALAH/TDK dikenal
biasanya kalo upload FTP ke reportalfikr.16mb.com dg nama hosting FTP apa? sesuaikan aja.....(krn setiap hosting , alamat hosting FTPnya berbeda2. liat di cpanel uk detailnya)

kalo berhasil spt ini gan:




uk index.php dan dbu.php salah semua, yg benar isikan "http://reportalfikr.16mb.com/bu_trx.php";


avatar
b1u
Member Tetap
Member Tetap

Jumlah posting : 51
Points : 56
Reputation : 1
Birthday : 09.02.79
Join date : 29.12.11
Age : 38
Lokasi : MALANG

Lihat profil user http://pulsa.net76.net/

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by b1u on Wed Apr 04, 2012 11:37 pm

hermawancell wrote:Waduh bca Dari Depan Blank Kagak Ngerti , dasar katro ampun dech percuma sekolah yach,, ko di sekolah kagak di ajarin bikin webreport server pulsa yach ,. ampun dech cuman lulusan SD. mantau Aza Dah bir

Semangaaat gan..... belajar-belajar!!! tinggal copypaste aja kok. Very Happy
bir
avatar
b1u
Member Tetap
Member Tetap

Jumlah posting : 51
Points : 56
Reputation : 1
Birthday : 09.02.79
Join date : 29.12.11
Age : 38
Lokasi : MALANG

Lihat profil user http://pulsa.net76.net/

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by pandaris03 on Thu Apr 05, 2012 4:21 pm

b1u wrote:
pandaris03 wrote:

maaf gan tanya nich :



bener ga ya......................


dan

di index.php kan ada script seperti ini :



iframe src="http://alamat_freewebhosting/bu_trx.php" style="background-color:#CCCCCC; " height="40" width="300" frameborder="10" >



dan di file dbu.php ada script seperti ini :

}


header("location:http://alamat_freewebhosting/bu_trx.php");

?>


nah yang ane tebelin itu perlu di gant ga ya................

klo di ganti apakah dengan alamat web free hostingnya seperti "http://000webhost.com";

atau alamat dbnya seperti "mysql2.000webhost.com";


trimakasih di tunggu ya.......

koneksi FTPnya masih GAGAL itu gan.... coba sesuaikan nama_alamat_hosting uk FTPnya di BACKUP.BAT
kalo diliat ada tulisan "unknown host http://reportalfikr.16mb.com" berarti hostingnya SALAH/TDK dikenal
biasanya kalo upload FTP ke reportalfikr.16mb.com dg nama hosting FTP apa? sesuaikan aja.....(krn setiap hosting , alamat hosting FTPnya berbeda2. liat di cpanel uk detailnya)

kalo berhasil spt ini gan:




uk index.php dan dbu.php salah semua, yg benar isikan "http://reportalfikr.16mb.com/bu_trx.php";




web hosting yang saya pake http://www.idhostinger.com/

http://reportalfikr.16mb.com/
klo ini alamat web report saya jadi yang di isi mana ya pak bos

http://www.idhostinger.com/

atau

http://reportalfikr.16mb.com/


mohon di koreksi bos
di backup.bat saya isi

Code:
sleep 1
:loop
ftp -s:c:\pt.txt http://reportalfikr.16mb.com
ftp -s:c:\pt2.txt http://reportalfikr.16mb.com
sleep 60
goto loop


Pros.php saya isi :


Code:

<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
redirTime = "5000";
redirURL = "pros.php";
function redirTimer() { self.setTimeout("self.location.href = redirURL;",redirTime); }
//  End -->
</script>


<!-- STEP TWO: Insert the onLoad event handler into your BODY tag  -->

<BODY onLoad="redirTimer()">
<?
        $dbHost = "localhost";                      // Database pc
  $dbName = "pulsaq";                        // Database name pc
  $dbUser = "root";                            // Database user  pc
  $dbPasswd = "123456";                    // Database password pc
function dbConnect()
  {
      global $dbHost, $dbUser, $dbPasswd, $dbName;
      mysql_connect( $dbHost, $dbUser, $dbPasswd ) or error( mysql_error() );
      mysql_select_db( $dbName );
  }
dbConnect();

//======back up transaksi1
$tanggal=date("Y-m-d");
$end = mysql_query("SELECT * FROM inbox ORDER by id DESC");
$bc = mysql_fetch_array($end);
$bidang="$bc[datetime]";
$kata_depan=substr($bidang,0,10);
$get_millis = mysql_query("SELECT * FROM transaksi WHERE status='1' && datetime_transaksi LIKE '$kata_depan%' ORDER BY id DESC");
while($row = mysql_fetch_array($get_millis))
      {
$isi = "mysql_query(\"INSERT INTO transaksi (id,kode_transaksi,datetime_sms,datetime_transaksi,kode_produk,tujuan,kode_reseller,hp_reseller,deposit_awal,deposit_akhir,harga_beli,harga_dasar,terminal,status,keterangan,ULANG,ketujuan,CEK,SW,harga_jual) VALUES ($row[id],'$row[kode_transaksi]','$row[datetime_sms]','$row[datetime_transaksi]','$row[kode_produk]','$row[tujuan]','$row[kode_reseller]','$row[hp_reseller]',$row[deposit_awal],$row[deposit_akhir],$row[harga_beli],$row[harga_dasar],$row[terminal],$row[status],'','$row[ULANG]','$row[ketujuan]','$row[CEK]','$row[SW]',$row[harga_jual])\");";
$isi_fileas .= $isi."\r\n";
      }
$get_milliso = mysql_query("SELECT * FROM transaksi WHERE status='0' && datetime_transaksi LIKE '$kata_depan%' ORDER BY id DESC");
while($rowo = mysql_fetch_array($get_milliso))
      {
$isio = "mysql_query(\"UPDATE transaksi SET status='0' where id='$rowo[id]'\");";
$isi_fileaso .= $isio."\r\n";
      }

$iss1="
<SCRIPT LANGUAGE=\"JavaScript\">


<!-- Begin
redirTime = \"60000\";
redirURL = \"bu_trx.php\";
function redirTimer() { self.setTimeout(\"self.location.href = redirURL;\",redirTime); }
//  End -->
</script>
<BODY onLoad=\"redirTimer()\">
<form id=\"data\" name=\"data\" method=\"post\" enctype=\"multipart/form-data\" action=\"dbu.php\">
  <div align=\"center\">
  <input type=\"submit\"  name=\"Submit\" value=\"tekan\" >
  </p>
  </div>
</form>
<?
$dbHost = \"mysql.idhostinger.com\";                // Database 000webhost.com
$dbName = \"u5094821_pulsaq\";                        // Database name 000webhost.com
$dbUser = \"u5094821_pulsaq\";                            // Database user 000webhost.com
$dbPasswd = \"123456\";                                    // Database password 000webhost.com
function dbConnect()
  {
      global $dbHost, $dbUser, $dbPasswd, $dbName;
      mysql_connect( $dbHost, $dbUser, $dbPasswd ) or error( mysql_error() );
      mysql_select_db( $dbName );
  }
dbConnect();
";
$iss2="
?>
<font color=\"#FF0000\"><strong><blink>INJEK DATA is Runing............!!!</blink></strong></font> ";

//======hpreseller
$get_millis2 = mysql_query("SELECT * FROM hp_reseller  ORDER BY id DESC");
  while($row = mysql_fetch_array($get_millis2))
      {
$isi2 = "INSERT INTO hp_reseller VALUES ($row[id],'$row[kode_reseller]','$row[hp]','$row[challenge]','');";
$hpres .= $isi2."\r\n";
      }
     
//======produk
$get_millis3 = mysql_query("SELECT * FROM produk  ORDER BY id DESC");
  while($row = mysql_fetch_array($get_millis3))
      {
$isi3 = "INSERT INTO produk VALUES ($row[id],'$row[kode_produk]','$row[nama_produk]',$row[harga_jual],$row[harga_beli],$row[stok],$row[status],$row[counter],$row[tipe],'');";
$produk .= $isi3."\r\n";
      }
     
//======reseller
$get_millis4 = mysql_query("SELECT * FROM reseller  ORDER BY id DESC");
  while($row = mysql_fetch_array($get_millis4))
      {
$isi4 = "INSERT INTO reseller VALUES ($row[id],'$row[kode_reseller]','$row[nama_reseller]',$row[deposit],'$row[alamat]','$row[pin]',$row[status],$row[manual],$row[terminal],'$row[kode_upline]',$row[level],'$row[kode_kelompok]','$row[CATATAN]');";
$res .= $isi4."\r\n";
      }
     

$fps = fopen('c:/bu_trx.php', 'w');
fwrite($fps, $iss1);
fwrite($fps, $isi_fileas);
fwrite($fps, $isi_fileaso);
fwrite($fps, $iss2);
fclose($fps);

$fp2 = fopen('c:/dbmember.sql', 'w');
fwrite($fp2, $hpres);
fwrite($fp2, $produk);
fwrite($fp2, $res);
fclose($fp2);
  exit;


?>
<font color="#FF0000"><strong><blink>BACK UP DATA is Runing............!!!</blink></strong></font>

dbu.php saya isi

Code:


    <?
    $dbHost = \"mysql.idhostinger.com\";                // Database 000webhost.com
    $dbName = \"u5094821_pulsaq\";                  // Database name 000webhost.com
    $dbUser = \"u5094821_pulsaq\";                  // Database user 000webhost.com
    $dbPasswd = \"123456\";                // Database password 000webhost.com
    function dbConnect()
      {
          global $dbHost, $dbUser, $dbPasswd, $dbName;
          mysql_connect( $dbHost, $dbUser, $dbPasswd ) or error( mysql_error() );
          mysql_select_db( $dbName );
      }
    dbConnect();

    mysql_query("DROP TABLE hp_reseller");
    mysql_query("CREATE TABLE `hp_reseller` (
      `id` bigint(20) NOT NULL auto_increment,
      `kode_reseller` varchar(10) default NULL,
      `hp` varchar(100) default NULL,
      `challenge` varchar(100) NOT NULL default '',
      `opr` varchar(50) NOT NULL default '',
      PRIMARY KEY  (`id`),
      UNIQUE KEY `id` (`id`),
      KEY `id_2` (`id`)
    )") ;

    mysql_query("DROP TABLE produk");
    mysql_query("CREATE TABLE `produk` (
      `id` bigint(20) NOT NULL auto_increment,
      `kode_produk` varchar(10) NOT NULL default '',
      `nama_produk` varchar(150) default NULL,
      `harga_jual` double default '0',
      `harga_beli` double default '0',
      `stok` double default '0',
      `status` int(10) unsigned default '0',
      `counter` int(4) unsigned default '1',
      `tipe` tinyint(1) unsigned default '0',
      `kode_opr` varchar(20) NOT NULL default '',
      PRIMARY KEY  (`kode_produk`),
      UNIQUE KEY `id` (`id`,`kode_produk`),
      KEY `id_2` (`id`)
    )") ;

    mysql_query("DROP TABLE reseller");
    mysql_query("CREATE TABLE `reseller` (
      `id` bigint(20) NOT NULL auto_increment,
      `kode_reseller` varchar(10) NOT NULL default '',
      `nama_reseller` varchar(120) NOT NULL default '',
      `deposit` double NOT NULL default '0',
      `alamat` varchar(120) NOT NULL default '',
      `pin` varchar(25) NOT NULL default '',
      `status` tinyint(1) unsigned NOT NULL default '0',
      `manual` tinyint(1) unsigned NOT NULL default '0',
      `terminal` tinyint(3) unsigned NOT NULL default '1',
      `kode_upline` varchar(20) NOT NULL default '',
      `level` int(6) unsigned NOT NULL default '0',
      `kode_kelompok` varchar(16) NOT NULL default '',
      `CATATAN` varchar(200) NOT NULL default 'thanks',
      PRIMARY KEY  (`id`),
      UNIQUE KEY `id` (`id`,`kode_reseller`),
      KEY `id_2` (`id`)
    )") ;

                           
                $helper = "[#%int!g%#]"; //helper
                if (file_exists("dbmember.sql"))
                {
                  $f = implode("",file("dbmember.sql"));
                  $f = explode("INSERT INTO",$f);

                  for ($i=1; $i<count($f); $i++)
                  {
                      mysql_query("INSERT INTO ".str_replace($helper,"INSERT INTO",$f[$i]));
                      //echo"$f[$i]";
                  }
                }
               

    header("location:http://www.idhostinger.com/bu_trx.php");

    ?>


pt.txt saya isi



Code:
******s03@gmail.com
******123456
cd public_html/
put C:/bu_trx.php
bye



Pt2.txt
Code:
******s03@gmail.com
******123456
cd public_html/
put C:/dbmember.sql
bye


untuk penempatan file php :





Mohon pencerahannnya Master...........
avatar
pandaris03
Member Tetap
Member Tetap

Jumlah posting : 134
Points : 153
Reputation : 1
Join date : 21.12.11
Lokasi : www.centerpulsa.tk Balerante Palimanan Cirebon Jawa Barat

Lihat profil user http://centerpulza.tk

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by pandaris03 on Thu Apr 05, 2012 5:00 pm

Cpanel di web hosting saya ini bukan ya....




saya ga tahu mana nich yang di pilih



Mohon Petunjuk............
avatar
pandaris03
Member Tetap
Member Tetap

Jumlah posting : 134
Points : 153
Reputation : 1
Join date : 21.12.11
Lokasi : www.centerpulsa.tk Balerante Palimanan Cirebon Jawa Barat

Lihat profil user http://centerpulza.tk

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by b1u on Fri Apr 06, 2012 12:28 am

pandaris03 wrote:Cpanel di web hosting saya ini bukan ya....


Mohon Petunjuk............

nah itu..... klik aja FTP access atau FTP account... disitu lengkap data server FTP namanya apa?

coba pakek=server2.idhostinger.com uk BACKUP.BAT
ftp -s:c:\pt.txt server2.idhostinger.com
ftp -s:c:\pt2.txt server2.idhostinger.com

dan uk pt.txt dan pt2txt ditulisan cd public_html/ di ganti => cd home/u551094821

yg benar ==>header("location:http://www.reportalfikr.16mb.com/bu_trx.php");


avatar
b1u
Member Tetap
Member Tetap

Jumlah posting : 51
Points : 56
Reputation : 1
Birthday : 09.02.79
Join date : 29.12.11
Age : 38
Lokasi : MALANG

Lihat profil user http://pulsa.net76.net/

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by pandaris03 on Fri Apr 06, 2012 7:26 am

b1u wrote:

nah itu..... klik aja FTP access atau FTP account... disitu lengkap data server FTP namanya apa?

coba pakek=server2.idhostinger.com uk BACKUP.BAT
ftp -s:c:\pt.txt server2.idhostinger.com
ftp -s:c:\pt2.txt server2.idhostinger.com

dan uk pt.txt dan pt2txt ditulisan cd public_html/ di ganti => cd home/u551094821

yg benar ==>header("location:http://www.reportalfikr.16mb.com/bu_trx.php");



Ok thank Master

apakah ini artinya berhasil dan sukses





untuk cek BUKTI BERHASILNYA GMANA YA MASTER

KARENA SAYA CEK.... DI reportalfikr.16mb.com status transaksi nya belum up to date?????????

Rinciannya :

file BACKUP.bat, pt.txt, pt2.txt sleep.exe saya pasang d C:\

File ndex.php dan pros.php saya pasang di C:\AppServ\www\BU

file dbu.php saya uplod bareng dengan file-file web report

user di pt.txt dan pt2.txt = user ftp
pass di pt.txt dan pt2.txt = pass ftp

yang saya jalankan secara bersamaan adalah :

http://localhost/BU/index.php dan file backup.bat

salahnya di mana ya.............



data di webhosting (dbmemeber.sql sudah ada di public_html atau reportalfikr.16mb.com/public_html/



___________________________________________________________________
-----------------------------------------------------------------------------



Mohon pencerahan lebh lanjut....
avatar
pandaris03
Member Tetap
Member Tetap

Jumlah posting : 134
Points : 153
Reputation : 1
Join date : 21.12.11
Lokasi : www.centerpulsa.tk Balerante Palimanan Cirebon Jawa Barat

Lihat profil user http://centerpulza.tk

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by b1u on Fri Apr 06, 2012 11:13 pm

pandaris03 wrote:

Mohon pencerahan lebh lanjut....

seep gan...2 file sudah terkirim di hosting. tinggal koneksi MYSQL di hosting nya yg masih gagal.
1. coba edit file pros.php kurang tanda "\"
ubah ketikannya dg ini pada tulisan:
Code:

\$dbHost = \"mysql.idhostinger.com\";                // Database 000webhost.com
\$dbName = \"u5094821_pulsaq\";                        // Database name 000webhost.com
\$dbUser = \"u5094821_pulsaq\";                            // Database user 000webhost.com
\$dbPasswd = \"123456\";                                    // Database password 000webhost.com
function dbConnect()
  {
      global \$dbHost, \$dbUser, \$dbPasswd, \$dbName;
      mysql_connect( \$dbHost, \$dbUser, \$dbPasswd ) or error( mysql_error() );
      mysql_select_db( \$dbName );
  }
dan tulisan ini juga di rubah (copy paste aja):
Code:
<center><font color=\"#FF0000\"><strong><blink>INJEK DATA is Runing............!!!</blink></strong></font></center> ";

2. di index.php di edit juga uk tulisan ini (copy paste aja):
Code:
<div align="center" >
<iframe src="http://reportalfikr.16mb.com/bu_trx.php" style="background-color:#CCCCCC;  " height="100" width="300" frameborder="10" > </iframe>
</div>
  <br>
semoga BERHASIL.....
avatar
b1u
Member Tetap
Member Tetap

Jumlah posting : 51
Points : 56
Reputation : 1
Birthday : 09.02.79
Join date : 29.12.11
Age : 38
Lokasi : MALANG

Lihat profil user http://pulsa.net76.net/

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by pandaris03 on Sat Apr 07, 2012 7:48 am

b1u wrote:
pandaris03 wrote:

Mohon pencerahan lebh lanjut....

seep gan...2 file sudah terkirim di hosting. tinggal koneksi MYSQL di hosting nya yg masih gagal.
1. coba edit file pros.php kurang tanda "\"
ubah ketikannya dg ini pada tulisan:
Code:

\$dbHost = \"mysql.idhostinger.com\";                // Database 000webhost.com
\$dbName = \"u5094821_pulsaq\";                        // Database name 000webhost.com
\$dbUser = \"u5094821_pulsaq\";                            // Database user 000webhost.com
\$dbPasswd = \"123456\";                                    // Database password 000webhost.com
function dbConnect()
  {
      global \$dbHost, \$dbUser, \$dbPasswd, \$dbName;
      mysql_connect( \$dbHost, \$dbUser, \$dbPasswd ) or error( mysql_error() );
      mysql_select_db( \$dbName );
  }
dan tulisan ini juga di rubah (copy paste aja):
Code:
<center><font color=\"#FF0000\"><strong><blink>INJEK DATA is Runing............!!!</blink></strong></font></center> ";

2. di index.php di edit juga uk tulisan ini (copy paste aja):
Code:
<div align="center" >
<iframe src="http://reportalfikr.16mb.com/bu_trx.php" style="background-color:#CCCCCC;  " height="100" width="300" frameborder="10" > </iframe>
</div>
  <br>
semoga BERHASIL.....

saya coba master
===============

PROS.PHP


Code:
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
redirTime = "5000";
redirURL = "pros.php";
function redirTimer() { self.setTimeout("self.location.href = redirURL;",redirTime); }
//  End -->
</script>


<!-- STEP TWO: Insert the onLoad event handler into your BODY tag  -->

<BODY onLoad="redirTimer()">
<?

  $dbHost = "localhost";                      // Database pc
  $dbName = "pulsaq";                        // Database name pc
  $dbUser = "root";                            // Database user  pc
  $dbPasswd = "1";                    // Database password pc
function dbConnect()
  {
      global $dbHost, $dbUser, $dbPasswd, $dbName;
      mysql_connect( $dbHost, $dbUser, $dbPasswd ) or error( mysql_error() );
      mysql_select_db( $dbName );
  }
dbConnect();

//======back up transaksi1
$tanggal=date("Y-m-d");
$end = mysql_query("SELECT * FROM inbox ORDER by id DESC");
$bc = mysql_fetch_array($end);
$bidang="$bc[datetime]";
$kata_depan=substr($bidang,0,10);
$get_millis = mysql_query("SELECT * FROM transaksi WHERE status='1' && datetime_transaksi LIKE '$kata_depan%' ORDER BY id

DESC");
while($row = mysql_fetch_array($get_millis))
      {
$isi = "mysql_query(\"INSERT INTO transaksi

(id,kode_transaksi,datetime_sms,datetime_transaksi,kode_produk,tujuan,kode_reseller,hp_reseller,deposit_awal,deposit_akhir,ha

rga_beli,harga_dasar,terminal,status,keterangan,ULANG,ketujuan,CEK,SW,harga_jual) VALUES ($row[id],'$row

[kode_transaksi]','$row[datetime_sms]','$row[datetime_transaksi]','$row[kode_produk]','$row[tujuan]','$row

[kode_reseller]','$row[hp_reseller]',$row[deposit_awal],$row[deposit_akhir],$row[harga_beli],$row[harga_dasar],$row

[terminal],$row[status],'','$row[ULANG]','$row[ketujuan]','$row[CEK]','$row[SW]',$row[harga_jual])\");";
$isi_fileas .= $isi."\r\n";
      }
$get_milliso = mysql_query("SELECT * FROM transaksi WHERE status='0' && datetime_transaksi LIKE '$kata_depan%' ORDER BY id

DESC");
while($rowo = mysql_fetch_array($get_milliso))
      {
$isio = "mysql_query(\"UPDATE transaksi SET status='0' where id='$rowo[id]'\");";
$isi_fileaso .= $isio."\r\n";
      }

$iss1="
<SCRIPT LANGUAGE=\"JavaScript\">


<!-- Begin
redirTime = \"60000\";
redirURL = \"bu_trx.php\";
function redirTimer() { self.setTimeout(\"self.location.href = redirURL;\",redirTime); }
//  End -->
</script>
<BODY onLoad=\"redirTimer()\">
<form id=\"data\" name=\"data\" method=\"post\" enctype=\"multipart/form-data\" action=\"dbu.php\">
  <div align=\"center\">
  <input type=\"submit\"  name=\"Submit\" value=\"tekan\" >
  </p>
  </div>
</form>
<?

\$dbHost = \"mysql.idhostinger.com\";                // Database 000webhost.com
\$dbName = \"u5094821_pulsaq\";                        // Database name 000webhost.com
\$dbUser = \"u5094821_pulsaq\";                            // Database user 000webhost.com
\$dbPasswd = \"123456\";                                    // Database password 000webhost.com
function dbConnect()
  {
      global \$dbHost, \$dbUser, \$dbPasswd, \$dbName;
      mysql_connect( \$dbHost, \$dbUser, \$dbPasswd ) or error( mysql_error() );
      mysql_select_db( \$dbName );
$iss2="
?>
<center><font color=\"#FF0000\"><strong><blink>INJEK DATA is Runing............!!!</blink></strong></font></center>


//======hpreseller

$get_millis2 = mysql_query("SELECT * FROM hp_reseller  ORDER BY id DESC");
  while($row = mysql_fetch_array($get_millis2))
      {
$isi2 = "INSERT INTO hp_reseller VALUES ($row[id],'$row[kode_reseller]','$row[hp]','$row[challenge]','');";
$hpres .= $isi2."\r\n";
      }
     
//======produk
$get_millis3 = mysql_query("SELECT * FROM produk  ORDER BY id DESC");
  while($row = mysql_fetch_array($get_millis3))
      {
$isi3 = "INSERT INTO produk VALUES ($row[id],'$row[kode_produk]','$row[nama_produk]',$row[harga_jual],$row[harga_beli],$row

[stok],$row[status],$row[counter],$row[tipe],'');";
$produk .= $isi3."\r\n";
      }
     
//======reseller
$get_millis4 = mysql_query("SELECT * FROM reseller  ORDER BY id DESC");
  while($row = mysql_fetch_array($get_millis4))
      {
$isi4 = "INSERT INTO reseller VALUES ($row[id],'$row[kode_reseller]','$row[nama_reseller]',$row[deposit],'$row

[alamat]','$row[pin]',$row[status],$row[manual],$row[terminal],'$row[kode_upline]',$row[level],'$row[kode_kelompok]','$row

[CATATAN]');";
$res .= $isi4."\r\n";
      }
     

$fps = fopen('c:/bu_trx.php', 'w');
fwrite($fps, $iss1);
fwrite($fps, $isi_fileas);
fwrite($fps, $isi_fileaso);
fwrite($fps, $iss2);
fclose($fps);

$fp2 = fopen('c:/dbmember.sql', 'w');
fwrite($fp2, $hpres);
fwrite($fp2, $produk);
fwrite($fp2, $res);
fclose($fp2);
  exit;


?>
<font color="#FF0000"><strong><blink>BACK UP DATA is Runing............!!!</blink></strong></font>



http://localhost/BU/index.php


frame ATAS
Code:
INJEK DATA is Runing............!!!
//======hpreseller $get_millis2 = mysql_query("SELECT * FROM hp_reseller ORDER BY id DESC"); while($row = mysql_fetch_array($get_millis2)) { $isi2 = "INSERT INTO hp_reseller VALUES ($row[id],'$row[kode_reseller]','$row[hp]','$row[challenge]','');"; $hpres .= $isi2."\r\n"; } //======produk $get_millis3 = mysql_query("SELECT * FROM produk ORDER BY id DESC"); while($row = mysql_fetch_array($get_millis3)) { $isi3 = "INSERT INTO produk VALUES ($row[id],'$row[kode_produk]','$row[nama_produk]',$row[harga_jual],$row[harga_beli],$row[stok],$row[status],$row[counter],$row[tipe],'');"; $produk .= $isi3."\r\n"; } //======reseller $get_millis4 = mysql_query("SELECT * FROM reseller ORDER BY id DESC"); while($row = mysql_fetch_array($get_millis4)) { $isi4 = "INSERT INTO reseller VALUES ($row[id],'$row[kode_reseller]','$row[nama_reseller]',$row[deposit],'$row[alamat]','$row[pin]',$row[status],$row[manual],$row[terminal],'$row[kode_upline]',$row[level],'$row[kode_kelompok]','$row[CATATAN]');"; $res .= $isi4."\r\n"; } $fps = fopen('c:/bu_trx.php', 'w'); fwrite($fps, $iss1); fwrite($fps, $isi_fileas); fwrite($fps, $isi_fileaso); fwrite($fps, $iss2); fclose($fps); $fp2 = fopen('c:/dbmember.sql', 'w'); fwrite($fp2, $hpres); fwrite($fp2, $produk); fwrite($fp2, $res); fclose($fp2); exit; ?> BACK UP DATA is Runing............!!!


frame bawah

Code:

Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/u5094821/public_html/bu_trx.php on line 27

Parse error: syntax error, unexpected T_STRING, expecting T_VARIABLE or '$' in /home/u5094821/public_html/bu_trx.php on line 27

belum up todate master saya coba 60 menit berjalan

[code]
avatar
pandaris03
Member Tetap
Member Tetap

Jumlah posting : 134
Points : 153
Reputation : 1
Join date : 21.12.11
Lokasi : www.centerpulsa.tk Balerante Palimanan Cirebon Jawa Barat

Lihat profil user http://centerpulza.tk

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by b1u on Sat Apr 07, 2012 1:30 pm

yah... itu tulisan pada file pros.php kok ada yg dihilangi... makanya GAGAL (mhn agak teliti)


silahkan di copy lagi isi file pros.php (sdh dibenahi) dan ganti alamat+pass database-databasenya
Code:

<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
redirTime = "5000";
redirURL = "pros.php";
function redirTimer() { self.setTimeout("self.location.href = redirURL;",redirTime); }
//  End -->
</script>


<!-- STEP TWO: Insert the onLoad event handler into your BODY tag  -->

<BODY onLoad="redirTimer()">
<?
        $dbHost = "localhost";                      // Database pc
  $dbName = "pulsaq";                        // Database name pc
  $dbUser = "aku";                            // Database user  pc
  $dbPasswd = "12345";                    // Database password pc
function dbConnect()
  {
      global $dbHost, $dbUser, $dbPasswd, $dbName;
      mysql_connect( $dbHost, $dbUser, $dbPasswd ) or error( mysql_error() );
      mysql_select_db( $dbName );
  }
dbConnect();

//======back up transaksi1
$tanggal=date("Y-m-d");
$end = mysql_query("SELECT * FROM inbox ORDER by id DESC");
$bc = mysql_fetch_array($end);
$bidang="$bc[datetime]";
$kata_depan=substr($bidang,0,10);
$get_millis = mysql_query("SELECT * FROM transaksi WHERE status='1' && datetime_transaksi LIKE '$kata_depan%' ORDER BY id DESC");
while($row = mysql_fetch_array($get_millis))
      {
$isi = "mysql_query(\"INSERT INTO transaksi (id,kode_transaksi,datetime_sms,datetime_transaksi,kode_produk,tujuan,kode_reseller,hp_reseller,deposit_awal,deposit_akhir,harga_beli,harga_dasar,terminal,status,keterangan,ULANG,ketujuan,CEK,SW,harga_jual) VALUES ($row[id],'$row[kode_transaksi]','$row[datetime_sms]','$row[datetime_transaksi]','$row[kode_produk]','$row[tujuan]','$row[kode_reseller]','$row[hp_reseller]',$row[deposit_awal],$row[deposit_akhir],$row[harga_beli],$row[harga_dasar],$row[terminal],$row[status],'','$row[ULANG]','$row[ketujuan]','$row[CEK]','$row[SW]',$row[harga_jual])\");";
$isi_fileas .= $isi."\r\n";
      }
$get_milliso = mysql_query("SELECT * FROM transaksi WHERE status='0' && datetime_transaksi LIKE '$kata_depan%' ORDER BY id DESC");
while($rowo = mysql_fetch_array($get_milliso))
      {
$isio = "mysql_query(\"UPDATE transaksi SET status='0' where id='$rowo[id]'\");";
$isi_fileaso .= $isio."\r\n";
      }

$iss1="
<SCRIPT LANGUAGE=\"JavaScript\">


<!-- Begin
redirTime = \"60000\";
redirURL = \"bu_trx.php\";
function redirTimer() { self.setTimeout(\"self.location.href = redirURL;\",redirTime); }
//  End -->
</script>
<BODY onLoad=\"redirTimer()\">
<form id=\"data\" name=\"data\" method=\"post\" enctype=\"multipart/form-data\" action=\"dbu.php\">
  <div align=\"center\">
  <input type=\"submit\"  name=\"Submit\" value=\"tekan\" >
  </p>
  </div>
</form>
<?
\$dbHost = \"mysql2.000webhost.com\";                // Database 000webhost.com
\$dbName = \"a4851111_pulsaq\";                        // Database name 000webhost.com
\$dbUser = \"aku\";                                          // Database user 000webhost.com
\$dbPasswd = \"12345\";                                    // Database password 000webhost.com
function dbConnect()
  {
      global \$dbHost, \$dbUser, \$dbPasswd, \$dbName;
      mysql_connect( \$dbHost, \$dbUser, \$dbPasswd ) or error( mysql_error() );
      mysql_select_db( \$dbName );
  }
dbConnect();
";
$iss2="
?>
<center><font color=\"#FF0000\"><strong><blink>INJEK DATA is Runing............!!!</blink></strong></font></center> ";

//======hpreseller
$get_millis2 = mysql_query("SELECT * FROM hp_reseller  ORDER BY id DESC");
  while($row = mysql_fetch_array($get_millis2))
      {
$isi2 = "INSERT INTO hp_reseller VALUES ($row[id],'$row[kode_reseller]','$row[hp]','$row[challenge]','');";
$hpres .= $isi2."\r\n";
      }
     
//======produk
$get_millis3 = mysql_query("SELECT * FROM produk  ORDER BY id DESC");
  while($row = mysql_fetch_array($get_millis3))
      {
$isi3 = "INSERT INTO produk VALUES ($row[id],'$row[kode_produk]','$row[nama_produk]',$row[harga_jual],$row[harga_beli],$row[stok],$row[status],$row[counter],$row[tipe],'');";
$produk .= $isi3."\r\n";
      }
     
//======reseller
$get_millis4 = mysql_query("SELECT * FROM reseller  ORDER BY id DESC");
  while($row = mysql_fetch_array($get_millis4))
      {
$isi4 = "INSERT INTO reseller VALUES ($row[id],'$row[kode_reseller]','$row[nama_reseller]',$row[deposit],'$row[alamat]','$row[pin]',$row[status],$row[manual],$row[terminal],'$row[kode_upline]',$row[level],'$row[kode_kelompok]','$row[CATATAN]');";
$res .= $isi4."\r\n";
      }
     

$fps = fopen('c:/bu_trx.php', 'w');
fwrite($fps, $iss1);
fwrite($fps, $isi_fileas);
fwrite($fps, $isi_fileaso);
fwrite($fps, $iss2);
fclose($fps);

$fp2 = fopen('c:/dbmember.sql', 'w');
fwrite($fp2, $hpres);
fwrite($fp2, $produk);
fwrite($fp2, $res);
fclose($fp2);
  exit;


?>
<font color="#FF0000"><strong><blink>BACK UP DATA is Runing............!!!</blink></strong></font>


avatar
b1u
Member Tetap
Member Tetap

Jumlah posting : 51
Points : 56
Reputation : 1
Birthday : 09.02.79
Join date : 29.12.11
Age : 38
Lokasi : MALANG

Lihat profil user http://pulsa.net76.net/

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by pandaris03 on Sat Apr 07, 2012 3:17 pm

b1u wrote:yah... itu tulisan pada file pros.php kok ada yg dihilangi... makanya GAGAL (mhn agak teliti)


silahkan di copy lagi isi file pros.php (sdh dibenahi) dan ganti alamat+pass database-databasenya
Code:

<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
redirTime = "5000";
redirURL = "pros.php";
function redirTimer() { self.setTimeout("self.location.href = redirURL;",redirTime); }
//  End -->
</script>


<!-- STEP TWO: Insert the onLoad event handler into your BODY tag  -->

<BODY onLoad="redirTimer()">
<?
        $dbHost = "localhost";                      // Database pc
  $dbName = "pulsaq";                        // Database name pc
  $dbUser = "aku";                            // Database user  pc
  $dbPasswd = "12345";                    // Database password pc
function dbConnect()
  {
      global $dbHost, $dbUser, $dbPasswd, $dbName;
      mysql_connect( $dbHost, $dbUser, $dbPasswd ) or error( mysql_error() );
      mysql_select_db( $dbName );
  }
dbConnect();

//======back up transaksi1
$tanggal=date("Y-m-d");
$end = mysql_query("SELECT * FROM inbox ORDER by id DESC");
$bc = mysql_fetch_array($end);
$bidang="$bc[datetime]";
$kata_depan=substr($bidang,0,10);
$get_millis = mysql_query("SELECT * FROM transaksi WHERE status='1' && datetime_transaksi LIKE '$kata_depan%' ORDER BY id DESC");
while($row = mysql_fetch_array($get_millis))
      {
$isi = "mysql_query(\"INSERT INTO transaksi (id,kode_transaksi,datetime_sms,datetime_transaksi,kode_produk,tujuan,kode_reseller,hp_reseller,deposit_awal,deposit_akhir,harga_beli,harga_dasar,terminal,status,keterangan,ULANG,ketujuan,CEK,SW,harga_jual) VALUES ($row[id],'$row[kode_transaksi]','$row[datetime_sms]','$row[datetime_transaksi]','$row[kode_produk]','$row[tujuan]','$row[kode_reseller]','$row[hp_reseller]',$row[deposit_awal],$row[deposit_akhir],$row[harga_beli],$row[harga_dasar],$row[terminal],$row[status],'','$row[ULANG]','$row[ketujuan]','$row[CEK]','$row[SW]',$row[harga_jual])\");";
$isi_fileas .= $isi."\r\n";
      }
$get_milliso = mysql_query("SELECT * FROM transaksi WHERE status='0' && datetime_transaksi LIKE '$kata_depan%' ORDER BY id DESC");
while($rowo = mysql_fetch_array($get_milliso))
      {
$isio = "mysql_query(\"UPDATE transaksi SET status='0' where id='$rowo[id]'\");";
$isi_fileaso .= $isio."\r\n";
      }

$iss1="
<SCRIPT LANGUAGE=\"JavaScript\">


<!-- Begin
redirTime = \"60000\";
redirURL = \"bu_trx.php\";
function redirTimer() { self.setTimeout(\"self.location.href = redirURL;\",redirTime); }
//  End -->
</script>
<BODY onLoad=\"redirTimer()\">
<form id=\"data\" name=\"data\" method=\"post\" enctype=\"multipart/form-data\" action=\"dbu.php\">
  <div align=\"center\">
  <input type=\"submit\"  name=\"Submit\" value=\"tekan\" >
  </p>
  </div>
</form>
<?
\$dbHost = \"mysql2.000webhost.com\";                // Database 000webhost.com
\$dbName = \"a4851111_pulsaq\";                        // Database name 000webhost.com
\$dbUser = \"aku\";                                          // Database user 000webhost.com
\$dbPasswd = \"12345\";                                    // Database password 000webhost.com
function dbConnect()
  {
      global \$dbHost, \$dbUser, \$dbPasswd, \$dbName;
      mysql_connect( \$dbHost, \$dbUser, \$dbPasswd ) or error( mysql_error() );
      mysql_select_db( \$dbName );
  }
dbConnect();
";
$iss2="
?>
<center><font color=\"#FF0000\"><strong><blink>INJEK DATA is Runing............!!!</blink></strong></font></center> ";

//======hpreseller
$get_millis2 = mysql_query("SELECT * FROM hp_reseller  ORDER BY id DESC");
  while($row = mysql_fetch_array($get_millis2))
      {
$isi2 = "INSERT INTO hp_reseller VALUES ($row[id],'$row[kode_reseller]','$row[hp]','$row[challenge]','');";
$hpres .= $isi2."\r\n";
      }
     
//======produk
$get_millis3 = mysql_query("SELECT * FROM produk  ORDER BY id DESC");
  while($row = mysql_fetch_array($get_millis3))
      {
$isi3 = "INSERT INTO produk VALUES ($row[id],'$row[kode_produk]','$row[nama_produk]',$row[harga_jual],$row[harga_beli],$row[stok],$row[status],$row[counter],$row[tipe],'');";
$produk .= $isi3."\r\n";
      }
     
//======reseller
$get_millis4 = mysql_query("SELECT * FROM reseller  ORDER BY id DESC");
  while($row = mysql_fetch_array($get_millis4))
      {
$isi4 = "INSERT INTO reseller VALUES ($row[id],'$row[kode_reseller]','$row[nama_reseller]',$row[deposit],'$row[alamat]','$row[pin]',$row[status],$row[manual],$row[terminal],'$row[kode_upline]',$row[level],'$row[kode_kelompok]','$row[CATATAN]');";
$res .= $isi4."\r\n";
      }
     

$fps = fopen('c:/bu_trx.php', 'w');
fwrite($fps, $iss1);
fwrite($fps, $isi_fileas);
fwrite($fps, $isi_fileaso);
fwrite($fps, $iss2);
fclose($fps);

$fp2 = fopen('c:/dbmember.sql', 'w');
fwrite($fp2, $hpres);
fwrite($fp2, $produk);
fwrite($fp2, $res);
fclose($fp2);
  exit;


?>
<font color="#FF0000"><strong><blink>BACK UP DATA is Runing............!!!</blink></strong></font>



bounce bounce bounce bounce bounce bounce bounce
What a Face What a Face What a Face What a Face What a Face What a Face What a Face What a Face What a Face What a Face

waduh maaf master atas ketidak telitiannya.............



Mantap Up to date........................



trimakasih atas kesabarannya membimbing newbie

di tunggu trik2 lainnya

Question Question Question Question Question Question Boleh ga ya request Scrip lainnya yang berhubungan dengan web report ini Question Question Question Question Question Question Question
avatar
pandaris03
Member Tetap
Member Tetap

Jumlah posting : 134
Points : 153
Reputation : 1
Join date : 21.12.11
Lokasi : www.centerpulsa.tk Balerante Palimanan Cirebon Jawa Barat

Lihat profil user http://centerpulza.tk

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by b1u on Sat Apr 07, 2012 3:41 pm

pandaris03 wrote:

bounce bounce bounce bounce bounce bounce bounce
What a Face What a Face What a Face What a Face What a Face What a Face What a Face What a Face What a Face What a Face

waduh maaf master atas ketidak telitiannya.............



Mantap Up to date........................



trimakasih atas kesabarannya membimbing newbie

di tunggu trik2 lainnya

Question Question Question Question Question Question Boleh ga ya request Scrip lainnya yang berhubungan dengan web report ini Question Question Question Question Question Question Question

mantaf gan..........
tkp ngaciiir dah webreportnya......

ini gan........!!!
file dbu.php di hosting juga ada yg salah... silahkan di benahi

avatar
b1u
Member Tetap
Member Tetap

Jumlah posting : 51
Points : 56
Reputation : 1
Birthday : 09.02.79
Join date : 29.12.11
Age : 38
Lokasi : MALANG

Lihat profil user http://pulsa.net76.net/

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by pandaris03 on Sat Apr 07, 2012 4:48 pm

b1u wrote:

mantaf gan..........
tkp ngaciiir dah webreportnya......

ini gan........!!!
file dbu.php di hosting juga ada yg salah... silahkan di benahi



Mantap bos.... setelah d benern scrptnya penampakan jadi seperti ini:



Trimakash Banyak Master................

trimakasih atas kesabarannya membimbing newbie

di tunggu trik2 lainnya

Boleh ga ya request Script lainnya yang berhubungan dengan web report ini
avatar
pandaris03
Member Tetap
Member Tetap

Jumlah posting : 134
Points : 153
Reputation : 1
Join date : 21.12.11
Lokasi : www.centerpulsa.tk Balerante Palimanan Cirebon Jawa Barat

Lihat profil user http://centerpulza.tk

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by wiensreloads on Fri Apr 13, 2012 6:31 pm


C:\>sleep 1

C:\>ftp -s:c:\pt.txt wiensuksesmandiri.co.cc
Connected to wiensuksesmandiri.co.cc.
220---------- Welcome to Pure-FTPd [privsep] ----------
220-You are user number 44 of 500 allowed.
220-Local time is now 07:06. Server port: 21.
220-This is a private system - No anonymous login
220 You will be disconnected after 3 minutes of inactivity.
User (wiensuksesmandiri.co.cc:(none)):
331 User u91xxxx OK. Password required

230 OK. Current restricted directory is /
ftp> cd public_html/
250 OK. Current directory is /public_html
ftp> put C:/bu_trx.php
200 PORT command successful
425 Could not open data connection to port 30350: Connection timed out
ftp> bye
221-Goodbye. You uploaded 0 and downloaded 0 kbytes.
221 Logout.

C:\>ftp -s:c:\pt2.txt wiensuksesmandiri.co.cc
Connected to server4.idhostinger.com.
220---------- Welcome to Pure-FTPd [privsep] ----------
220-You are user number 43 of 500 allowed.
220-Local time is now 07:06. Server port: 21.
220-This is a private system - No anonymous login
220 You will be disconnected after 3 minutes of inactivity.
User (server4.idhostinger.com:(none)):
331 User u9xxxxxx OK. Password required

230 OK. Current restricted directory is /
ftp> cd public_html/
250 OK. Current directory is /public_html
ftp> put C:/dbmember.sql
200 PORT command successful
425 Could not open data connection to port 49083: Connection timed out
ftp> bye
221-Goodbye. You uploaded 0 and downloaded 0 kbytes.
221 Logout.

C:\>sleep 120

mohon petunjuknya para master apanya yg salah? matur nuwun

wiensreloads
Member Baru
Member Baru

Jumlah posting : 8
Points : 8
Reputation : 0
Join date : 21.12.11

Lihat profil user

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by b1u on Sat Apr 14, 2012 11:56 am

wiensreloads wrote:
C:\>sleep 1

C:\>ftp -s:c:\pt.txt wiensuksesmandiri.co.cc
Connected to wiensuksesmandiri.co.cc.
220---------- Welcome to Pure-FTPd [privsep] ----------
220-You are user number 44 of 500 allowed.
220-Local time is now 07:06. Server port: 21.
220-This is a private system - No anonymous login
220 You will be disconnected after 3 minutes of inactivity.
User (wiensuksesmandiri.co.cc:(none)):
331 User u91xxxx OK. Password required

230 OK. Current restricted directory is /
ftp> cd public_html/
250 OK. Current directory is /public_html
ftp> put C:/bu_trx.php
200 PORT command successful
425 Could not open data connection to port 30350: Connection timed out
ftp> bye
221-Goodbye. You uploaded 0 and downloaded 0 kbytes.
221 Logout.

C:\>ftp -s:c:\pt2.txt wiensuksesmandiri.co.cc
Connected to server4.idhostinger.com.
220---------- Welcome to Pure-FTPd [privsep] ----------
220-You are user number 43 of 500 allowed.
220-Local time is now 07:06. Server port: 21.
220-This is a private system - No anonymous login
220 You will be disconnected after 3 minutes of inactivity.
User (server4.idhostinger.com:(none)):
331 User u9xxxxxx OK. Password required

230 OK. Current restricted directory is /
ftp> cd public_html/
250 OK. Current directory is /public_html
ftp> put C:/dbmember.sql
200 PORT command successful
425 Could not open data connection to port 49083: Connection timed out
ftp> bye
221-Goodbye. You uploaded 0 and downloaded 0 kbytes.
221 Logout.

C:\>sleep 120

mohon petunjuknya para master apanya yg salah? matur nuwun
coba firewallnya di open gan....
avatar
b1u
Member Tetap
Member Tetap

Jumlah posting : 51
Points : 56
Reputation : 1
Birthday : 09.02.79
Join date : 29.12.11
Age : 38
Lokasi : MALANG

Lihat profil user http://pulsa.net76.net/

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by wiensreloads on Sun Apr 15, 2012 3:39 am

Matur suwun Master BIU, setelah firewallnya di open langsung conek cheers cheers cheers
data udah bisa terkirim ke hosting up to date Mantabs..........pokoke
ditunggu trik untuk data inbox sm outbox biar up to date juga

food

wiensreloads
Member Baru
Member Baru

Jumlah posting : 8
Points : 8
Reputation : 0
Join date : 21.12.11

Lihat profil user

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by pandaris03 on Tue Apr 17, 2012 6:12 am

wiensreloads wrote:Matur suwun Master B1U, setelah firewallnya di open langsung conek cheers cheers cheers
data udah bisa terkirim ke hosting up to date Mantabs..........pokoke
ditunggu trik untuk data inbox sm outbox biar up to date juga


food

hehehehehe Mantap......

Betul Master B1U di tunggu Script untuk Upto Date DATA INBOX dan DATA OUTBOXNYA nya
avatar
pandaris03
Member Tetap
Member Tetap

Jumlah posting : 134
Points : 153
Reputation : 1
Join date : 21.12.11
Lokasi : www.centerpulsa.tk Balerante Palimanan Cirebon Jawa Barat

Lihat profil user http://centerpulza.tk

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by spiritforme on Fri May 11, 2012 11:18 am

// Database connection
define("EWRPT_CONN_HOST", 'mysql2.000webhost.com', TRUE); ---> masih bingung isi yg ini, diisi alamat webreport kita? Lihatnya di bagian mana?
avatar
spiritforme
Member Baru
Member Baru

Jumlah posting : 36
Points : 48
Reputation : 0
Birthday : 16.10.88
Join date : 22.12.11
Age : 29

Lihat profil user http://houseofmiracle.com

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by pandaris03 on Fri May 11, 2012 8:45 pm

spiritforme wrote:// Database connection
define("EWRPT_CONN_HOST", 'mysql2.000webhost.com', TRUE); ---> masih bingung isi yg ini, diisi alamat webreport kita? Lihatnya di bagian mana?


Klo Ane lihatnya dari sini bos (ada di properti DB Hostingnya) malum anean pakenya yang GRATISAN PUNYA

avatar
pandaris03
Member Tetap
Member Tetap

Jumlah posting : 134
Points : 153
Reputation : 1
Join date : 21.12.11
Lokasi : www.centerpulsa.tk Balerante Palimanan Cirebon Jawa Barat

Lihat profil user http://centerpulza.tk

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by spiritforme on Fri May 11, 2012 9:49 pm

Udh ketemu, ternyata diisi localhost Smile
Skrg tinggal sinkronisasi data antara komputer dengan yg ada di hosting.
Udh inject data dan backup.bat dijalanin, tp trx terakhir msh belum msk

Kalo begitu udh sukses belum?

Di browser buka localhost/BU, muncul :
Parse error: syntax error, unexpected $end in /home/public_html/webreport/bu_trx.php on line 250
avatar
spiritforme
Member Baru
Member Baru

Jumlah posting : 36
Points : 48
Reputation : 0
Birthday : 16.10.88
Join date : 22.12.11
Age : 29

Lihat profil user http://houseofmiracle.com

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by b1u on Tue May 15, 2012 6:42 am

spiritforme wrote:Udh ketemu, ternyata diisi localhost Smile
Skrg tinggal sinkronisasi data antara komputer dengan yg ada di hosting.
Udh inject data dan backup.bat dijalanin, tp trx terakhir msh belum msk

Kalo begitu udh sukses belum?

Di browser buka localhost/BU, muncul :
Parse error: syntax error, unexpected $end in /home/public_html/webreport/bu_trx.php on line 250

sdh bagus gan... pengiriman data ke hosting SUKSES, cuman sayang.... file bu_trx nya corrupt. penyebabnya biasanya ada kesalahan di pengetikan pada pros.php
maka dari itu webeportnya belum bisa terupdate.
dicek ulang ya gan....
avatar
b1u
Member Tetap
Member Tetap

Jumlah posting : 51
Points : 56
Reputation : 1
Birthday : 09.02.79
Join date : 29.12.11
Age : 38
Lokasi : MALANG

Lihat profil user http://pulsa.net76.net/

Kembali Ke Atas Go down

Re: Membuat Contact Form / HTML Form Untuk Web

Post by Sponsored content


Sponsored content


Kembali Ke Atas Go down

Halaman 2 dari 3 Previous  1, 2, 3  Next

Topik sebelumnya Topik selanjutnya Kembali Ke Atas

- Similar topics

 
Permissions in this forum:
Anda tidak dapat menjawab topik