handle=ora_logon("user38@WWW","iam3849") or die; cursor=ora_open(handle); ora_commitoff(handle);
query="insert into ad(url, banner, alt, descript, priority) values('url', 'banner_name', 'alt', 'descript', priority)"; ora_parse(cursor, query) or die; ora_exec(cursor); ora_close(cursor); ora_logoff(handle);
echo "< title >广告新增完成< /title >"; echo "< /head >"; echo "< body >"; echo "< a href=".url." >< img src=/uploads/img//200742516241885977801." alt=/"".alt."/" border=0 >< /a >< p >"; echo "< ul type=disc >"; echo "< li >广告网址: ".url; echo "< li >辅助字串: ".alt; echo "< li >广告说明: ".descript; echo "< li >显示加权: ".priority; echo "< /ul >"; }
? > < /body > < /html >
当然要使用上面的程式之前别忘了先增加 ad 资料表,SQL 及栏位如下
CREATE TABLE ad ( url varchar2(1024) not null, banner varchar2(1024) not null, alt varchar2(255) null, descript varchar2(255) null, priority number(4) not null default 1 );