Jump to content

jamesclues

Members
 View Profile  See their activity

  • Posts

    17

  • Joined

  • Last visited

 Content Type 

Everything posted by jamesclues

  1. jamesclues
    FIXXED IT MY SELF WITH ABIT OF GOGLE
  2. jamesclues
    Basically, what I need to do is have when a user clicks on index.php?beat=NORTH, it displays the north data where they can then filter it by week I have split the week up with 1234567 so if its mon to fri it would be 12345, I need to turn the Search into a dropdown with 3 fields and label them 12345= MON - FRI OR 13456 = MON - SAT or 1234567 = MON - SUN SQL CODE -- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jul 14, 2023 at 06:04 PM -- Server version: 10.5.19-MariaDB-cll-lve -- PHP Version: 8.1.16 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `0000` -- -- -------------------------------------------------------- -- -- Table structure for table `DATA` -- CREATE TABLE `DATA` ( `id` smallint(10) NOT NULL, `street` varchar(250) NOT NULL, `restriction` varchar(250) NOT NULL, `day` varchar(250) NOT NULL, `time` varchar(250) NOT NULL, `beat` varchar(25) NOT NULL, `week` varchar(15) NOT NULL, `map` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `DATA` -- INSERT INTO `DATA` (`id`, `street`, `restriction`, `day`, `time`, `beat`, `week`, `map`) VALUES (1, 'PETER STREET', 'NO BALL GAMES', 'MON - SUN', '9AM - 5PM', 'NORTH', '1234567', 'PETER STREET NEWCASTLE'), (2, 'BILL STREET', 'NO CARS', 'MON - FRI', '9AM - 3PM', 'SOUTH', '12345', 'BILL STREET NEWCASTLE'), (3, 'WOOL ST', 'NO CARD GAMES', 'MON - SAT', '9AM - 8PM', 'SOUTH', '123456', 'WOOL STREET NEWCASTLE'); -- -- Indexes for dumped tables -- -- -- Indexes for table `DATA` -- ALTER TABLE `DATA` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `DATA` -- ALTER TABLE `DATA` MODIFY `id` smallint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; php file Code Below <!DOCTYPE html> <html lang="en"> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> <meta charset="UTF-8"> <title>SCHOOL STREET RULES</title> <style> #customers { font-family: Arial, Helvetica, sans-serif; border-collapse: collapse; width: 100%; } #customers td, #customers th { border: 1px solid #ddd; padding: 8px; } #customers tr:nth-child(even){background-color: #f2f2f2;} #customers tr:hover {background-color: #ddd;} #customers th { padding-top: 12px; padding-bottom: 12px; text-align: left; background-color: #04AA6D; color: white; } body { margin: 0; font-family: Arial, Helvetica, sans-serif; } .topnav { overflow: hidden; background-color: #333; } .topnav a { float: left; color: #f2f2f2; text-align: center; padding: 14px 16px; text-decoration: none; font-size: 17px; } .topnav a:hover { background-color: #ddd; color: black; } .topnav a.active { background-color: #04AA6D; color: white; } </style> </head> <body> <div class="container"> <div class="topnav"> <a href="index.php">HOME</a> </div> <div style="padding-top:25px"> <center><h2>street rules</h2></center> </div> <div class="row"> <div class="col-md-20 col-md-offset-0" style="margin-top: 2%;"> <div class="row"> <?php $conn = new mysqli('localhost', '0000000', '00000000', '00000000000'); if(isset($_GET['search'])){ $searchKey = $_GET['search']; $sql = "SELECT * FROM DATA WHERE Week LIKE '%$searchKey%'" ; }else $sql = "SELECT * FROM DATA WHERE week LIKE ''" ; $result = $conn->query($sql); ?> <form action="" method="GET"> <div class="col-md-6"> <input type="text" name="search" class='form-control' placeholder="Search By day" value=<?php echo @$_GET['search']; ?> > </div> <div class="col-md-6 text-left"> <button class="btn">Search</button> </div> </form> <br> <br> </div> <table class="table table-bordered" id="customers"> <tr> <th>Street / Location</th> <th>Restriction</th> <th>Day / Time</th> <th>Beat</th> <th>Map</th> </tr> <?php while( $row = $result->fetch_object() ): ?> <tr> <td><?php echo $row->street ?></td> <td><?php echo $row->restriction ?></td> <td><?php echo $row->day ?> | <?php echo $row->time ?></td> <td><?php echo $row->beat ?></td> <td> <a href="https://www.google.com/maps/place/<?php echo $row->map ?>">MAP</a> </td> </tr> <?php endwhile; ?> </table> </div> </div> </div> <P> <CENTER> <footer>&copy; Copyright 2023 SCHOOL TEAM</footer></CENTER></P> </body> </html>
  3. jamesclues
    I have a school assignment to complete. I am new to PHP I have tried many guides but I seem to be failing I have a MySQL database with the following setup TABLE = data Columns = id, street, restriction, dayplate, timeplate, location, area, days Example data ID street restriction dayplate timeplate location area days 1 Wood St No Ball Games MON - FRI 9am - 4pm REAR SOUTH 12345 2 Peter St No Children MON - SUN 8am - 1pm FRONT NORTH 1234567 I NEED A FILTER LIKE (DAYS) = 12345 only display mon - fri data & (AREA) if select south only display data for south I need to display the data like this STREET RESTRICTION DAY / TIME WOOD ST NO BALL GAMES MON - FRI 9am - 4pm
  4. jamesclues
    getting following error message [30-Mar-2018 17:14:34 UTC] PHP Parse error: syntax error, unexpected end of file in /home/hotels/public_html/3.php on line 122 . Spent 2 hours trying to make this work anyone got any ideas maybe i am just tired and not seeing what the problem is i have made sure all my connections are closed off. <!DOCTYPE HTML> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Base Hotel - Standard Room</title> <link rel="stylesheet" href="system/css/global.css"> <link class="colour" rel="stylesheet" href="system/css/colour-blue.css"> <link class="pattern" rel="stylesheet" href="system/css/pattern-china.css"> <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css"> </head> <?php include 'header.php'; ?> <?php include 'conn.php'; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); //Query $sql = "SELECT * FROM Hotels WHERE hotelid = '1' LIMIT 1;"; $result = mysqli_query ($conn, $sql); while($row = mysqli_fetch_array($result)) { $string = $facilities; $delimiters = Array(","); $facilitiessplit = explode($delimiters,$string); //Whatever you want to do for each row... echo " <div id='container'> <header> <div id='header'> <div class='h1'> <h1><span> ".$row[hotelname]." </span> <span class='tagline'> ".$row[address]." </span></h1> </div> </div> </header> <!-- Header | END --> <!-- Content | START --> <main> <div class='centre'> <div id='left'> <!-- Slideshow | START --> <div id='slideshow'> <div class='slider'> <div class='item'><img alt='' src='".$row[hotelimg1]."' width='770' height='500' /></div> <div class='item'><img alt='' src='".$row[hotelimg2]."' width='770' height='500' /></div> <div class='item'><img alt='' src='".$row[hotelimg3]."' width='770' height='500' /></div> <div class='item'><img alt='' src='".$row[hotelimg4]."' width='770' height='500' /></div> <div class='item'><img alt='' src='".$row[hotelimg5]."' width='770' height='500' /></div> </div> <div class='nav'> <a class='prev'><i class='fa fa-chevron-left'></i></a> <a class='next'><i class='fa fa-chevron-right'></i></a> </div> </div> <!-- Slideshow | END --> <div id='content'> <div align='left'> <h2><strong>Welcome to </strong> ".$row[hotelname]."</h2> <p> ".$row[hoteldescrtiption]." </p> <ul class='tags'> echo '<li>'; print_r($facilitiessplit); echo '</li>'; </ul> </div> <a href='guest-book.html' class='button'><span data-hover='BOOK ONLINE'>BOOK ONLINE</span></a> </div> </div> } $conn->close(); ?> <!-- Sidebar | START --> <?php include 'sidebar.php'; ?> <!-- Sidebar | END --> </div> <!-- Google Map | START --> <script> function initialize() { var latlng = new google.maps.LatLng(-31.957482,115.856868); var myOptions = { zoom: 14, center: latlng, mapTypeId: google.maps.MapTypeId.ROADMAP, scrollwheel: false }; var map = new google.maps.Map(document.getElementById('googlemap'), myOptions); var marker = new google.maps.Marker({ position: latlng, map: map, icon: 'system/images/point.png' }); } function loadScript() { var script = document.createElement('script'); script.type = 'text/javascript'; script.src = 'https://maps.googleapis.com/maps/api/js&callback=initialize'; document.body.appendChild(script); } window.onload = loadScript; </script> <div id='map'> <div id='googlemap'></div> </div> <!-- Google Map | END --> </main> <?php include 'footer.php'; ?>
  5. jamesclues
    do you have an example a simple way ?
  6. jamesclues
    When I run this I am getting no errors and no data back please can someone tell me what i am doing wrong <?php include 'conn.php'; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); //Query $sql = $conn->prepare("SELECT hotelid, hotelname FROM Hotels WHERE hotelid = '1'"); $sql->execute() ; ?> <div id="container"> <header> <div id="header"> <div class="h1"> <?php while( $row = $sql->fetch()) : ?> <h1><span><?php echo $row['hotelname']; ?></span> <?php endwhile ?>
  7. jamesclues
    I took your advice and changed the code it's working now header("Location: http://reports.domain.com/$website"); }else{ header("Location: report.html"); } exit; ?>
  8. jamesclues
    I Basically when a user submits the form $website="domain.com" so i want the user redirected to http://reports.mydomain.com/domain.com The red is the domain.com from the form submitted print "<meta http-equiv=\"refresh\" content=\"1;URL=http://report.domain.com/<$website>">"; Where read at the top $website is where the form submitted domain will appear... I tried this code but i get error 500 server // send email$success = mail($EmailTo, $Subject, $Body, "From: <$EmailFrom>"); // redirect to success page if ($success){ print "<meta http-equiv=\"refresh\" content=\"1;URL=http://report.domain.com/<?php echo $website ?>">"; } else{ print "<meta http-equiv=\"refresh\" content=\"1;URL=freereport.html\">"; } ?>
  9. jamesclues
    Basically I have form that after submission i want it to goto http://report.domain.com/ domain.com user entered in the form this is where the domain is picked up from $website =($_POST['website']); // send email $success = mail($EmailTo, $Subject, $Body, "From: <$EmailFrom>"); // redirect to success page if ($success){ print "<meta http-equiv=\"refresh\" content=\"1;URL=http://report.domain.com/<$website>">"; } else{ print "<meta http-equiv=\"refresh\" content=\"1;URL=freereport.html\">"; } ?> </body> </html> please, can anyone help I have been searching on google for 3 hours unable to find a solution.
×
×
  • 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.