- 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
.....
86 Posted Topics
 | 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]'"; |
 | An Ajax reload would be great |
| | 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 … |
| | You can try $endDate='2014-04-11'; $startdate='2014-04-01'; $daydiff = floor( ( strtotime( $endDate ) - strtotime( $startdate ) ) / 86400); echo $daydiff; it will count the day difference between the 2 dates |
| | You need js to do it see this [sample](http://www.tutorialrepublic.com/codelab.php?topic=faq&file=jquery-show-hide-div-using-checkboxes) |
 | hi you can use something like an **identifier** that will be send together with the data in **contactsGo.php** where you will use a simple IF statement to check if the data is from that specific form or not. and base on the IF Statement you can use a simple **header … |
| | want an honest answer? **You Can't**. if you have an answer Pls **DO** share it with **US**....  |
 | Hi Just echo your submitted data in another page if you want something like a preview page before inserting it to DB as **rhodoscoder** suggested.. something like preview.php <?php echo $_POST['name']; ?> |
 | Hi for client side you can add Javascript for form validation. when the submit button is click it will check your form element if its is empty or not..or if your using **html5** just use the new **required** attribute and for a server side validation use (PHP) just to be …  |
| | Hi if your gonna insert new data in the db why are you using UPDATE query? you need to use INSERT query like $query= "INSERT INTO studio(name,phone,`date`,time_from,time_till,studio) VALUES ('$name','$phone','$date','$time_from','$time_till','$studio')"; also mysql_real_escape_string is already deprecated refer to this [link](http://php.net/manual/en/function.mysql-real-escape-string.php) and you better use mysqli or pdo for the same reason |
| | then u better find someone that is willing to write it for you. coz no one here will just shove the answer in your mounth. better yet show us what u have and lots of guys here will be willing to help you out. |
| | 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 … |
| | 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 … |
| | 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 … |
| | Hi as **JorgeM** and **diafol** said you need to check if the user has the rights to access a certain page you need something like $level=$_SESSION['SESS_ACCESS_LEVEL']; if($level=='1') { header("location: access-denied.php"); exit(); } |
 | for it to show automatically you need a trigger to execute the query e.g page refresh or an ajax function that will refresh every x second . Care to shed us more details about it..? also can you show as your script ? |
| | Hi what have you tried so far..?just a suggestion 1st make a html / Php file with 4 radio button per question for the selection of answer then another file to handle the process when the submit button is click.maybe if you can show us something to start of we … |
| | Hi can you show us a sample output base on your form.. |
| | 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 … |
| | hi first you need to change you form action from ` <form action="#" method="post" id="sendemail">` to <form action="youraction.php" method="post" id="sendemail"> then can you show as your script on sending email as you've said you already have the script for it and by the way what you've posted is not yet … |
| | Re: Session problem Hi just a thought try putting the $_SESSION['id']=$row['id']; inside the while statement in your first script.  |
| | 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 … |
| | 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 … |
The End.