URL: https://linuxfr.org/forums/linux-debutant/posts/code-php-pour-stocke-des-donnees-sur-une-base-de-donnees
Title: code php pour stocké des données sur une base de données
Authors: SHQ
Date: 2012年10月10日T19:20:32+02:00
Tags: 
Score: -2
bonjour
en premier je m'excuse si mon français n'es pas correct ( je ne suis pas français ).
j'ai un scripte avec le quelle j'active des accès a distance est c'est base sur des code php, les information des accès sans stocker dans un fichier xml.
mon souhait c'est de stocker les information de ces accès dans une base de données
[url pour visualise le scripte](http://mediteo.free.fr/active/)
code php:
 <? $GLOBALS['file_codes']="proxy.codes"; $GLOBALS['file_act']="proxy.act"; $GLOBALS['file_user']="User.xml"; $GLOBALS['IDENT']="Super-Code"; function sh_scr($user,$pass,$msg,$enddate=0) { $_GET['LastName']=$user; //========================================================================================== //!!!!!!!!! must always be there do not delete this line!!!! //========================================================================================== echo "Attend Redemarer Le DreamBox\n\n"; //echo "\ncp /tmp/actv.tmp /tmp/aaa\n"; //========================================================================================== echo "\ngrep -v \"#\" /var/tuxbox/plugins/D�marche4.cfg> /tmp/actv.cfg";
 	echo "\necho \"#LastName={$_GET['LastName']}\">> /tmp/actv.cfg";
 	echo "\nmv /tmp/actv.cfg /var/tuxbox/plugins/D�marche4.cfg";
 	echo "\necho \"CWS_KEEPALIVE = 300\"> /var/keys/newcamd.list";
 	echo "\necho \"CWS_INCOMING_PORT = 21010\">> /var/keys/newcamd.list";
 	echo "\necho \"CWS = host.no-ip.org 5000 {$user} {$pass} 01 02 03 04 05 06 07 08 09 10 11 12 13 14\">> /var/keys/newcamd.list";
 	echo "\necho \"M: { 01 }\">> /var/keys/mg_cfg";
 	echo "\necho \"C: { 01 }\">> /var/keys/mg_cfg";
 	echo "\necho \"A: { 00 }\">> /var/keys/mg_cfg";
 	echo "\necho \"U: { 01 }\">> /var/keys/mg_cfg";
 	echo "\necho \"T: { 00 }\">> /var/keys/mg_cfg";
 	echo "\necho \"G: { 01 }\">> /var/keys/mg_cfg";
 	echo "\necho \"N: { 07 } 5 30\">> /var/keys/mg_cfg";
 	echo "\necho \"K: { 05 }\">> /var/keys/mg_cfg";
 	echo "\necho \"Q: { 600}\">> /var/keys/mg_cfg";
 	echo "\necho \"O: { 02 } root dreambox\">> /var/keys/mg_cfg";
 	echo "\necho \"S: { 08 } 80\">> /var/keys/mg_cfg";
 	echo "\necho \"E: { 15 }\">> /var/keys/mg_cfg";
 	echo "\necho \"H: { 07 }\">> /var/keys/mg_cfg";
 	echo "\necho \"R: { 00 }\">> /var/keys/mg_cfg";
 	//==========================================================================================
 	// !!!!!!!!! must always be there do not delete this lines below!!!!
 	//==========================================================================================
 	echo "\necho -n \"{$msg}\"> /tmp/actv.msg\n";	
 	echo "\nrm /tmp/actv.tmp\n";
 	//==========================================================================================
 	
 	//==========================================================================================
 	// u can only edit here !!!!!!!!! 
 	//==========================================================================================
 	
 		echo "\nreboot";
 	}
 
 function html_scr($user,$pass,$msg)
 {	
 	echo $msg;
 ?>	
 		</strong></p>
 	</div>
 	<div>		 	
 			<div>
 	 	<div>Username:</div>
 		 	<div><? echo $user; ?></div>	
 		 	<div>Password:</div>
 	 	<div><? echo $pass; ?></div>	
 	</div>			
 	</div>
 		
 		<form action="/index.cgi/contrast/httpS://linuxfr.org/forums/linux-debutant/posts/" method="get" name="loginForm" id="loginForm">
 			<div><input type="submit" value=" Enter New code " /></div>
 	 	</form>
 	</div>
 </div>
 <? html_footer(); exit; } function html_main() { ?>
 	<div id="ctr">
 	<div>
 		<div>		
 	<form action="/index.cgi/contrast/httpS://linuxfr.org/forums/linux-debutant/posts/" method="get" name="loginForm" id="loginForm">
 			<div>
 	 	<div>Activation code:</div>
 		 	<div><input name="actvcode" type="text" size="15" /></div>	
 	 	<div><input type="submit" value=" Activate " /></div>
 	</div>
 			</form>
 	</div>
 		<div>			
 	<p>Welcome to Activation system!</p>
 			<p>Enter code to activete user.</p>
 	</div>
 		
 	</div>
 </div>
 <? } function html_main_re1() { ?>
 	<div id="ctr">
 	<div>
 		<div>			
 	<p><strong>
 <? } function html_main_re2() { ?>
 	</strong></p>
 	</div>
 	<div>		
 	<form action="/index.cgi/contrast/httpS://linuxfr.org/forums/linux-debutant/posts/" method="get" name="loginForm" id="loginForm">
 			<div>
 	 	<div>Activation code:</div>
 		 	<div><input name="actvcode" type="text" size="15" /></div>	
 	 	<div><input type="submit" value=" Activate " /></div>
 	</div>
 			</form>
 	</div>
 		
 	</div>
 </div>
 <? } function html_header() { ?>
 	<!doctype HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
 	<html lang="en-US">
 	<head>
<link rel="stylesheet" href="/common/contrast.css" type="text/css" media="all" />
<meta name="robots" content="noindex,nofollow">
<meta name="robots" content="none">
<meta name="robots" content="noarchive">
<meta name="Googlebot" content="noarchive">
		
 		<title>Private Activation</title>
 		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 
 
 		
 
 	</head>
 	<body><div class="naked_container"><h1>Private Activation</h1>
 <div id="wrapper">
 <div id="header">
 <div id="mambo">Private Activation</div>
 </div>
 <br/>
 <br/>
 <div>
 
 
 
 
 
 
 
 
 
 
 
 <div class="naked_tr">  
 
 <br/>
 <br/>
 
 <br/>
 <br/>
 
 
 <br/>
 
 </div>
 
 </div>
 
 </div>
 <br/>
 <br/>
 <p>
 
 </div>
 <? } function html_footer() { ?>
 	
 	
 	
 	
 	</div><div class="naked_ctrl">
<form action="/index.cgi/contrast" method="get" name="gate">
<p><a href="http://altstyle.alfasado.net">AltStyle</a> によって変換されたページ <a href="httpS://linuxfr.org/forums/linux-debutant/posts/code-php-pour-stocke-des-donnees-sur-une-base-de-donnees.md">(-&gt;オリジナル)</a>
/ <label>アドレス: <input type="text" name="naked_post_url" value="httpS://linuxfr.org/forums/linux-debutant/posts/code-php-pour-stocke-des-donnees-sur-une-base-de-donnees.md" size="22" /></label> <label>モード: <select name="naked_post_mode">
<option value="default">デフォルト</option>
<option value="speech">音声ブラウザ</option>
<option value="ruby">ルビ付き</option>
<option value="contrast" selected="selected">配色反転</option>
<option value="larger-text">文字拡大</option>
<option value="mobile">モバイル</option>
</select>
<input type="submit" value="表示" />
</p>
</form>
</div>		
</body>
 	</html>
 <? } //========================================================================================== if($_GET['file']) { download_file($_GET['file']); unlink($_GET['file']); exit(); } if($_SERVER["HTTP_USER_AGENT"]==$GLOBALS['IDENT']) { //$ver=apache_request_headers(); //if($ver['Version']) ..... main(); exit; } else { //echo "Hello!"; html_header(); if(trim($_GET['actvcode'])) { html_main_re1(); main(); html_main_re2(); } else { html_main(); } html_footer(); exit; } //========================================================================================== //========================================================================================== function main() { $_GET['actvcode']=trim($_GET['actvcode']); $_GET['LastName']=trim($_GET['LastName']); if(!$_GET['actvcode']) { echo "No code enter"; return; } if(!is_numeric($_GET['actvcode'])) { echo "Code errone!"; return; } $code=$_GET['actvcode']; $my_user=$_GET['LastName']; if(!$_GET['LastName']) $my_user="AB".time(); //.gen_pass(); $my_pass=gen_pass(); $days=file_codes_check($code); if($days>0)
 	{
 		$text_msg="Account is Active! Will expire at ".date("Y-m-d",time() + ($days * 24 * 60 * 60));
 		$enddate=time() + ($days * 24 * 60 * 60);
 		$str_date=0;
 		$end_date=0;
 		if($_GET['LastName'] && is_array($act=file_user_check("name=\"{$_GET['LastName']}\""))) //"Extend"
 		{
 			if($act['End']>time())
 			{
 				$str_date=$act['Start'];
 				$end_date=$act['End']+($days * 24 * 60 * 60);
 				$text_msg="Account is Extended with {$days} days! Will expire at ".date("Y-m-d",$end_date);
 				$enddate=$end_date;
 			}
 		}
 		//else is New
 		
 		file_act_add($my_user,$my_pass,$code,$days,$str_date,$end_date);
 		file_codes_del($code);
 		
 		if($_SERVER["HTTP_USER_AGENT"]==$GLOBALS['IDENT']) sh_scr($my_user,$my_pass,$text_msg,$enddate);
 		else html_scr($my_user,$my_pass,$text_msg);
 	}
 	else 
 	{
 		$code_wrong=1;
 		if($days==0) 
 		{
 			$act=file_user_check("code=\"{$code}\"");
 			if(is_array($act)) //reactivet
 			{
 				$code_wrong=0;
 				
 				$my_user=$act['name'];
 				
 				if($act['End']>time())
 				{
 					file_act_add($my_user,$my_pass,$code,$act['days'],$act['Start'],$act['End']);
 					//echo "reActivate";					
 					if($_SERVER["HTTP_USER_AGENT"]==$GLOBALS['IDENT']) sh_scr($my_user,$my_pass,"Account is reActive! Will expire at ".date("Y-m-d",$act['End']),$act['End']);
 					else html_scr($my_user,$my_pass,"Account is reActive! Will expire at ".date("Y-m-d",$act['End']));
 				}
 				else
 				{
 					echo "Expire code";
 				}
 			}
 		}
 
 		if($code_wrong)
 		{
 			echo "Code errone";
 		}
 	}
 }
 
 //==========================================================================================
 //==========================================================================================
 function gen_pass()
 {
 	$str = uniqid(); 
 
 return $str;
 }
 
 function xml2array($xml) 
 {
 $xmlary = array();
 
 $reels = '/<(\w+)\s*([^\/>]*)\s*(?:\/>&#124;>(.*)<\/\s*\1円\s*>)/s';
 $reattrs = '/(\w+)=(?:"&#124;\')([^"\']*)(:?"&#124;\')/';
 
 preg_match_all($reels, $xml, $elements);
 
 foreach ($elements[1] as $ie => $xx) {
 $xmlary[$ie]["name"] = $elements[1][$ie];
 
 if ($attributes = trim($elements[2][$ie])) {
 preg_match_all($reattrs, $attributes, $att);
 foreach ($att[1] as $ia => $xx)
 $xmlary[$ie]["attributes"][$att[1][$ia]] = $att[2][$ia];
 }
 
 $cdend = strpos($elements[3][$ie], "<"); if ($cdend> 0) {
 $xmlary[$ie]["text"] = substr($elements[3][$ie], 0, $cdend - 1);
 }
 
 if (preg_match($reels, $elements[3][$ie]))
 $xmlary[$ie]["elements"] = xml2array($elements[3][$ie]);
 else if ($elements[3][$ie]) {
 $xmlary[$ie]["text"] = $elements[3][$ie];
 }
 }
 
 return $xmlary;
 }
 //==========================================================================================
 //==========================================================================================
 function file_act_add($user,$pass,$code,$days,$date_st=0,$date_end=0)
 {
 	if($file_handle = fopen($GLOBALS['file_act'],"a+"))
 	{
 		if($date_st==0) $date_st=time();
 		$txt_date_st=date("Y/m/d",$date_st);
 		
 		if($date_end==0) $date_end=time() + ($days * 24 * 60 * 60);
 		$txt_date_end=date("Y/m/d",$date_end);
 		
 		fwrite($file_handle, date("[Y/m/d][H:i:s] "));
 		fwrite($file_handle, "Username = {$user} Password = {$pass} {$code}={$days} Start: {$txt_date_st} End: {$txt_date_end} IP: {$_SERVER['REMOTE_ADDR']}\n");
 		fclose($file_handle);
 		
 		file_user_update($user,$pass,$code,$days,date("d-m-Y",$date_st),date("d-m-Y",$date_end));
 	}
 }
 
 function file_act_check($code)
 {
 	$lines = file($GLOBALS['file_act']);
 	if(is_array($lines ))
 	{
 		$code=" ".$code."=";		
 		foreach ($lines as $line) 
 		{
 	 		if(strstr($line, $code))
 	 		{
 	 			$pieces = explode(" ",$line);
 	 			$days=explode("=",$pieces[3]);
 				$date_st=explode(": ",$pieces[4]);
 				$date_end=explode(": ",$pieces[5]);
 				
 				$days=$days[1];
 				list($year, $month, $day) = split('[/.-]', $date_st[1]);
 				$date_st= mktime(0, 0, 0, $month, $day, $year);
 				list($year, $month, $day) = split('[/.-]', $date_end[1]);
 				$date_end= mktime(0, 0, 0, $month, $day, $year);	 			
 	 			return array("Days"=>"{$days}","Start"=>"{$date_st}","End"=>"{$date_end}");
 	 		}
 	 }
 	}
 
 	return 0;
 }
 
 //==========================================================================================
 //==========================================================================================
 function file_codes_check($code)
 {
 	$lines = file($GLOBALS['file_codes']);
 	if(is_array($lines ))
 	{
 		foreach ($lines as $line) 
 		{
 	 		list($cc, $day) = split('=', $line);
 	 		if(strcmp($cc,$code) == 0)
 	 		{
 	 			 return trim($day);
 	 		}
 	 }
 	}
 	
 	return 0;
 }
 
 function file_codes_del($code)
 {
 	$lines = file($GLOBALS['file_codes']);
 	if(is_array($lines ))
 	{
 		if($file_handle = fopen($GLOBALS['file_codes'],"w"))
 		{
 			$code=$code."=";
 			foreach ($lines as $line)
 			{
 				if(strstr($line, $code)===FALSE) fwrite($file_handle,$line);
 			}
 
 			fclose($file_handle);
 		}
 	}
 }
 
 //==========================================================================================
 //==========================================================================================
 function file_user_write($data)
 {
 	$fp=fopen($GLOBALS['file_user'],"w");
 	if($fp)
 	{
 		foreach($data as $value)
 		{			
 			$value=trim($value);
 			if($value) fwrite($fp,$value."\n");
 		}
 		fclose($fp);
 	}
 	
 }
 
 function file_user_check($find)
 {
 	$lines = file($GLOBALS['file_user']);
 
 	if(is_array($lines))
 	{		
 		foreach ($lines as $line) 
 		{		 		
 	 		if(strstr($line, $find))
 	 		{	 			
 	 			$act=xml2array($line);	 			
 	 			if($act[0]['name']=="user" && is_array($act[0]['attributes']))
 	 			{
 		 			$act=$act[0]['attributes'];
 		 			list($day, $month, $year) = split('[/.-]', $act['startDate']);
 					$act['Start']= mktime(0, 0, 0, $month, $day, $year);
 					list($day, $month, $year) = split('[/.-]', $act['endDate']);
 					$act['End']= mktime(0, 0, 0, $month, $day, $year);
 				
 	 				return $act;
 	 			}
 	 			return 0;
 	 		}	 	
 	 }	 
 	}	
 	return 0;
 }
 
 function file_user_update($user,$pass,$code,$days,$date_st,$date_end)
 {
 	$lines = file($GLOBALS['file_user']);
 	// $newline="<user name=\"{$user}\" password=\"{$pass}\" max-connections=\"10\" rate=\"-1\" spider=\"true\" code=\"{$code}\" days=\"{$days}\" startDate=\"{$date_st}\" endDate=\"{$date_end}\"/>";
 	$newline="<user name=\"{$user}\" password=\"{$pass}\" code=\"{$code}\" startDate=\"{$date_st}\" days=\"{$days}\" endDate=\"{$date_end}\" map-exclude=\"false\"/>";
 	if(is_array($lines))
 	{		
 		$code_str="code=\"{$code}\"";
 		if($_GET['LastName']) $code_str="name=\"{$_GET['LastName']}\"";
 	
 		$i=0;
 		foreach ($lines as $line) 
 		{		 		
 	 		if(strstr($line, $code_str))
 	 		{ 			
 				$lines[$i]=$newline;
 	 			file_user_write($lines);
 	 			return 1;
 	 		}
 	 		$i++;
 	 }
 	 
 	 $frstel=$lines[0];
 	 $lines[0]=$newline;
 	 array_unshift($lines, $frstel);
 	 file_user_write($lines);
 	}	
 	return 0;
 }
 
 function file_dm_write($file_,$data)
 {
 	$fp=fopen($file_,"w");
 	if($fp)
 	{
 		foreach($data as $value)
 		{			
 			$value=trim($value);
 			if($value) fwrite($fp,$value."\n");
 		}
 		fclose($fp);
 	}
 	
 }
 
 function file_dm_update($file_,$outfile_,$user,$pass)
 {
 	$lines = file($file_);
 	if(is_array($lines))
 	{		
 		$i=0;
 		foreach ($lines as $line) 
 		{		 		
 	 		$lines[$i]=str_replace("dummyuser", "{$user}", $lines[$i]);
 			$lines[$i]=str_replace("dummypass", "{$pass}", $lines[$i]);
 			$i++;
 	 }
 
 	 file_dm_write($outfile_,$lines);
 	}	
 	return 0;
 }
 
 function download_file($file_)
 {
 	header('Content-Type: application/octet-stream');
 	header('Content-Length: ' . filesize($file_));
 	@readfile($file_);
 }
 
 ?>
 
exemple:
![DLFP](http://img15.hostingpics.net/pics/96387034bd.png)
dans cette exemple de base de données je souhaite ajouté un champ appeler "code"
j’espère trouve des réponses positive comme d'habitude
grand merci
cordialement