正常数据库连接是这样的
- <?php
- //连接数据库
- $link = mysql_connect('localhost', 'root', '123456')
- mysql_select_db('ruida');
- //执行查询语句
- $query = 'select * from user where name="xiaoming"';
- $result = mysql_query($query);
- //整理格式输出
- while ($line = mysql_fetch_assoc($result)) {
- echo "...";
- }
- //释放结果集,关闭链接
- mysql_free_result($result);
- mysql_close($link);
- ?>
- <?php
- //连接数据库
- $link = mysql_connect('localhost', 'root', '123456')
- mysql_select_db('ruida');
- //执行查询语句
- $query = 'select * from user where name="xiaoming"';
- $result = mysql_query($query);
- //整理格式输出
- while ($line = mysql_fetch_assoc($result)) {
- echo "...";
- }
- //释放结果集,关闭链接
- mysql_free_result($result);
- mysql_close($link);
- ?>
- //玩家提问,创建了一个任务
- $task = $user->createTask();
- //客服拉取任务
- $task = $cs->pullTask();
- //客服开始解决问题
- $cs->startTask();
- //客服解决问题后,结束此次服务
- $cs->endTask();
- //玩家提问,创建了一个任务
- $task = $user->createTask();
- //客服拉取任务
- $task = $cs->pullTask();
- //客服开始解决问题
- $cs->startTask($task);
- //客服解决问题后,结束此次服务
- $cs->endTask($task);
- //玩家提问,创建了一个任务
- $result = $user->createTask();
- $this->assertEqual(true,$result);
- //客服拉取任务
- $task = $cs->pullTask();
- $this->assertNotEqual(null,$task->id);
- //客服开始解决问题
- $result = $cs->startTask($task);
- $this->assertEqual(true,$result);
- //客服解决问题后,结束此次服务
- $result = $cs->endTask($task);
- $this->assertEqual(true,$result);
- sudo crontab -e
- */5 * * * * ( sh cs_check.sh >> /cs.log 2>&1 )
- $area = 100;
- if($city == "北京")
- {
- $unit_price = 20000;
- $tax_rate = 0.2;
- $total_price = $area*$unit_price+$tax_rate($area*$unit_price);
- }
- elseif($city == "上海" || $city == "广州" )
- {
- $unit_price = 18000;
- $tax_rate = 0.1;
- $total_price = $area*$unit_price+$tax_rate($area*$unit_price);
- }
- else
- {
- $unit_price = 5000;
- $total_price = $area*$unit_price;
- }
- $area = 100;
- if($city == "北京")
- {
- $unit_price = 20000;
- $tax_rate = 0.2;
- $total_price = $area*$unit_price+$tax_rate($area*$unit_price);
- }
- elseif($city == "上海" || $city == "广州" )
- {
- $unit_price = 18000;
- $total_price = $area*$unit_price;
- }
- else
- {
- //...
- }
- $area = 100;
- $unit_price = priceLookUp($city);
- $tax_rate = rateLookUp($city);
- $total_price = (1+$tax_rate)$area*$unit_price;
- if($city == "北京")
- {
- $unit_price = 20000;
- $tax_rate = 0.2;
- $total_price = (1+$tax_rate)$area*$unit_price;
- }
- elseif($city == "上海" || $city == "广州" )
- {
- $unit_price = 18000;
- $tax_rate = 0.1;
- $total_price = (1+$tax_rate)$area*$unit_price;
- }
- else
- //...
- $unit_price = priceLookUp($city);
- $tax_rate = rateLookUp($city);
- $total_price = (1+$tax_rate)$area*$unit_price;
怎样的封装才是理想化的?