Re: [toekangweb] remote upload?

On 10/22/05, greecian ruler <herodotusz@yahoo.com> wrote:
>
> guys, mau nanya nih..
>
> Apa bisa kita melakukan update database MySQL suatu
> server (misal letaknya di jakarta) dari sebuah web di
> lokasi berbeda (misal di bandung)?


Ya bisa mas. Tinggal di configure saja permission MySQLnya biar user bisa
diakses diluar localhost (server Jkt). Sebab secara de facto user root pass
kosong itu hostnya localhost. Trus phpnya tinggal buat connection ke MySql
tersebut.
http://id.php.net/mysql
<?php
// Connecting, selecting database
$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('my_database') or die('Could not select database');

// Performing SQL query
$query = 'SELECT * FROM my_table';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
?>

Host ya IP atau domain yg berisi MySQL itu, beserta user and pass. Selesai
deh.

> kemudian bagaimana
> jika dalam proses update juga terdapat file (gambar,
> misalnya) yang harus dikirim? apa bisa dilakukan
> peng-upload-an file secara remote ke home directory
> server di jakarta, padahal yang kita akses adalah
> suatu web di bandung?


Bisa juga, khan PHP bisa FTP juga. Atau kalau males ya pakai function copy()
saja, tapi hati2, nanti owner filenya bisa anonymous/none. Resikonya ya ndak
bisa dimanipulasi (delete etc).
http://id.php.net/ftp

<?php
// set up basic connection
$conn_id = ftp_connect($ftp_server);

// login with username and password
$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass);

// check connection
if ((!$conn_id) || (!$login_result)) {
echo "FTP connection has failed!";
echo "Attempted to connect to $ftp_server for user $ftp_user_name";
exit;
} else {
echo "Connected to $ftp_server, for user $ftp_user_name";
}

// upload the file
$upload = ftp_put($conn_id, $destination_file, $source_file, FTP_BINARY);

// check upload status
if (!$upload) {
echo "FTP upload has failed!";
} else {
echo "Uploaded $source_file to $ftp_server as $destination_file";
}

// close the FTP stream
ftp_close($conn_id);
?>



PS: ini saya asumsi programmingnya PHP karena pakai MySQL.

Terima kasih atas jawabannya.
>
>
>

--
Best regards,

Natali Ardianto

natali@ardianto.com


[Non-text portions of this message have been removed]



---
Website: http://toekangweb.or.id/
Arsip milis : http://groups.yahoo.com/group/toekangweb/messages

---

YAHOO! GROUPS LINKS

•  Visit your group "toekangweb" on the web.
   
•  To unsubscribe from this group, send an email to:
   toekangweb-unsubscribe@yahoogroups.com
   
•  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

---