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

MYSQLÓëSmartyµÄÓ¦ÓÃ

ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
£¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖFatal error: Call to undefined method mysql::fetch_row() in D:\WWW\news\index.php on line 12
,ÒÔÖÁÎÒ¶Á²»µ½{$row[1]}£¬¾ßÌåµÄ´úÂëÈçÏ£¬
//.......smarty_inc.php
<?php
include_once("Smarty/Smarty.class.php"); //°üº¬smartyÀàÎļþ

$smarty = new Smarty(); //½¨Á¢smartyʵÀý¶ÔÏó$smarty
$smarty->config_dir="Smarty/Config_File.class.php"; // Ŀ¼±äÁ¿
$smarty->template_dir = "./templates"; //ÉèÖÃÄ£°åĿ¼
$smarty->compile_dir = "./templates_c"; //ÉèÖñàÒëĿ¼
$smarty->cache_dir = "./caches/"; //»º´æÄ¿Â¼
$smarty->caching = true; //¿ªÆô»º´æ,ΪflaseµÄʱºî»º´æÎÞЧ
$smarty->cache_lifetime = 600; //»º´æÊ±¼ä
//----------------------------------------------------

//×óÓұ߽ç·û£¬Ä¬ÈÏΪ{}£¬µ«Êµ¼ÊÓ¦Óõ±ÖÐÈÝÒ×ÓëJavaScriptÏà³åÍ»

//----------------------------------------------------

$smarty->left_delimiter = "{";

$smarty->right_delimiter = "}";
?>
//......mysql_class.php
<?php
/*
* class mysql
* www.php100.com ±à¼­Æ÷½Ì³Ì
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/

  class mysql{


  private $ho


Ïà¹ØÎÊ´ð£º

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

mysql´¢´æ¹ý³ÌµÄÎÊÌâ

ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£

http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......

cÓïÑÔÈçºÎÁ¬½ÓMYSQL£¿

´ó¼ÒºÃ:
ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......

Ò»¸ömysqlµÄÎÊÌâ

ÓÐÒ»¸ö±í mytable ÓÐÏÂÃæ¼¸¸ö×Ö¶Î
id    class(ѧÉú°à¼¶)    studentSex(ѧÉúÐÔ±ð,1ÄÐ2Å®)  studentName(ѧÉúÐÔÃû)

¼ÙÉèÏÖÓÐÊ®¼¸¸ö°à¼¶,
ÎÒÏë»ñµÃ°à¼¶ÖÐÄÐѧÉú×î¶àµÄÈýÌõÏàÓ¦ ......

Çë½Ìmysql innodbÊý¾ÝÎļþ´óС³¬¹ýϵͳÏÞÖÆµÄÎÊÌâ

ÓÉÓÚÒÔǰûÓÐinnodbµÄÓ¦Óþ­Ñ飬ÔÚÅäÖÃinnodbµÄinnodb_data_file_pathÑ¡ÏîʱÓõÄÊÇĬÈÏÅäÖã¨ibdata1:10M:autoexte
nd£© ,½ñÌì·¢ÏÖ´ËÊý¾Ý¿âÔÚͬ²½Ö÷Êý¾Ý¿âÊý¾Ýʱ£¨´ËinnodbÊÇ×÷Ϊһ̨myisam dbµÄÀ䱸»úÆ÷£©£¬ibda ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ