這行程式就是將檔案存在 /home/htdocs/ad 的目錄中,就上面的例子而言,就將檔案存到 /home/htdocs/ad/myphoto.gif。重要的是,存放的目錄不能是 Web Server 無法讀到的目錄,而應(yīng)放在網(wǎng)站的 Homepage 所在目錄中,才可以在網(wǎng)路上看到。
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 >廣告網(wǎng)址: ".url; echo "< li >輔助字串: ".alt; echo "< li >廣告說明: ".descript; echo "< li >顯示加權(quán): ".priority; echo "< /ul >"; }
? > < /body > < /html >
當(dāng)然要使用上面的程式之前別忘了先增加 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 );