Posts
 
Reputation
Joined
Last Seen
Ranked #501
Strength to Increase Rep
+5
Strength to Decrease Rep
-1
79% Quality Score
Upvotes Received
16
Posts with Upvotes
16
Upvoting Members
11
Downvotes Received
4
Posts with Downvotes
4
Downvoting Members
3
6 Commented Posts
2 Endorsements
Ranked #621
Ranked #779
~68.6K People Reached
About Me

.....

Favorite Tags
Member Avatar for ronjacob012

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 …

Member Avatar for monika_12
0
14K
Member Avatar for ehpratah

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. …

Member Avatar for ehpratah
0
203
Member Avatar for ehpratah

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] => …

Member Avatar for ehpratah
0
283
Member Avatar for ribrahim

Try looking at *Inner join* and *count()* http://www.w3schools.com/sql/sql_join_inner.asp

Member Avatar for diafol
0
262
Member Avatar for ehpratah

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 …

Member Avatar for ehpratah
0
622
Member Avatar for ehpratah

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 …

Member Avatar for ehpratah
0
3K
Member Avatar for ehpratah

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 …

Member Avatar for ehpratah
0
284
Member Avatar for cristian.stilpeanu.1_1

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 …

Member Avatar for cereal
0
1K
Member Avatar for ehpratah

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 …

Member Avatar for ehpratah
0
284
Member Avatar for naazer.hussain

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

Member Avatar for bugz313
0
792
Member Avatar for ehpratah

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 …

Member Avatar for Slavi
0
335
Member Avatar for janicemurby
Member Avatar for janicemurby
0
210
Member Avatar for ehpratah

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 …

Member Avatar for ehpratah
0
330
Member Avatar for ehpratah

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 …

Member Avatar for pzuurveen
0
213
Member Avatar for praba_web

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 …

Member Avatar for cereal
0
11K
Member Avatar for ehpratah

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 …

Member Avatar for ehpratah
0
336
Member Avatar for markii.borabon_1

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 = …

Member Avatar for kaleemullah360
0
438
Member Avatar for berserk

hi check your form action you are sending your data in a .html file try making a .php file

Member Avatar for berserk
0
431
Member Avatar for RonKevinT.Manuela

you are assigning a number when you use = only. try Using == iN yOUr if statement not = like $row['roleID'] == 1

Member Avatar for ehpratah
0
224
Member Avatar for SID5721
Member Avatar for amit.chaudhari.71
Member Avatar for hanspeare

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>

Member Avatar for broj1
0
311
Member Avatar for faisal.qureshi.7121614

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

Member Avatar for faisal.qureshi.7121614
0
403
Member Avatar for engrjd91

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]'";

Member Avatar for engrjd91
0
663
Member Avatar for everton.retweets
Member Avatar for david.roun.7_1

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 …

Member Avatar for david.roun.7
0
325
Member Avatar for Ganesh_6

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 …

Member Avatar for Bachu
0
241
Member Avatar for ehpratah

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 …

Member Avatar for ehpratah
0
319
Member Avatar for seotheo

Hi have you tried using js for redirection? just for debugging purpose try window.location.href="thankyou.php"; see if its working

Member Avatar for ehpratah
0
3K
Member Avatar for ehpratah

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 …

Member Avatar for ehpratah
0
3K