Hi Everyone! I have an application that has thousand of records. the problem that i am having right now is that my website is performing slow.when i am trying to swtich to other link on the site which have a query running on the background it takes ages to load. i already tried using cloudflare to optimize the system but the slow querying still persist. can anybody have an idea that can help me optmize the poor performace of my database? By the way the system is hosted in a dedicated server but the resources consumption is very high. Thanks …

Member Avatar
Member Avatar
+0 forum 2

Hi Guys! I cant find a way to show my data array the way i need it to be hope you can help me. i already tried using array_push(), json_encode() but still no result. basically what i am getting is like this Array ( [0] => Array ( [name] => Boat + Cab [TOTAL] => 3 ) [1] => Array ( [name] => Bus + Boat [TOTAL] => 41040 ) [2] => Array ( [name] => Bus + Boat + Cab [TOTAL] => 840 ) [3] => Array ( [name] => Bus Only [TOTAL] => 14343.75 ) [4] => Array …

Member Avatar
Member Avatar
+0 forum 4

Hi! Im creating individual excel file base on the duedate and client name of a reservation and sending it automatically on that date.but im having a trouble dispalying the SUM/ Grandtotal of each excel summary that i created. the grandtotal inside my while loop is also incrementing. i dont now what i am doing wrong. Example for today i have 4 Client that has a duedate today. and the script automatically generated the excel file summary of each client. Client 1. **7 STONES** ![1.jpg](/attachments/large/3/80865fbd4503de12d4e92f87cb782ca5.jpg "align-center") Client 2. **Your Travel Planner** ![2.jpg](/attachments/large/3/55ec7e0726c5b10a809533a6d9d9a51d.jpg "align-center") Client 3. **ZOEMIE** ![3.jpg](/attachments/large/3/8c4718cc6a98257f7babcbd9193b09f9.jpg "align-center") And the Last …

Member Avatar
Member Avatar
+0 forum 5

Hi Everyone! Can anybody point me to the right direction or check what am i doing wrong. Im trying to export data from php to excel using phpexcel( which is working fine if im am only getting 1 specific record). but when i tried adding a loop to create a workbook im having a problem. the data does not match the actual record from DB this is the script Currently editing: /home/msicph/public_html/sedaatria/demo/toexcel/genexcel.php Encoding: Reopen Switch to Code Editor Close Save <?php error_reporting(E_ALL); ini_set('display_errors', TRUE); ini_set('display_startup_errors', TRUE); define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); date_default_timezone_set('Europe/London'); /** PHPExcel_IOFactory */ require_once dirname(__FILE__) …

Member Avatar
Member Avatar
+0 forum 12

Hi Has anyone of you having a problem opening firefox , google chrome and thunderbird since yesterday? coz almost all of our unit that is running in ubuntu and Zorin OS are experiencing the same bugs.. i already tried updating and upgrading the OS but still having the error and i also tried re installing the applications but im not getting any progress..

Member Avatar
Member Avatar
+0 forum 2

Hi Im having a hardtime making my query work the way it should be.i'm getting wrong output. basically what im trying to do is a simple user statistic that will show the user inputed data and user processed data base on the date range the user selected. heres the screenshots for better visualization ![1.jpg](/attachments/large/3/5d026cec4cbfe61d5bb47291bbbda47f.jpg "align-center") and the query for that is. first Get all the user from the user table `Select Name from user GROUP BY Name ORDER BY Name ASC` then i will loop inside the reservations table for the matching username base on the date range selected select …

Member Avatar
Member Avatar
+0 forum 6

Hi i just wanna know if there are way to **decrypt a files that is infected and decrypted by a virus / malware**? all of the files from one of the workstation are encryted as in totaly you cannot open the files.there is a noted in there saying that i need to pay a certain amount of money for them to give the decryption key. i already tried using some decrypter tools that i found and also tried uploading it to decryptcryptolocker.com in hopes that it can still be decrypt , i already scan the computer using a bootable antivirus, …

Member Avatar
Member Avatar
+0 forum 4

Hi everyone i need some help down here. i am trying to connect multiple db and at the same time i want to sum the value of the column. what i have right now is this SELECT SUM(total) as branch1sales FROM icm.sales UNION SELECT sum(total) as branch2sales FROM hism.sales its computing correctly but the problem is the branch2 alias is being invoke. what am i doing wrong? see attached image for the output ![Untitled.jpg](/attachments/small/3/2380191a296b9b064ffa52c969a268a3.jpg "align-left") thanks

Member Avatar
Member Avatar
+0 forum 2

Hi can anyone help me find what am i doing wrong. i have an xml request that check data on db and return the result. and base on that result it will clear or highlight a textbox. its working fine using the original function but when i add another xml request the function that i add don't work properly but the first function is working fine my script SHOWPLATE WORKING function showplate(str) { if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && …

Member Avatar
Member Avatar
+0 forum 3

Hi need some insight on how to show record from different database on the same server. i also tried using join but didnt get the correct output. im finding a way to make it work using just one query. my last resort will be using different query to select the data i need(hope i wouldn't go that way) what i have so far is this. it show the record of both database but somehow it repeating the same record `SELECT DB2.processed_trans.Ra_num , DB1.processed_trans.Ra_num FROM DB2.processed_trans JOIN DB1.processed_trans ;` thanks, neil

Member Avatar
Member Avatar
+0 forum 8

Hi all I need some advice making my query work properly. I already played around it a dozen of times and still can't get it work. So as my last option im here:) . what im trying to achieve is sum all amount of a particular rows and display the Grandtotal which is working fine but I get stuck in this last requirement which is.. see screenshot below as I cant really explain it properly..:D ![6448078814c6781f0120d45d197df3b8](/attachments/small/3/6448078814c6781f0120d45d197df3b8.jpg "align-right") here are my table dump CREATE TABLE IF NOT EXISTS `info` ( `SDate` varchar(255) NOT NULL, `Grand_total` varchar(255) NOT NULL, `Payment_type` varchar(7) NOT …

Member Avatar
Member Avatar
+0 forum 3

Good day everyone Not sure if this is the right place to ask this but im trying to connect to my database online "Control Panel of my hosting site" from my local machine basically the webpage is running locally. but i want the data to be fetch online. my question is do i need to configure my CP? if yes what do i need to change? heres the config That im working with $mysql_hostname="***.***.*.***"; // IP ADD OF MY CP i also tried the webaddress $mysql_database="****"; $mysql_user="****"; $mysql_password="***"; $con = mysqli_connect($mysql_hostname,$mysql_user, $mysql_password, $mysql_database); mysqli_select_db($con,"svcseuro_nwh")or die(mysql_error()); date_default_timezone_set('Asia/Manila'); the original config on …

Member Avatar
Member Avatar
+0 forum 2

Good Day Guys Im Having a hardtime getting this simple script working, basically im trying to open pop up windows when a link is click(which work fine until i found out that the same data is being fetch over and over again which is the last data inserted in the DB) this the part of the script while ($rows = mysql_fetch_assoc($query)) { echo" <script language='javascript'> function win() { window.open('overview.php?id=$rows[Id]','Window3','menubar=no,width=600,height=610,toolbar=yes,scrollbars=yes,'); } </script>"; echo " <tr> <td align='center'><a href='javascript:win()' >".$rows['RA']."</td> <td width='12%'>".$rows['Name']."</td> <td>".date('j F, Y', strtotime($rows['SDate']))." / ".$rows['Time']."</td> <td align='center'>".$rows['Service']."</td> <td width='3%'>".$rows['Remarks']."</td> </tr> "; } What am i doing wrong? Thanks neil,

Member Avatar
Member Avatar
+0 forum 3

Good Day Guys So im having this issue with this site that i develop which is running 24/7 that eats a huge amount of bandwidth every time the page reload every 10sec using META TAG that is affecting our operations specifically our net connection. What i wanna know is if i switch to a AJAX reload would it solved my problem? Hope to hear you're opinion about it so i can made the necessary changes as soon as possible. Thanks Neil

Member Avatar
Member Avatar
+0 forum 3

Good Day everyone I have 3 forms index.html , parent.html and popup.html just wondering how can i close parent.html and redirect it to index.html when the popup.html submit button is click? i already tried searching on google but i cant get any clear solution on how to achieved it. i know that i would be needing js to make it possible but it seems that i cant find any article on it. can anybody point me on the right track Thanks

Member Avatar
Member Avatar
+0 forum 1

Hi i have this query that search data between two date range `select RA, Name, Model, Plate, Service, Grand_total, Payment_type from advance WHERE SDate BETWEEN '" . $from . "' AND '" . $to . "' ORDER BY Payment_type` which is working great but i need to alter it so that it will also search for specific time range between that date range but seems not working properly `"select RA, Name, Model, Plate, Service, Grand_total, Payment_type from advance WHERE SDate BETWEEN '" . $from . "' AND '" . $to . "' AND Time BETWEEN '" . $fromtime . "' …

Member Avatar
Member Avatar
+0 forum 5

Hey guys im here again with another question on how to solve this specific problem i have, Whic is also releated on my last thread which is http://www.daniweb.com/web-development/php/threads/461702/cant-combine-two-sql-statement .. so the question now is i have this table Name Payment_type Service_charge test 1 Cash 10 test 2 Cash 20 test 3 Charge 100 test 4 Charge 100 test 5 Invoice 50 output is total Cash: 30 total Charge: 200 totaL Invoice: 50 Grandtotal :280 I can already get the Grandtotal but i can find a way to get the total cash,charge and invoice what query should i use..? do i …

Member Avatar
Member Avatar
+0 forum 10

Good Day everyone(even if its already 10pm here) i know its seems very easy to some of you guys but seems i cant get an hold onto it.. so i have this query that search data between 2 date range(which is working fine) and another query that add all data from a specific field in my table(whic is also working). The thing is now what i needed to do is to combine the two queries in one here's the first query select * from advance WHERE SDate BETWEEN '" . $from . "' AND '" . $to . "' ORDER …

Member Avatar
Member Avatar
+0 forum 5

Move this from JavaScript / DHTML / AJAX Good Day everyone i'm having a hardtime figuring out how to make this certain idea of mine to work basically im trying to capture the checkbox value and its label but im not getting anyluck..and also im having problem explaning what im trying to do so i decided to attached an image of what will be the output.. Im not asking for any script but just an idea how can i achieved it but if somebody's generous enough i wont reject it either:)) the form part ![9ba01e73fbf743c827029b1c945651c1](/attachments/large/3/9ba01e73fbf743c827029b1c945651c1.jpg "9ba01e73fbf743c827029b1c945651c1") and the expected result …

Member Avatar
Member Avatar
+0 forum 10

Good Day everyone i'm having a hardtime figuring out how to make this certain idea of mine to work basically im trying to capture the checkbox value and its label but im not getting anyluck..and also im having problem explaning what im trying to do so i decided to attached an image of what will be the output.. Im not asking for any script but just an idea how can i achieved it but if somebody's generous enough i wont reject it either:)) ![44466e83794f8593d7208aa8a7b889f9](/attachments/large/3/44466e83794f8593d7208aa8a7b889f9.jpg "44466e83794f8593d7208aa8a7b889f9")

Member Avatar
Member Avatar
+0 forum 2

Good Day everyone im having trouble in script right now basically im trying to make an if statement that will assign rate base on the destination, branch ,service and vehicle. which is working fine just a moment ago but when i add another array for another destination it seems that its not using the assigned array but keeps on using the first assigned array heres the script ` $destination ="SM"; $branch = "Davao International Airport"; $service = "Transfer In"; $vehicle = "Vios"; $destination_10_to_12km_away = array( "WATERFRONT HOTEL" => "WATERFRONT HOTEL", "HOTEL ELENA" => "HOTEL ELENA", "GRAND REGAL HOTEL" => "GRAND …

Member Avatar
Member Avatar
+0 forum 3

Good Day Everone Just wanna ask for a suggestion if it is possible to Save data in DB and at the same time Print the form when the submit button is clicked? and if possible how can i obtain it? Here's what ive tried form.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>test</title> <style type="text/css"> <!-- .style1 { font-size: 18px; font-weight: bold; } --> </style> </head> <body> <span class="style1">Sample RA</span><br><br> <form action="save.php" method="post"> I <input name="Name" type="text" placeholder="State your Name"/> certified that the info on this form is true and legitimate<br><br><br> …

Member Avatar
Member Avatar
+0 forum 6

Hey Everyone Im having a lil trouble rightnow making this script work. What im trying to do is make a script that will change the bgcolor color to red if the Serving time is less than or equal to 1 hr left which is working now but in the long run while testing the script i found a bug which is if the current time is already 5min past the Serving time the bgcolor needs to turn to color orange. but its not working properly Here's the script <?php date_default_timezone_set('Asia/Manila'); $current_time= "18:10"; $serving_time="18:05"; if (strtotime($current_time) >= (strtotime($serving_time) - 3600 )) …

Member Avatar
Member Avatar
+0 forum 7

Hi Guys wanna ask some assistance/ help I'm making something like notification with jquery and php and its working fine now the only problem that i encounter is on the notification its only show one data repeatedly its not showing the other data that supposed to be showed Here's my script on showing the notification <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <link href="jquery.notice.css" type="text/css" media="screen" rel="stylesheet" /> <?php date_default_timezone_set('Asia/Manila'); $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = ''; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); $dbname …

Member Avatar
Member Avatar
+0 forum 5

Hi to all just wanna ask how to achieve something like on show all data if a certain field on the table is equal to **2**. basically what im trying to make is a search form by the way the searching part is working it just that its showing all the data what i really need to achieve is show the data if `tablefiled==2` THE Table structure is Id Name Sdate Active_view 1 Person 1 2013-04-1 2 2 Person 2 2013-04-5 1 3 Person 3 2013-04-25 1 4 Person 4 2013-04-1 2 5 Person 1 2013-04-1 1 The process that …

Member Avatar
Member Avatar
+0 forum 5

Hi need some help suggestion I am trying to search data form two date range but it seems not working properly when i search for $from_date = "2013-04-01"; $to_date = "2013-04-04"; $query = mysql_query("SELECT * FROM date WHERE Date between '" . $from_date . "' AND '" . $to_date . "' ORDER by id DESC"); it will only return Guest 1 2013-04-01 Guest 2 2013-04-02 Guest 3 2013-04-03 Guest 4 2013-04-01 it is omitting Guest 5 2013-04-04 and i also try uisng this query `$query = mysql_query("SELECT * FROM date WHERE Date >= '" . $from_date . "' AND Date …

Member Avatar
Member Avatar
+0 forum 15

Hi to all i just cant get the grasp of what im trying to do basically i'm making a script that will higlight a certain **data(Date /time)** in my table if data < 3 min of current time.. ex $data="March 12, 2013, 16:18"; $current_time="March 12, 2013, 16:20" if($data< 3min of $current_time) { echo"highlight me im fresh"; } else if($data > 5min of $current_time) { echo"oldies"; } something like that but i cant find a way to implement

Member Avatar
Member Avatar
+0 forum 4

Hi to All Just wondering how cn i achieve something like this example i select **January** for the first list menu and select **2013** for the second one now what im trying to achieve here is how to show all the data for the said month and year without submitting the form. i dont thing i can use javascript on this one...what should i use? also you can look at this reference for better visualization http://www.lazada.com.ph/shop-laptops/asus/?price=10000-19999&sort=popularityasc&dir=asc thanks neil

Member Avatar
Member Avatar
+0 forum 3

hi fellas out thiere im having a headache right now in sending email with attachment..im using ftp in storing the file in my dirctory and sending it to my email...i can upload the file and send it but the prolem is when i try to dowload the file from the email it has no data as in "0 bytes"..any suggestion or insight please thanks..i just modify this code for my needs... here is the sendmail.php <?php $ftp_server='www.mysite.com';//serverip $conn_id = ftp_connect($ftp_server); // login with username and password $user="myusername"; $passwd="mypassword"; $login_result = ftp_login($conn_id, $user, $passwd); // check connection if ((!$conn_id) || (!$login_result)) …

Member Avatar
Member Avatar
+0 forum 2

Hi All Just have a question I'm having difficulties in displaying my data in Desc..cant find where i need to put the DESC in my query this is the code function.php <?php function pagination($query, $per_page = 10,$page = 1, $url = '?'){ $query = "SELECT COUNT(*) as `timestamp` FROM {$query}"; $row = mysql_fetch_array(mysql_query($query)); $total = $row['timestamp']; $adjacents = "2"; $page = ($page == 0 ? 1 : $page); $start = ($page - 1) * $per_page; $prev = $page - 1; $next = $page + 1; $lastpage = ceil($total/$per_page); $lpm1 = $lastpage - 1; $pagination = ""; if($lastpage > 1) { …

Member Avatar
Member Avatar
+0 forum 2

The End.