Jump to content

jamesclues

Members
 View Profile  See their activity

  • Posts

    17

  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

jamesclues's Achievements

Member

Member (2/5)

0

Reputation

2

Community Answers

  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
    Now I get Notice: Undefined index: send in send.php on line 2 if($_POST["send"]) { Notice: Undefined index: send in send.php on line 34 if($_POST["send"]) { Full Code Below <? if($_POST["send"]) { //collect post variables $name = $_POST["name"]; $address = $_POST["address"]; $town = $_POST["town"]; $postocde = $_POST["postocde"]; $telephone = $_POST["telephone"]; $email = $_POST["email"]; $enquiry = $_POST["enquiry"]; //build email body $body .= "Name: $name \n"; $body .= "Address: $address \n"; $body .= "Town: $town \n"; $body .= "Postcode: $postcode \n"; $body .= "Telephone: $telephone \n"; $body .= "Email: $email \n"; $body .= "Enquiry: $enquiry \n"; //create email headers $headers = 'From: '.$email. "\r\n" . 'Reply-To: ' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); //send $send = mail("test@domain.com","Online Enquiry",$body,$headers);} ?> <? if($_POST["send"]) { //collect post variables $name = $_POST["name"]; $email = $_POST["email"]; //build email body $body .= "Name: $name \n"; $body .= "Thank you for your Enquiry \n"; //create email headers $headers = "From: 'test@test.com' \r\n". 'Reply-To: ' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); //send $send = mail("$email","Online Enquiry",$body,$headers);} ?>
  5. jamesclues
    PHP Contact form Send Below. Line 54 where the error says is ?> at the end please can someone help me.. <? if($_POST["send"]) { //collect post variables $name = $_POST["name"]; $address = $_POST["address"]; $town = $_POST["town"]; $postocde = $_POST["postocde"]; $telephone = $_POST["telephone"]; $email = $_POST["email"]; $enquiry = $_POST["enquiry"]; //build email body $body .= "Name: $name \n"; $body .= "Address: $address \n"; $body .= "Town: $town \n"; $body .= "Postcode: $postcode \n"; $body .= "Telephone: $telephone \n"; $body .= "Email: $email \n"; $body .= "Enquiry: $enquiry \n"; //create email headers $headers = 'From: '.$email. "\r\n" . 'Reply-To: ' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); //send $send = mail("test@domain.com","Online Enquiry",$body,$headers); ?> <? if($_POST["send"]) { //collect post variables $name = $_POST["name"]; $email = $_POST["email"]; //build email body $body .= "Name: $name \n"; $body .= "Thank you for your Enquiry \n"; //create email headers $headers = "From: 'test@domain.com' \r\n". 'Reply-To: ' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); //send $send = mail("$email","Online Enquiry",$body,$headers); ?>
  6. jamesclues
    Can anyone help please.... Still not working now i get Parse error: syntax error, unexpected $end in send.php on line 54 Line 54 is ?> ???
  7. jamesclues
    Still not working now i get Parse error: syntax error, unexpected $end in send.php on line 54 Line 54 is ?> <? if($_POST["send"]) { //collect post variables $name = $_POST["name"]; $address = $_POST["address"]; $town = $_POST["town"]; $postocde = $_POST["postocde"]; $telephone = $_POST["telephone"]; $email = $_POST["email"]; $enquiry = $_POST["enquiry"]; //build email body $body .= "Name: $name \n"; $body .= "Address: $address \n"; $body .= "Town: $town \n"; $body .= "Postcode: $postcode \n"; $body .= "Telephone: $telephone \n"; $body .= "Email: $email \n"; $body .= "Enquiry: $enquiry \n"; //create email headers $headers = 'From: '.$email. "\r\n" . 'Reply-To: ' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); //send $send = mail("test@domain.com","Online Enquiry",$body,$headers); ?> <? if($_POST["send"]) { //collect post variables $name = $_POST["name"]; $email = $_POST["email"]; //build email body $body .= "Name: $name \n"; $body .= "Thank you for your Enquiry \n"; //create email headers $headers = "From: 'test@domain.com' \r\n". 'Reply-To: ' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); //send $send = mail("$email","Online Enquiry",$body,$headers); ?>
  8. jamesclues
    Parse error: syntax error, unexpected T_STRING in send.php on line 47 Line 47 = $headers = 'From: 'test@domain.com' "\r\n" . Full Code of Area where problem Happening. //create email headers $headers = 'From: 'test@domain.com' "\r\n" . 'Reply-To: ' . "\r\n" . 'X-Mailer: PHP/' . phpversion();
  9. jamesclues
    I have a Form which is on contact.html and posts the data to send.php Contact Form Fields FIELD NAMES BELOW. name address town postocde telephone email enquiry <? if($_POST["send"]) { //collect post variables $name = $_POST["name"]; $address = $_POST["address"]; $town = $_POST["town"]; $postocde = $_POST["postocde"]; $telephone = $_POST["telephone"]; $email = $_POST["email"]; $enquiry = $_POST["enquiry"]; //build email body $body .= "Name: $name \n"; $body .= "Address: $address \n"; $body .= "Town: $town \n"; $body .= "Postcode: $postcode \n"; $body .= "Telephone: $telephone \n"; $body .= "Email: $email \n"; $body .= "Enquiry: $enquiry \n"; //create email headers $headers = 'From: '.$email. "\r\n" . 'Reply-To: ' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); //send $send = mail("info@domain.co.uk","Online Enquiry"); ?> <? if($_POST["send"]) { //collect post variables $name = $_POST["name"]; $email = $_POST["email"]; //build email body $body .= "Name: $name \n"; $body .= "Thank you for your Enquiry \n"; //create email headers $headers = 'From: 'info@domain.co.uk "\r\n" . 'Reply-To: ' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); //send $send = mail("$email","Online Enquiry"); ?> Still having issue got some code off a web site but still does not work
  10. jamesclues
    Well the only code I have is in ASP. So I need to convert this into PHP I have never used PHP in my life till today and have no idea where to start I have search forums and web sites but nothing what i need <% dim firstname dim surname dim address dim town dim postocde dim telephone dim emailaddress dim enquiry firstname=request.form("firstname") surname=request.form("surname") address=request.form("address") town=request.form("town") postocde=request.form("postocde") telephone=request.form("telephone") emailaddress=request.form("emailaddress") enquiry=request.form("enquiry") dim msg1 msg1="<p>Contact Request from Web Site</p>" msg1=msg1 & "<b>First Name:</b> " & firstname & "<br>" msg1=msg1 & "<b>Last Name:</b> " & surname & "<br>" msg1=msg1 & "<b>Last Name:</b> " & address & "<br>" msg1=msg1 & "<b>Last Name:</b> " & town & "<br>" msg1=msg1 & "<b>Last Name:</b> " & postocde & "<br>" msg1=msg1 & "<b>Last Name:</b> " & telephone & "<br>" msg1=msg1 & "<b>Last Name:</b> " & emailaddress & "<br>" msg1=msg1 & "<b>Last Name:</b> " & enquiry & "<br>" Set JMail = Server.CreateObject("JMail.SMTPMail") JMail.ServerAddress = "smtp.domain.co.uk:25" JMail.Sender = emailaddress JMail.Subject = "Subject Enquiry" JMail.AddRecipient "info@domain.com" JMail.ContentType = "text/html" JMail.Body = msg1 JMail.Priority = 0 JMail.Execute %> <% dim msg2 msg2="<b>Dear " & firstname & "</b>" msg2=msg2 & "<p>Thank you for contacting us.</p>" msg2=msg2 & "<p>We will contact you in the next 24 hours</p>" Set JMail = Server.CreateObject("JMail.SMTPMail") JMail.ServerAddress = "smtp.Domain.co.uk:25" JMail.Sender = "info@Domain.com" JMail.Subject = "Doman Enquiry" JMail.AddRecipient emailaddress JMail.ContentType = "text/html" JMail.Body = msg2 JMail.Priority = 0 JMail.Execute %> <html><head><meta http-equiv="refresh" content="1;url=http://www.domain.com/thankyou.asp"><title>Domain</title> </head><br><br><br> <br><center><font color=#000000 face=arial size=3> <b>SENDING EMAIL TO DOMAIN.COM</font><br><br> <font color=#000000 face=arial size=4> <br>http://www.Domains.com</b></font></center> </body></html>
  11. jamesclues
    Hi I am very new to PHP i used to use asp but I thought I would try PHP My Problem is changing a send mail script FIELD NAMES BELOW. firstname surname address town postocde telephone emailaddress enquiry ------------------------------------ Email Example Sent to My Self me@domain.com Subject New Enquiry from Web Site. firstname surname address town postocde telephone emailaddress enquiry ------------------------------------- Email Example Sent to User to Confirm Dear firstname Subject New Enqury from domain.com Thank you for you email we will be in touch soon. after send redirected to a THANKS.PHP I dunno how to do this
×
×
  • 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.