- Strength to Increase Rep
- +5
- Strength to Decrease Rep
- -1
- Upvotes Received
- 16
- Posts with Upvotes
- 16
- Upvoting Members
- 11
- Downvotes Received
- 4
- Posts with Downvotes
- 4
- Downvoting Members
- 3
.....
 | Hi First you must create a script that will check your DB if if the duedate is 2 days before. a simple select query will work.something like `SELECT * FROM table WHERE DATEDIFF(NOW(), duedate) < 2` if the statement return true add your send mail code. for it to send … |
 | 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. … |
| | 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] => … |
| | Try looking at *Inner join* and *count()* http://www.w3schools.com/sql/sql_join_inner.asp |
| | 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 … |
| | 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 … |
| | 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 … |
 | Hi as **cereal** been pointing out you just need to add your "phpmailer " /sending code on your form action like `<form action="phpmailer.php" method="post">` after that you need to pass the data from your form to the phpmailer.php script that you wrote like this <?php require 'PHPMailerAutoload.php'; //======= this is …  |
| | 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 … |
| | Is your session ID set? try echoing for the value first if your really getting it.your file should start with a session_start() function for your session variable to work try adding it at line 2 |
| | 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 …  |
 | Research pls http://www.w3schools.com/php/php_mysql_select.asp |
| | 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 … |
| | 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 …  |
| | Hi as JorgeM said you need a js for it to be done...my suggestion is 1. Full the data from your db and arrange it as you desire 2. On page load use windows.print() or add a button or image that when click will call the print dialog box. like … |
| | 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 … |
 | Re: date_diff Hi just a stupid question do you have a default timezone included or activated? if no include in it at the beginning your your code or activate it on your server. date_default_timezone_set('Asia/Manila'); $date="10-10-2014"; $datetime1 = date_create(date('d - M - Y')); $datetime2 = date_create($date); $interval = date_diff($datetime1, $datetime2); echo $diff = …  |
| | hi check your form action you are sending your data in a .html file try making a .php file |
 | you are assigning a number when you use = only. try Using == iN yOUr if statement not = like $row['roleID'] == 1 |
| | |
 | |
 | Hi one simple solution is use windows.confirm javascript just put your delete query inside the js like <script> if (window.confirm('are you sure you want to delete this data?')) { .. your delete query }else{ do anything } </script>  |
 | Hi you can use a condition statement inside your query that check whether your row contain the data that you wanna count.. SELECT COUNT(DISTINCT CASE WHEN approved = '0' THEN id END) 'zero', COUNT(DISTINCT CASE WHEN approved = '1' THEN id END) 'ones' FROM business_details |
 | try removing **".** sign on line 97 like this and retry $change_pass = "UPDATE users SET user_pass = '$new_pass' WHERE user_name = '$_SESSION[user_name]'"; |
 | |
| | Hi Try something like this $mysql_hostname="localhost"; $mysql_database=""; $mysql_user=""; $mysql_password=""; $con = mysqli_connect($mysql_hostname,$mysql_user, $mysql_password, $mysql_database); $name=trim(mysql_real_escape_string($_POST['name'])); $sql=("CREATE TABLE IF NOT EXISTS `$name` ( `sender` varchar(30), `message` varchar(300), `dateposted` date )"); if (mysqli_query($con,$sql)) { echo "Table $name created successfully"; } else { echo "Error creating table: " . mysqli_error($con); } and refer … |
| | hi a simple solution to that is when the user click submit direct the user to your form.php and after the process in form.php is completed redirect the data from form.php to form1.php. you can use several approch to achieve this the most simple one is use GET to pass …  |
| | 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 … |
| | Hi have you tried using js for redirection? just for debugging purpose try window.location.href="thankyou.php"; see if its working |
| | 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 … |