This is a migrated thread and some comments may be shown as answers.

Can the Schedular work with a MySQL database?

1 Answer 116 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Pavel
Top achievements
Rank 1
Pavel asked on 05 Sep 2013, 02:27 AM
The existing datasource seems to want to connect via PDO constructor with a direct path to a database file. As I do not know the direct path to my database file, how would I connect to a database using a MySQL connection string instead with a predefined server, username, password and database where the equivalent mysqli constructor would be: 

new mysqli($server, $username, $password, $myDB);


Paul

1 Answer, 1 is accepted

Sort by
0
Pavel
Top achievements
Rank 1
answered on 09 Sep 2013, 01:29 AM
this is no longer a problem for me. I was able to connect and display data using the following format:

$result = new SchedulerDataSourceResult('mysql:host=localhost;dbname=some_db', 'some_user', 'some_pass');
Tags
Scheduler
Asked by
Pavel
Top achievements
Rank 1
Answers by
Pavel
Top achievements
Rank 1
Share this question
or