禍種明珠
我教你記得給我加分哈:1,在html頁面或者php頁面寫一個表單,將這個頁面的內(nèi)容提交另外一個php頁面,這個php頁面是連接msq數(shù)據(jù)庫的,存到數(shù)據(jù)庫里面,然后你的html頁面里面寫查詢語句代碼如下:<?phpif(isset($_POST['content'])){ exit($_POST['content']);}?><form method="post"> <textarea name="content"cols="50"rows="10">內(nèi)容</textarea> <input type="submit"value="提交"/></form>
薩萬奇
<?php$con = mysql_connect("localhost","root","密碼");if (!$con){die('Could not connect: ' . mysql_error());}mysql_select_db("wexeditor", $con);mysql_query("set names utf8");$result = mysql_query("SELECT name,tel,kd,dh,datetime FROM student");echo "<table border='1'>";while($row = mysql_fetch_array($result)){ echo "<tr>"; echo "<td>".$row['name']."</td>"; echo "<td>".$row['tel']."</td>"; echo "<td>".$row['kd']."</td>"; echo "<td>".$row['dh']."</td>"; echo "<td>".date("Y-m-d",$row['datetime'])."</td>"; echo "</tr>";}echo "</table>";mysql_close($con);?>這個其實就是PHP手冊里的一個例子,多看看手冊,對你有幫助
田丁丁
<?phpfunction pai( $NumStr ) { $Arr = preg_split('/[\,,]+/is', $NumStr); $Ou = $Ji = array(); foreach( $Arr as $val ) { $val % 2 == 0 ? $Ou[] = $val : $Ji[] = $val; } arsort($Ji); asort($Ou); //print_r( $Ji ); echo join(',', $Ji ), ',', join(',', $Ou );}function ca( $NumStr ) { $Arr = preg_split('/[\,,]+/is', $NumStr); echo max( $Arr ) - min( $Arr );}function length( $Num ) { echo strlen( $Num );}pai('3,6,5,71,75,34,45,23,16');echo '<br/>';ca('15,78,65,10,30');echo '<br/>';length(4578445);
陷空老祖
恩 改了 你試試看這個我不可能寫得直接能連接到你所要求的數(shù)據(jù)庫的,因為不知道你數(shù)據(jù)庫信息與表的設(shè)計,所以你要自己更換代碼里的hostname,db_user,password,db以及表名,字段名,更換了應(yīng)當(dāng)就可以直接使用的,用戶名密碼正確與錯誤我做了修改<?phpsession_start(); $host = "localhost"; //服務(wù)器名稱 $db_user = "root"; //用戶名 $db_password = "74862856"; //密碼 $db = "TEST"; //所要連接的數(shù)據(jù)庫 $link_id = @ mysql_connect($host,$db_user,$db_password) or die("連接數(shù)據(jù)庫失敗".mysql_error()); $db_selected = mysql_select_db($db,$link_id); if(!$db_selected){ die("未找到指定的數(shù)據(jù)庫".mysql_error()); } if(isset($_COOKIE['user'])){ $sql = 'select * from name where user="'.$_COOKIE['user'].'"'; $result = @ mysql_query($sql,$link_id) or die("SQL語句出錯"); $row = mysql_fetch_array($result,MYSQL_ASSOC); if(isset($row)){ //如果數(shù)據(jù)庫中存在該用戶 Header("Location:index.php"); //合法COOKIE直接跳轉(zhuǎn)到指定界面 }else{ $_COOKIE['user'] = ""; //非法COOKIE清空 Header("Location:login.php"); //重新載入界面 }}if(isset($_POST['submitted'])){ $user = $_POST['user']; $pwd = $_POST['pwd']; $sql = 'select * from name where user="'.$user.'"'; $result = @ mysql_query($sql,$link_id) or die("SQL語句出錯"); $row = mysql_fetch_array($result,MYSQL_ASSOC); $cmp_pwd = $row['password']; if($cmp_pwd == $pwd){ //用從數(shù)據(jù)庫取出的密碼和提交的密碼比較 setcookie("user",$user,time()+300); //設(shè)置COOKIE echo "<script language=javascript>alert('登錄成功');</script>"; Header("Location:index.php"); //跳轉(zhuǎn)到指定頁面 }else{ echo "<script language=javascript>alert('用戶名或密碼錯誤');</script>"; Header("Location:login.php"); //重新載入頁面 }}?><html> <head> <title>登錄窗口</title> <meta http-equiv="Content-Type" content="text/html" charset="utf8"> </head> <body> <form action="just.php" method="post"> 用戶名: <input type="text" name="user" /> 密碼: <input type="password" name="pwd" /> <br/> <input type="hidden" name="submitted" value="1" /> <input type="submit" value="登錄" /> </form> </body></html>這個僅作參考,因為是非常簡化的登錄界面,沒有對提交的數(shù)據(jù)進(jìn)行驗證,密碼也不是按加密處理的,COOKIE的驗證也是不安全,但整個流程的形式有了,你可以自己慢慢擴(kuò)展
秘魔神裝
<table width="1008" border="0" cellspacing="0" cellpadding="0" style="margin-left:auto; margin-right:auto; margin-top:5px;border:#147FD1 1px solid;"><tr><?$i=0 foreach($Obj_huiyi as $k=>$val){?><td><?=$val['title'] ?></td><?$i++;if($i%2==0)echo "</tr><tr>"}?></tr></table>就這個原理大概就這樣子了。1.用循環(huán)。內(nèi)2.沒兩條數(shù)據(jù)換容行。
深宵煮酒
你的input type=hidden 里面的變量 $i 第一次的時候是沒有值的, 如下代碼e68a843231313335323631343130323136353331333238663538運行就可以了<table width="500"cellpadding="0"cellspacing="0"border="1" bgcolor="f0f0f0"> <form name="form3"method="POST"action="b3.php"> <tr> <td width="50%" height="30" align="center"valign="middle">base64</td> <td width="50%" align="center"valign="middle">base64 jiema</td> </tr> <tr> <td width="50%" align="center"valign="middle"> <input type="text"name="coding" size="20"/> </td> <td width="50%" align="center"valign="middle"> <input type="text"name="decode" size="20"/> </td> </tr> <tr> <td height="50"align="center"valign="middle">經(jīng)過BASE64編碼后: <?php echo"".base64_encode($_POST['coding']); $i=base64_encode($_POST['coding']); ?></td> <td align="center" valign="middle">經(jīng)過BASE64解碼后:<?php echo "<input type=hidden name=decode value=$i>"; echo"".base64_decode($i ? $i : $_POST['decode']); ?></td> </tr> <tr> <td height="30"colspan="2"><input type="submit"name="submit" value="提交"size="20"/></td> </tr> </form> </table>
秦嫫
<?php //參數(shù)Aisset($_GET['A']) ? $A = $_GET['A'] : '';//Time$time = date("Y/m/d");echo $time;//IP$ip = $_SERVER['REMOTE_ADDR'];if(!empty($_SERVER['HTTP_CLIENT_IP'])) {$ip = $_SERVER['HTTP_CLIENT_IP'];} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];}echo $ip;$db = mysql_connect('localhost', 'root', '') or die (mysql_error());//連接不上,就32313133353236313431303231363533e58685e5aeb931333332633636會顯示mysql出錯的原因。mysql_select_db("518", $db);$sql = "INSERT INTO TableName (Time, IP, A)VALUES ('$time','$ip','$A')";if (!mysql_query($sql,$db)) { die('Error: ' . mysql_error()); }echo "1 record added";$query = "SELECT A FROM TableName WHERE A LIKE '$A'";$result = mysql_query($query) or die("Invalid query; " .mysql_error());if (!mysql_fetch_array($result)){ echo 1;} else { echo 0;}mysql_free_result($result);mysql_close();?>
妖僧
<?phpmysql_query("insert into guahao values('".$name."','".$nl."','".$shouji."','".$sname."','".$info."')");?>
李撰
判斷這個變量$_SESSION['ses_group_staff_id']是否有值,如果沒有,則轉(zhuǎn)向login.php頁面應(yīng)該是判斷有沒有登錄的代碼