pixeltrace
-
Posts
577 -
Joined
-
Last visited
Never
Posts posted by pixeltrace
-
-
Hi,
is there anyone here who knows where i can get the msn messenger api
for linux/php?
i am developing a new site now and my boss needs a msn messenger to be added on the website
something like an online chat for users to interact with the website's owner.
hope anyone here can help me with this.
thanks!
-
Hi,
i am developing a site and everything on the site is static
meaning no database.
now, they wanted to add a search tool bar
thats is only meant to search by keywords
my problem is i dont know how to do it because i have done it before.
hope anyone here can help me
thanks!
-
Hi,
problem solve already.
thanks for all the help.
just for reference, this is my working code
<? include '../admean/db_connect.php'; ?> <script type="text/javascript"> <!-- function toggle_visibility(id) { var e = document.getElementById(id); if(e.style.display == 'block') e.style.display = 'none'; else e.style.display = 'block'; } //--> </script> <table width="400" border="0" cellspacing="0" cellpadding="0"> <? $uSql = "SELECT category_name, cid FROM engsoon_categories WHERE parent ='0'"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ $i = 1; while($uRow = mysql_fetch_array($uResult)){ $pid = $uRow["cid"]; $category_name = $uRow['category_name']; //$keys = array_keys ($category_name); ?> <tr> <td> <a href="#" onclick="toggle_visibility('<? echo "$i"; ?>');"><? echo "$category_name"; ?></a> <? $sql2 = "SELECT category_name, cid FROM engsoon_categories WHERE parent='$pid'"; $result = mysql_query($sql2, $connection); if(!$result){ echo 'no data found'; }else{ echo "<table id=" . $i ." style='display:none'>"; while($row = mysql_fetch_array($result)){ $cname = $row['category_name']; ?> <? echo "<tr><td>--"."$cname"."</td></tr>"; } echo "</table>"; } ?> </td> </tr> <? $i++; } } ?> </table> </body> </html>thanks!
-
thanks!
$i works!
-
hi,
i need to list something which will be driven from mysql database
and the output that i want to have is something like this.
1. item1
2. item 2
3. item3
4. item5
.........
how can i generate the numbers 1. - 4. ......?
thanks!
-
hi,
i tried it but its still not working.
i check the source code of the html output and here is how it look like
<script type="text/javascript"> <!-- function toggle_visibility(id) { var e = document.getElementById(id); if(e.style.display == 'block') e.style.display = 'none'; else e.style.display = 'block'; } //--> </script> <table width="400" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <a href="#" onclick="toggle_visibility('');">testparent1</a> <table id=2><tr><td>--testsubcategory2</td></tr></table> <table id=3><tr><td>--testsub</td></tr></table> </td> </tr> <tr> <td> <a href="#" onclick="toggle_visibility('');">testparent2</a> <table id=5><tr><td>--testsubcategory1</td></tr></table> <table id=6><tr><td>--testsubcategory2</td></tr></table> </td> </tr> </table> </body> </html>what i wanted to achieve is that
the toggle visibility () value of testparent1 will be equal to the
table id= of
testsubcategory2
testsub
so forth and so on.
how can i make it work that way?
hope you could help me with this.
thanks!
-
Hi,
i found a easy way,
i just used a javascript that will show or hide the submenus.
but i have a problem, i need to have the value of my id to increment +1 for every count of my main menu
and i dont know how to do it.
i placed 1++ on the parameter that i wanted to increment +1 but its not working and i am getting an error
Parse error: syntax error, unexpected T_INC in /home/brennan/public_html/ideas-people/engsoon/products/test.php on line 26
below is my current code
<? include '../admean/db_connect.php'; ?> <script type="text/javascript"> <!-- function toggle_visibility(id) { var e = document.getElementById(id); if(e.style.display == 'block') e.style.display = 'none'; else e.style.display = 'block'; } //--> </script> <table width="400" border="0" cellspacing="0" cellpadding="0"> <? $uSql = "SELECT category_name, cid FROM engsoon_categories WHERE parent ='0'"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ $pid = $uRow["cid"]; ?> <tr> <td><a href="javascript;" onclick="toggle_visibility('<? 1++ ?>');"><?= $uRow['category_name']; ?></a> <? $sql2 = "SELECT category_name, cid FROM engsoon_categories WHERE parent='$pid'"; $result = mysql_query($sql2, $connection); if(!$result){ echo 'no data found'; }else{ while($row = mysql_fetch_array($result)){ $cname = $row['category_name']; ?> <? echo "<table id=" . 1++ ."><tr><td>--"."$cname"."</td></tr></table>"; } } ?> </td> </tr> <? } } ?> </table> </body> </html>hope you could help me fix this.
thanks!
-
Hi,
anyone here has done a vertical menu using php with mysql database?
something like this
menu1
> submenu1
> submenu2
> submenu3
menu2
>submenu4
>submen5
then when you click the menu it shows/ hide the submenu.
hope you could help me with this.
thanks!
-
hi,
thanks for the reply.
i made another solution, its working for
$sql_parent_check only but not for $sql_subcat_check
below is my current code
<? session_start(); if (session_is_registered("username")){ $username = $_SESSION['username']; $cid = $_GET['cid']; include 'db_connect.php'; $query = mysql_query("SELECT parent, category_name, cid FROM engsoon_categories WHERE cid= '$cid'") or die(mysql_error()); $row = mysql_fetch_array( $query ); $category_name = $row["category_name"]; $parent = $row["parent"]; $category_name_cn = $row["category_name_cn"]; //$parent_cn = $row["parent_cn"]; //$cid = $row["cid"]; ?> <table width="100" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="6" align="left"><img src="../images/spacer.gif" width="6" height="10" /></td> <td width="100%"><table width="216" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3" valign="top" bgcolor="#3261BB"><img src="images/spacer.gif" width="1" height="1" /></td> </tr> <tr> <td align="left" bgcolor="#3261BB" width="1"><img src="images/spacer.gif" width="1" height="1" /></td> <td width="214" valign="top"> <form name="fileup" method="post" enctype="multipart/form-data" action="<? echo $PHP_SELF; ?>"> <table width="515" border="0" cellspacing="2" cellpadding="3"> <tr> <td colspan="4" valign="top"><img src="images/spacer.gif" width="10" height="1" /></td> </tr> <tr> <td colspan="4" bgcolor="#999999" class="text2">EDIT PRODUCT CATEGORY</td> </tr> <tr> <td colspan="4" valign="top"><img src="images/spacer.gif" width="10" height="10" /></td> </tr> <tr> <td width="148" align="right" valign="top" class="text6"><? if ($parent == '0'){ echo "parent category :"; }else{ echo "category name :"; } ?> </td> <td> </td> <td width="332" colspan="2" class="text7"><input name="category_name" type="text" size="40" value="<? echo "$category_name"; ?>" class="textfield"></td> </tr> <? if ($parent ==0) {echo "";}else { ?> <tr> <td align="right" valign="top" class="text6">parent category : </td> <td width="1"> </td> <td colspan="2"><select name="parent" class="textfield"> <option value="">-- select parent category --</option> <? $_SESSION['fu'] = $parent; $uSql = "SELECT category_name, cid FROM engsoon_categories WHERE parent =0"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ ?> <option value="<?= $uRow[1]?>" <?php if(($uRow[1] == $_SESSION['fu']))print 'selected';?>> <?= $uRow[0]?> </option> <? } } ?> </select></td> </tr> <tr> <td align="right" valign="top" class="text6"> </td> <td width="1"> </td> <td colspan="2" class="text7">* select a parent category only for sub category items </td> </tr> <? } ?> <tr> <td> </td> <td> </td> <td colspan="2"><input type="submit" value="submit" name="submit"> <input type="hidden" name="username" value="<? echo "$username"; ?>"> <input type=hidden value=http://www. name=redirect> <input type="hidden" value="<? echo "$cid"; ?>" name="cid" /> <input type="hidden" value="<? echo "$category_name"; ?>" name="cname" /> <input type="hidden" value="<? echo "$parent"; ?>" name="p" /> </td> </tr> <tr> <td> </td> <td> </td> <td colspan="2"> </td> </tr> </table> </form> </td> <td align="right" bgcolor="#3261BB" width="1"><img src="images/spacer.gif" width="1" height="1" /></td> </tr> <tr> <td colspan="3" valign="top" bgcolor="#3261BB"><img src="images/spacer.gif" width="1" height="1" /></td> </tr> </table></td> <td width="6" align="right"><img src="../images/spacer.gif" width="6" height="10" /></td> </tr> </table> <? //see if we have submited and that the files array has been set if(($_POST["submit"]=="submit")){ $category_name = $_POST['category_name']; $parent = $_POST['parent']; $cname = $_POST['cname']; $p = $_POST['p']; //$category_name_cn = $_POST['category_name_cn']; //$parent_cn = $_POST['parent_cn']; $cid = $_POST['cid']; if (($cname != $category_name)&&($p != $parent)){ //parent category verification english $sql_parent_check = mysql_query("SELECT category_name FROM engsoon_categories WHERE parent = 0 AND category_name='$category_name'"); $parent_check = mysql_num_rows($sql_parent_check); if($parent_check > 0){ echo '<script language=javascript> alert("parent category already exist!");top.location = "categorymngr.php?id=3&cid='.$cid.'";</script>'; unset($parent); exit(); } //subcategory verification english $sql_subcat_check = mysql_query("SELECT category_name FROM engsoon_categories WHERE parent = '$parent' AND category_name='$category_name'"); $subcat_check = mysql_num_rows($sql_subcat_check); if($subcat_check > 0){ echo '<script language=javascript> alert("subcategory item for this parent category already exist!");top.location = "categorymngr.php?id=3&cid='.$cid.'";</script>'; unset($parent); exit(); } } /* if (($_SESSION['category_name_cn'] != '$category_name_cn')&&($_SESSION['parent_cn'] != '$parent_cn')){ //parent category verification chinese $sql_parent_check = mysql_query("SELECT category_name_cn FROM engsoon_categories WHERE parent_cn = '0' AND category_name_cn='$category_name_cn'"); $parent_check = mysql_num_rows($sql_parent_check); if($parent_check > 0){ echo '<script language=javascript> alert("chinese parent category already exist!");top.location = "categorymngr.php?id=3&cid='.$cid.'";</script>'; unset($parent_cn); exit(); } //subcategory verification chinese $sql_subcat_check = mysql_query("SELECT category_name_cn FROM engsoon_categories WHERE parent_cn = '$parent_cn' AND category_name_cn='$category_name_cn'"); $subcat_check = mysql_num_rows($sql_subcat_check); if($subcat_check > 0){ echo '<script language=javascript> alert("chinese subcategory item for this parent category already exist!");top.location = "categorymngr.php?id=3&cid='.$cid.'";</script>'; unset($category_name_cn); exit(); } } */ $category_name = stripslashes($category_name); $parent = stripslashes($parent); //$category_name_cn = stripslashes($category_name_cn); //$parent_cn = stripslashes($parent_cn); $sql="UPDATE engsoon_categories SET category_name ='$category_name', parent='$parent' WHERE cid='$cid'"; mysql_query($sql) or die("error:".mysql_error()); echo '<script language=javascript> alert("category item has been updated!");top.location = "categorymngr.php?id=2";</script>'; } }else{ echo "<font face=\"Arial\">You are not authorized to access this page ... Please <a href='../index.php'>Login</a></font>"; } ?>could you help me fix this? because what i wanted to happen is
if there is any change done from the text fields category_name and parent
the checking will compare the post value vs the original value
and will run the sql query to check if the category_name where parent = and category = to the post values are already existing.
is there something wrong with my condition?
hope you could help me fix this.
Thanks!
-
Hi,
has anyone here did a setup already
that has apache2-tomcat4 mod_jk connector?
i went to a lot of reference sites already but cant make it work
hope anyone from here can help me because i've
been working on this for almost 2 weeks now.
thanks!
-
hi,
i have an edit page that has a validation scripts to check if the session value is != or = to the post value
currently, its not working and is always telling me that the item is already existing whenever i dont do any changes on the value
below is my code for this page
<? session_start(); if (session_is_registered("username")){ $username = $_SESSION['username']; $cid = $_GET['cid']; include 'db_connect.php'; $query = mysql_query("SELECT parent, category_name, parent_cn, category_name_cn, cid FROM engsoon_categories WHERE cid= '$cid'") or die(mysql_error()); $row = mysql_fetch_array( $query ); $category_name = $row["category_name"]; $parent = $row["parent"]; $category_name_cn = $row["category_name_cn"]; $parent_cn = $row["parent_cn"]; $cid = $row["cid"]; ?> <table width="100" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="6" align="left"><img src="../images/spacer.gif" width="6" height="10" /></td> <td width="100%"><table width="216" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3" valign="top" bgcolor="#3261BB"><img src="images/spacer.gif" width="1" height="1" /></td> </tr> <tr> <td align="left" bgcolor="#3261BB" width="1"><img src="images/spacer.gif" width="1" height="1" /></td> <td width="214" valign="top"> <form name="fileup" method="post" enctype="multipart/form-data" action="<? echo $PHP_SELF; ?>"> <table width="515" border="0" cellspacing="2" cellpadding="3"> <tr> <td colspan="4" valign="top"><img src="images/spacer.gif" width="10" height="1" /></td> </tr> <tr> <td colspan="4" bgcolor="#999999" class="text2">EDIT PRODUCT CATEGORY</td> </tr> <tr> <td colspan="4" valign="top"><img src="images/spacer.gif" width="10" height="10" /></td> </tr> <tr> <td width="148" align="right" valign="top" class="text6"><? if ($parent == '0'){ echo "parent category :"; }else{ echo "category name :"; } ?> </td> <td> </td> <td width="332" colspan="2" class="text7"><input name="category_name" type="text" size="40" value="<? echo "$category_name"; ?>" class="textfield"></td> </tr> <? if ($parent ==0) {echo "";}else { ?> <tr> <td align="right" valign="top" class="text6">parent category : </td> <td width="1"> </td> <td colspan="2"><select name="parent" class="textfield"> <option value="">-- select parent category --</option> <? $_SESSION['fu'] = $parent; $uSql = "SELECT category_name, cid FROM engsoon_categories WHERE parent =0"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ ?> <option value="<?= $uRow[1]?>" <?php if(($uRow[1] == $_SESSION['fu']))print 'selected';?>> <?= $uRow[0]?> </option> <? } } ?> </select></td> </tr> <tr> <td align="right" valign="top" class="text6"> </td> <td width="1"> </td> <td colspan="2" class="text7">* select a parent category only for sub category items </td> </tr> <tr> <td align="right" valign="top" class="text6"> </td> <td width="1"> </td> <td colspan="2" class="text7"> </td> </tr> <? } ?> <tr> <td align="right" valign="top" class="text6"><? if ($parent_cn == '0'){ echo "chinese parent category :"; }else{ echo "chinses category name :"; } ?></td> <td width="1"> </td> <td colspan="2" class="text7"><input name="category_name_cn" type="text" size="40" value="<? echo "$category_name_cn"; ?>" class="textfield"></td> </tr> <? if ($parent_cn ==0) {echo "";}else { ?> <tr> <td align="right" valign="top" class="text6">chinese parent category :</td> <td width="1"> </td> <td colspan="2" class="text7"><select name="parent_cn" class="textfield"> <option value="">-- select parent category --</option> <? $_SESSION['fus'] = $parent_cn; $uSql2 = "SELECT category_name_cn, cid FROM engsoon_categories WHERE parent_cn =0"; $uResult = mysql_query($uSql2, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ ?> <option value="<?= $uRow[1]?>" <?php if(($uRow[1] == $_SESSION['fus']))print 'selected';?>> <?= $uRow[0]?> </option> <? } } ?> </select></td> </tr> <tr> <td align="right" valign="top" class="text6"> </td> <td width="1"> </td> <td colspan="2" class="text7">* select a parent category only for sub category items </td> </tr> <? } ?> <tr> <td> </td> <td> </td> <td colspan="2"><input type="submit" value="submit" name="submit"> <input type="hidden" name="username" value="<? echo "$username"; ?>"> <input type=hidden value=http://www. name=redirect> <input type="hidden" value="<? echo "$cid"; ?>" name="cid" /></td> </tr> <tr> <td> </td> <td> </td> <td colspan="2"> </td> </tr> </table> </form> </td> <td align="right" bgcolor="#3261BB" width="1"><img src="images/spacer.gif" width="1" height="1" /></td> </tr> <tr> <td colspan="3" valign="top" bgcolor="#3261BB"><img src="images/spacer.gif" width="1" height="1" /></td> </tr> </table></td> <td width="6" align="right"><img src="../images/spacer.gif" width="6" height="10" /></td> </tr> </table> <? //see if we have submited and that the files array has been set if(($_POST["submit"]=="submit")){ $category_name = $_POST['category_name']; $parent = $_POST['parent']; $category_name_cn = $_POST['category_name_cn']; $parent_cn = $_POST['parent_cn']; $cid = $_POST['cid']; if (($_SESSION['category_name'] != '$category_name')&&($_SESSION['parent'] != '$parent')){ //parent category verification english $sql_parent_check = mysql_query("SELECT category_name FROM engsoon_categories WHERE parent = '0' AND category_name='$category_name'"); $parent_check = mysql_num_rows($sql_parent_check); if($parent_check > 0){ echo '<script language=javascript> alert("parent category already exist!");top.location = "categorymngr.php?id=3&cid='.$cid.'";</script>'; unset($parent); exit(); } //subcategory verification english $sql_subcat_check = mysql_query("SELECT category_name FROM engsoon_categories WHERE parent = '$parent' AND category_name='$category_name'"); $subcat_check = mysql_num_rows($sql_subcat_check); if($subcat_check > 0){ echo '<script language=javascript> alert("subcategory item for this parent category already exist!");top.location = "categorymngr.php?id=3&cid='.$cid.'";</script>'; unset($category_name); exit(); } } if (($_SESSION['category_name_cn'] != '$category_name_cn')&&($_SESSION['parent_cn'] != '$parent_cn')){ //parent category verification chinese $sql_parent_check = mysql_query("SELECT category_name_cn FROM engsoon_categories WHERE parent_cn = '0' AND category_name_cn='$category_name_cn'"); $parent_check = mysql_num_rows($sql_parent_check); if($parent_check > 0){ echo '<script language=javascript> alert("chinese parent category already exist!");top.location = "categorymngr.php?id=3&cid='.$cid.'";</script>'; unset($parent_cn); exit(); } //subcategory verification chinese $sql_subcat_check = mysql_query("SELECT category_name_cn FROM engsoon_categories WHERE parent_cn = '$parent_cn' AND category_name_cn='$category_name_cn'"); $subcat_check = mysql_num_rows($sql_subcat_check); if($subcat_check > 0){ echo '<script language=javascript> alert("chinese subcategory item for this parent category already exist!");top.location = "categorymngr.php?id=3&cid='.$cid.'";</script>'; unset($category_name_cn); exit(); } } $category_name = stripslashes($category_name); $parent = stripslashes($parent); $category_name_cn = stripslashes($category_name_cn); $parent_cn = stripslashes($parent_cn); $sql="UPDATE engsoon_categories SET category_name ='$category_name', parent='$parent', category_name_cn='$category_name_cn', parent_cn='$parent_cn' WHERE cid='$cid'"; mysql_query($sql) or die("error:".mysql_error()); echo '<script language=javascript> alert("category item has been updated!");top.location = "categorymngr.php?id=2";</script>'; } }else{ echo "<font face=\"Arial\">You are not authorized to access this page ... Please <a href='../index.php'>Login</a></font>"; } ?>hope you could help me fix this
thanks!
-
Hi,
I installed apache 2.0.43 in my linux test server
using httpd2.0.43.tar.gz and do the typical installation
./configure
make
make install
the source codes and configs are located
in
/usr/local/apache2/
now i wanted to start my apache and use
# /usr/local/apache2/bin/apachectl start
but i am getting this error message
httpd: could not open document config file /httpd.conf
what could be the cause of this? i already rebooted my test server
but its still the same.
hope you could help me fix this.
thanks!
-
Hi,
i installed linux redhat 9 and it already has apache 2.0.20
now, i wanted to upgrade my apache to 2.0.43
my problem now, i dont know where to get the
upgrade file and how.
hope you could help me with this. and if you could give me
the link where to download the upgrade file.
i would appreciate it very much.
thanks!
-
Hi,
After my sql query statement, in that same page
i just echo the text content made from tinymce.
<? echo "$textcontenthere"; ?>
from there instead of just displaying the text, its also showing the html tags like
<tr><td>.....<br><font style>......
hope you could help me with this.
thanks!
-
hi,
i have an backend page that uses tinymce
to make text contents for the front-end.
my problem now, whenever i am displaying the text content made from
tinymce, its also showing the HTML tags and parameters.
how can i fix this?
hope you could help me with this.
thanks!
-
hi,
i have a problem, we have setup a new website in our server
and already have tomcat and mysql.
i installed apached since we will be installing a php website on that same server.
my problem now,
when i check my phpinfo
i dont see mysql there.
how can i add the mysql path in my php in a linux platform.
hope you could help me with this.
thanks!
-
hi,
i need to backup our entire test server and its only using 1 partition.
this is the first time that i will be backing up linux server.
Hope you could help me on how to do this.
thanks!
-
hi,
here is what i have done
installed apache2, mysql5
installed the website files
my problem now is how i can test the site in our test server?
is there anything else which i need to do so when i go to the browser and type the ip address of
that test server i can already view the site?
hope you could help me with this.
thanks!
-
hi,
yes load data is giving me the same problem
any other solution?
thanks!
-
hi,
any updates on this?
i tried using
shell> split -b 32000000 database.sql
and
shell> split -l 400 database.sql
the database was split but i dont know how to import them to mysql.
hope you could help me with this.
thanks so much!
-
hi,
i need help, i hava a DB backup that i need to dump into our new server
and the size is 2.6GB
i know that in mysql 5 the max load is only 1GB
my problem now is whenever i am using
shell> mysql -p -h localhost database < database.sql
i am getting this error
ERROR 1153 (08S01) at line 33: Got a packet bigger than 'max_allowed_packet' bytes
i need to know what other options i can use so i can import the database
hope you could help me with this.
thanks!
-
hi,
need help,
what is the mysql command to dump database?
i have a database.sql database file and the database name is not yet existing.
i tried
mysqldump -h localhost > database-db.sql
mysqldump: Got error: 1049: Unknown database 'opencms' when selecting the database
but i am getting an error and i dont think i am using the correct command.
hope you could help me with this.
thanks!
-
Hi,
I need to install SOAP to synchronize data from our client's database to our live server in linux/php environment.
i already installed and setup soap in our server
but i dont know how to create the wsdl file and what are the needed codes that i need to place there
so i can connect to the client's database and have it synchronize with our live server database.
hope you could help me with this.
thanks a lot!
-
hi,
i need help.
we need to test a specific website in our new test server.
so what i have now is, i already unzip the site files into our test server
including the sql.
my problem now, i dont know how to test the site via browser if its working fine.
since i haven't setup a website in a linux environment before.
hope you could help me on the setup.
thanks!
[SOLVED] need help on my update page
in PHP Coding Help
Posted
hi,
i have a simple update page but its seem that its not working.
whenever i click the update button, its just refreshes the page and the content is still the same.
below is my current code
<? $id = $_GET['id']; include '../db_connect.php'; $query = mysql_query("SELECT content_id, category_name, content_value FROM static_contents WHERE content_id= '$id'") or die(mysql_error()); $row = mysql_fetch_array( $query ); $content_id = $row["content_id"]; $category_name = $row["category_name"]; $content_value = $row["content_value"]; ?> <html> <head> <title>Manymoonshop Static Content Update</title> <!-- TinyMCE --> <script language="javascript" type="text/javascript" src="tinymce/jscripts/tiny_mce/tiny_mce.js"></script> <script language="javascript" type="text/javascript"> tinyMCE.init({ mode : "textareas", theme : "advanced", plugins : "table,save,advhr,advimage,advlink,emotions,iespell,insertdatetime,preview,zoom,media", <!--theme_advanced_buttons1_add_before : "save,newdocument,separator",--> theme_advanced_buttons1_add : "fontselect,fontsizeselect", theme_advanced_buttons2_add : "forecolor,backcolor", <!--theme_advanced_buttons2_add_before: "cut,copy,paste,pastetext,pasteword,separator,search,replace,separator",--> <!--theme_advanced_buttons3_add_before : "tablecontrols,separator",--> <!--theme_advanced_buttons3_add : "emotions,iespell,media,advhr,separator,print,separator,ltr,rtl,separator,fullscreen",--> theme_advanced_toolbar_location : "top", theme_advanced_toolbar_align : "left", theme_advanced_statusbar_location : "bottom", content_css : "example_word.css", plugi2n_insertdate_dateFormat : "%Y-%m-%d", plugi2n_insertdate_timeFormat : "%H:%M:%S", external_link_list_url : "example_link_list.js", external_image_list_url : "example_image_list.js", media_external_list_url : "example_media_list.js", file_browser_callback : "fileBrowserCallBack", paste_use_dialog : false, theme_advanced_resizing : true, theme_advanced_resize_horizontal : false, theme_advanced_link_targets : "_something=My somthing;_something2=My somthing2;_something3=My somthing3;", paste_auto_cleanup_on_paste : true, paste_convert_headers_to_strong : false, paste_strip_class_attributes : "all", paste_remove_spans : false, paste_remove_styles : false }); function fileBrowserCallBack(field_name, url, type, win) { // This is where you insert your custom filebrowser logic alert("Filebrowser callback: field_name: " + field_name + ", url: " + url + ", type: " + type); // Insert new URL, this would normaly be done in a popup win.document.forms[0].elements[field_name].value = "someurl.htm"; } </script> <!-- /TinyMCE --> <style type="text/css"> .heading { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 20px; font-weight: bold; line-height: 1.5; color: #666666; } </style> </head> <body> <form name="content" action="<? echo $PHP_SELF; ?>" method="post"> <table width="400" border="0" cellspacing="0" cellpadding="0"> <tr> <td style="padding:8px" class="heading"><? echo "$category_name";?> : update</td> </tr> <tr> <td> </td> </tr> <tr> <td style="padding:8px"><textarea id="elm1" name="elm1" rows="35" cols="80" style="width: 100%"><? echo "$content_value"; ?></textarea></td> </tr> <tr> <td align="right" style="padding:8px"><input type="submit" name="Submit" value="Update"> <input type="submit" name="close" value="Close Window" onClick="javascript:window.close();"> <input type="hidden" value="<? echo "$content_id"; ?>" name="id"> <input type="hidden" value="<? echo "$category_name"; ?>" name="category_name"></td> </tr> </table> </form> </body> </html> <? if ($_POST["submit"] == "Update"){ $content_id = $_POST['id']; $category_name = $_POST['category_name']; $content_value = mysql_real_escape_string(stripslashes($_POST['content_value'])); $sql="UPDATE static_contents SET content_value='$content_value' WHERE content_id='$content_id'"; mysql_query($sql) or die("error:".mysql_error()); echo "$category_name"."content has been updated<br><a href='javascript:window.close()'>Close Window</a>"; } ?>hope you could help me with this.
thanks!