Jump to content

jamesclues

Members
 View Profile  See their activity

  • Posts

    17

  • Joined

  • Last visited

 Content Type 

Posts posted by jamesclues

    PHP MYSQL LEARNING

    in PHP Coding Help

    Posted

    2 hours ago, jamesclues said:

    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>

     

    FIXXED IT MY SELF WITH ABIT OF GOGLE

    PHP MYSQL LEARNING

    in PHP Coding Help

    Posted

    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>

     

    PHP MYSQL LEARNING

    in PHP Coding Help

    Posted · Edited by 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

    Parse error: syntax error, unexpected $end in send.php

    in PHP Coding Help

    Posted

    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);}

?>

    Parse error: syntax error, unexpected $end in send.php

    in PHP Coding Help

    Posted

    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);

?>

    Send Mail to my self and a User * NEW TO PHP

    in PHP Coding Help

    Posted

    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);

?>

    Send Mail to my self and a User * NEW TO PHP

    in PHP Coding Help

    Posted

    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 :(

    Send Mail to my self and a User * NEW TO PHP

    in PHP Coding Help

    Posted

     

    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>

    Send Mail to my self and a User * NEW TO PHP

    in PHP Coding Help

    Posted

    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.