[计算机]PHP教程训练.doc

第1章 PHP概述国程序5-1文件上传客户名字: 文件名称: 程序5-2文件名为adadd.php新增广告广告: 广告网址:辅助字符串: 广告说明: 显示加权: ? else if (file_exists(/home/htdocs/ad/.$banner_name) CommonHeader(文件 .$banner_name. 已存在); echo 广告文件已经存在n; exit; ;/复制上传广告图到指定目录中 copy($banner,/home1/biglobe3/ad/.$banner_name);/配置系统环境变量 putenv(ORACLE_SID=WWW); putenv(NLS_LANG=american_taiwan.zht16big5); putenv(ORACLE_HOME=/home/oracle/product/7.3.2); putenv(LD_LIBRARY_PATH=/home/oracle/product/7.3.2/lib); putenv(ORA_NLS=/home/oracle/product/7.3.2/ocommon/nls/admin/data); putenv(ORA_NLS32=/home/oracle/product/7.3.2/ocommon/nls/admin/data); /对数据库进行操作$handle=ora_logon(用户名,密码) 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 广告新增完成; echo ; echo ; echo ; echo ; echo 广告网址: .$url; echo 辅助字符串: .$alt; echo 广告说明: .$descript; echo 显示加权: .$priority; echo ;?程序5-3文件名为：ad.php 0;ora_parse($cursor, $query);ora_exec($cursor);$i=$pricount=0;/读取广告信息while(ora_fetch($cursor) $ad$i0 = ora_getcolumn($cursor,0);$ad$i1 = ora_getcolumn($cursor,1);$ad$i2 = ora_getcolumn($cursor,2);$ad$i3 = ora_getcolumn($cursor,3);$pricount += $ad$i3;$i+;ora_close($cursor);ora_logoff($handle);srand(double)microtime()*1000000);$pri = rand(1,$pricount);$pricount=0;for($i=0; $icount($ad); $i+) $pricount += $ad$i3;if ($pri = $pricount) $ad1=; echo $ad10;?程序5-4文件名：ad_install.php?phprequire ad_inc.php;$action=$QUERY_STRING;$pagename=$PHP_SELF;/进行数据库连接MYSQL_CONNECT($hostname, $username, $password) OR DIE(数据库连接失败);mysql_select_db( $dbName) or die(选择数据库失败);head();if($action = create):/创建库表banners_adstats$create= CREATE TABLE $table (id TINYINT not null AUTO_INCREMENT，/广告编号clicks_life VARCHAR (20) DEFAULT 0 not null，/广告总点击次数clicks_day VARCHAR (20) DEFAULT 0 not null，/当天广告点击次数dat_type VARCHAR (15) not null，/广告类型，即图文或纯文本displays_life VARCHAR (20) DEFAULT 0 not null，/广告显示的总次数displays_day VARCHAR (20) DEFAULT 0 not null，/当天广告显示的次数zone VARCHAR (50) not null，/客户所在区域image_url VARCHAR (200) not null，/图文广告中图像的URL地址url VARCHAR (200) not null，/广告URL地址html BLOB not null，/文本广告的内容PRIMARY KEY (id) ；$exec = MYSQL_QUERY($create);if($exec = 1):print 库表创建成功!;else:print 库表创建失败!;endif; print ;print Install;print ;endif;MYSQL_CLOSE();?5.3.2 通用函数的建立为了便于用户依据实际运行环境，重新设置该系统中所用变量的初始值以及集中管理系统中的通用函数。该实例将通用的变量和函数写在一个通用的文件中。下面来看看这个文件的具体内容。程序5-5文件名：ad_inc.php?php/主机名 通常为localhost$hostname = localhost;/文件ad_click.php的存放目录$redirect = /php-bin/ads/ad_click.php;/数据库名$dbName = ledbanners_adstats;/操作MySQL数据库的用户名$username = root; /操作MySQL数据库的口令$password = ; /数据库表名$table = banners_adstats; /管理员的口令$admin_pass = admin; /显示广告轮播系统Ads的标题function head() print 广告轮播系统Ads/标题/采取样式表单（css）方式进行页面显示 Ads v1.0;/显示版本信息 /显示用户输入错误口令信息function bad_pass() head();print Bad Password;exit();?程序5-6文件名：ad_admin.php新添广告/输入图文广告的有关信息form action=?do_add method=POST图像位置:链:地域:口令:或/输入纯文本广告的有关信息输入一个广告的HTMLform action=?do_add method=POST地域:口令:?phpelseif($action = do_add):/口令验证if($admin_password != $admin_pass): bad_pass();endif;head(); /将输入的广告信息入库if($dat_type = image): $query = INSERT INTO $table (zone,url,image_url,dat_type) VALUES ($zone, $link, $image, $dat_type); $result = MYSQL_QUERY($query);print 添加成功;elseif($dat_type = html): $query = INSERT INTO $table (zone, url, html, dat_type) VALUES ($zone, NULL, $html_input, $dat_type); $result = MYSQL_QUERY($query);print 添加成功;else:print 添加失败;endif;elseif($action = modify): /修改已存在广告的处理head();/从数据库中获取广告的编号$query = SELECT * FROM $table;$result = MYSQL_QUERY($query);$number = MYSQL_NUMROWS($result);$i=0;print (点击要进行修改的广告);WHILE ($i $number): $id= mysql_result($result,$i,id); $image_url= mysql_result($result,$i,image_url); $url= mysql_result($result,$i,url); $dat_type= mysql_result($result,$i,dat_type); $html= mysql_result($result,$i,html); if($dat_type = image): printnModify; elseif($dat_type = html): print $htmlModify; else: print nModify; endif; $i+;ENDWHILE;print ;elseif($action = mod_id):$query = SELECT * FROM $table WHERE id = $ad_id;$result = MYSQL_QUERY($query); /获取要修改的广告的有关信息$id= mysql_result($result,0,id);$zone= mysql_result($result,0,zone);$image_url= mysql_result($result,0,image_url);$url= mysql_result($result,0,url);$dat_type= mysql_result($result,0,dat_type);$html= mysql_result($result,0,html); head();if($dat_type = image):?修改form action=?do_modify method=POST图像位置:input type=text name=image size=60 value=链:input type=text name=link size=60 value=位置:input type=text name=zone value=口令:input type=hidden name=mod_id value=form action=?do_add method=POST位置:input type=text name=zone value=口令:input type=hidden name=mod_id value=form action=?do_modify method=POST图像位置:input type=text name=image size=60 value=链:input type=text name=link size=60 value=位置:input type=text name=zone value=口令:input type=hidden name=mod_id value=?phpendif;elseif($action = do_modify):if($admin_password != $admin_pass):bad_pass();endif;/对数据库进行更新if($dat_type = image): $update_query = UPDATE $table SET zone = $zone WHERE id = $mod_id; $update_result = MYSQL_QUERY($update_query); $update_query = UPDATE $table SET image_url = $image WHERE id = $mod_id; $update_result = MYSQL_QUERY($update_query); $update_query = UPDATE $table SET url = $link WHERE id = $mod_id; $update_result = MYSQL_QUERY($update_query); elseif($dat_type = html): $update_query = UPDATE $table SET zone = $zone WHERE id = $mod_id; $update_result = MYSQL_QUERY($update_query); $update_query = UPDATE $table SET html = $html WHERE id = $mod_id; $update_result = MYSQL_QUERY($update_query); else: $update_query = UPDATE $table SET zone = $zone WHERE id = $mod_id; $update_result = MYSQL_QUERY($update_query); $update_query = UPDATE $table SET image_url = $image WHERE id = $mod_id; $update_result = MYSQL_QUERY($update_query); $update_query = UPDATE $table SET url = $link WHERE id = $mod_id; $update_result = MYSQL_QUERY($update_query);endif;head();print 库更新成功;elseif($action = delete): /删除广告的处理head();/从数据库中获取要删除广告的编号$query = SELECT * FROM $table;$result = MYSQL_QUERY($query);$number = MYSQL_NUMROWS($result);$i=0;print ;WHILE ($i $number): /获取欲删除广告的有关信息 $id= mysql_result($result,$i,id); $image_url= mysql_result($result,$i,image_url); $url= mysql_result($result,$i,url); $dat_type= mysql_result($result,$i,dat_type); $html= mysql_result($result,$i,html); if($dat_type = image):print nn;elseif($dat_type = html):print$htmlnn;else:print nn;endif; $i+;ENDWHILE;printPassword:;print n;print n;print n;elseif($action = do_del):if($admin_password != $admin_pass): bad_pass();endif;/从数据库中删除广告head();for($i=0; $i count($del_id); $i+)$query = DELETE FROM $table WHERE id = $del_id$i;$exec = MYSQL_QUERY($query);if($exec = 1):print 将要删除广告的编号是: $del_id$in;else:print 删除出错n;endif; print n成功删除;elseif($action = stats): /统计并显示广告显示的次数以及被点击的次数head();$font=;?位置 总显示次数 日显示次数 总点击次数日点击次数?$query = SELECT * FROM $table;$result = MYSQL_QUERY($query);$number = MYSQL_NUMROWS($result);$i=0;WHILE ($i $number):/获取广告的详细信息$id= mysql_result($result,$i,id);$image_url= mysql_result($result,$i,image_url);$url= mysql_result($result,$i,url);$zone= mysql_result($result,$i,zone);$displays_life= mysql_result($result,$i,displays_life);$displays_day= mysql_result($result,$i,displays_day);$clicks_life= mysql_result($result,$i,clicks_life);$clicks_day= mysql_result($result,$i,clicks_day);print $font $url ($zone)$font $displays_life$font $displays_day$font $clicks_life$font $clicks_day;$tdisplays_life=$tdisplays_life+$displays_life;$tdisplays_day=$tdisplays_day+$displays_day;$tclicks_life=$tclicks_life+$clicks_life;$tclicks_day=$tclicks_day+$clicks_day;$i+;ENDWHILE;print $font Totals:$font $tdisplays_life$font $tdisplays_day$font $tclicks_life$font $tclicks_day; print ;elseif($action = clear_day): /清除数据库内当天所记录的信息head();?form action=?do_clear_day method=POST口令:?phpelseif($action = do_clear_day):if($admin_password != $admin_pass):bad_pass();endif;$query = SELECT * FROM $table;$result = MYSQL_QUERY($query);$number = MYSQL_NUMROWS($result);$i=0;WHILE ($i /显示广告轮播系统的主页面广告轮播系统主菜单a href=?add target=mainFrame添加广告a href=?modify target=mainFrame修改广告a href=?delete target=mainFrame删除广告a href=?stats target=mainFrame显示统计信息a href=?clear_day target=mainFrame清除当天的记录 欢迎使用广告轮播系统ads 请从左边的菜单中选取操作选项。广告轮播系统ads frame name=leftFrame scrolling=auto noresize src=?lframeframe name=mainFrame src=?rframe需框架方式显示该网页，但你的浏览器不支持框架方式显示。程序5-7文件名：ad_click.php 1):print 数据库内记录有错!;endif;$url= mysql_result($result,$randomnumber,url);$clicks_life= mysql_result($result,$randomnumber,clicks_life);$clicks_day= mysql_result($result,$randomnumber,clicks_day);header(Location: $url);/对广告点击的次数加1+$clicks_life;+$clicks_day;/更新数据库内clicks_life及clicks_day字段的值$update_query = UPDATE $table SET clicks_life = $clicks_life WHERE id = $req_id;$update_result = MYSQL_QUERY($update_query);$update_query = UPDATE $table SET clicks_day = $clicks_day WHERE id = $req_id;$update_result = MYSQL_QUERY($update_query);/关闭数据库MYSQL_CLOSE();?程序5-8文件名：ad.php?phprequire ad_inc.php;$pagename = $PHP_SELF; /进行数据库连接MYSQL_CONNECT($hostname, $username, $password) OR DIE(数据库连接失败);mysql_select_db( $dbName) or die(选择数据库失败);$query = SELECT * FROM $table;$result = MYSQL_QUERY($query);$number = MYSQL_NUMROWS($re