[PHP]PDOµ÷Óô洢¹ý³Ì
1. Êý¾Ý¿âÖÐÒÑ´´½¨´æ´¢¹ý³Ìuser_logon_check, PHPµ÷ÓÃʾÀýÈçÏÂ,
<?php
$dsn = 'mssql:dbname=MyDbName;host=localhost';
$user = 'sa';
$password = '666666';
try {
$dbCon = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
print 'Connection failed: '.$e->getMessage();
exit;
}
$username = '123';
$userpsw = '123';
//$xp_userlogon = $dbCon ->query("exec user_logon_check '$username','$userpsw'");
//mysql->call user_logon_check('$username','$userpsw');
//mysql->call user_logon_check(?,?)
$xp_userlogon = $dbCon->prepare('exec user_logon_check ?,?');
$xp_userlogon->bindParam(1,$username);
$xp_userlogon->bindParam(2,$userpsw);
$xp_userlogon->execute();
$uCol = $xp_userlogon->columnCount();
echo $uCol."<br>";
while($row = $xp_userlogon->fetch()){
for( $i=0; $i<$uCol; $i++ )
print $row[$i]." ";
print "<br>";
}
?>
Ïà¹ØÎĵµ£º
iconvº¯Êý¿âÄܹ»Íê³É¸÷ÖÖ×Ö·û¼¯¼äµÄת»»£¬ÊÇphp±à³ÌÖв»¿ÉȱÉٵĻù´¡º¯Êý¿â¡£
1¡¢ÏÂÔØlibiconvº¯Êý¿âhttp://ftp.gnu.org/pub/gnu/libiconv/libiconv-1.9.2.tar.gz£»
2¡¢½âѹËõtar -zxvf libiconv-1.9.2.tar.gz;
3¡¢°²×°libiconv
££configure --prefix=/usr/local/iconv
#make
......
¹úÍâµÄ¿ªÔ´¼¼ÊõÒ²Ó°ÏìºÍÍƶ¯Á˹úÄÚ¿ªÔ´³ÌÐòµÄ·¢Õ¹£¬ÉÏÎÄÎÒ½éÉܵġ¶¹úÍâÓÅÐ㿪ԴPHP½¨Õ¾³ÌÐòÒ»ÀÀ¡·ÖУ¬ºÜ¶à¹úÍ⿪Դ³ÌÐò²¢²»Ì«·ûºÏÖйúÈ˵ÄʹÓÃÏ°¹ß£¬¶ø¹úÄÚÓÐһЩ³§¼Ò»ò¸öÈËÒ²×öÁËһЩ²»´íµÄ²úÆ·£¬²»ÉÙ³ÌÐòÊÇÌṩԴ´úÂëÏÂÔصģ¬ËäÈ»ÓÐЩÔÚÐí¿ÉÐÒéÉϺͿªÔ´Ðí¿ÉÖ¤ÓÐЩ³öÈ룬µ«ÆäÔÚʹÓÃÉÏ»¹ÊÇͦ·ûºÏÖйúÈ˵ÄʹÓÃÏ°¹ß£¬½ñÌìÎÒ¾ ......
¿ªÔ´½¨Õ¾³ÌÐòÈñà³Ì¸ßÊÖºÍÖ»¶®´ò×ÖÉÏÍøµÄÈ˶¼¿ÉÒÔ¿ìËÙ½¨Á¢Ò»¸ö¹¦ÄÜÇ¿´ó¡¢½çÃæƯÁÁµÄÍøÕ¾¡£²»¹ÜÄãÊÇÏ뽨һ¸ö²©¿Í¡¢ÂÛ̳¡¢CMS¡¢µç×ÓÉÌÎñÍøÕ¾£¬»òÊÇWiki¡¢Ïà²á¹ÜÀí¡¢RSS¾ÛºÏºÍÀàDiggÍøÕ¾¡£Ä㶼¿ÉÒÔͨ¹ýÕâЩ½¨Õ¾¹¤¾ß¿ìËÙ½¨Á¢¡£
ÎÒÃÇ֮ǰ½éÉܹý23¸ö¿ªÔ´µÄCMS¹ÜÀíϵͳ£¬ÏÖÔÚÔòÈÃÎÒÃÇÀ´¿´Ò»ÏÂ26¿î¿ªÔ´½¨Õ¾³ÌÐò¡£
¹úÍâPHP¿ªÔ´½¨ ......
1 PHPÖе¥ÒýºÅÓëË«ÒýºÅµÄÇø±ð
¡¡¡¡ÔÚPHPÖУ¬Í¨³£Ò»¸ö×Ö·û´®±»¶¨ÒåÔÚÒ»¶ÔÒýºÅÖУ¬È磺
'I am a string in single quotes'
"I am a string in double quotes"
¡¡¡¡PHPÓï·¨·ÖÎöÆ÷ÊÇÓóɶԵÄÒýºÅÀ´ÅжÏÒ»¸ö×Ö·û´®µÄ¡£Òò´Ë£¬ËùÓÐ×Ö·û´®±ØÐëʹÓÃͬһÖÖµ¥»òÕßË«
ÒýºÅÀ´¶¨Ò忪ʼºÍ½áÊø¡£ÀýÈ磬ÏÂÃæµÄ×Ö´®¶¨ÒåÊ ......
¡¡¡¡Ã¿´ÎÎÒÃÇ·ÃÎÊ PHP ½Å±¾µÄʱºò£¬¶¼Êǵ±ËùÓеÄPHP½Å±¾Ö´ÐÐÍê³Éºó£¬ÎÒÃDzŵõ½·µ»Ø½á¹û¡£Èç¹ûÎÒÃÇÐèÒªÒ»¸ö½Å±¾³ÖÐøµÄÔËÐУ¬ÄÇôÎÒÃǾÍҪͨ¹ý PHP ³¤Á¬½ÓµÄ·½Ê½£¬À´´ïµ½ÔËÐÐÄ¿µÄ¡£
¡¡¡¡Ã¿¸ö PHP ½Å±¾¶¼ÏÞÖÆÁËÖ´ÐÐʱ¼ä£¬ËùÒÔÎÒÃÇÐèҪͨ¹ý set_time_limit À´ÉèÖÃÒ»¸ö½Å±¾µÄÖ´ÐÐʱ¼äΪÎÞÏÞ³¤£»È»ºóʹÓà flush() ºÍ ob_flush() ......