ÎÒÔÚas4Éϰ²×°ÁËmysqlºÍphp-mysql
rpm -qa | grep php-mysql
php-mysql-4.3.9-3.22.4
rpm -qa | grep MySQL
MySQL-shared-4.1.20-0
MySQL-devel-standard-4.1.20-0.rhel4
MySQL-client-4.1.20-0
MySQL-server-standard-4.1.20-0.rhel4
¿ÉÊÇÔÚä¯ÀÀÆ÷´ò¿ªweb²âÊÔÒ³ÃæÊ±¿Õ°×£¬¾ßÌå²âÊÔphpÎļþ ......
ÏÈÌùÉÏ´úÂë°É£¬
<?php
if(!empty($_POST[username])){//ÊÂÏÈÎÒÓÐÒ»¸öÈÃÓû§ÊäÈëÓû§ÃûµÄ½çÃæ£¬È»ºóͨ¹ý±íµ¥´«´ïÕâ¸öÒ³Ãæ£¬
include ('conn.php');//Á¬½ÓÊý¾Ý¿â
$username=$_POST['username'];
$sql="SELECT * from `user` WHERE ......
ÔÚPHPÖУ¬Ê¹ÓÃlike²éѯÄÚÈÝʱ ÈçºÎ²»Çø·Ö´óСд£¿
Linuxϵͳ
¾ÍÊÇÊäÈëµÄ¹Ø¼ü´ÊÊÇ love ʱ£¬Êý¾Ý¿âÖÐΪLove LOVE lovE¶¼ÄÜÆ¥Åä
²¹³ä£º ÊÇmysqlÊý¾Ý¿â´æ
ʹÓÃÕâÑùµÄÓï¾ä£ºsql="select * from abc where a_name like '%$keyword%'";
ÄãÓõÄÊÇʲôÊý¾Ý¿â
Èç¹ûÊÇmysqlµÄ»° ²éѯµÄʱºòÄ¬È ......
PHPÖУ¬Ê¹ÓÃmysqlÊý¾Ý¿â,Linuxϵͳ¡£
ÔÚʹÓÃËÑË÷¹¦ÄÜʱ£¬Ö±½ÓÖ´ÐÐÕâÑùµÄÓï¾ä°²È«Âð£¿
$keyword=$_POST["keyword"];
$sql="select * from abc where a_name like '%$keyword%'";
$rs=mysql_query($sql);
.....
Èç¹û²»°²È«£¬Ó¦¸ÃÔõô¹ýÂË£¿Ð»Ð»
²»ÊÇ×ö¿ª·¢µÄ ¶ÔÕâ¸ö²»ÊìϤ
$keyword = trim($ke ......
GÁËһȦ£¬»ù±¾´úÂë¶¼ÊÇ£º
$arr=getimagesize($file);
imagecopyresized($newim, $im, 0, 0, 0,0, $width, $height,$arr[0] ,$arr[1] );
µ«ÊÇÕâ²¢²»ÊÇÎÒÒªµÄ£¬ÕâÊÇËõСͼƬ»ò·Å´óͼƬ¡£
¶øÎÒÒªµÄÊǼôÇÐͼƬ£¬¾ÍÊÇ×ö±Úֽվʱ£¬ÎÒÃÇ»áÐèÒª½«Ôͼ£¨¿ÉÄÜÊÇ1440x900£©£¬¼ôÇгÉ800x600µÄ¡£
¶ø²»ÊÇËõС¡£
³¬¹ý800x600µÄµØ·½²» ......
±¾È˳õѧPHP£¬Çë½Ìһϣ¬Õâ¸öº¯Êý²»Ì«Ã÷°×,Çë¿´¼Ó´Ö²¿·Ö
---------------
* »ñȡij¸öÀ¸Ä¿Áбí
* @param $pid À¸Ä¿ID
function getCategoryList($pid=0){
global $db;
return $db->getList("select * from category where pid=".$pid);
}
---------------
function getList($sql) {
$res = $th ......