Jump to content

zgkhoo

Members
 View Profile  See their activity

  • Posts

    507

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by zgkhoo

  1. zgkhoo
    mysql server: mysql 5.0.45 mysql client: mysql 5.1.11
  2. zgkhoo
  3. zgkhoo
    how to auto pop out print wizard using js? or when user click some php button then direct printing.. thanks
  4. zgkhoo
    <?php session_start(); if(!($_SESSION['UserID'])){ session_destroy(); header('Location: ../../../plslogin.php'); exit(); } ?> how to make if header('Location: ../../../plslogin.php'); not found then go to header('Location: ../../plslogin.php'); ??
  5. zgkhoo
    mysql_query('BEGIN TRANSACTION_NAME'); mysql_query('SELECT * FROM whatever...') mysql_query('UPDATE blah blah...') if(check for errors) { mysql_query('ROLLBACK'); } else { mysql_query('COMMIT'); } wat if the browser hang or suddently terminate? then it wont have chance to run if(check for errors) and perform the rollback or commit.... will lead to database confilict :-\ :-\
  6. zgkhoo
    transactions? where? thanks..
  7. zgkhoo
    wat is meant by indexes? thanks
  8. zgkhoo
    is it need add in the table or row "lock" for share database? eg online database that share among the user of the website. is it will write conflict when there is no add in 'lock" thanks..
  9. zgkhoo
    how to copy the structure and also the data too? use SELECT INTO or? thanks
  10. zgkhoo
    how to duplicate table? eg now i got one table name "testing123" and i wanna another copy of this table and using different name .."testing456"...how to do that? thanks in advance.
  11. zgkhoo
    i meant eg..now got three record in the table PID, 1001,1002,1003, when i delete 1002...wat will happen when i insert another record.? the system will use the deleted pid which is 1002 or will use new pid which is 1004. not auto increment....i adding php coding to control the pid... which one is better? in performance..thanks..
  12. zgkhoo
    thanks..but wat is auto increment meant? wat if i remove a record in the middle of the table? the auto increment id for this record(assuming 1201)will be disappear or? will be use for next record insert? my table structure like this, need to modify or not? thanks..again $sql = "CREATE TABLE pyramid ( PID integer(10), Serialnum varchar(10), UplineSerial varchar(10), UplinePID integer(10), Downleft integer(10), Downright integer(10), LeftSerial varchar(10), RightSerial varchar(10), RowNum integer(10), ColumnPosi integer(10), ColumnTotal integer(10), DownlineAmount integer(10), Initial varchar(10), ActivateTime datetime, Status varchar(10), UserID varchar(10), ExpiredDate datetime, CreateDate datetime, Golden varchar(10), Primary Key (PID) )";
  13. zgkhoo
    if the table consist of 10 thousand record....this function will be extremely slow.
  14. zgkhoo
    //find the last pid function findlastPID($pyrtable) { echo "</br>pyrtable=====".$pyrtable; $result=mysql_query("SELECT PID from $pyrtable ORDER BY PID"); if(mysql_num_rows($result)==0){ return 1001; } else{ while($row = mysql_fetch_array($result,MYSQL_ASSOC)){ $pid=$row[PID]; }//end while return $pid+1; }//end else }//end function this function need loop WHOLE table..wasting resources and wasting time any solution that can directly find the last record in a table(which order by ID) which certainly will faster the transaction? thanks in advance.
  15. zgkhoo
    how to change this datagrid to email alike datagrid. which only show the topic and click the topic and then only can view the actual message? thanks in advance.. [attachment deleted by admin]
  16. zgkhoo
    add1card.php <html> <body> <!--<table border="1"> <tr> <td> </td> <td>--> <form action="view1card.php" method="post"> <table border="1"> <tr> <td width="181">Serial Number</td> <td width="168"> <input type="text" name="serial1" /> </td> </tr> <tr> <td width="181">Activate Code Length</td> <td width="168"> <input type="text" name="slength"> </td> </tr> <tr> <td width="181">Activate Code Type</td> <td width="168"> <select name="code_type"> <option value="Character(Big Letter)">Character(Big Letter)</option> <option value="Character(Small Letter)">Character(Small Letter)</option> <option value="Number">Number</option> <option value="Mix">Mix</option> </select> </td> </tr> <tr> <td width="181">Point</td> <td width="168"> <input type="text" name="spoint"> </td> </tr> <tr> <td width="181">Expirly Date</td> <td width="168"> <input type="text" name="sexpiry_date"> </td> </tr> <tr> <td width="181"> <input type="reset" name="reset" /> </td> <td width="168"> <input type="submit" name="submit" /> </td> </tr> </table> <!--</td> </tr> </table>--> </form> </body> </html>
  17. zgkhoo
    cardsubmenu.php <head> <link rel="stylesheet" type="text/css" href="../../../style.css" /> </head> <div id="bodyarea" style="padding: 1ex 0px 2ex 0px;"> <table width="100%" border="0" cellpadding="0" cellspacing="0" style="padding-top: 1ex;"> <tr> <td width="180" valign="top"> <table border="0" cellpadding="4" cellspacing="1" class="bordercolor" width="191"> <tr> <td class="catbg">Card</td> </tr> <tr class="windowbg2"> <td class="smalltext" height="87"> <p><a href="displayaddcard.php">Add Card</a><br /> <a href="displayaddsingle.php">Add Single Card</a><br /> <a href="card_manipulation.php">View/Edit/Delete Card</a><br/> </a><br /> <br /> </p> </td> </tr> </table> </div>
  18. zgkhoo
    admin main.php <html> <head> <link rel="stylesheet" type="text/css" href="../../../style.css" /> </head> <body> <div id="bodyarea" style="padding: 1ex 0px 2ex 0px;"> <table width="100%" border="0" cellpadding="0" cellspacing="0" style="padding-top: 1ex;"> <tr> <td width="180" valign="top"> <table border="0" cellpadding="4" cellspacing="1" class="bordercolor" width="674" height="42" align="center"> <tr> <td class="catbg" width="140" height="40"> <div align="center"><a href="/EN/menu/Card/cardmenu.php">Card</a></div> </td> <td class="catbg" width="209" height="40"> <div align="center"><a href="/EN/menu/UserMg/managemenu.php">User Management</a></div> </td> <td class="catbg" width="143" height="40"> <div align="center"><a href="#">Product Management</a></div> </td> <td class="catbg" width="143" height="40"> <div align="center"><a href="#">Status Management</a></div> </td> <td class="catbg" width="143" height="40"> <div align="center"><a href="#">Reward Management</a></div> </td> <td class="catbg" width="143" height="40"> <div align="center"><a href="/EN/menu/AccountMg/acctmenu.php">Account Management</a></div> </td> <td class="catbg" width="143" height="40"> <div align="center"><a href="/EN/menu/AdminPass/displayadminpass.php">Change Password</a></div> </td> <td class="catbg" width="143" height="40"> <div align="center"><a href="#">System Management</a></div> </td> </tr> <tr> <td class="catbg" width="143" height="40"> <div align="center"><a href="/EN/menu/Rate/rate.php">Rate Management</a></div> </td> <td class="catbg" width="143" height="40"> <div align="center"><a href="/EN/menu/AssoTable/assotable.php">Pyramid Associated</a></div> </td> <td class="catbg" width="143" height="40"> <div align="center"><a href="/EN/menu/AdminCard/admincard.php">Insert Admin Card</a></div> </td> <td class="catbg" width="143" height="40"> <div align="center"><a href="/EN/menu/Feedback/fbackmenu.php">Feedback</a></div> </td> <td class="catbg" width="143" height="40"> <div align="center"><a href="/EN/menu/CardPending/cardpending.php">Message/Pending Card Exchange</a></div> </td> <td class="catbg" width="143" height="40"> <div align="center"><a href="/EN/menu/CashPending/cashpending.php">PendingCashWithdraw</a></div> </td> <td class="catbg" width="143" height="40"> <div align="center"><a href="/EN/menu/othersgame/othersgame.php">Others GameCard</a></div> </td> <td class="catbg" width="155" height="40"> <div align="center"><a href="/EN/menu/logout.php">Log Out</a></div> </td> </tr> </table> </div> </body> </html>
  19. zgkhoo
    <?php session_start(); echo "loginname=".$_SESSION['loginname']; //$login=$_SESSION['loginname']; //echo "<br/>"; //echo "loginvariable=".$login; /*echo "<table border=2> <tr> td>";*/ ?> <html> <head> <title>Add Card</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script language="JavaScript"> <!-- function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); // --> </script> </head> <body bgcolor="#FFFFFF" text="#000000"> <div id="Layer1" style="position:absolute; left:12px; top:13px; width:754px; height:42px; z-index:1"> <?php include '../adminmain.php'; ?> </div> <div id="Layer2" style="position:absolute; left:9px; top:58px; width:758px; height:292px; z-index:2"> <table width="100%" border="0" height="293"> <tr> <td width="30%" height="242"> <?php include 'cardsubmenu.php'; ?> </td> <td width="70%" height="242"> <?php include 'add1card.php'; ?> </td> </tr> </table> </div> </body> </html> the bottom row of menu cant click at all..why? the alignment of page also not correct..(see the picture) thanks. [attachment deleted by admin]
  20. zgkhoo
    how about write all function and save in an functions.php file and include using include '../../functions.php'; ???
  21. zgkhoo
    i have complete write a group of functions.. a group of function should save in a class file or php file? and how to integrate into several pages? use include or require keyword? thanks
  22. zgkhoo
    i got my own designed page, so cant purely use joomla, i know how to use joomla....but just duno combine joomla with my designed php page.
  23. zgkhoo
    eg. user can edit the mainpage content with several category themself without need the programmer edit the source code. thanks
  24. zgkhoo
    how to integrate joomla with my first page? thanks
  25. zgkhoo
    any ready made CMS package that can integrate into mainpage? eg. user can edit the mainpage content with several category themself without need the programmer edit the source code. thanks
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.