PHP - Organise Event Listings From Mysql Database

I'm using the latest version of XAMPP on Windows and can't figure out why I'm not seeing the correct directory listing when using the scandir() function.  The first time i opened the web page I got the correct listing of what was in the directory.  After moving and adding files, I opened the web page again and got the same listing I had before i moved and added files.  Is this the correct spot to ask this or should I use the XAMPP support forums?

I tried

$path= 'C:\\xampp\\htdocs\\website\\img\';
$listing = scandir($path);
print_r($listing);

I had 5 files in the 'img' directory the first time I opened the website and got the correct listings.  I then added 10 new files and moved 2 files out and refreshed the page and got the same listings of the original 5 files. I closed and reopened the browser  and tired again and got the original 5 files again.  

 

I've got 2 database tables (states, stores) and I want to output all the states with a list of specific locations under each state.

My 'states' table has a 'state_id' and 'state' while my 'stores' table has all the store information along with the 'state_id' to work with the 'states' table.

How would I ago about formulating a loop to display all locations organized by each state, etc.?

Hello:

I am building a Staff list, that I want to use to allow the owner of a company to upload a photo, name, phone, and email of each person on his staff.

I am using this approach from a tutorial I found online:
Database:
Code: [Select]
CREATE TABLE employees (id int(5), name VARCHAR(30), email VARCHAR(30), phone VARCHAR(30), photo VARCHAR(30))

Form:
Code: [Select]
<form enctype="multipart/form-data" action="Add.php" method="POST">
Name: <input type="text" name="name"><br>
E-mail: <input type="text" name = "email"><br>
Phone: <input type="text" name = "phone"><br>
Photo: <input type="file" name="photo"><br>
<input type="submit" value="Add">
</form>

Add.php
Code: [Select]
<?php
include('include/myConn.php');
?>

...

<?php 

$target = "images/"; 
$target = $target . basename( $_FILES['photo']['name']); 

$name=$_POST['name']; 
$email=$_POST['email']; 
$phone=$_POST['phone']; 
$pic=($_FILES['photo']['name']); 
 
mysql_query("INSERT INTO `employees` VALUES ('$name', '$email', '$phone', '$pic')") ; 
 
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) 
{
echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; 
} 
else 
{ 

echo "Sorry, there was a problem uploading your file."; 
} 
?>

Display.php
Code: [Select]
<?php
include('include/myConn.php');
?>

...

<?php

$data = mysql_query("SELECT * FROM employees") or die(mysql_error()); 

while($info = mysql_fetch_array($data));

{
echo "<img src=images/".$info['photo'] ."> <br>"; 
echo "<b>Name:</b> ".$info['name'] . "<br> "; 
echo "<b>Email:</b> ".$info['email'] . " <br>"; 
echo "<b>Phone:</b> ".$info['phone'] . " <hr>";
} 

?>

I am not getting any errors and the photo is uploaded to the "images" folder, but none of the data displays ...

I do not see why ..

Any ideas?

Also, if any one has done something like this before and has a better approach to doing this, I am all ears.

I do want to allow the owner to edit and delete the profiles as well.

Thanks.

Hi All,
I have a form that enables the user to know events that occur in a specific city. Most of the time they get the results in a few seconds, despite the fact that many rows in various tables might be searched for detailed infos about the events in that city.
However, this form partly relies on a table against which a MySQL event regularly does some operations. If the user uses the form while the event is being executed, they have to wait up to 30 seconds before getting the results, and sometimes only part of the html page is generated.
Is there a way to avoid this lengthy waiting time ?
I am wondering whether or not the best would be putting the site on maintenance while the event is being executed, with a "please come back in a few minutes" message.
Thanks in advance for your help.
 

Hey Everyone,

I'm currently implementing a very simple advert posting site (like a classifieds but its more like a forum atm). I've got advert posting working okay and the next step I'm thinking about is interacting with paypal to handle payments. My know of the Paypal IPN is VERY limited so I'm looking for some pointers really.

- Once an item has been paid for how would I go out about removing the post from my website (Payment = true, advert = delete kinda thing..)
     
   The way I was thinking was something to do with the advert ID perhaps? I'm really not sure though so ideas would be very helpful!

- How exactly would I go about implementing the PayPal IPN, very broad question I know but I'm not overly sure..

Sorry for sounding like a bit of a noob (I guess I am really!)

The website is located here (http://is.gd/04qcz5)

and the database setup is like so (Just in case that's helpful at all?)

Database stores Advert ID, Category ID and User ID in a table along with the advert details.

Any help is greatly appreciated, I look forward to hearing from you all!

Cheers

hope someone can help me out here, stuck on this page...
This page shows the details of the listing they had just clicked on on the previous page. this part works
If the person logged in is the person who is looking at the page, the email section does not show. this part works
However, the part I cannot get to work, is when the logged in user types their email message and clicks send email. at this point the details of listing stop showing
please SOMEONE HELP ME
thanks in advance, i hope
Code: [Select]
<?php
  // Start the session
  require_once('startsession.php');

  // Insert the page header
  $page_title = 'Listing Details';
  require_once('header.php');

  require_once('connectvars.php');

  // Show the navigation menu
  require_once('navmenu.php');
 

if(isset($_POST['submit'])){
 $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); 

  // Retrieve the user data from MySQL
  $query1 = 'SELECT email FROM ob_user WHERE username="' . $user_name . '"';
  $data1 = mysqli_query($dbc, $query1);
  $row1 = mysqli_fetch_array($data1);
  
  $email = $row1['email'];
  
 $to = $email;
 $subject = 'OurBazzar response to' . $subject . '';
 $body = $_POST['email'];
 $headers = 'From: caleb.jordan.flax@gmail.com';
 if (mail($to, $subject, $body, $headers)) {
   echo("<p>Message sent!</p>");
  } else {
   echo("<p>Message delivery failed...</p>");
  }
  end();
}



  if (isset($_GET['listing_id']) && isset($_GET['subject']) && isset($_GET['description']) && isset($_GET['price']) && isset($_GET['date']) && isset($_GET['city']) && isset($_GET['state']) && isset($_GET['user_id']) && isset($_GET['category_id'])) {
  
    // Grab the score data from the GET
    $listing_id = $_GET['listing_id'];
    $title = $_GET['subject'];
    $description = $_GET['description'];
    $price = $_GET['price'];
    $date = $_GET['date'];
$city = $_GET['city'];
    $state = $_GET['state'];
    $userid = $_GET['user_id'];
    $categoryid = $_GET['category_id'];

  }

// Connect to the database 
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); 

  // Retrieve the user data from MySQL
  $query = 'SELECT username FROM ob_user WHERE user_id="' . $userid . '"';
  $data = mysqli_query($dbc, $query);
  $row = mysqli_fetch_array($data);

  $query1 = 'SELECT name FROM ob_category WHERE category_id="' . $categoryid . '"';
  $data1 = mysqli_query($dbc, $query1);
  $row1 = mysqli_fetch_array($data1); 
  
$user_name = $row['username'];
$category_name = $row1['name']; 

echo '<table>';
echo '<tr><td colspan="2"><strong>' . $title . '</strong></td></tr>';
echo '<tr><td>Created by: </td><td>' . $user_name . '</td></tr>';
echo '<tr><td>Date created: </td><td>' . $date . '</td></tr>';
echo '<tr><td>Location: </td><td>' . $city . ', ' . $state . '</td></tr>';
echo '<tr><td>Category: </td><td>' . $category_name . '</td></tr>';
echo '<tr><td>Description: </td><td>' . $description . '</td></tr>';
echo '</table>'; 

if ((isset($_SESSION['username'])) && ($_SESSION['username'] != $user_name)) {

?>

<br />
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<fieldset>
<legend>Send Email to <?php echo $user_name; ?></legend>
<label for="email">Message: </label>
<input type="text" name="email" /><br />
<input type="submit" value="Send Email" name="submit">
</fieldset>

<?php

}
require_once('footer.php');
?>

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=330163.0

I have a listener which executes a HTTP request to a remote API before the User entity is persisted and uses the response to set one of the entity's properties.  It will also listen for update and remove and will make the appropriate HTTP request to the API but will not modify the entity.  All works as desired... Almost.  If when persisting the entity, I have some error, the remote API and my application become out of sync.  I wish to change my application to perform a second call to the API if an error occurs and reverse the previous call.  My thoughts on how to implement a

Place a try/catch block when executing the query.  Don't like this approach. Add an ExceptionListener which somehow retrieves the entity and makes the applicable changes.  Maybe part of the solution, but too complicated to be the full solution. When adding, updating, or deleting a user from the remote API under UserListener's three methods, adding a callback which gets executed upon a PDOException.  I think this is the best approach and expanded my thoughts below.

 

<?php

namespace App\EventListener;

use Doctrine\Persistence\Event\LifecycleEventArgs;
use App\Service\HelpDeskClient;
use App\Entity\AbstractUser;

final class UserListner
{
    private $helpDeskClient;

    public function __construct(HelpDeskClient $helpDeskClient)
    {
        $this->helpDeskClient = $helpDeskClient;
    }

    public function prePersist(AbstractUser $user, LifecycleEventArgs $event)
    {
        $this->helpDeskClient->addUser($user);   //$user will be updated with the HTTP response
    }

    public function preUpdate(AbstractUser $user, LifecycleEventArgs $event)
    {
        $this->helpDeskClient->updateUser($user);
    }

    public function preRemove (AbstractUser $user, LifecycleEventArgs $event)
    {
        $this->helpDeskClient->deleteUser($user);
    }
}

Okay, how do I actually do this?  Was thinking of modifying UserListner as follows:

//...
use Symfony\Component\HttpKernel\KernelEvents;

final class UserListner
{
    // ...
    
    public function prePersist(AbstractUser $user, LifecycleEventArgs $event)
    {
        $this->helpDeskClient->addUser($user);
        
        $event->getObjectManager()->getEventManager()->addEventListener(KernelEvents::EXCEPTION, function($something) use($user) {
            // Use $this->helpDeskClient to reverse the changes
        });
    }
    
    // Similar for update and remove
}

 

But when trying this approach, I get a PDOException, but my callback never gets excecated.  I've also tried replacing KernelEvents::EXCEPTION with '\PDOException' (note the quotes) with no success.

Any ideas what I should be doing differently?

Maybe some totally different approach?  I suppose I could make the request to the API after the DB query is complete for updating and deleting, but not for adding.

How would I go about doing the following:

I have a csv like this
Quote

"Division","Section","Group","Product Code","Description","Description + Secondary Description"
"Division 1","Section 1","Group 1","BMSLPL25","Test Name","Test Description"
"Division 1","Section 1","Group 2","BMSLPL26","Test Name 2","Test Description 2"
"Division 2","Section 2","Group 2","BMSLPL27","Test Name 3","Test Description 3"



I have a database structured like this
Quote

Divisions
---
id
name
parent_id

Groups
---
id
name
division_id

Products
---
id
code
description
secondary_description



Section is a sub division. What is the best way to get the information from CSV into this database? Should I have another table and store the CSV data as is and then query that to make the other tables.
Any help much appreciated.

For some reason Im not able to connect to mysql database, when i fill in the form and select search, it just basically refreshes the page but does not come up with no error messages or any results from my database. any help is appreciated.

HTML Code

Code: [Select]

<table id="tb1">
<tr>
<td><p class="LOC">Location:</p></td>
<td><div id="LC">
<form action="insert.php" method="post">
<select multiple="multiple" size="5" style="width: 150px;" >
<option>Armley</option>
<option>Chapel Allerton</option>
<option>Harehills</option>
<option>Headingley</option>
<option>Hyde Park</option>
<option>Moortown</option>
<option>Roundhay</option>
</select>
</form>
</div>
</td>

<td><p class="PT">Property type:</p></td>
<td><div id="PS">
<form action="insert.php" method="post">
<select name="property type" style="width: 170px;">
<option value="none" selected="selected">Any</option>
<option value="Houses">Houses</option>
<option value="Flats / Apartments">Flats / Apartments</option>
</select>
</form>
</div>
</td><td>
<div id="ptype">
<form action="insert.php" method="post">
<input type="radio" class="styled" name="ptype" value="forsale"/> For Sale

<p class="increase">
<input type="radio" class="styled" name="ptype" value="forrent"/> To Rent
</p>
<p class="increase">
<input type="radio" class="styled" name="ptype" value="any"/> Any
</p>
</form>
</div>
</td>
</tr>

</table>

<div id="table2">
<table id="NBtable">
<tr>
<td><p class="NBS">Number of bedrooms:</p></td>
<td><div id="NB">
<form action="insert.php" method="post">
<select name="number of bedrooms">
<option value="none" selected="selected">No Min</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select> to

<select name="number of bedrooms">
<option value="none" selected="selected">No Max</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</form>
</div>
</td>

<td><p class="PR">Price range:</p></td>
<td><div id="PR">
<form action="insert.php" method="post">
<select name="price range">
<option value="none" selected="selected">No Min</option>
<option value="50,000">50,000</option>
<option value="60,000">60,000</option>
<option value="70,000">70,000</option>
<option value="80,000">80,000</option>
<option value="90,000">90,000</option>
<option value="100,000">100,000</option>
<option value="110,000">110,000</option>
<option value="120,000">120,000</option>
<option value="130,000">130,000</option>
<option value="140,000">140,000</option>
<option value="150,000">150,000</option>
<option value="160,000">160,000</option>
<option value="170,000">170,000</option>
<option value="180,000">180,000</option>
<option value="190,000">190,000</option>
<option value="200,000">200,000</option>
<option value="210,000">210,000</option>
<option value="220,000">220,000</option>
<option value="230,000">230,000</option>
<option value="240,000">240,000</option>
<option value="250,000">250,000</option>
<option value="260,000">260,000</option>
<option value="270,000">270,000</option>
<option value="280,000">280,000</option>
<option value="290,000">290,000</option>
<option value="300,000">300,000</option>
<option value="310,000">310,000</option>
<option value="320,000">320,000</option>
<option value="330,000">330,000</option>
<option value="340,000">340,000</option>
<option value="350,000">350,000</option>
</select> to

<select name="price range">
<option value="none" selected="selected">No Max</option>
<option value="50,000">50,000</option>
<option value="60,000">60,000</option>
<option value="70,000">70,000</option>
<option value="80,000">80,000</option>
<option value="90,000">90,000</option>
<option value="100,000">100,000</option>
<option value="110,000">110,000</option>
<option value="120,000">120,000</option>
<option value="130,000">130,000</option>
<option value="140,000">140,000</option>
<option value="150,000">150,000</option>
<option value="160,000">160,000</option>
<option value="170,000">170,000</option>
<option value="180,000">180,000</option>
<option value="190,000">190,000</option>
<option value="200,000">200,000</option>
<option value="210,000">210,000</option>
<option value="220,000">220,000</option>
<option value="230,000">230,000</option>
<option value="240,000">240,000</option>
<option value="250,000">250,000</option>
<option value="260,000">260,000</option>
<option value="270,000">270,000</option>
<option value="280,000">280,000</option>
<option value="290,000">290,000</option>
<option value="300,000">300,000</option>
<option value="310,000">310,000</option>
<option value="320,000">320,000</option>
<option value="330,000">330,000</option>
<option value="340,000">340,000</option>
<option value="350,000">350,000</option>

</select>
</form>
</div>
</td>


</tr>

</table>

PHP Code
Code: [Select]

<?php
$server = "";      // Enter your MYSQL server name/address between quotes
$username = "";    // Your MYSQL username between quotes
$password = "";    // Your MYSQL password between quotes
$database = "";    // Your MYSQL database between quotes

$con = mysql_connect($server, $username, $password);       // Connect to the database
if(!$con) { die('Could not connect: ' . mysql_error()); }  // If connection failed, stop and display error

mysql_select_db($database, $con);  // Select database to use

$result = mysql_query("SELECT * FROM tablename");  // Query database

while($row = mysql_fetch_array($result)) {     // Loop through results
  echo "<b>" . $row['id'] . "</b><br>\n";      // Where 'id' is the column/field title in the database
  echo $row['location'] . "<br>\n";            // Where 'location' is the column/field title in the database
  echo $row['property_type'] . "<br>\n";       // as above
  echo $row['number_of_bedrooms'] . "<br>\n";  // ..
  echo $row['purchase_type'] . "<br>\n";       // ..
  echo $row['price_range'] . "<br>\n";         // ..
}

mysql_close($con);  // Close the connection to the database after results, not before.
?>

To connect to my database I an entering mysql database details just at the first top lines server,username,password and database. is thats correct?

Thank You for your help in adavance.

Im trying to connect to a database from php. Heres the code:
<?php
  $dbc = mysqli_connect('192.168.0.122', 'boyyo', 'KiaNNa11', 'aliendatabase')
    or die('Error connecting to MySQL server.');
   
   
  $query = "INSERT INTO aliens_abduction (first_name, last_name, " .
    "when_it_happened, how_long, how_many, alien_description, " .
   "what_they_did, fang_spotted, other, email) " .
   "VALUES ('Sally', 'Jones', '3 days ago', '1 day', 'four', " .
   "green with six tentacles', 'We just talked and played with a dog', " .
   "'yes', 'I may have seen your dog. Contact me.', " .
   "'sally@gregs-list.net')";
   
   $result = mysqli_query($dbc, $query)
   or die('Error querying database.');
   ?>

I think i have a theory that my MySQL server location is wrong but i dont know. I use HostGator to do this and im using Phpmyadmin. But everytime i type in a form that i created it says Error querying database. Can someone tell me whats wrong with this code. Oh by the way im using head first into PHP and MySQL

Hi,

I cant connect to my Mysql database.
I get this problem:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'esolarch_databas'@'localhost' (using password: YES) in /home7/esolarch/public_html/new/storescripts/connect_to_mysql.php on line 21
could not connect to mysql

Code: [Select]
<?php  
/*  
1: "die()" will exit the script and show an error statement if something goes wrong with the "connect" or "select" functions. 
2: A "mysql_connect()" error usually means your username/password are wrong  
3: A "mysql_select_db()" error usually means the database does not exist. 
*/ 
// Place db host name. Sometimes "localhost" but  
// sometimes looks like this: >>      ???mysql??.someserver.net 
$db_host = "localhost"; 
// Place the username for the MySQL database here 
$db_username = "esolarch_database";  
// Place the password for the MySQL database here 
$db_pass = "Password";  
// Place the name for the MySQL database here 
$db_name = "esolarch_admin2"; 

// Run the actual connection here  
mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql");
mysql_select_db("$db_name") or die ("no database");              
?>

Okay, I have been following this tutorial: http://www.freewebmasterhelp.com/tutorials/phpmysql/1 to achieve exactly what I wanted to get done. I also followed the way to have it formatted in tables and added extra columns that I needed, included an "Options" column which houses three links, including "edit" and "delete"

Now, I have everything working fine but I am stumped on how to get the "edit" and "delete" links to work for each individual entry that is listed. I have to have these features so the entries can be edited and deleted without having to physically go into the MySQL database to do it. The tutorial explains how to do it in Step 6, but I am confused. I'm not quite sure where to place the code for the links, which are generated automatically every time a new entry is inputted into the database.

Anybody available to help me out? Thanks!

Hello playERZ'

So, I have a dinky contact form that validates and uses:
Code: [Select]
<form name="infoget" action="<?=$_SERVER['PHP_SELF']?>" method="post">
to validate the form via an external validate.php, then generate the email.

Finally:

// Send the mail using PHPs mail() function
mail($to, $subject, $body);
header("Location:customize_search.php");


So, this takes the user to a more advanced form after they 'send' the first form.

1 - Is it possible to have the second form autofill with the POSTed data and NOT use MySQL or database whatever?
2 - If so, how??

There is a "PHP ajax cascading dropdown using MySql" at codestips.com/php-ajax-cascading-dropdown-using-mysql/

I want to use this technique but with a XML or array file instead of mysql database, but my knowledge about mysql is very low. How I can modify this code to catch the categories and products from an array, instead of mysql database?
Code: [Select]
$connect=mysql_connect($server, $db_user, $db_pass)
      or die ("Mysql connecting error");
echo '<table align="center"><tr><td><center><form method="post" action="">Category:<select name="category" onChange="CategoryGrab('."'".'ajaxcalling.php?idCat='."'".'+this.value);">';
$result = mysql_db_query($database, "SELECT * FROM Categories");
$nr=0;
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
 $nr++;
 echo "<option value=".'"'.$row['ID'].'" >'.$row['Name']."</option>";
}
echo '</select>'."\n";
echo '<div id="details">Details:<select name="details" width="100" >';
$result = mysql_db_query($database, "SELECT * FROM CategoriesDetails WHERE CategoryID=1");
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "<option value=".$row['ID'].">".$row['Name']."</option>";
}
echo '</select></div>';
echo '</form></td></tr></table>';
mysql_close($connect);
ajaxcalling.php is
Code: [Select]
include("config.php");
$ID=$_REQUEST['idCat'];
$connect=mysql_connect($server, $db_user, $db_pass);
echo 'Details:<select name="details" width="100">';
$result = mysql_db_query($database, "SELECT * FROM CategoriesDetails WHERE CategoryID=".$ID);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "<option value=".$row['ID'].">".$row['Name']."</option>";
}
echo '</select>';
mysql_close($connect);