home

clear breadcrumbs

search

login

php_mysql_oop_example

<code> , <?php , $servername = DQlocalhostDQ; , $username = DQrootDQ; , $password = DQDQ; , $dbname = DQwordpressDQ; , , // Create connection , $conn = new mysqli($servername, $username, $password, $dbname); , // Check connection , if ($conn->connect_error) { , die(DQConnection failed: DQ . $conn->connect_error); , } , , $sql = DQSELECT * FROM wp_usersDQ; , $result = $conn->query($sql); , , if ($result->num_rows > 0) { , // output data of each row , while($row = $result->fetch_assoc()) { , echo DQname: DQ . $rowuser_login. DQ - email: DQ . $rowuser_email. DQ<br>DQ; , } , } else { , echo DQ0 resultsDQ; , } , $conn->close(); , </code>