Salve, nella index.php della Guida Pratica PHP di questo sito, vi chiedo gentilmente come devo modificare i parametri di Connessione dal Database se utilizzo XAMPP.

Codice PHP:
<?php

$limit = 5; // articoli per pagina

$mysql = new mysqli(‘localhost’, ‘root’, ”, ‘html_it_articles’);
if(!$mysql)
{
    die(“Errore di connessione al database, impossibile procedere”);
}

$result = $mysql->query(“SELECT COUNT(*) AS tot FROM articles”)->fetch_assoc();

$page = isset($_GET['p']) ? $_GET['p'] : 1;
$totals = $result['tot'];
$totals_pages = ceil($totals / $limit);

$articles = $mysql->query(“
    SELECT
        AR.id AS id,
        AR.title AS title,
        CONCAT(SUBSTR(AR.article, 1, 200),  ‘ …’) AS content,
        CONCAT(AU.surname, ‘ ‘, AU.name) AS author
    FROM
        articles AR,
        authors AU
    WHERE
        AR.author_id = AU.id
    ORDER BY id DESC
    LIMIT “.(($page – 1) * $limit).”,”.$limit);
?>
<html>
    <head>
        <title>Articoli</title>
    </head>
    <body>
        <ul>[*]<a href=”index.php”>Lista articoli</a>[*]<a href=”insert.php”>Inserisci un articolo</a>[/list]
        

Articoli totali: <?php echo $totals; ?></p>
        <table width=”500px”>
            <?php
            while($article = $articles->fetch_assoc())
            {
                printf(‘<tr>
                        <td>%d. <a href=”show.php?id=%d”>%s</a> (%s) </td>
                    </tr>
                    <tr>
                        <td>

%s</p></td>
                    </tr>
                    <tr>
                        <td><hr /></td>
                    </tr>’,
                    $article['id'],
                    $article['id'],
                    $article['title'],
                    $article['author'],
                    $article['content']
                    );
            }
            ?>
        </table>
        

Pagina <?php echo $page; ?> di <?php echo $totals_pages; ?> 

        <?php
        if($page – 1 > 0)
        {
            echo ‘[url="”?p=’.($page"]< prev[/url] | ‘;
        }else
        {
            echo ‘< prev | ‘;
        }
        if($page + 1 <= $totals_pages)
        {
                    echo ‘[url="”?p=’.($page"]next >[/url]’;
        }else
        {
                    echo ‘next >’;
        }
        ?>
        </p>
    </body>
</html>
Io ho modificato questa stringa con :
$mysql = new mysqli(‘localhost’, ‘root’, ‘mia_password’ , ‘html_it_articles’);
Ma ricevo errore.


Grazie :ciauz