PHP, MySQL - Classifeds Ad Site
Can anyone recommend a good resource (tutorial, blog, YouTube videos, etc.) to create a classfieds ad site using PHP and MySQL? I have this as a final project for a class and am really struggling with it. I am super frustrated so any help would be greatly appreciated!
See also questions close to this topic
- Wordpress Contact form 7 save to Mysql
PHP Insert/Update $_SESSION Variable into User Session from server
So here's the scenario: I have user SIDs stored in database while active and I want to change/set a $_SESSION variable in the user's session. I do know there are other ways (Ajax, etc) to accomplish the same thing, but now I am intensely curious to see if there is a way to make this work.
Here's what I'm trying, User SessionID=1234567890 code, refreshed every 15 seconds:
And I run this on the server:
<?php session_id('1234567890'); session_start(); $_SESSION['Message']="Hello!"; ?>
And the result is the user session hangs on refresh instead of popping up the alert.
From the docs I have read, it seems like this is not specifically excluded, but I can see where it may cause slight security concerns. I have no security concerns in this case.
So, is there any way to make this work?
Php call script that calls another script using curl
I have three
phpscripts on two different servers:
Server - index.php, check.php Server - session.php
And i want them to basically function like this:
index.php calls session.php which calls check.php
index.phpis sending a
check.phpwhich is searching that ip into the database and if it's there check.php prints
validelse it prints
Session doesn't existif
invalid... but when the message gets to
index.phpthe message is combined
invalidSession doesn't exist.
Is there a way to call php scripts between servers without getting this combined message?
SQL - Selecting items from table based on data in other tables?
In the above relational schema, how would I do the following?:
List the names of all students that have a higher GPA than the minimum required GPA for the major they have applied for.
How can I fetch data in a specific row associated with an array?
I'm trying to display all data from a table with one row having a specific value, would, I currently have this:
$sql = 'SELECT list_id, list_category, list_title, list_description, list_price, list_pictures'; $sql = 'SELECT * FROM listings WHERE list_category='$array'';
Then I'm not sure that's the correct way to add a value to the row?