| |
Forum PHP IndonesiaDapatkan pertolongan pertama pada kebingungan PHP dan sekitarnya |
|
|
|
|
|
| |
|
|
All times are GMT + 7 Hours
|
|
trigger buat sms-gateway
 |
Sat Jul 04, 2009 10:28 |
 |
 Author |
Message |
sugiarto
PHP Master
Joined: 09 Jun 2008
Posts: 240
Location: Surabaya
|
| Post subject: trigger buat sms-gateway |
 |
|
hai semuanya bantu saya,,,
da yang punya contoh script trigger under postgre sql ??????????
yang nantinya akan saya buat auto reply di gammu / sms gateway 
atau contoh script triggernya ma struktur tabel-tabelnya saja...
Terima Kasih |
|
| |
|
|
|
Sat Jul 04, 2009 11:27 |
|
| Author |
Message |
hlie
I am PHP
Joined: 10 Apr 2008
Posts: 3050
Location: Singapore
|
| Post subject: |
|
|
tinggal create aja kan triggernya
mau pas setelah di insert atau setelah update?
_________________
Past is Experience,Present is Experiments,Future is Expectations,Use your Experience in your Experiments to achieve your Expectations...!!!
www.slackware.com |
|
| |
|
|
|
Mon Jul 06, 2009 21:39 |
|
| Author |
Message |
sugiarto
PHP Master
Joined: 09 Jun 2008
Posts: 240
Location: Surabaya
|
| Post subject: postgre |
|
|
ugh sulit om,,,soalnya kbanyakan kondisi
akhirnya aku buat stored procuder ja
hehehehehe
thanks ya om |
|
| |
|
|
|
Tue Jul 07, 2009 08:18 |
|
| Author |
Message |
hlie
I am PHP
Joined: 10 Apr 2008
Posts: 3050
Location: Singapore
|
| Post subject: |
|
|
SP sama Trigger ampir sama kok cara kodingnya :D
_________________
Past is Experience,Present is Experiments,Future is Expectations,Use your Experience in your Experiments to achieve your Expectations...!!!
www.slackware.com |
|
| |
|
|
|
Fri Sep 04, 2009 22:23 |
|
| Author |
Message |
poet_noer
PHP Master
Joined: 24 Jan 2008
Posts: 349
Location: jakarta
|
|
| |
|
|
|
Sun Jan 10, 2010 16:17 |
|
| Author |
Message |
mursidaccess
PHPuser
Joined: 09 Jan 2010
Posts: 25
Location: http://mursid.web.id
|
| Post subject: |
|
|
yang dimaksud trigger yang ini bener ga?
| Code: | <?php delimiter //
CREATE TRIGGER sms.autorespond AFTER INSERT on sms.inbox
FOR EACH ROW BEGIN
IF(New.TextDecoded = "REG HOT")
THEN INSERT INTO outbox(DestinationNumber,TextDecoded,Coding,CreatorID)values(New.SenderNumber,"ANDA TELAH TEDAFTAR",'Default_No_Compression','1');
ELSE insert into outbox(DestinationNumber,TextDecoded,Coding,CreatorID)values(New.SenderNumber,"FORMAT SALAH, ULANGI LAGI",'Default_No_Compression','1');
end if;
end;
// ?> |
|
|
| |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
|
|
|
|
Powered by phpBB © 2001, 2002 phpBB Group
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
Oracle, MSSQL, Postgre, MS Access 
