《基礎(chǔ)物理實(shí)驗(yàn)》預(yù)習(xí)及數(shù)據(jù)處理數(shù)據(jù)庫應(yīng)用系統(tǒng)new

1、File_dir: index.phpbootstrap()-run();File_dir: applicationcontrollersIndexController.phplistpreview();$this-view-items = $list;File_dir: applicationcontrollersUsersController.phpjudgeAuthentication();public function createAction()$this-judgeAuthentication();$request = $this-getRequest();$form = new

2、Application_Form_Createusers();if ($this-getRequest()-isPost() if ($form-isValid($request-getPost() $user = new Model_DbTable_bpeusers();$row = $form-getValues();$data = array(username = $rowusername,passwd = md5($rowpassword),);$result = $user-adduser($data);return $this-_helper-redirector(list);$t

3、his-view-form = $form;public function changeAction()$this-_helper-getHelper(layout)-disableLayout();$user_info = $this-judgeAuthentication();$user_name = $this-_getParam(username, 0);$password = $this-_getParam(password, 0);if ($user_name&$password) $data = array(username = $user_name,passwd = md5($

4、password),);$user = new Model_DbTable_bpeusers();$user-updateuser($user_info-id,$data);$authAdapter = Zend_Auth:getInstance();$authAdapter-clearIdentity();$this-_redirect(/users/login);public function loginAction()$userform = new Application_Form_Loginusers();if ($this-_request-isPost() & $userform-

5、isValid($_POST) /$data = $userform-getValues();/$db = Zend_Db_Table:getDefaultAdapter();/ .$authadapter = new Zend_Auth_Adapter_DbTable($db, bpeusers, username, passwd);/ $authadapter-setIdentity($datausername);$authadapter-setCredential(md5($datapassword);/ $result = $authadapter-authenticate();if

6、($result-isValid()/ DbTable $auth = Zend_Auth:getInstance();$storage = $auth-getStorage();$storage-write($authadapter-getResultRowObject(array(id,username, passwd);$this-view-loginMessage = ;return $this-_helper-redirector(index,index); else $this-view-loginMessage = ;$this-view-form = $userform;pub

7、lic function logoutAction ()/ action body$authAdapter = Zend_Auth:getInstance();$authAdapter-clearIdentity();$this-_redirect(/);public function judgeAuthentication()$auth = Zend_Auth:getInstance();if (!$auth-hasIdentity() /not log inecho ;echo ;die(); else return $auth-getIdentity();File_dir: applic

8、ationcontrollersBackController.phpjudgeAuthentication();public function indexAction()function deletepreAction($id)$id = $this-_getParam(id, 0);if($id)$table = new Model_DbTable_bpepreview();$table-deletepreview(int)$id);$table2 = new Model_DbTable_bpedataprocess();$table2-deletedatabyexp_id(int)$id)

9、;$table3 = new Model_DbTable_bpechart();$table3-deletechartbyexp_id(int)$id);$this-_redirect(/);function editpreAction($id)$table = new Model_DbTable_bpepreview();if ($this-getRequest()-isPost()$data = $this-getRequest()-getPost();$index_pic_content = stripcslashes($dataindex_pic);preg_match_all(/sr

10、c=/?(.*?)/, $index_pic_content, $match);$content = array(class = $dataclass,name = $dataname,intro = $dataintro,goal = $datagoal,equip = $dataequip,principle = $dataprinciple,equip_intro = $dataequip_intro,content = $datacontent,data = $datadata,notice = $datanotice,think = $datathink,time = date(Y-

11、m-d H:i:s),picture= $match10?$match10:);if($databpe_id)$table-updatepreview($databpe_id,$content);else$table-addpreview($content);$this-_redirect(/);else$id = $this-_getParam(id, 0);if($id)$data = $table-getpreview(int)$id);$this-view-content = $data;function adddataAction()if ($this-getRequest()-is

12、Post() $data = $this-getRequest()-getPost();$content = array(exp_id = $dataexp_id,/ pre_innum = $dataup_pre_input_num,/ pre_inname = $dataup_pre_input_name,/ pre_outnum = $dataup_pre_output_num,/ pre_outname = $dataup_pre_output_name,/ pre_formula = $dataup_pre_formula,arr_num = $dataup_group_num,ar

13、r_innum = $dataup_input_num,arr_inname = $dataup_input_name,arr_outnum = $dataup_output_num,arr_outname = $dataup_output_name,arr_formula = $dataup_formula,order = $dataup_order,/ aft_innum = $dataup_aft_input_num,/ aft_inname = $dataup_aft_input_name,/ aft_outnum = $dataup_aft_output_num,/ aft_outn

14、ame = $dataup_aft_output_name,/ aft_formula = $dataup_aft_formula,);$add = new Model_DbTable_bpedataprocess();$add-adddataprocess($content);$this-_redirect(/back/listdata/exp_id/.$dataexp_id);else$id = $this-_getParam(exp_id, 0);$getname = new Model_DbTable_bpepreview();$expname = $getname-getprevie

15、w(int)$id);$this-view-exp_name = $expnamename;$this-view-exp_id = $expnameid;$this-view-exp_num = $this-_getParam(count, 0);function deletedataAction()$this-_helper-getHelper(layout)-disableLayout();$id = $this-_getParam(id, 0);if($id)$delete = new Model_DbTable_bpedataprocess();$delete-deletedatapr

16、ocess($id);$this-_redirect(/back/listdata/exp_id/.$this-_getParam(exp_id, 0);function updateformulaorderAction()$this-_helper-getHelper(layout)-disableLayout();if ($this-getRequest()-isPost() $post = $this-getRequest()-getPost();if($postformula_id)$order = new Model_DbTable_bpedataprocess();$order-u

17、pdateorder($postformula_id,array(order=$postformula_order);$this-_redirect(/back/listdata/exp_id/.$postformula_exp_id);function listdataAction()$id = $this-_getParam(exp_id, 0);if($id)$getname = new Model_DbTable_bpepreview();$expname = $getname-getpreview(int)$id);$getformula = new Model_DbTable_bp

18、edataprocess();$data1 = $getformula-getdataprocessbyexp_id(int)$id);foreach ($data1 as $k = $data)$innum = $dataarr_innum;$dataarr_inname = substr($dataarr_inname,0,-1);$dataarr_outname = substr($dataarr_outname,0,-1);$dataarr_formula = substr($dataarr_formula,0,-1);$inname = explode(,$dataarr_innam

19、e);$char = a;for($i = 0;$i getchartbyexp_id(int)$id);foreach ($data2 as $k = $data)$dataseries_x_num = substr($dataseries_x_num,0,-1);$dataseries_title = substr($dataseries_title,0,-1);$data2$k = $data;$view_data = array(exp_id = $expnameid,exp_name = $expnamename,data = $data1,data2 = $data2,);$thi

20、s-view-view_data = $view_data;function addchartAction()if ($this-getRequest()-isPost() $data = $this-getRequest()-getPost();$series_x_num = ;$series_title =;for($i=0;$i$dataseries_num;$i+)$series_x_num .= $dataseries_x_num$i.,;for($i=0;$i $dataexp_id,title = $datatitle,x_title = $datax_title,y_title

21、 = $datay_title,series_num = $dataseries_num,series_x_num = $series_x_num,series_title = $series_title,order = $dataorder,);$add = new Model_DbTable_bpechart();$add-addchart($content);$this-_redirect(/back/listdata/exp_id/.$dataexp_id);else$id = $this-_getParam(exp_id, 0);$getname = new Model_DbTabl

22、e_bpepreview();$expname = $getname-getpreview(int)$id);$this-view-exp_name = $expnamename;$this-view-exp_id = $expnameid;$this-view-exp_num = $this-_getParam(count, 0);function deletechartAction()$this-_helper-getHelper(layout)-disableLayout();$id = $this-_getParam(id, 0);if($id)$delete = new Model_

23、DbTable_bpechart();$delete-deletechart($id);$this-_redirect(/back/listdata/exp_id/.$this-_getParam(exp_id, 0);function updatechartorderAction()$this-_helper-getHelper(layout)-disableLayout();if ($this-getRequest()-isPost() $post = $this-getRequest()-getPost();if($postchart_id)$order = new Model_DbTa

24、ble_bpechart();$order-updateorder($postchart_id,array(order=$postchart_order);$this-_redirect(/back/listdata/exp_id/.$postchart_exp_id);public function judgeAuthentication()$auth = Zend_Auth:getInstance();if (!$auth-hasIdentity() /not log inecho ;echo ;die(); else $this-view-identity = $auth-getIden

25、tity();File_dir: applicationcontrollersGetDataController.php_helper-getHelper(layout)-disableLayout();if($this-getRequest()-isPost()$data = $this-getRequest()-getPost();$table = new Model_DbTable_bpepreview();/1$table-updateviewnum($dataexp_id);/$data_v = $table-getpreview($dataexp_id);for($i=1;$i11

26、;$i+)$data_v = str_replace(*formula*%.$i,$data_v);$data_v = str_replace(*formula*,$data_v);$data_v = str_replace(*chart*,$data_v);$this-_helper-getHelper(Json)-sendJson(json_encode($data_v);function getinputAction()$this-_helper-getHelper(layout)-disableLayout();if($this-getRequest()-isPost()$table_

27、data = new Model_DbTable_bpedataprocess();$table_chart = new Model_DbTable_bpechart();$table_pre = new Model_DbTable_bpepreview();$data = $this-getRequest()-getPost();$data_array = $table_data-getdataprocessbyexp_id($dataexp_id);$chart_array = $table_chart-getchartbyexp_id($dataexp_id);$pre = $table

28、_pre-getpreview($dataexp_id);$pre_dataprocess = $predata;$start = -9;foreach($data_array as $key=$val)$arr_id = $valid;$arr_num = $valarr_num;$arr_inname = explode(,substr($valarr_inname,0,-1);$arr_innum = $valarr_innum;$arr_outname = explode(,substr($valarr_outname,0,-1);$arr_outnum = $valarr_outnu

29、m;/$start = strpos($pre_dataprocess,*formula*,$start+9);if($start)$is_percent = ;$percent_num = 0;if(substr($pre_dataprocess,$start+9,1)=%)$percent_num = substr($pre_dataprocess,$start+10,1);/$form = ;$form .= ;if($arr_num=1)$name = a;foreach($arr_inname as $value_in)$form .= .$value_in.;$name+;else

30、$form .= ;foreach($arr_inname as $value_in)$form .= .$value_in.;$form .= ;for($row=0;$row$arr_num;$row+)$form .= .($row+1).;$name = a;foreach($arr_inname as $value_in)$form .= ;$name+;$form .= ;$form .= ;$form .=;$form .= ;foreach($arr_outname as $key=$value_out)$is_percent = ;if($percent_num=$key+1

31、)$is_percent = 1;$form .= .$value_out.;$form .= ;$sym_length = 9;if($percent_num)$sym_length = 11;/$pre_dataprocess = substr_replace($pre_dataprocess,$form,$start,$sym_length);$start = -7;foreach($chart_array as $key=$val)$arr_id = $valid;$arr_title = $valtitle;$arr_x_title = $valx_title;$arr_y_titl

32、e = $valy_title;$arr_series_num = $valseries_num;$arr_series_x_num = explode(,substr($valseries_x_num,0,-1);$arr_series_title = explode(,substr($valseries_title,0,-1);/$start = strpos($pre_dataprocess,*chart*,$start+7);if($start)/$form = ;$form .=.$arr_title.;$form .= x.$arr_x_title.y.$arr_y_title.)

33、;foreach($arr_series_x_num as $key=$value)$name = a;$form .= ;$form .=.$arr_series_title$key.;for($i=0;$i$value;$i+)$form .= .($i+1).x=y=;$name+;$form .= ;$form .=;$form .= ;$form .= ;/$pre_dataprocess = substr_replace($pre_dataprocess,$form,$start,7);$array = array(exp_id = $dataexp_id,exp_name = $

34、prename,html = $pre_dataprocess,);$this-_helper-getHelper(Json)-sendJson(json_encode($array);File_dir: applicationcontrollersCalculateController.phpgetRequest()-getPost();$f_input_name = explode(,$post_valuef_input_name);$f_input_val = explode(,$post_valuef_input_val);foreach($f_input_name as $key=$

35、val)$post_value$val = $f_input_val$key;$this-_helper-getHelper(layout)-disableLayout();$data_table = new Model_DbTable_bpedataprocess();$data = $data_table-getdataprocess($post_valueid);$post_value_d = array(id=,submit=);function key_compare_func($key1, $key2)if ($key1 = $key2)return 0;else if ($key

36、1 $key2)return 1;elsereturn -1;$post_value = array_diff_ukey($post_value,$post_value_d, key_compare_func);/ $post_value = array(/ a =1,/ b =2,/ );/ $data_table = new Model_DbTable_bpedataprocess();/ $data = $data_table-getdataprocessbyexp_id(1);/ var_dump($data);/ $data = $data0;$functionchange = ar

37、ray(abs = A,acos = B,asin = C,atan = D,cos = E,exp = F,log = G,log10 = H,sin = I,sqrt = J,tan = K,);foreach($functionchange as $key = $value)$dataarr_formula = str_replace($key,$value,$dataarr_formula);foreach($post_value as $key = $value)/ $datapre_formula = str_replace($key,$value,$datapre_formula

38、);$dataarr_formula = str_replace($key,$value,$dataarr_formula);/ $dataaft_formula = str_replace($key,$value,$dataaft_formula);/ $pre = explode(,substr($datapre_formula,0,-1);/ $pre_outname = explode(,substr($datapre_outname,0,-1);/ $pre_outvalue = array();/ foreach($pre as $key = $pre_value)/ / $exp

39、ression = $pre_value.#;/ $temp = $this-math_rpn($expression);/ $pre_outvalue = $this-math_value($temp);/ / foreach($pre_outname as $key=$value)/ / $pre_out$value=$pre_outvalue$key;/ / var_dump($pre_out);/ for($i = 0;$i $value)/ / $temp_key = substr($key,-1,1);/ if($temp_key = $i)/ / $temp_key = subs

40、tr($key,0,2);/ $temp_formula = str_replace($temp_key,$key,$temp_formula);/ / / foreach($post_value as $key = $value)/ / $temp_formula = str_replace($key,$value,$temp_formula);/ / $arr = explode(,substr($temp_formula,0,-1);/ $arr_outname = explode(,substr($dataarr_outname,0,-1);/ $arr_outvalue = array();/ foreach($arr as $key = $arr_value)/ / $expression = $arr_value.#;/ $temp = $this-math_rpn($expression);/ $arr_outvalue = $this-math_value($temp);/ / foreach($arr_outname as $key=$value)/ / $arr_out$value.$