**************************************
Yes of course. The connection code I've always used is this:
<? php
// This page is named conexao.php
// ------------------------------------------------ -
// PDO connection model
// PDO is an interface for communicating with
//database. It can be MySQL database,
// PostgreSQL, SQLite and others
// Definition of Beraldo
// ------------------------------------------------ -
define ('MYSQL_HOST', 'localhost');
define ('MYSQL_USER', 'root');
define ('MYSQL_PASSWORD', '');
define ('MYSQL_DB_NAME', 'info16br');
// Connect to the database
try
{
$ PDO = new PDO ('mysql: host ='. MYSQL_HOST. '; Dbname ='.
MYSQL_DB_NAME, MYSQL_USER, MYSQL_PASSWORD);
$ PDO-> exec ("set names utf8"
}
catch (PDOException $ e)
{
'Error connecting to MySQL:'. $ e-> getMessage ();
}
I have a news, please note:
a) I opened phpMyAdmin with the new version Wampserver64;
b) The first page "Welcome to phpMyAdmin" comes as default "root" in the "Server choice:" kept "MariaDB;
c) Opened the second page (now with Server: MariaDB: 3306). I went to the "Database" tab, in the "Create database" field, I typed the name of a database for example "info16br";
d) The "info16br" database was created on the "MariaDB" server;
e) Then I went to the "Import" tab and pointed to my backup folder for the "info16br" file. Ready! Now I have the database with the tables all right;
f) Then I went to dreamweaver, and had my page opened. Ready! Opened the page with the connection to phpMySQL, the records ... everything as before;
I have nothing against MariaDB, but I read very little about MariaDB and everything in English. What a whimper isn't it?
I ask, please, working with MariaDB server is the same as in "SQL server". Just create the normal "SQL query (s)" as you did with an SQL server? Basically what changes in terms of creating the query, View in relation to the SQL server?
Thank you!!!
Edited 1 time(s). Last edit at 03/24/2020 01:50PM by RiggsFolly.