• Member Avatar for ehpratah
    ehpratah

    Replied To a Post in How would I use two actions?

    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 …
  • Member Avatar for ehpratah
    ehpratah

    Began Watching create sql table at register

    I'm wanting to create an sql table, when a user registers at my site. This table will eventually be used to log messages. The code follows: <?php require('../connect/kidsblogsconnect.php'); $name=trim(mysql_real_escape_string($_POST['name'])); mysql_query("CREATE …
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in create sql table at register

    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 …
  • Member Avatar for ehpratah
    ehpratah

    Marked Solved Status for Sum and other SQL QUERY concern

    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 …
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in Sum and other SQL QUERY concern

    Got It.. I use IF statement inside the query like this SELECT SDate, SUM(IF(Payment_type = 'Cash', Grand_total, 0)) AS 'Cash', SUM(IF(Payment_type = 'Credit', Grand_total, 0)) AS 'Credit Card', SUM(IF(Payment_type = …
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in Sum and other SQL QUERY concern

    Hi Do you mean ("select SDate, Payment_type, SUM( Grand_total ) AS 'total_daily' from info WHERE SDate BETWEEN '2014-05-18' AND '2014-05-19' GROUP BY `SDate`, Payment_type") Still not getting it. How can …
  • Member Avatar for ehpratah
    ehpratah

    Edited Sum and other SQL QUERY concern

    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 …
  • Member Avatar for ehpratah
    ehpratah

    Created Sum and other SQL QUERY concern

    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 …
  • Member Avatar for ehpratah
    ehpratah

    Began Watching Sum and other SQL QUERY concern

    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 …
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in Redirect to thankyou page

    On line 46 change `header('Location: http://www.google.com/');` to echo'<script>window.location.href="https://www.google.com.ph"; </script>';
  • Member Avatar for ehpratah
    ehpratah

    Marked Solved Status for Connect to online DB from localhost

    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 …
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in Connect to online DB from localhost

    unfortunately remote mysql is not available on my Cpanel. i just ask my provider to whitelist and allow my ip so i can connect to mysql data.
  • Member Avatar for ehpratah
    ehpratah

    Created Connect to online DB from localhost

    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 …
  • Member Avatar for ehpratah
    ehpratah

    Began Watching Connect to online DB from localhost

    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 …
  • Member Avatar for ehpratah
    ehpratah

    Began Watching Redirect to thankyou page

    Hi, I am trying to get a form to redirect to a thank you page but after several attempts I am still no closer to achieving this. Below is the …
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in Redirect to thankyou page

    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
    ehpratah

    Replied To a Post in how to find number of days ago between two date in php

    Hi Sorry about that its just that i am using it here in philippines and have no problem when it comes to leaf year or daylight. anyway base on the …
  • Member Avatar for ehpratah
    ehpratah

    Began Watching how to find number of days ago between two date in php

    how to find number of days(days ago)different between today and database date .. eg: difference between 04/09/2014 and 06/08/2014 =(no of days ago)
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in how to find number of days ago between two date in php

    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 …
  • Member Avatar for ehpratah
    ehpratah

    Began Watching How to load a div on click checkboxs

    i may select one or more category.... <?php include('db.php'); $sql = mysqli_query("select * from brandname where category = 'cloths' "); while($row = mysqli_fetch_array($sql)){ echo $row['brandname']; } ?> <form action="checkbox.php" method="post"> …
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in How to load a div on click checkboxs

    You need js to do it see this [sample](http://www.tutorialrepublic.com/codelab.php?topic=faq&file=jquery-show-hide-div-using-checkboxes)
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in send form to another page and redirect to the same page

    there are really other way to do it. i just show you a simple solution. can you elavorate what your trying to achieve without using this and this. from what …
  • Member Avatar for ehpratah
    ehpratah

    Began Watching send form to another page and redirect to the same page

    I have many pages which has the same form so I made a page called contactsGo.php and all the forms on the other pages should send to this page what …
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in send form to another page and redirect to the same page

    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 …
  • Member Avatar for ehpratah
    ehpratah

    Began Watching show data on different sections on click a link without anchor tag in html

    how to show data on different sections on click a link without anchor tag in html without using js,css or php
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in show data on different sections on click a link without anchor tag in html

    want an honest answer? **You Can't**. if you have an answer Pls **DO** share it with **US**....
  • Member Avatar for ehpratah
    ehpratah

    Began Watching *Page Redirect After User Submission Via Form*

    *I apologize if this has already been asked/answered* I am have trouble with this, although I imagine the solution is rather simple: 1. User completes form and submits 2. Page …
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in *Page Redirect After User Submission Via Form*

    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 …
  • Member Avatar for ehpratah
    ehpratah

    Began Watching Contact form doesent redirect after being submitted

    Hello bretheren and programming Gurus? Am new and blank about php and just trying to experiment to get things as i want. Am using the code below but it does …
  • Member Avatar for ehpratah
    ehpratah

    Replied To a Post in Contact form doesent redirect after being submitted

    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 …

The End.