Nak Blok Nama Yg Dah Black List

[master potato 0]

salam..

nak mintak tolong ajar/baiki kelemahan yg ada pada yg sudi (bulan pose ni byk dpt pahala )

saya telah buat satu form utk daftar permohonan kursus..
so..saya cadang nk blok bagi nama yg telah di black list (contoh x bayar yuran kursus semester) daripada dia daftar kursus..
buat2 error jgk...aisey men..
cume saya buat ek? kalo user nk isi permohonna 2 kali memang dh x bleh dh..so kalo nk blok user yg dh di black list tu nk kene buat table baru jgk ke?lps tu saya kene masukkan/upload ic diaorg siap2 la ke?

contoh code:

[color="#FF0000"]<?
include "../db_settings.php";
include "../db_connection.php";


if (isset($_POST['Submit']))
{
$ic = $_POST['ic'];
$nama = $_POST['nama'];


if (empty($ic))
{
echo "<script>alert(\"Sila isikan NO. KAD PENGENALAN anda!\");javascript:history.back();</script>";
exit();
}

if (empty($nama))
{
echo "<script>alert(\"Sila isikan NAMA PENUH anda!\");javascript:history.back();</script>";
exit();
}




$result = mysql_query("select * from kursus where ic='$ic'") or die("cant connect");
$myrow = mysql_fetch_array($result);

if ( $myrow['ic'] == $ic)
{

echo "<script>alert(\"Harap Maaf! Anda telah mengisi permohonan ini.\");javascript:history.back();</script>.";
exit();

}


$mysql = mysql_query("insert into kursus (ic,nama) values ('$ic','$nama')") or die("Can't connect to the database");


echo "<script>location='permohonan_kursus_berjaya.php';</script>";


}

?>[/color]


x tau dh cmane nk masukkan coding utk nk blok ni..

[NeoLogy 74]

dalam table tu..cube tambah satu lagi column utk blacklist status..

gune sql query "SELECT *FROM kursus WHERE (ic='$ic' AND blacklist='0') LIMIT 1"

kalo query return result then permohonan berjaya..kalo failed, pemohon disenarai hitamkan..

[master potato 0]

[quote name='NeoLogy' date='04 September 2010 - 02:38 PM' timestamp='1283582338' post='1047090']
dalam table tu..cube tambah satu lagi column utk blacklist status..

gune sql query "SELECT *FROM kursus WHERE (ic='$ic' AND blacklist='0') LIMIT 1"

kalo query return result then permohonan berjaya..kalo failed, pemohon disenarai hitamkan..
[/quote]

maaf bos..try buat tp x block la...my b saya silap kt mane2 coding tu kot..harap dapat tunjuk ajar lg...
contoh cooding saya:


utk database MySQL punye export


[color="#FF0000"]--
-- Database: `permohonan`
--

-- --------------------------------------------------------

--
-- Table structure for table `kursus`
--

CREATE TABLE IF NOT EXISTS `kursus` (
`ic` varchar(20) NOT NULL DEFAULT '',
`nama` varchar(50) NOT NULL DEFAULT '',
`blacklist` varchar(20) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kursus`
--[/color]


[color="#0000FF"](daftar.php)[/color]

[color="#FF0000"]<?
include "db_settings.php";
include "db_connection.php";

if (isset($_POST['Submit']))
{
$ic = $_POST['ic'];
$nama = $_POST['nama'];


if (empty($ic))
{
echo "<script>alert(\"Sila isikan NO. KAD PENGENALAN anda!\");javascript:history.back();</script> ";
exit();
}

if (empty($nama))
{
echo "<script>alert(\"Sila isikan NAMA PENUH anda!\");javascript:history.back();</script> ";
exit();
}

$result = mysql_query("SELECT *FROM kursus WHERE (ic='$ic' AND blacklist='0') LIMIT 1") or die("cant connect");
$myrow = mysql_fetch_array($result);

if ( $myrow['ic'] == $ic)
{

echo "<script>alert(\"Harap Maaf! Anda telah mengisi permohonan ini.\");javascript:history.back();</script>." ;
exit();

}

$mysql = mysql_query("insert into kursus (ic,nama) values ('$ic','$nama')") or die("Can't connect to the database");

echo "<script>location='permohonan_kursus_berjaya.php';</script>";

}

?>

<form name="form1" method="post" action="daftar.php">

<input name="ic" type="text" id="ic" onBlur="valid(this,'special')" onKeyUp="valid(this,'special')" size="12" maxlength="12">IC<BR />
<input type="text" name="nama" size="50" onClick="change_case();" maxlength="200">NAMA<BR />
<input type="submit" name="Submit" value="Hantar">&nbsp;&nbsp;

</form>[/color]

[NeoLogy 74]

blacklist punye field tu make sure ko taruk default value '0'..pastu ko try set satu data dgn blacklist field='1'
pastu try..

[master potato 0]

[quote name='NeoLogy' date='04 September 2010 - 04:45 PM' timestamp='1283589911' post='1047099']
blacklist punye field tu make sure ko taruk default value '0'..pastu ko try set satu data dgn blacklist field='1'
pastu try..
[/quote]
alamak bos..x jd jgk la..kurang paham kit la bos...

[NeoLogy 74]

[quote name='master potato' date='04 September 2010 - 04:55 PM' timestamp='1283590557' post='1047101']
alamak bos..x jd jgk la..kurang paham kit la bos...
[/quote]

ok..ko dah ada table kursus kn?

aku assume ni ko punya table n data.

ic nama blacklist
============================================
xxxxxxxxx Ali 0
yyyyyyyyy Abu 0
zzzzzzzzz Bakar 1
============================================

sql = "select *from kursus where (ic='$ic' and blacklist='0')"

let say ic dari form ic='zzzzzzzzz'

so, query sql ko akan jadi "select *from kursus where (ic='zzzzzzzzz' and blacklist='0')"
berdasarkan query ni, mestilah result dia 0 kn?
so, user yg punyai ic='zzzzzzzzz' telah diblacklist..so, kuar la alert yg paparkan user dah diblacklist..

[master potato 0]

[quote name='NeoLogy' date='04 September 2010 - 05:18 PM' timestamp='1283591894' post='1047102']
ok..ko dah ada table kursus kn?

aku assume ni ko punya table n data.

ic nama blacklist
============================================
xxxxxxxxx Ali 0
yyyyyyyyy Abu 0
zzzzzzzzz Bakar 1
============================================

sql = "select *from kursus where (ic='$ic' and blacklist='0')"

let say ic dari form ic='zzzzzzzzz'

so, query sql ko akan jadi "select *from kursus where (ic='zzzzzzzzz' and blacklist='0')"
berdasarkan query ni, mestilah result dia 0 kn?
so, user yg punyai ic='zzzzzzzzz' telah diblacklist..so, kuar la alert yg paparkan user dah diblacklist..
[/quote]

orait bos..tenkiu sgt2...dh paham atas tumjuk ajar..
chek2 rupenye coding yg bos bg tu kat blacklist tu lupe saya letak value 1 le hehe baru perasan td...so skrg settle..
ok bos dh nk bebuke ni..tp smangat lg nk chek cooding ni..ape2 pn terima kasih and slamat berbuka... Edited September 4, 2010 by master potato