php mysql»Ø¹öʾÀý
Ê×ÏÈ£¬½¨InnoDBÀàÐÍµÄ±í£¬²ÅÄÜÖ§³ÖÊÂÎñ
$handler = mysql_connect('localhost', '', '');
mysql_select_db('test');
mysql_query('SET AUTOCOMMIT=0'); // ÉèÖÃΪ²»×Ô¶¯Ìá½»²éѯ
mysql_query('START TRANSACTION'); // ¿ªÊ¼²éѯ£¬ÕâÀïÒ²¿ÉÒÔʹÓÃBEGIN
mysql_query("INSERT INTO users VALUES ('ccc')");
mysql_query("DELETE from users WHERE username = 'aac'");
if (mysql_affected_rows($handler) == 0)
mysql_query('ROLLBACK'); // Èç¹ûɾ³ýδÕÒµ½ÏàÓ¦µÄ¼Ç¼Ôò»Ø¹ö£¬²»Ö´ÐÐÉÏÃæµÄ²åÈë²éѯ
mysql_query('COMMIT');
mysql_close($handler);
Ïà¹ØÎĵµ£º
PayPal ¿ìËÙ¡¢°²È«¶øÓÖ·½±ã£¬ÊÇ¿ç¹ú½»Ò×µÄÊ×Ñ¡ÔÚÏ߸¶¿î·½Ê½¡£ÏÖÔÚPayPal¿ÉÒԺ͹úÄڴ󲿷ÖÐÅÓÿ¨¹ØÁª,¿ÉÒÔʵÏÖ¹úÈ˵Ŀç¹ú½»Ò×ÊÕÖ§¡£
ÉêÇëPayPal×¢²áÍøÖ·£ºhttps://www.paypal.com/
paypal½Ó¿ÚÓëÆäËü½Ó¿ÚÓÐЩ²»Í¬£¬ÉÔ΢¸´ÔÓÒ»µã¡£ ÆäÊµÒøÐнӿÚÒ²ËãÊÇÒ»¸öÕ¾µãµÄ²å¼þ¡£
Ëùνpaypal ipn£¨Instant Payment Notification£©£¬¾Í ......
½â¾ö·½·¨£º
1¡¢¹Ø±ÕÊý¾Ý¿âÁ¬½Ó;
2¡¢ÓÒ»÷Êý¾Ý¿âÑ¡Ôñ“Á¬½ÓÊôÐÔ”£»
3¡¢Ñ¡Ôñ“¸ß¼¶”ÊôÐÔÒ³£¬½«“ʹÓÃMySQL×Ö·û¼¯”µÄ¹´È¥µô£¬²¢Ñ¡Ôñ“±àÂë”Ϊ“936 (ANSI/OEM - Simplified Chinese GBK)”
4¡¢¹Ø±Õ±£´æ£¬ÖØÐÂÁ¬½Ó¡£ ......
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
#make install
4¡¢ÖØÐ±àÒëphp Ô ......
.$dbhost = 'localhost';
$dbuser = 'root'; //ÄãµÄmysqlÓû§Ãû
$dbpass = '123456'; //ÄãµÄmysqlÃÜÂë
$dbname = 'data'; //ÄãµÄmysql¿âÃû
//Á¬½Ó±¾µØÊý¾Ý¿â
$GLOBALS["conn"] = mysql_connect($dbhost,$dbuser,$dbpass);
//´ò¿ªÊý¾Ý¿â
mysql_select ......