Jump to content

piano0011

Members
  • Posts

    189
  • Joined

  • Last visited

Everything posted by piano0011

  1. Hey guys! I am trying to do a drop right menu to add to my drop down menu and I almost got it but just can't seem to push the padding to the right of it... Here is my part of my html and css code:I put a div class there because I wasn't sure if I needed it but don't think so.... <!DOCTYPE html> <html> <head> <title></title> <meta charset="utf-8"> <link rel="stylesheet" type="text/css" href="style.css"> <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.1.0/css/all.css" integrity=">sha384-lKuwvrZot6UHsBSfcMvOkWwlCMgc0TaWr+30HWe3a4ltaBwTZhyTEggF5tJv8tbt" crossorigin="anonymous"> <link href="https://fonts.googleapis.com/css?family=Aldrich|Mr+Dafoe" rel="stylesheet"> </head> <body> <header> <nav> <ul> <li><a href="#">Member's section</a><div class="down"><i class="fas fa-caret-down"></i></div> <ul> <li><a href="index.php">Main Page</a></li> <li><a href="practice_diary.php">Practice diary</a></li> <li><a href="redeem.php">Redeem Your Points!</a></li> <li><a href="forum_main.php">Forum</a></li> <li><a href="quiz.php">Music Test</a></li> <li><a href="review.php">Review</a></li> <li><a href="update.php">Update Profile</a></li> <li><a href="#">Games</a> <div class="games"> <ul> <li><a href="guessing_game.php">Guessing Game</a></li> <li><a href="rock_paper_scissors.php">Rock, Paper, Scissors</a></li> </ul> </div> </li> </ul> </li> <li><a href="primer.php">Primer Level</a><div class="down"><i class="fas fa-caret-down"></i></div> <ul> <li><a href="level1.php">Level 1</a></li> <li><a href="level2.php">Level 2</a></li> <li><a href="level3.php">Level 3</a></li> </ul> </li> <li><a href="signup.php">Signup</a></li> <li><a href="refer.php">Referral page</a></li> <li><a href="reset.php">Reset Password</a></li> <li><a href="qa.php">More Information</a><div class="down"><i class="fas fa-caret-down"></i></div> <ul> <li><a href="contact.php">Contact Us</a></li> <li><a href="donation.php">Donation</a></li> <li><a href="activate.php">Activate Email</a></li> </ul> </li> <div class="profile_image"> <ul> <li><a href="uploadform.php">Upload Profile Picture</a></li> <div class="delete_profile"><li><a href="deleteprofile.php">Delete picture profile</a></li></div> </ul> </div> CSS code: header nav ul ul ul li{ position: absolute; display: none; } header nav ul ul li:hover ul li{ display: block ; position: relative; left: 200px; bottom: 100px; }
  2. hey guys! I am trying to create a service section and I got it to work before but when I changed the border to make it wider, it doesn't seem to be side by side anymore. Here is my CSS and html file and what it is looking liked at the moment: <!DOCTYPE html> <html> <head> <title>PianoCourse101</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="stylesheet" type="text/css" href="style.css"> <link href="https://fonts.googleapis.com/css?family=Aldrich|Mr+Dafoe" rel="stylesheet"> <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.1.0/css/all.css" integrity=">sha384-lKuwvrZot6UHsBSfcMvOkWwlCMgc0TaWr+30HWe3a4ltaBwTZhyTEggF5tJv8tbt" crossorigin="anonymous"> <link href="https://fonts.googleapis.com/css?family=Pacifico" rel="stylesheet"> <link href="https://fonts.googleapis.com/css?family=Great+Vibes|Lobster" rel="stylesheet"> <link href="https://fonts.googleapis.com/css?family=Great+Vibes|Lobster|Monoton|Orbitron" rel="stylesheet"> </head> <body> </body> </html> <section class="main-container"> <div class="crotchet"> <p>&#x1D15F</p> </div> <div class="minim"> <p>&#x1D15E</p> </div> <div class="quaver"> <p>&#x1D160</p> </div> <div class="pc101"> </div> <div class="music"><i class="fas fa-music fa-8x"></i></div></span> <div class="sharp"><p>&#9839</p></div> <div class="natural"><p>&#9838</p></div> <div class="flat"><p>&#9837</p></div> <div class="main-wrapper"> <div class="title"> <br></br> <h1>Welcome to PianoCourse101</h1> </div> <br></br> </div> <div class="main-wrapper"> <div class="first"> <h2>At PianoCourse101, your child can now learn how to play Classical music right from the comfort of your own home! It doesn't matter if your child has no music foundation because there are lessons suitable for beginners and advanced students! Based on the "Bastien Piano Basics series", your child will be able to learn the basic hand positions, posture, finger numbers and letter names!<br></br> There are four levels in the "Bastien Piano Basics" series, beginning with the primer level, which is suitable for beginners. Once your child has completed the primer level, your child will be able to progress to Level 1, follow by Level 2 and Level 3.<br></br>Currently, PianoCourse101 lessons are mainly for children but we also encourage if you are an adult and also wish to learn how to play the piano to join us! In due course, there will also be lessons for adults!</h2> </div> </div> <div class="form"> <form class="signup-form" action="newsletters.php" method="POST"> <div class="newsletters"> <label><center>Enter your E-mail Address</center></label> </div> <br></br> <div class="index_form"><center><input type="text" name='email' placeholder="Enter E-mail Address"></center></div> <br></br> <center><button type="submit" name="submit">Subscribe to PianoCourse101!</button></center> <br></br> </form> </div> <img class="snoopy" src="includes/pictures/snoopy.jpg" alt="snoopy playing the piano" /> </section> <div class="services_main">Services</div> <div class="services"> <div class="service1"> <h1>Level 1</h1> <div class="image"> <a href="signup.php"><p>&#127929</p></a> </div> <h3>Purchase the Level 1 Subscriptionplan!<br>Learn how to play the piano right from the comfort of your own home!<br>Monthly fee: $100<br>Yearly fee: $800</h3> </span> <div class="service1"> <h1>Level 2</h1> <div class="image"> <a href="signup.php"><p>&#127931</p></a> </div> <h4>Purchase the Level 2 Subscriptionplan!<br>Learn how to play the piano right from the comfort of your own home!<br>Monthly fee: $150<br>Yearly fee: $1300</h4> </div> <div class="service1"> <h1>Level 3</h1> <div class="image"> <a href="signup.php"><p>&#127927</p></a> </div> <h5>Purchase the Level 3 Subscriptionplan!<br>Learn how to play the piano right from the comfort of your own home!<br>Monthly fee: $200<br>Yearly fee: $1800</h5> </div> </div> <span class="index_views"><p>There are <?php echo "<span class='index_views_counter'> $views </span>";?> visitors who have visited <?php echo "<span class='index_views_counter'> $pagename </span>"; ?>!</p></span> </body> </html> This is my CSS code: div.service1 { width: 800px; border: 1px solid #c1c1c1; margin: 20px 50px; padding: 0 5px; float: left; } div.service1 > p { font-size: 14px; color: #000000; max-width: 250px; padding-top: 30px; text-align: justify; text-justify: inter-word; } div.services { width: 2500px; margin: 0 auto; } div.services h1 { font-size: 50px; font-weight: bold; background-color: #c1c1c1; color: #000000; padding: 10px 0; } div.image { max-width: 300px margin: 15px 0 0 0; padding-top: 30px; } div.image h3 { position: relative; bottom: 300px; } div.image h4 { position: relative; top: 200px; } div.services_main { text-align: center; font-size: 40px; color: #6495ED; margin: 100px 0 50px 0; font-family: 'Aldrich', sans-serif; font-family: 'Mr Dafoe', cursive ; } div.image:hover { opacity: 0.2; max-width: 200px; margin-top: 15px; }
  3. Thanks guys and really appreciate the feedback!
  4. Hey guys! This is a strange issue but I have been trying to implement a forum into my website and I know that i will always get problems when trying to follow someone's else but anyway, he has included the use of limit=1. For some reason, my other codes suddenly won't work and when I mean won't work, I mean that it will display multiple times like a loop unless I also use limit=1. Is this usually the case? Should I always use limit=1? to make sure that only 1 record is displayed?
  5. I got it to work but for some reason, I just have to move the footer.php to the bottom of the code..... I guess footer.php contains some html but how come the header.php can stay at the top?
  6. Hey guys!I have the following error and I am not sure why because I thought that we could include the header.php and footer.php file at the top? I will include both my footer.php file and level.php: This is my footer.php file: <!DOCTYPE html> <html> <head> <title>Copyright 2018</title> <link rel="stylesheet" type="text/css" href="style.css"> <link href="https://fonts.googleapis.com/css?family=Aldrich" rel="stylesheet"> <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.1.0/css/all.css" integrity="sha384-lKuwvrZot6UHsBSfcMvOkWwlCMgc0TaWr+30HWe3a4ltaBwTZhyTEggF5tJv8tbt" crossorigin="anonymous"> </head> <body> <footer> <div class="copyright clearfix"> <div class="container clearfix"> <div class="text float left"> Copyright PianoCourse101 2018 </div> <ul class="links float right"> <li><a href=""><i class="fab fa-facebook-square"></i></a></li> <li><a href=""><i class="fab fa-twitter-square"></i></a></li> <li><a href=""><i class="fab fa-instagram"></i></a></li> <li><a href=""><i class="fab fa-youtube-square"></i></a></li> </ul> </div> </div> </footer> </body> </html> This is my level1.php file <!DOCTYPE html> <html> <head> <title></title> <meta charset="utf-8"> <link rel="stylesheet" type="text/css" href="style.css"> </head> <body> <?php include_once 'header.php'; include_once 'footer.php'; $level1promo_expirydate = date('Y-m-d H:i:s', strtotime("+2 day")); $paidbydate = date('Y-m-d H:i:s', strtotime("+2 day")); $emailreminder = 1; $emailreminderreset = null; $subscriptionplandelete = null; $paidbydatedelete = null; $subscriptionplandatedelete = null; $expirydatedelete = null; $feemonthlysdelete = null; $feesyearlydelete = null; $paidreset = null; $totalfees = null; $overdue = 1; $overduereset = 0; $activatereset = 0; $level1promo_activate = 0; if(!isset($_SESSION['u_uid'])) { header("Location: index.php?level1=notlogin"); exit(); } else { include_once 'includes/dbh.php'; //Created a template $sql = "SELECT * FROM memberships WHERE user_uid = ?;"; //Create a prepared statement $stmt = mysqli_stmt_init($conn); //Prepare the prepared statement if (!mysqli_stmt_prepare($stmt, $sql)) { echo 'SQL statement failed'; } else { //Bind parameters to the placeholder mysqli_stmt_bind_param($stmt, "s", $_SESSION['u_uid']); //Run parameters inside database mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); while ($row = mysqli_fetch_assoc($result)) { if ($row['subscriptionplan'] === 'Level 1' && $row['activate'] == 0 && $row['level1promo_activate'] == 0) { header("Location: update.php?level1=notactivated"); exit(); } else { if ($row['subscriptionplan'] === 'Level 1' && $row['activate'] == 1 && $row['emailreminder'] == 0 && $row['overdue'] == 0 && $row['paid'] == 0 && $row['feesmonthly'] != 0 && date("Y-m-d H:i:s") > $row['paidbydate']) { $company = "pianocourse101@hotmail.com"; $subject = "Level 1 monthly subscriptionplan payment is overdue: Please pay by the ".$paidbydate; $mailTo = $_SESSION['u_email']; $headers = "From: ".$company; $txt = "Hello ".$_SESSION['u_first']." ".$_SESSION['u_last']."! \n\n Your payment was due on the ".$row['paidbydate'].". It has now been extended to the following due date ".$paidbydate."\n\nPlease make sure that you have made your payment ASAP in order to access your Level 1 videos by the current due date. \n\nFailure to make payment will result in the cancellation of your Level 1 monthly subscriptionplan"; mail($mailTo, $subject, $txt, $headers); $sql = "UPDATE memberships SET paidbydate = ?, emailreminder = ?, overdue = ? WHERE user_uid = ? "; $stmt = mysqli_stmt_init($conn); //Prepare the prepared statement if (!mysqli_stmt_prepare($stmt, $sql)) { echo 'SQL statement failed'; } else { //Bind parameters to the placeholder mysqli_stmt_bind_param($stmt, "siis", $paidbydate, $emailreminder, $overdue, $_SESSION['u_uid']); //Run parameters inside database mysqli_stmt_execute($stmt); } header("Location: update.php?level1=overdue"); exit(); } else { if ($row['subscriptionplan'] === 'Level 1' && $row['activate'] == 1 && $row['emailreminder'] == 1 && $row['overdue'] == 1 && $row['paid'] == 0 && $row['feesmonthly'] != 0 && date("Y-m-d H:i:s") > $row['paidbydate']) { $company = "pianocourse101@hotmail.com"; $subject = "Level 1 monthly subscriptionplan payment has been cancelled!"; $mailTo = $_SESSION['u_email']; $headers = "From: ".$company; $txt = "Hello ".$_SESSION['u_first']." ".$_SESSION['u_last']."! \n\n Your payment was due on the ".$row['paidbydate'].". Your Level 1 monthly subscriptionplan has been cancelled because you have failed to make payment and already have received an email reminder! \n\nPlease subscribe again if you wish to access your Level 1 videos!"; mail($mailTo, $subject, $txt, $headers); $sql = "UPDATE memberships SET subscriptionplan = ?, subscriptionplandate = ?, feesmonthly = ?, expirydate = ?, paidbydate = ?, emailreminder = ?, overdue = ?, activate = ? WHERE user_uid = ? "; $stmt = mysqli_stmt_init($conn); //Prepare the prepared statement if (!mysqli_stmt_prepare($stmt, $sql)) { echo 'SQL statement failed'; } else { //Bind parameters to the placeholder mysqli_stmt_bind_param($stmt, "ssissiiis", $subscriptionplandelete, $subscriptionplandatedelete, $feemonthlysdelete, $expirydatedelete, $paidbydatedelete, $emailreminderreset, $overduereset, $activatereset, $_SESSION['u_uid']); //Run parameters inside database mysqli_stmt_execute($stmt); } header("Location: update.php?level1=cancelled"); exit(); } else { if ($row['subscriptionplan'] === 'Level 1' && $row['activate'] == 1 && $row['emailreminder'] == 0 && $row['overdue'] == 0 && $row['paid'] == 0 && $row['feesyearly'] != 0 && date("Y-m-d H:i:s") > $row['paidbydate']) { $company = "pianocourse101@hotmail.com"; $subject = "Level 1 yearly subscriptionplan payment is overdue: Please pay by the ".$paidbydate; $mailTo = $_SESSION['u_email']; $headers = "From: ".$company; $txt = "Hello ".$_SESSION['u_first']." ".$_SESSION['u_last']."! \n\n Your payment was due on the ".$row['paidbydate'].". It has now been extended to the following due date ".$paidbydate."\n\nPlease make sure that you have made your payment ASAP in order to access your Level 1 videos by the current due date. \n\nFailure to make payment will result in the cancellation of your Level 1 yearly subscriptionplan"; mail($mailTo, $subject, $txt, $headers); $sql = "UPDATE memberships SET paidbydate = ?, emailreminder = ?, overdue = ? WHERE user_uid = ? "; $stmt = mysqli_stmt_init($conn); //Prepare the prepared statement if (!mysqli_stmt_prepare($stmt, $sql)) { echo 'SQL statement failed'; } else { //Bind parameters to the placeholder mysqli_stmt_bind_param($stmt, "siis", $paidbydate, $emailreminder, $overdue, $_SESSION['u_uid']); //Run parameters inside database mysqli_stmt_execute($stmt); } header("Location: update.php?level1=overdue"); exit(); } else { if ($row['subscriptionplan'] === 'Level 1' && $row['activate'] == 1 && $row['emailreminder'] == 1 && $row['overdue'] == 1 && $row['paid'] == 0 && $row['feesyearly'] != 0 && date("Y-m-d H:i:s") > $row['paidbydate']) { $company = "pianocourse101@hotmail.com"; $subject = "Level 1 yearly subscriptionplan payment has been cancelled!"; $mailTo = $_SESSION['u_email']; $headers = "From: ".$company; $txt = "Hello ".$_SESSION['u_first']." ".$_SESSION['u_last']."! \n\n Your payment was due on the ".$row['paidbydate'].". Your Level 1 yearly subscriptionplan has been cancelled because you have failed to make payment and already have received an email reminder! \n\nPlease subscribe again if you wish to access your Level 1 videos!"; mail($mailTo, $subject, $txt, $headers); $sql = "UPDATE memberships SET subscriptionplan = ?, subscriptionplandate = ?, feesmonthly = ?, expirydate = ?, paidbydate = ?, emailreminder = ?, overdue = ?, activate = ? WHERE user_uid = ? "; $stmt = mysqli_stmt_init($conn); //Prepare the prepared statement if (!mysqli_stmt_prepare($stmt, $sql)) { echo 'SQL statement failed'; } else { //Bind parameters to the placeholder mysqli_stmt_bind_param($stmt, "ssissiiis", $subscriptionplandelete, $subscriptionplandatedelete, $feemonthlysdelete, $expirydatedelete, $paidbydatedelete, $emailreminderreset, $overduereset, $activatereset, $_SESSION['u_uid']); //Run parameters inside database mysqli_stmt_execute($stmt); } header("Location: update.php?level1=cancelled"); exit(); // Up to this point, the code is working } else { if ($row['subscriptionplan'] === 'Level 1' && $row['feesmonthly'] != 0 && $row['activate'] == 1 && $row['paid'] == 1 && date("Y-m-d H:i:s") > $row['expirydate']) { $company = "pianocourse101@hotmail.com"; $subject = "Level 1 monthly subscriptionplan payment has been cancelled!"; $mailTo = $_SESSION['u_email']; $headers = "From: ".$company; $txt = "Hello ".$_SESSION['u_first']." ".$_SESSION['u_last']."! \n\n Your payment was due on the ".$row['paidbydate'].". Your Level 1 monthly subscriptionplan has been cancelled because you have failed to make payment and already have received an email reminder! \n\nPlease subscribe again if you wish to access your Level 1 videos!"; mail($mailTo, $subject, $txt, $headers); $sql = "UPDATE memberships SET subscriptionplan = ?, subscriptionplandate = ?, feesmonthly = ?, paid = ?, expirydate = ?, paidbydate = ?, emailreminder = ?, overdue = ?, activate = ? WHERE user_uid = ? "; $stmt = mysqli_stmt_init($conn); //Prepare the prepared statement if (!mysqli_stmt_prepare($stmt, $sql)) { echo 'SQL statement failed'; } else { //Bind parameters to the placeholder mysqli_stmt_bind_param($stmt, "ssiissiiis", $subscriptionplandelete, $subscriptionplandatedelete, $feemonthlysdelete, $paidreset, $expirydatedelete, $paidbydatedelete, $emailreminderreset, $overduereset, $activatereset, $_SESSION['u_uid']); //Run parameters inside database mysqli_stmt_execute($stmt); } header("Location: update.php?level1=expired"); exit(); } else { if ($row['subscriptionplan'] === 'Level 1' && $row['feesyearly'] != 0 && $row['activate'] == 1 && $row['paid'] == 1 && date("Y-m-d H:i:s") > $row['expirydate']) { $company = "pianocourse101@hotmail.com"; $subject = "Level 1 yearly subscriptionplan payment has been cancelled!"; $mailTo = $_SESSION['u_email']; $headers = "From: ".$company; $txt = "Hello ".$_SESSION['u_first']." ".$_SESSION['u_last']."! \n\n Your payment was due on the ".$row['paidbydate'].". Your Level 1 yearly subscriptionplan has been cancelled because you have failed to make payment and already have received an email reminder! \n\nPlease subscribe again if you wish to access your Level 1 videos!"; mail($mailTo, $subject, $txt, $headers); $sql = "UPDATE memberships SET subscriptionplan = ?, subscriptionplandate = ?, feesyearly = ?, paid = ? expirydate = ?, paidbydate = ?, emailreminder = ?, overdue = ?, activate = ? WHERE user_uid = ? "; $stmt = mysqli_stmt_init($conn); //Prepare the prepared statement if (!mysqli_stmt_prepare($stmt, $sql)) { echo 'SQL statement failed'; } else { //Bind parameters to the placeholder mysqli_stmt_bind_param($stmt, "ssiissiiis", $subscriptionplandelete, $subscriptionplandatedelete, $feeyearlysdelete, $paidreset, $expirydatedelete, $paidbydatedelete, $emailreminderreset, $overduereset, $activatereset, $_SESSION['u_uid']); //Run parameters inside database mysqli_stmt_execute($stmt); } header("Location: update.php?level1=expired"); exit(); // last working code! } if ($row['subscriptionplan'] === 'Level 1' && $row['activate'] == 1 && $row['paid'] == 1 && date("Y-m-d H:i:s") <= $row['expirydate']) { header("Location: level1videos.php?levelvideos=success"); exit(); } else { if ($row['subscriptionplan'] === 'Level 1' && $row['activate'] == 1 && $row['paid'] == 0 && date("Y-m-d H:i:s") <= $row['expirydate']) { header("Location: update.php?level1=notpaid"); exit(); } else { if ($row['subscriptionplan2'] === 'Level 2' && $row['level2promo_activate'] == 1 && date("Y-m-d H:i:s") > $row['expirydate2'] && $row['paid2'] == 0 && $row['activate2'] == 0) { header("Location: update.php?level1promo=expired"); exit(); } else { if ($row['subscriptionplan2'] === 'Level 2' && $row['level2promo_activate'] == 1 && date("Y-m-d H:i:s") <= $row['expirydate2'] && $row['paid2'] == 0 && $row['activate2'] == 0) { header("Location: level2videos.php?level1promo=success"); exit(); } else { header("Location: update.php?level1=notchosen"); exit(); } } } } } } } } } } } } }
  7. It was my fault... the name is not called submit.. I had the wrong name
  8. Hey guys! I am trying to make a forum and got the following errors: According to my url, the error seems to be in my post_reply_parse.php.... Upon further looking at the code, I think the problem lies in this section: ``` <?php include_once 'header.php'; if (!isset($_SESSION['u_uid'])) { header ("Location: index.php?post_reply_parse=notlogin"); exit(); } else { if (!isset($_POST['submit'])) { header("Location: post_reply.php?post_reply_parse=error"); exit(); } else { include_once 'includes/dbh.php'; $date = date("Y-m-d H:i:s"); $creator = $_SESSION['u_uid']; $reply_content = $_POST['reply_content']; $cid = $_POST['cid']; $tid = $_POST['tid']; $limit = 1; ``` For some reason, if I do this, then it works: <?php include_once 'header.php'; if (!isset($_SESSION['u_uid'])) { header ("Location: index.php?post_reply_parse=notlogin"); exit(); } else { include_once 'includes/dbh.php'; $date = date("Y-m-d H:i:s"); $creator = $_SESSION['u_uid']; $reply_content = $_POST['reply_content']; $cid = $_POST['cid']; $tid = $_POST['tid']; $limit = 1;
  9. I understand, I was trying to get it to work first before substituting it with the ?
  10. I have listened and in my other forum, I did mention that my database is working. I know that we all have our own unique ways to set up variables but I do understand how to get it to work with my database. I am not copying and pasting but am a visual learning and therefore learns thing when other people are showing contents, such as on the youtube videos. I just find it easier to learn that way. I have also read some stuff from stackoverflow but they mentioned that isset is mainly used to see if a variable is set such as in a form? I should use session to determine if a session exists or not? Besides, I have no prior computer skills so I need to find ways to learn from scratch and tried to make effort to learn..
  11. I just saw your comment just then... maybe I should change the || to &&.. That is weird.... I changed it to && and it does work but just wondering how come it is working in the tutorial? My apologies, he made a mistake in the video.. he forgot to check to see if it is an empty string
  12. Okay... because I am trying to follow this tutorial on how to set up a forum but I am stucked at around the 13:23 mins mark. When I tested the page at the end of that video segment, it is always saying that I am not logged in even though that I am.. I will attach the two latest files, which I think should be working hand in hand below. It should take me to the create_topic.php page. It seems that the $_GET variable is not picking up the cid <?php include_once 'header.php'; if (!isset($_SESSION['u_uid'])) { header("Location: index.php?view_category=notlogin"); exit(); } else { include_once 'includes/dbh.php'; $cid = $_GET['cid']; $logged = " <a href='create_topic.php?cid=".$cid."'>Click here to create a topic</a>"; $sql = "SELECT id FROM categories WHERE id= '".$cid."' LIMIT 1"; $stmt = mysqli_stmt_init($conn); if (!mysqli_stmt_prepare($stmt, $sql)) { echo 'SQL error'; } else { mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); $resultCheck = mysqli_num_rows($result); if ($resultCheck >0) { $sql2 = "SELECT * FROM topics WHERE category_id='".$cid."' ORDER BY topic_reply_date DESC"; $stmt = mysqli_stmt_init($conn); if (!mysqli_stmt_prepare($stmt, $sql2)) { echo 'SQL error'; } else { mysqli_stmt_execute($stmt); $result2 = mysqli_stmt_get_result($stmt); $resultCheck2 = mysqli_num_rows($result2); if ($resultCheck2 > 0) { $topics .= "<table width='100%' style='border-collapse: collapse:'>"; $topics .= "<tr><td colspan='3'><a href='forum.php'>Return to Forum Index</a>".$logged."</td></tr>"; $topics .= "<tr style='background-color: #dddddd:'><td>Topic Title</td>><td width='65' align='center'>Replies</td><td width='65' align='center'>Views</td></tr>"; $topics .= "<tr><td colspan='3'><hr></td></tr>"; while ($row = mysqli_fetch_assoc($result2)) { $tid = $row['id']; $title = $row['topic_title']; $views = $row['topic_views']; $date = $row['topic_date']; $creator = $row['topic_creator']; $topics .= "<tr><td><a href='view_topic.php?cid=".$cid."&tid=".$tid."'>".$title."</a><br /><span class='post_info'>Posted by: ".$creator." on ".$date."</span></td><td align='center'>0</td><td align='center'>".$views."</td></tr>"; $topics .= "<tr><td colspan='3'><hr /></td></tr>"; } $topics .= "</table>"; } else { echo "<a href='header.php'>Return to the Forum page</a>"; echo "<p> There are no topics in this Category yet.".$logged."</p>"; } } }else { echo "<a href='header.php'>Return to the Forum page</a>"; echo "<p> You are trying to view a catebory that does not exists yet.</p>"; } } } // This is the second file called create_topic.php <?php include_once 'header.php'; if ((!isset($_SESSION['u_uid'])) || ($_GET['cid'])) { header("Location: index.php?create_topic=notlogin"); exit(); } $cid = $_GET['cid']; ?> <!DOCTYPE html> <html> <head> <title></title> </head> <body> <form action="create_topic_parse.php" method="POST"> <label>Topic Title</label> <br></br> <input type="text" name="topic_title" size="98" maxlength="150"> <br></br> <label>Topic Content</label> <br></br> <textarea name="topic_content" rows="5" cols="75"></textarea> <br></br> <br></br> <input type="hidden" name="cid" value="<?php echo $cid; ?>"> <input type="submit" name="topic_submit" value="Create Your Topic"> </form> </body> </html>
  13. Hey guys! I have seen on the internet a couple of ways to write the following statement but the latter one looks a bit weird with that extra opening ( before !isset, which way is the norm here? if (isset($_POST['room']) || ($_POST['cottage']) || ($_POST['villa'])) { } but I have seen somewhere that you can also write if ((!isset($_POST['submit'])) || ($_GET['u_uid']))
  14. I can get my php form to process the timer result and insert the record into the database but when I add the header function, it keeps taking me to the header function instead of showing the timer. My guess is that because it is processing the php first, it is doing this. I just like to know if I can have a header function it this is the case? <?php include_once 'includes/dbh.php'; $timer = 60; $time = $_POST['time']; $user_uid = 'piano0011'; $sql = "UPDATE primerlevel_tests SET time_achieved = ? WHERE user_uid = ? "; $stmt = mysqli_stmt_init($conn); if (!mysqli_stmt_prepare($stmt, $sql)) { echo 'SQL error'; } else { mysqli_stmt_bind_param($stmt, "ss", $time, $user_uid); mysqli_stmt_execute($stmt); } header("Location: update.php?countdown=success"); exit(); ?> <style type="text/css"> div.timer { text-align: center; margin: 15% auto; } #msg { color: red; } </style> <html> <head> <script type="text/javascript"> var timer = <?php echo $timer ?>; // 1 minute timer.... var min = 0; var sec = 0; var active = 1; function startTimer() { if (active==0) return; if (timer == 0) timer = <?=$timer?> ; timer--; min = parseInt(timer/60); sec = parseInt(timer%60); if(timer < 1) { $timer = 0; min = 0; sec = 0; document.getElementById("msg").innerHTML = "You have to start again" ; document.getElementById("time").value = "00:00:00"; active = 1; return; } else { if (min < 10) min = '0'+min; if (sec < 10) sec = '0'+sec; document.getElementById("msg").innerHTML = "" ; document.getElementById("time").value = "00:" + min.toString() + ":" + sec.toString(); } setTimeout(function() { startTimer(); }, 1000); } function stop() { if (min + sec > 0) { alert("Thank you for completing the test. You finished the test at: " + min.toString() + ":" + sec.toString()); document.form1.submit(); active = 0; } } </script> </head> <body> <div class="timer"> <h1>Welcome to Timertrone.</h1> <br> <form name='form1' action='' method="post"> Time left: <input type="text" name="time" id="time" value=""> </form> <span id="msg"></span> </br> <button name="start" onclick="startTimer()">Start</button> <button name="stop" onclick="stop()">Stop</button> </div> </body> </html> It only works if I get rid of the // header("Location": update.php?countdown=success");
  15. Ok.. i will take a look and also, will the above work and is it good practice to use a separate page for the javascript code? As in <script src="">?
  16. I might have asked this before but should I be storing the value: 00:00:00 as time or timestamp? I guess timestamp is for date where you have the days as well but for time, it is just time? and I don't have to explode and remove the : to store it I guess?
  17. I just tried it above the h2 tag as follows, without the position property but it looks like this:
  18. Barand, why did you use a form name="form1" because I can't see this in any of the functions? Apologies... I see it..
  19. ok.... that explains it because if the value of the timer is not checked or input in the form, there will always be an error... I think... My apologies Barand, I can't believe I posted in different places.. I must have overlooked! In your code, can I add a submit buttons and a form tag ? I will try to see if that will process the variables in php with a form tag.. You guys should make some video tutorials as some people may be more of a visual learner.... but thanks!
  20. Hey guys! I am trying to add some horizontal rules to the following code and there should be one right before my second h2 tag (which is located at the end of the code) but it is showing a bit lower instead as shown below;... do I have to use position relative to move it, is this a common practice for this element? while ($row = mysqli_fetch_assoc($result)) { echo '<div class="update_heading">'; echo '<b><h2>Below are your premium membership information for Level 1</b></h2>'; echo '</div>'; echo '<br></br>'; echo '<div class="update_text">'; echo '<h3>'; echo 'Your premium membership subscription plan A is: <div class="information">'.$row['subscriptionplan'].'</div>'; echo '<br></br>'; echo 'Your premium membership date of subscription for subscription plan A is: <div class="information"> '.$row['subscriptionplandate'].'</div>'; echo '<br></br>'; if ($row['feesmonthly'] === null) { echo 'Your premium membership fee for subscription plan A is: <div class="information"> $'.$row['feesyearly'].'</div>'; } else { echo 'Your premium membership fee for subscription plan A is: <div class="information"> $'.$row['feesmonthly'].'</div>'; } echo '<br></br>'; if ($row['paid'] == 0) { echo 'Your premium membership payment status for subscription plan A is: <div class="information"> Not paid </div>'; } else { echo 'Your premium membership payment status for subscription plan A is: <div class="information">Paid</div>'; } echo '<br></br>'; echo 'Your premium membership expiry date for subscription plan A is: <div class="information">'.$row['expirydate'].'</div>'; echo '<br></br>'; echo 'Your premium membership paid by date for subscription plan A is: <div class="information">'.$row['paidbydate'].'</div>'; echo '<br></br>'; if ($row['emailreminder'] == 0) { echo 'You have <div class="information">no overdue fees </div> for subscription plan A'; } else { echo 'You have <div class="information"> overdue fees </div> for subscription plan A'; } echo '<br></br>'; if ($row['activate'] == 0) { echo 'You <div class="information">need to activate</div> your premium membership for subscription plan A'; } else { echo 'You <div class="information">have already activated</div> your premium membership for subscription plan A'; } echo '<br></br>'; echo '<br></br>'; echo '</h3>'; echo '</div>'; echo '<hr>'; echo '<div class="update_heading2">'; echo '<b><h2>Below are your premium membership information for Level 2</b></h2>'; echo '</div>';
  21. I think I forgot to change the stop button type to button as well. When I changed both buttons type to buttons, then it does work but I am not sure why my isset function is always showing as error? I am trying to add another button for the user to submit it for the timer result to be processed but it is showing as undefined index: <?php if (!isset($_POST['submit'])) { header ("Location: update.php?countdown2=error"); } else { $timer = 60; $result = $_POST['timer']; echo $result; } ?> <!DOCTYPE html> <html> <head> <title></title> <link rel="stylesheet" type="text/css" href="style.css"> <link href="https://fonts.googleapis.com/css?family=Lobster" rel="stylesheet"> </head> <body> <script> var timer = <?php echo $timer ?>; // 1 minute timer.... var min = 0; var sec = 0; function startTimer() { min = parseInt(timer/60); sec = parseInt(timer%60); if(timer<1) { document.write("You have to start again!"); } document.getElementById("time").innerHTML = + min.toString() + ":" + sec.toString(); timer--; setTimeout(function() { startTimer(); }, 1000); } function stopTimer() { alert("Thank you for completing the test. You finished the test at: " + min.toString() + ":" + sec.toString()); var result = document.getElementById('time').innerHTML; document.getElementById('input').value = result; // window.location.href = "update.php"; } </script> <form> <div class="timer"> <h1>Welcome to Timertrone.</h1> <br></br> <form action="" method="POST"> <b>Time Left: </b> <span class="timer_display" id="time"> ...</span> <input type="text" name="timer" id="input"> <h1 id="buttons"></h1> <button type="button" name="start" onclick="startTimer()">Start</button> <button type="button" name="stop" onclick="stopTimer()">Stop</button> <button type="submit" name="submit" >Submit</button> </form> </div> </div> </body> </html>
  22. I tried using stopTimer for my button and also changed the function to stopTimer. It almost work but the time does display in the input box but only momentarily. I tried to echo it into the php but it says undefined index <?php $timer = 60; $result = $_POST['timer']; echo $result; ?> <!DOCTYPE html> <html> <head> <title></title> <link rel="stylesheet" type="text/css" href="style.css"> <link href="https://fonts.googleapis.com/css?family=Lobster" rel="stylesheet"> </head> <body> <script> var timer = <?php echo $timer ?>; // 1 minute timer.... var min = 0; var sec = 0; function startTimer() { min = parseInt(timer/60); sec = parseInt(timer%60); if(timer<1) { document.write("You have to start again!"); } document.getElementById("time").innerHTML = + min.toString() + ":" + sec.toString(); timer--; setTimeout(function() { startTimer(); }, 1000); } function stopTimer() { alert("Thank you for completing the test. You finished the test at: " + min.toString() + ":" + sec.toString()); var result = document.getElementById('time').innerHTML; document.getElementById('input').value = result; // window.location.href = "update.php"; } </script> <form> <div class="timer"> <h1>Welcome to Timertrone.</h1> <br></br> <form action="" method="POST"> <b>Time Left: </b> <span class="timer_display" id="time"> ...</span> <input type="text" name="timer" id="input"> <h1 id="buttons"></h1> <button type="button" name="start" onclick="startTimer()">Start</button> <button type="submit" name="stop" onclick="stopTimer()">Stop</button> </form> </div> </div> </body> </html>
  23. I tried to have a look at other programs such as raw etc but i guess most of these programs only open svg files and not movie files... i triex movie makers, but don't have other movie editors.. are there any free editors that support both movies and svg? Maybe i have to save that picture as something else like a gif? I think movie makers only support gif or png ect
  24. Thanks and I really appreciate your kind assistance everyone...... can't wait to get my piano website up and running
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.