Tolongin donk...
PHP neh...gw cupu kalo main coding...
<?php
session_start();
?>
<?php
$username = $_SESSION['username'];
$connect = mysql_connect("localhost", "root","") or die("Couldn't connect!");
mysql_select_db("phplogin")or die("Couldn't find db");
//$id = $_POST['studentList']; <--seharusnya pass ini dari page lain, tapi karena mo nge-test, gw dah disable ini...dan langsung hard code B1101 query dibawah
$to = mysql_query("SELECT `parentEmail` FROM `parent` WHERE parent.studentID = 'B1101'");
$subject = $_POST['subject'];
$message = $_POST['message'];
$send_contact=mail($to,$subject,$message);
if($send_contact){
echo "E-Mail is sent!";
}
else {
echo "ERROR";
}
?>
<?php
mysql_close();
?>
email yg gw kirim gk jalan dan ada error message
"Warning: mail() expects parameter 1 to be string, resource given in C:\xampp\htdocs\HTPP\send_contact.php on line 23
ERROR"
ini kenapa yak? query gw dah gw coba di phpmyadmin, jalan kok...gk masalah....
:'(
_/\_ thanks in advance
sorry ,tapi ga ngerti juga T_T
Quote from: Sol Capoeira on 07 January 2012, 05:09:37 PM
Tolongin donk...
PHP neh...gw cupu kalo main coding...
<?php
session_start();
?>
<?php
$username = $_SESSION['username'];
$connect = mysql_connect("localhost", "root","") or die("Couldn't connect!");
mysql_select_db("phplogin")or die("Couldn't find db");
//$id = $_POST['studentList']; <--seharusnya pass ini dari page lain, tapi karena mo nge-test, gw dah disable ini...dan langsung hard code B1101 query dibawah
$to = mysql_query("SELECT `parentEmail` FROM `parent` WHERE parent.studentID = 'B1101'");
$subject = $_POST['subject'];
$message = $_POST['message'];
$send_contact=mail($to,$subject,$message);
if($send_contact){
echo "E-Mail is sent!";
}
else {
echo "ERROR";
}
?>
<?php
mysql_close();
?>
email yg gw kirim gk jalan dan ada error message
"Warning: mail() expects parameter 1 to be string, resource given in C:\xampp\htdocs\HTPP\send_contact.php on line 23
ERROR"
ini kenapa yak? query gw dah gw coba di phpmyadmin, jalan kok...gk masalah....
:'(
_/\_ thanks in advance
Fungsi mail() memerlukan parameter string:
mail ( string to, string subject, string message [, string additional_headers [, string additional_parameters]] )
Sedangkan pd coding anda, variabel parameter $to yg digunakan pd fungsi mail() mengambil dari fungsi mysql_query() yg mengembalikan (return function-nya) resource:
resource mysql_query ( string query [, resource link_identifier] )
Seharusnya coding-nya diubah menjadi:
<?php
session_start();
?>
<?php
$username = $_SESSION['username'];
$connect = mysql_connect("localhost", "root","") or die("Couldn't connect!");
mysql_select_db("phplogin")or die("Couldn't find db");
//$id = $_POST['studentList']; <--seharusnya pass ini dari page lain, tapi karena mo nge-test, gw dah disable ini...dan langsung hard code B1101 query dibawah
$result = mysql_query("SELECT `parentEmail` FROM `parent` WHERE parent.studentID = 'B1101'");
$hsl_qry = mysql_fetch_array($result); // hasil query disimpan dlm var array
$to = $hsl_qry[0]; // array index pertama (0) menyimpan 'parentEmail' krn itu satu2nya field yg dipanggil dlm query SELECT di atas
$subject = $_POST['subject'];
$message = $_POST['message'];
$send_contact=mail($to,$subject,$message);
if($send_contact){
echo "E-Mail is sent!";
}
else {
echo "ERROR";
}
?>
<?php
mysql_close();
?>
Semoga bisa membantu....
OMG A LIFE SAVER!...
Semoga kamma baek loe berbuah...~~
thanks a lot..:)
one problem solved, now gw continue develop neh barang....kalo ada pertanyaan lage....aku post disini..hahhaa
thanks a lot buat petunjuknya
Problem baru neh bro...minta tunjuk ajar..~~
gw mo kirim multiple email, nah...cuma, ini kayakne cuma bisa kirim satu doank, perlu pake loop yak?
Note:
$radio <--radio button di page sebelum-nya, kalo value-nya = allParents, maka dia execute coding dibawah...
if ($radio == 'allParents'){
$result=mysql_query("SELECT`parentEmail` FROM `parent`");
$qry_result = mysql_fetch_array($result);
$to = $qry_result[0];
$subject = $_POST['subject'];
$message = $_POST['message'];
$send_contact=mail($to,$subject,$message);
}
sekarang gw coba masukin while loop ke coding diatas...
if ($radio == 'allParents'){
$result=mysql_query("SELECT`parentEmail` FROM `parent`");
<?php
while($qry_result=mysql_fetch_array($result)){
?>
$to = $qry_result[0];
$subject = $_POST['subject'];
$message = $_POST['message'];
$send_contact=mail($to,$subject,$message);
}
<?php
}
?>
jujur, gw gk ngerti pake while loop di PHP...:( makin liat makin pusing... :(
mohon petunjuknya~.... ;)
Ya, benar pake looping. Saya liat codingnya udah benar dan tidak akan ada masalah, kecuali tanpa pembuka dan penutup coding php nya yang terlalu banyak.
Kalo subject dan message-nya sama, gak perlu di dalam looping, keluarkan aja:
<?php
if ($radio == 'allParents'){
$result=mysql_query("SELECT`parentEmail` FROM `parent`");
$subject = $_POST['subject'];
$message = $_POST['message'];
while($qry_result=mysql_fetch_array($result)){
$to = $qry_result[0];
$send_contact=mail($to,$subject,$message);
} // end while
} // end if
?>
Quote from: ariyakumara on 08 January 2012, 10:59:13 AM
Ya, benar pake looping. Saya liat codingnya udah benar dan tidak akan ada masalah, kecuali tanpa pembuka dan penutup coding php nya yang terlalu banyak.
Kalo subject dan message-nya sama, gak perlu di dalam looping, keluarkan aja:
<?php
if ($radio == 'allParents'){
$result=mysql_query("SELECT`parentEmail` FROM `parent`");
$subject = $_POST['subject'];
$message = $_POST['message'];
while($qry_result=mysql_fetch_array($result)){
$to = $qry_result[0];
$send_contact=mail($to,$subject,$message);
} // end while
} // end if
?>
thanks banget bro...dah jalan!
makane kemaren malem, gw liat..kayakne dah bener while loop-nya, tapi kok gk bisa..=_="
gw gk pernah belajar PHP di Uni gw...tiba2 disuruh buat system pake PHP..haizz..=_="
sering2 kirim GRP buat Om Seniya ^:)^
Bro, skarang coding dah beres ;D
ada masalah baru, masalah cosmetic aja sih... :)
Setiap murid ada kelas masing2, nah di case ini, 1 kelas ada 2 murid (BIS306 ada 2 murid)...
(https://forum.dhammacitta.org/proxy.php?request=http%3A%2F%2Fi1180.photobucket.com%2Falbums%2Fx416%2Fjeffrey2530%2FCapture1.png&hash=01e0e37d2711ce6c0c1f1ec9ab8cb461ec51b162)
pas display di listbox malah keluar 2 BIS306...=_="
gw mau-nya subject ID cuma 1, jadi gk double BIS306...khan jelek kalo ada double gitu, kalo 100 murid, ada 100 BIS306 donk... :o
(https://forum.dhammacitta.org/proxy.php?request=http%3A%2F%2Fi1180.photobucket.com%2Falbums%2Fx416%2Fjeffrey2530%2FCapture2.png&hash=c012761da3b42fd912d88f8b79a97216fee87d9c)
coding gw buat listbox itu...
$result2 = mysql_query("SELECT `subjectID` FROM assesment");
<input type="radio" name="radio" id="radio" value="subjectOnly" />
<label for="subjectOnly"></label>Send by Subject ID, Please select Subject ID <select name="subjectList" id="subjectList">
<?php
while($rows=mysql_fetch_array($result2)){
?>
<option><? echo $rows['subjectID']; ?></option>
<?php
}
?>
</select>
gw terpaksa nanya lage, soale gw gk tao mo gmana search di google buat problem ini....dah coba keyword "merge item in listbox php", "combine values in listbox php", etc....tetep aja gk ada jawapan... :'(
Thanks again yak~
Quote from: Mas Tidar on 08 January 2012, 12:59:55 PM
sering2 kirim GRP buat Om Seniya ^:)^
dah kirim kemaren...:) tapi, gk bisa kirim lage, perlu nunggu time restriction-nya...:)
Quote from: Sol Capoeira on 08 January 2012, 01:27:40 PM
Bro, skarang coding dah beres ;D
ada masalah baru, masalah cosmetic aja sih... :)
Setiap murid ada kelas masing2, nah di case ini, 1 kelas ada 2 murid (BIS306 ada 2 murid)...
(https://forum.dhammacitta.org/proxy.php?request=http%3A%2F%2Fi1180.photobucket.com%2Falbums%2Fx416%2Fjeffrey2530%2FCapture1.png&hash=01e0e37d2711ce6c0c1f1ec9ab8cb461ec51b162)
pas display di listbox malah keluar 2 BIS306...=_="
gw mau-nya subject ID cuma 1, jadi gk double BIS306...khan jelek kalo ada double gitu, kalo 100 murid, ada 100 BIS306 donk... :o
(https://forum.dhammacitta.org/proxy.php?request=http%3A%2F%2Fi1180.photobucket.com%2Falbums%2Fx416%2Fjeffrey2530%2FCapture2.png&hash=c012761da3b42fd912d88f8b79a97216fee87d9c)
coding gw buat listbox itu...
$result2 = mysql_query("SELECT `subjectID` FROM assesment");
<input type="radio" name="radio" id="radio" value="subjectOnly" />
<label for="subjectOnly"></label>Send by Subject ID, Please select Subject ID <select name="subjectList" id="subjectList">
<?php
while($rows=mysql_fetch_array($result2)){
?>
<option><? echo $rows['subjectID']; ?></option>
<?php
}
?>
</select>
gw terpaksa nanya lage, soale gw gk tao mo gmana search di google buat problem ini....dah coba keyword "merge item in listbox php", "combine values in listbox php", etc....tetep aja gk ada jawapan... :'(
Thanks again yak~
Ubah aja query MySQL nya menjadi : "SELECT `subjectID` FROM assesment GROUP BY 'subjectID'":
<?php
$result2 = mysql_query("SELECT `subjectID` FROM assesment GROUP BY 'subjectID'");
?>
<input type="radio" name="radio" id="radio" value="subjectOnly" />
<label for="subjectOnly"></label>Send by Subject ID, Please select Subject ID <select name="subjectList" id="subjectList">
<?php
while($rows=mysql_fetch_array($result2)){
?>
<option><? echo $rows['subjectID']; ?></option>
<?php
}
?>
</select>
Quote from: Sol Capoeira on 08 January 2012, 01:30:47 PM
dah kirim kemaren...:) tapi, gk bisa kirim lage, perlu nunggu time restriction-nya...:)
Gak usah banyak2 ucapan terima kasihnya.... Cukup kirimkan aja separuh hasil project ini ke rekening gw... Hehehehe... Just kidding ;D
YOU ARE AWESOMELY BRILLIANT...!!! ;D
THANKS..!!
Ini final year project gw seh :P gk dapet uang...cuma dapet stress :)) makane dibagi2 disini...:)
tapi kayakne ini gk buat loe stress sama sekali :|
hahaha...
Thanks again! ;)
Quote from: Sol Capoeira on 08 January 2012, 04:11:45 PM
YOU ARE AWESOMELY BRILLIANT...!!! ;D
THANKS..!!
Ini final year project gw seh :P gk dapet uang...cuma dapet stress :)) makane dibagi2 disini...:)
tapi kayakne ini gk buat loe stress sama sekali :|
hahaha...
Thanks again! ;)
Ohhh final project toh... kirain project apaan....
Ok, good luck aja buat project nya.... :)