Online PHP editor | rfc for rqT4l

@ 2020-09-26T14:17:19Z

<?php

// -- PULLING IN PRODUCTS TO READ OUT TO USER -- //

$stmt = ("
    SELECT
        products.ID,
        products.title,
        products.category,
        products.location,
        products.price,
        products.negotiable,
        products.description,
        products.photo,
        products.user_id
    FROM
        products");


$result = $db->query($stmt);
    
foreach ($result as $row) {
    $product_id = $row['ID'];
    $title = htmlspecialchars($row['title'], ENT_QUOTES); // User input, prevent first order XSS
    $category = $row['category'];
    // local variable for remainder, ensuring to use htmlspecialchars() for any user input that will be read out to browser
}


// -- INSERTING PRODUCTS TO MAIN PRODUCT PAGE USING PREPARED STATEMENT -- //

// Incoming user input from some form
// Assign input to local variables
// Probably should validate data

$null_value = null; // To bind null values... I'm lazy

$stmt = $db->prepare("
    INSERT INTO
        products
    VALUES
        (?, ?, ?, ?, ?, ?, ?, ?, ?)");

$stmt->bind_param('sssssssss', 
    $null_value, 
    $title, 
    $category, 
    $location,
    $price,
    $negotiable,
    $description,
    $photo,
    $user_id);
    
$stmt->execute();
$result = $stmt->get_result();

Output for git.master, git.master_jit, rfc.property-hooks: Warning: Undefined variable $db in /in/rqT4l on line 20 Fatal error: Uncaught Error: Call to a member function query() on null in /in/rqT4l:20 Stack trace: #0 {main} thrown in /in/rqT4l on line 20
Process exited with code 255.

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page

2020-03-21 RFC: Is_Literal - declined
2020-12-04 Enumerations - included in PHP 8.1
2018-06-15 Typed Properties v2 - implemented in PHP 7.4
2016-08-12 Object typehint - included in PHP 7.2
2016-08-14 Arrow functions - withdrawn
2016-05-29 array_change_keys() - withdrawn
2016-04-19 Lexical scope support for anonymous classes - suspended
2016-04-17 Functional Interfaces - declined
2016-03-16 Typed Properties - superseded in favor of Typed Properties 2.0
2015-08-27 Callable Prototypes - declined
2015-05-01 Short Closures - declined / withdrawn in favor of Arrow Functions
2015-02-18 Scalar type hints v5 - included in PHP 7
2015-02-14 Union Types - declined
2013-09-22 Anonymous classes - included in PHP 7

preferences:dark modelive preview