刚学PHP遇到的难题

half_lif3

当我按submit了过后
就出现这个东西
难道我的database 除了问题吗？

Could not submit article; Unknown column 'title' in 'field list'

half_lif3

有点丢脸
问题解决了
想请问各位前辈
用php 来 edit css
来作 content management system
可行吗？
要来改website layout

[ 本帖最后由 half_lif3 于 11-6-2007 11:19 PM 编辑 ]

ikanyuchiew

当然可行啊 !

half_lif3

有谁有相关的参考呢？
留link给我...
拜托

ikanyuchiew

http://www.intranetjournal.com/php-cms/

half_lif3

我implement了 openWYSIWYG editor 进我的website
也可以把内容store 进去 mysql

可是我要如何把它retrieve 出来呢？
试了很多次...没有output 的

error is Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\fyp\admin\output.php on line 64

<?php
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; global $dbconn;
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; $result = @mysql_query('SELECT article_content FROM cms_articles');
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; while ($row = mysql_fetch_row($result)) &#160;//line 64
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; {
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; echo $row['article content'];
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; }
&#160; &#160; &#160; &#160; &#160; &#160; &#160;
&#160;?>

[ 本帖最后由 half_lif3 于 8-7-2007 02:41 AM 编辑 ]

hui_wooi

$result = @mysql_query('SELECT article_content FROM cms_articles');

[ 本帖最后由 hui_wooi 于 8-7-2007 03:00 AM 编辑 ]

half_lif3

<?php
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; require_once 'conn.php';
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;
&#160;&#160;&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; $result = mysql_query("SELECT article_content FROM cms_articles") or die("error query");
&#160;&#160;&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; while($row = mysql_fetch_row($result))
&#160;&#160;&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; {

&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; echo"&#160; &#160;&#160; &#160;&#160; &#160;&#160; &#160;&#160;&#160;<tr>";
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; echo"&#160; &#160;&#160; &#160;&#160; &#160;&#160; &#160;&#160; &#160;<tr><td>$row[3]</td></tr>";

&#160; &#160;&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; }
&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; ?>

改了一点coding
没有error出来
但什么content都显示不到出来
救命啊！
真paiseh酱简单的东西...刚刚开始学而已

[ 本帖最后由 half_lif3 于 8-7-2007 03:31 AM 编辑 ]

lmb

原帖由 half_lif3 于 8-7-2007 03:25 AM 发表


改了一点coding
没有error出来
但什么content都显示不到出来
救命啊！
真paiseh酱简单的东西...刚刚开始学而已

$result = mysql_query("SELECT article_content FROM cms_articles") or die ("error query");
while($row=mysql_fetch_assoc($result){
echo"              <tr>";
                echo"               <tr><td>$row['article_content']</td></tr>";

}

half_lif3

出这个error...什么意思呢？不过解决了...谢谢大大

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\Program Files\xampp\htdocs\fyp\admin\output.php on line 68

其实有点困扰...
眼前有份可以给我modify和expand function的 朋友的system
但我还是选择built from scratch
因为我对php 是一窍不通的...想学多点...但还是有参考朋友的system
希望我做对吧...毕竟是final year project
不学以后没得学了...

[ 本帖最后由 half_lif3 于 8-7-2007 03:18 PM 编辑 ]