אשכול: עזרה ב- Ckeditor
View Single Post
ישן 30-09-11, 20:44   # 3
Jonathan Zeierman
חבר וותיק
 
מיני פרופיל
תאריך הצטרפות: Jun 2007
הודעות: 1,003

Jonathan Zeierman לא מחובר  

ככה אני מציג את מה שהכנסתי למסד:
PHP קוד:
<?php
require ('admin/includes/PHP/db_connect.php'); //Requiring A Db Config File.
####################################################################################################
$query "SELECT main_text FROM index_page";                                                        ##
$result mysql_query($query)    or die("Mysql Getting The Next Error:" mysql_error());          ##
####################################################################################################
if ($row mysql_fetch_array($result))
{
        echo 
''.$row['main_text'].'';
}
mysql_close($db_connection); //Closing The Db Connection.
?>
ככה אני מעדכן:

PHP קוד:

        
function pages ()
        {
            echo 
'<html dir="rtl">
            <head>
            <title>עריכת עמודי תוכן</title>
            <meta http-equiv="Content-Language" content="he">
            <meta http-equiv="Content-Type" content="text/html; charset=windows-1255">
            <link href="includes/CSS/default.css" rel="stylesheet" type="text/css">
            </head>
            <body>
            <div class="navigation"><div><a href="index.php">ראשי</a> <img src="images/nav.gif">עריכת עמודי תוכן</div><div style="margin:5px"></div><table cellpadding="0" cellspacing="0" width="100%">
            <tr>
            <td align="right" class="nav_title">עריכת<font style="color:black;font-size:12px">(עמודי תוכן)</font></td>
            <td align="left" style="font-size:11px"><span style="padding-right:5px"><a href="javascript:history.go(-1)"><img src="images/up_level.gif"> חזור אחורה</a></span> <a href="editor.php?page=pages"><img src="images/refresh.gif"> רענן דף זה</a></td></tr>
            </table></div>
            <div class="DASKTOP">
            <fieldset>
            <legend>עריכת עמודי תוכן</legend>
            <div style="padding:10px">
            </div>
            </fieldset>
            <aligan=right>
            <table>
            <tr>
            <th>שם העמוד</th>
            <th>כתובת</th>
            <th>תבנית</th>
            <th>פעולות</th>        
            <th>נוסף</th>
            </tr>
            <tr>
            <td height="30px">&nbsp;&nbsp;עמוד ראשי&nbsp;&nbsp;</td>
            <td height="30px">&nbsp;&nbsp;http://net-power.co.il/demo_cms/index.php&nbsp;&nbsp;</td>
            <td height="30px">&nbsp;&nbsp;index&nbsp;&nbsp;</td>
            <td height="30px">
            &nbsp;&nbsp;
            <a href="editor.php?page=pages&act=edit_index"><img src="images/edit.gif" alt="" width="20px" height="20px" /> ערוך</a>
            &nbsp;&nbsp;-&nbsp;&nbsp;
            <a href="############"><img src="images/delete.gif" alt="" width="20px" height="20px" /> מחק</a>
            &nbsp;&nbsp;
            </td>        
            <td height="30px">&nbsp;&nbsp;נערך לאחרונה&nbsp;&nbsp;</td>
            </tr>        
            <tr>
            <td height="30px">&nbsp;&nbsp;צור קשר&nbsp;&nbsp;</td>
            <td height="30px">&nbsp;&nbsp;http://net-power.co.il/demo_cms/contact.php&nbsp;&nbsp;</td>
            <td height="30px">&nbsp;&nbsp;contact&nbsp;&nbsp;</td>
            <td height="30px">
            &nbsp;&nbsp;
            <a href="#############"><img src="images/edit.gif" alt="" width="20px" height="20px" /> ערוך</a>
            &nbsp;&nbsp;-&nbsp;&nbsp;
            <a href="#############"><img src="images/delete.gif" alt="" width="20px" height="20px" /> מחק</a>
            &nbsp;&nbsp;
            </td>        
            <td height="30px">&nbsp;&nbsp;נערך לאחרונה&nbsp;&nbsp;</td>
            </tr>        
            </table>
            </body>
            </html>'
;
            if (
$_GET['act'] == 'edit_index')
            {
                echo 
'<fieldset>
                <legend>עריכת דף ראשי</legend>
                <div style="padding:10px">
                </div>
                </fieldset>'
;
                echo 
"    <script type='text/javascript' src='ckeditor/ckeditor.js'></script>
                <script src='ckeditor/_samples/sample.js' type='text/javascript'></script>
                <link href='ckeditor/_samples/sample.css' rel='stylesheet' type='text/css' />
                <form action='' method='post'>
                <table>
                <tr>
                <td><gb>כותרת ראשית:</gb></td>
                <td><input type=text name='head1_title' value=''></td>
                </tr>
                <tr>
                <td><gb>כותרת משנית:</gb></td>
                <td><input type=text name='head2_title' value=''></td>
                </tr>
                <tr>
                <td><gb>כותרת לכתבה:</gb></td>
                <td><input type=text name='head3_title' value=''></td>
                </tr>
                </table>
                <p><label for='editor1'></label><br />
                <textarea cols='80' id='editor1' name='editor1' rows='10'></textarea>
                <script type='text/javascript'>
                CKEDITOR.replace( 'editor1',
                {
                    fullPage : true
                });
                </script></p>
                <table>
                <tr>
                <td><gb>כתובת לתמונה:</gb></td>
                <td><input type=text name='picture' value=''></td>
                </tr>
                </table>
                <input type='submit' value='Submit' name='index_page_update' />
                </form>"
;
                if (isset(
$_POST['index_page_update']))
                {
                    
################################################################################################
                    ##                             Require A DB Connection File.                                      ##
                    ################################################################################################
                    
require ('includes/PHP/db_connect.php');                                                      ##
                    ################################################################################################
                    ##                                        Variables.                                              ##
                    ################################################################################################
                    
$head1_title mysql_real_escape_string(htmlspecialchars($_POST['head1_title']));              ##
                    
$head2_title mysql_real_escape_string(htmlspecialchars($_POST['head2_title']));              ##
                    
$head3_title mysql_real_escape_string(htmlspecialchars($_POST['head3_title']));              ##
                    
$main_text mysql_real_escape_string(htmlspecialchars($_POST['editor1']));                      ##
                    
$picture mysql_real_escape_string(htmlspecialchars($_POST['picture']));                        ##
                    
$id mysql_real_escape_string(htmlspecialchars(0));                                          ##
                    ################################################################################################
                    ##echo '<meta http-equiv="Refresh" content="0; URL=index.php?page=Administrators">';              ##
                    ################################################################################################
                    ##                                    Update A Sql Table.                                          ##
                    ##############################################################################################################################################################################################################
                    
$query = ("UPDATE index_page SET head1_title='".$head1_title."' ,head2_title='".$head2_title."' ,head3_title='".$head3_title."' ,main_text='".$main_text."' ,picture='".$picture."' WHERE id='".$id."'");    ##
                    
$result mysql_query($query)    or die("Mysql Getting The Next Error:" mysql_error());                                                                                                                      ##
                    
mysql_close($db_connection); //Closing The Db Connection.                                                                                                                                                      ##
                    ##############################################################################################################################################################################################################
                
}
            }
        } 
__________________
יונתן.
אימייל: jonathan@zeierman.net
  Reply With Quote