Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySQLµÄcµ÷ÓÃ


1. ¸½¼ÓÏîÒ»¶¨ ¼ÓÉÏlibmysql.lib¡£
2. include Ò»¶¨¼ÓÉÏ mysqlµÄinclude£¨ÒòΪҪÅÜÕâ¹Ø¼üÒ»¾ä
#include <mysql.h>£©
3  lib Ò»¶¨¼ÓÉÏ mysqlµÄlib
 
ºÃÁËÏÂÃæÊÇʵÀýºÍphpº¯Êý»ù±¾Ò»ÑùµÄ¡£±¾È˲»¿ÉÄܸøÄã·­ÒëÎĵµ£¬º¯Êý²»¶®×Ô¼º¿´¡£
#include
<windows.h>//ÓÃÕâ¸ö·½±ã£¬°üº¬winsock.hËùÒÔ°üº¬winsockÒ²¿ÉÒÔ
#include <iostream>
#include <mysql.h>
using namespace std;
int main( int argc, char * argv[] )
{
//ÕâÀàÐͱð´íÁË£¬¾ßÌå¿´Îĵµ
 MYSQL mysql;
 MYSQL *pdata;
 MYSQL_RES
*result;   
 MYSQL_ROW
row;   
 char sqlcommand[80];
 mysql_init(&mysql);//Ò»¸ö³õʼ»¯
 mysql_options(&mysql,MYSQL_READ_DEFAULT_GROUP,"Gamer");
//¿ØÖÆÁ´½ÓÐÐΪµÄ
 pdata=mysql_real_connect(&mysql,"localhost","root","123456","gamer",0,NULL,0);
//Êý¾Ý¿âÁ´½Ó
 if(pdata)
 {
  cout<<"connect
successful!!"<<endl;
 }
 if(mysql_select_db(pdata,"gamerdata"))
 {
  cout<<"select_db
successful!!"<<endl;
 }
//È»ºóÑ¡ÔñÊý¾Ý¿âÁË£¬µ±È»ÓÃsqlÒ»Ñù£¬º¯Êý¿´×Å·½±ãµã
 sprintf(sqlcommand,"select * from
gamerdata");   
 
 mysql_query(pdata,sqlcommand);
//Õâ¾ä¸ÉʲôµÄ²»ÓÃÎÒ·Ñ´½ÉàÁË
 result =
mysql_use_result(pdata);
//»ñÈ¡¼Ç¼¼¯
 row = mysql_fetch_row(result);
//°´Êý×鷽ʽ°ÑÊý¾Ý·Åµ½rowÖУ¬µ±Ç°ÐеÄ
//¿´ËùÓÐÐмӸöÑ­»·¾ÍºÃ£¬Óαê×Ô¼º»áÅÜ£¬²»ÀÍ´ó¼Ò·ÑÐÄ¡£
 cout<<row[1];
//¿ÉÒÔÊä³öÁË£¬´ó¹¦¸æ³É
 mysql_close(pdata);
//±ðÍüÁË¿ªµÆ£¬ÍüÁ˹صÆ
}


Ïà¹ØÎĵµ£º

phpÏòMySQL²åÈëÊý¾Ý²»È« ½â¾ö·½·¨

½ñÌìΪÁËһЩÒÑÓÐÊý¾Ýµ¼ÈëMYSQLµÄÊý¾Ý¿â£¬ÎÒдÁËÒ»¸öºÜ¼òµ¥µÄPHP³ÌÐò¡£
³ÌÐò˼·ºÜ¼òµ¥£¬¾ÍÊǶÁÒ»ÌõÊý¾Ý£¬È»ºóÍùMYSQLÀï²åÈëÒ»Ìõ¡£
½á¹û×ÜÊÇ·¢ÏÖ Ã¿´Îµ¼ÈëÖ»Äܵ¼Èë2000Ìõ£¬¾Í×Ô¶¯Í£Ö¹ÁË£¬¶øÇÒûÓÐÈκÎÌáʾ¡£
ÔÚÍøÉÏËѽâ¾ö·½°¸¸÷ÖÖËѲ»µ½¡£
¸Õ¿ªÊ¼»³ÒÉÊÇÄڴ滺³å¸øÉÙÁË£¬µ÷ÁËһϣ¬»¹ÊDz»ÐС£¡£
×îºó·¢ÏÖÒ»¸ö¹æÂÉ£¬¾ÍÊÇ ......

PHP»·¾³ IIS+PHP+MYSQL»·¾³µÄ¼ÜÉè

ºÜ¾ÃûÓÐЩһЩÓÐÓô¦µÄµÄ¶«Î÷ÁË£¡½ñÌì¾Í²»ºúÂÒµÄд¶«Î÷ÁË!дһЩÓÐÓõ졵±È»Ç°ÌáÏÂÊǺܸÐлºÜ¶à¾­³£À´ÎÒ²©¿ÍµÄÅóÓÑһϣ¡¶àл´ó¼Ò£¡£¡£¡£¡£¡
½ñÌìдµÄÊǹØÓÚphp»·¾³¼ÜÉèµÄµÚÒ»ÖÖ·½Ê½£¡µ±È»ÎҾͲ»½ØÍ¼ÁË£¡´ó¼ÒÖ»Òª°´ÕÕ²Ù×÷¾Í¿ÉÒÔʵÏֵģ¡
Ò»¡¢°²×° PHP £º±¾ÎÄPHP°²×°Â·¾¶È¡ÎªD:\php\php4\(Ϊ±Ü»ìÏý£¬PHP5.1.x°æ±¾°²×°Â·¾ ......

error:cannot get C/H/S values

windows7 + ubuntu9.10Ë«Æô¶¯,Õâ¸öÓÐÌ«¶àµÄÌû×ÓÁË,²»¹ýÕâ´ÎµÄÇé¿ö±È½Ï¸´ÔÓ.
ÏÈ×°µÄWIN7,ºó×°UBUNTU,ûÓÐÈκÎÎÊÌâ.GRUBË«Æô¶¯.
ºóÀ´ÒòΪһ¸öÇé¿ö,ҪװXP,°ÑWIN7×öÁË ghost.×°ÍêXP,GRUBµ±È»Ã»ÓÐÁË,ÓÚÊÇÓÃubuntuÆô¶¯ÅÌÐÞ¸´.
ËäÈ»Æô¶¯²Ëµ¥³öÀ´ÁË,µ«Ö»ÄܽøÐÐubuntu,½øÈëwindowsµÄʱºò¾ÍÌáʾerror:cannot get C/H/S value ......

VIMÒ»¼ü±àÒëC³ÌÐò

    ÍøÉÏÓÐºÃ¶àÆªÎÄÕ½²ÈçºÎÅäÖÃ.vimrcÎļþÀ´ÊµÏÖVIMÀïÒ»¼ü±àÒ룬¿´ÁËһϱȽϸ´ÔÓ¡£ÎÒÒ»°ãûÓÐʲô´óµÄ³ÌÐòҪд£¬Ò»°ãµÄС³ÌÐòµ¥¸öCÎļþ¾Í¸ãµàÁË£¬ËùÒÔ¼ò»¯ÁËÒ»ÏÂÍøÉϵÄÅäÖã¬ÔÚ.vimrcÀï¼ÓÉÏÁ½ÐоÍÂú×ãÎÒµÄÐèÇóÁË¡£
    set makeprg=gcc\ -Wall\ -o\ %<\ %
map <F7> :make<CR ......

MySQL schemaÃüÃû¹æÔò

/*****************by
garcon1986************************************************************/
ͨÓùæÔò£º
Õû
¸öÊý¾Ý¿âÀïµÄÃû×Ö¶¼¾¡Á¿Ê¹ÓÃСд¡£ÕâÑùÄÜÏû³ýÓÉÓÚ´óСд£¨
case-sensitivity
£©´øÀ´
µÄ´íÎó¡£
Mysql
ĬÈÏÇø·Ö´óСд¡£
ʹ
ÓÃÏ»®Ïß¶Ï¿ªÃû×Ö£¬Ãû×ÖÖв»ÄÜ
ʹÓÿոñ¡£
Ãû×ÖÖо¡Á¿²»Òª
ʹ
ÓÃÊý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ