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);
Ïà¹ØÎĵµ£º
Ñ»·ÒýÓÃÒ»Ö±ÊÇPHP£¨Ó¦Óã©ÖÐÒ»¸öÍ»³öµÄÎÊÌâ¡£ÎÊÌâµÄ³öÏÖÊÇÓÉÓÚÕâÑùµÄÒ»¸öÊÂʵ£ºPHPΪphpÄÚ²¿±äÁ¿Ê¹ÓÃÒ»¸ö“ÒýÓüÆÊýÆ÷”ÄÚ´æ·ÖÅä»úÖÆ¡£ÕâÒ»»úÖÆ¶ÔһЩÏà±ÈÀ´Ëµ½Ï³¤Ê±¼äÔËÐеĽű¾£¨±ÈÈ磬ӦÓ÷þÎñÆ÷»òÕßeZ²âÊÔ×é¼þ£©»áÒý·¢ÎÊÌ⣬ÒòΪÄÚ´æÔڽű¾½áÊøÇ°Ê²»»á±»ÊͷŵôµÄ¡£µ«ÊÇ£¬£¨¼¸ºõ£©Ã»ÓÐÈË ......
from timyang¡¯s blog ×ÛºÏÈ¡ÉᣬʹÓÃMySQLÀ´´æ´¢key/value(schema-less)Êý¾Ý,valueÖпÉÒÔ·Å£º
Python dict
JSON object ʵ¼Êfriendfeed´æ·ÅµÄÊÇzlibѹËõµÄPython dictÊý¾Ý£¬µ±È»ÕâÖÖ°ó¶¨Ò»ÖÖÓïÑÔµÄ×ö·¨¾ßÓÐÕùÒéÐÔ¡£ ......
MYSQL Ó¦ÓÃÊ®·Ö¹ã·¶£¬ºÜ¶àÍøÕ¾¼¸ºõ¶¼ÔÚÓÃËû£¬ÒòΪËûµÄСÇɺÍÁé»îÐԵȷ½ÃæÈÃÎÒ¾ö¶¨Òª¶ÔËû½øÐÐÑо¿£¬µ½ÏÖÔÚÒѾ³É¹¦µÄ²»Óþ¹ýODBC£¬ADOµÈ·½Ê½¾Í¿ÉÒÔ¶ÁÈ¡ºÍ¸üÐÂÊý¾Ý¡£
ºÃÁ˲»¶àÂÞ࣬ÒÔÏÂÎÒÀ´½éÉÜ×ܸö³ÌÐòµÄϸ½Ú:
£¨Ò»£©APIÉùÃ÷
1. '·ÖÅä»ò³õʼ»¯ÊʺÏmysql_real_connect()µÄÒ»¸öMYSQL¶ÔÏñ¡ ......
just get a json
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<mce:script src="jquery-1.3.2.min.js" mce_src="jq ......
.$dbhost = 'localhost';
$dbuser = 'root'; //ÄãµÄmysqlÓû§Ãû
$dbpass = '123456'; //ÄãµÄmysqlÃÜÂë
$dbname = 'data'; //ÄãµÄmysql¿âÃû
//Á¬½Ó±¾µØÊý¾Ý¿â
$GLOBALS["conn"] = mysql_connect($dbhost,$dbuser,$dbpass);
//´ò¿ªÊý¾Ý¿â
mysql_select ......