[Multiple Tables Output in phpmyadmin]

Don't use "SELECT * ", specify the columns you need. Then apply aliases to differentiate between those with the same name.

 

Use explicit join syntax. Example

QUANTITY is used on stock_stockin_product and stock_product tables
SELECT 
    sip.quantity as quantity_sip
  , sp.quantity as quantity_sp
  , whatever_else 
FROM stock_stockin si
    INNER JOIN stock_stockin_product sip ON si.id=sip.stockin_id
    INNER JOIN stock_product sp ON sp.id=sip.product_id
WHERE 
    stock_date>='1488366000' 
    AND stock_date<='1488538800' 
    AND stock_product.brand_id='11' 
    AND stock_product.category_id='27' 
    AND stock_product.model LIKE '%iphone 6%' 
    AND stock_stockin.branch LIKE '%henderson%' 
GROUP BY si.id

[the server responded with a status of 406 (Not Acceptable)]

Use CODE tags.

[Login with password_verify() fail all time]

No. One query to get the stored password hash for the given username. Then verify the given password against that.

[Select name from a table!]

Your join syntax is wrong.

SELECT cat_name 
FROM domeniu_activitate d
INNER JOIN user_pers_juridica u
    ON d.cat_id = u.cat_id  
WHERE product_id = '$id'

It is also better to use prepared queries. You should not be putting data ($id) directly into your queries.

[Current Status and Previous States where to start]

CREATE TABLE `status_log` (
  `status_log_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT NULL COMMENT 'id of item owning the status',
  `status` tinyint(4) DEFAULT NULL,
  `changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`status_log_id`)
) ;

When the status changes, add a new record

mysql> select * from status_log;
+---------------+---------+--------+---------------------+
| status_log_id | item_id | status | changed             |
+---------------+---------+--------+---------------------+
|             1 |       1 |      1 | 2017-02-28 15:03:00 |
+---------------+---------+--------+---------------------+

-- add new record

mysql> INSERT INTO status_log (item_id, status) VALUES (1,2);

-- now you have

mysql> select * from status_log;
+---------------+---------+--------+---------------------+
| status_log_id | item_id | status | changed             |
+---------------+---------+--------+---------------------+
|             1 |       1 |      1 | 2017-02-28 15:03:00 |
|             2 |       1 |      2 | 2017-03-05 21:08:43 |
+---------------+---------+--------+---------------------+

[Current Status and Previous States where to start]

A column defined as type TIMESTAMP can be configured to automatically record the current time when

 

a ) the record is inserted, or

b ) the record is updated

 

You want the former so set its default value to CURRENT_TIMESTAMP

[Appointment booking script for calendar]

1 )  Not able to do what?

 

2 )  When you have a few more details to add, start you own topic and do not hijack someone else's.

[newbee to PHP, help with setting up my php to send to a txt file]

Please use code tags, or use the <> button in the toolbar, for your code.

[newbee to PHP, help with setting up my php to send to a txt file]

try

if ( is_numeric($BowlerAverage) && $BowlerAverage > 0 && $BowlerAverage <= 300 )

[newbee to PHP, help with setting up my php to send to a txt file]

No, you are still checking if a boolean expression is numeric.

[Early booking reservation system using DateTime]

Quite true. If I used the original unsortable date formats ...

$data = array(
    array('percentage' => '25', 'beforedate' => '10-12-2016' ),
    array('percentage' => '15', 'beforedate' => '31-03-2017' ),
    array('percentage' => '10', 'beforedate' => '30-04-2017' ),
    array('percentage' => '20', 'beforedate' => '31-01-2017' ),
    );

...the result is 10% as the result of sorting those dates is

10-12-2016
30-04-2017
31-01-2017
31-03-2017

[newbee to PHP, help with setting up my php to send to a txt file]

No matter what value have for the bowler average, your test will always fail.

 

The expression ($bowleraverage >= 0) is Boolean and therefore not numeric. EG

$bowleraverage = -1;
echo (is_numeric($bowleraverage >= 0)) ? 'OK' : 'Error' . '<br>';

$bowleraverage = 0;
echo (is_numeric($bowleraverage >= 0)) ? 'OK' : 'Error' . '<br>';

$bowleraverage = 50;
echo (is_numeric($bowleraverage >= 0)) ? 'OK' : 'Error' . '<br>';

That code outputs

Error
Error
Error

You need to separate the is_numeric() check from the value checks as ginerjm said.

[Early booking reservation system using DateTime]

Alternative solution

mysql> SELECT * FROM bookingdates;
+-----------------+------------+------------+
| bookingdates_id | beforedate | percentage |
+-----------------+------------+------------+
|               1 | 2017-12-10 |         25 |
|               2 | 2017-01-31 |         20 |
|               3 | 2017-03-31 |         15 |
|               4 | 2017-04-30 |         10 |
+-----------------+------------+------------+

SELECT percentage
FROM bookingdates
WHERE beforedate = (
    SELECT MIN(beforedate)
    FROM bookingdates
    WHERE beforedate >= CURDATE()
    );

+------------+
| percentage |
+------------+
|         15 |
+------------+

[Early booking reservation system using DateTime]

You need to sort the array into ascending date order. Then loop through the array until you come to a date that is >= today. This is the percent that you want so you can now break out of the loop.

 

Given the data you posted (but correcting the date format) you would have

$data = array(
    array('percentage' => '25', 'beforedate' => '2016-12-10' ),
    array('percentage' => '15', 'beforedate' => '2017-03-31' ),
    array('percentage' => '10', 'beforedate' => '2017-04-30' ),
    array('percentage' => '20', 'beforedate' => '2017-01-31' )
    );

// SORT BY DATE    
usort ($data, function($a, $b) {
                return strcmp($a['beforedate'], $b['beforedate']);
            });

// VIEW RESULTS            
$today = new DateTime();
$today->setTime(0,0,0);  // don't want the time portion

foreach ($data as $rec) {
    if ($today <= new DateTime($rec['beforedate'])) {
        $discount =  $rec['percentage'];
        break;
    }
}

echo "Applicable discount today is {$discount}%"; //--> 15%

[Get a variable from an Array]

We don't know what your input values are.

We don't know what you are expecting from those values.

We don't know what "not working" means.

 

You might as well try "Alexa! What is the page value?"

[Early booking reservation system using DateTime]

Firstly, you need to change those dates - they are not sortable. You need yyyy-mm-dd

[Sorting a String numerically 1-550]

see http://uk1.php.net/manual/en/function.natsort.php

[Sort order by last date modified]

I tried helping you with advice on writing a custom sort function and how it should return values, but you chose to totally ignore it. Therefore I am not inclined to waste any more of my time.

[Drawing HTML Table With MySQL Data]

Post your current code and I'll try to run it.

[Is there a more efficient method to compress these queries?]

see https://forums.phpfreaks.com/topic/303305-pdo-looping/?p=1543471&do=findComment&comment=1543471

[Any ideas why code is inserting just one character of each value?]

Just an fyi,

 

employeename, ttitle and email are not array.

 

These are displayed just once.

That's why they don't have the [] thing on them.

Then why are they output within a foreach loop?

[PDO Looping]

 

if ($stmt->execute()) {

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

$products[] = $row;

}

}

 

The times when you might want similar to that is when you want to specify the array indexes For example

if ($stmt->execute()) {
  while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $products[ $row['user_id'] ] = $row;
  }
}

or to group results

if ($stmt->execute()) {
  while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $products[ $row['cat_id'] ][] = $row;
  }
}

[Any ideas why code is inserting just one character of each value?]

If, say, $_POST['sourcename'] is a string and not an array then $_POST['sourcename'][$i] with be the $ith character of the string and not the $ith element of an array.

[Is there a more efficient method to compress these queries?]

One query, get all users and store in an indexed array. Not separate numbered variables.

[Public Function to retrieve data from 2 tables pdo]

In what way is that "outside the function"?

$db = DB();                                         // connection OUTSIDE the function

$vehicle_data = UserDetails($db, $user_id);                        // pass the $db connection as a parameter

plus you need to redefine the function to accept the extra parameter

function UserDetails ($db, $user_id) {
   // function code
}