Leanneschlueter Posted December 1, 2017 Share Posted December 1, 2017 Hi, Installed Apache, PHP and MySQL in Windows 10, all working fine and running.But, when testing PHP to connect to MySQL (using mysqli and PDO), both aren't working.Checked phpinfo, there have mysqlnd installed. Please help, thanks! Link to comment Share on other sites More sharing options...
benanamen Posted December 1, 2017 Share Posted December 1, 2017 How about posting the code you are having a problem with. "aren't working" doesn't tell us anything. What is the error message? You do have error reporting turned on right? Link to comment Share on other sites More sharing options...
baldwindavidrye Posted August 17, 2018 Share Posted August 17, 2018 For PDO you have to use follow to open the connection <?php $servername = "localhost"; $username = "username"; $password = "password"; try { $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully"; } catch(PDOException $e) { echo "Connection failed: " . $e->getMessage(); } ?> Link to comment Share on other sites More sharing options...
Barand Posted August 17, 2018 Share Posted August 17, 2018 You also need to define the charset for the connection set it so it uses proper prepared statements instead of emulating them It's also a good idea to set your favoured fetch method too. $dsn = "mysql:dbname=$database; host=$host; charset=utf8"; $db = new pdo($dsn, $username,$password, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC ]); Link to comment Share on other sites More sharing options...
cyberRobot Posted August 17, 2018 Share Posted August 17, 2018 Note that the original post was made several months ago. The OP stopped logging in a few days after the original post. Link to comment Share on other sites More sharing options...
Barand Posted August 17, 2018 Share Posted August 17, 2018 I know. Baldwindavidrye seems to have made it his mission to go through old posts and add his "pearls of wisdom". Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.