Fetching Objects from the Database

For anyone stil having issues setting up the database even after attempting all the suggested comments. Try the following as it finally worked for me and hope it helps you too:
I had remove all installed previous versions as well.
Used brew's remove & cleanup commands, unloaded the launchctl script, then deleted the mysql directory in /usr/local/var, deleted my existing /etc/my.cnf (leave that one up to you, should it apply) and launchctl plist

Updated the string for the plist. Note also your alternate security script directory will be based on which version of MySQL you are installing.

Step-by-step:

1. brew remove mysql
2. brew cleanup
3. launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
4. rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
5. sudo rm -rf /usr/local/var/mysql

I then started from scratch:

installed mysql with brew install mysql

ran the commands brew suggested: (see note: below)

unset TMPDIR

mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp

Start mysql with mysql.server start command, to be able to log on it

Used the alternate security script:

/usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installation

Followed the launchctl section from the brew package script output such as,

#start
launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

#stop
launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

from stackoverflow, can't add the link, sorry, but the title is 'brew install mysql on macOS'

I had to run mysql.server stop several times as it lept telling me that: A mysqld process already exists, but the page wouldn't work.

I use Postgres database, specifically Postgresql 15, and here is the things I had to do to get the init_db.php file to work.

1. Change DSN (Data Source Name)
2. Have to include DB name in the DSN
3. Remove "CREATE DATABASE..." statement
4. Update the "CREATE TABLE..." statement with the following:
   • Remove 'AUTO_INCREMENT' since Postgres doesn't have that Parameter.
   • Change id data type from integer to serial since that has Auto Increment built in.
   • Remove Collate since that is pretty much set on the Database and the not the column on the table.
   • Change formatting of single and double quotes and removed all the back ticks on the column names.
5. Update the formatting of the Insert statements to use double quotes in place of single quotes, and vice versa.

<?php

/*
 * SETTINGS!
 */
$databaseName = 'oo_battle';
$databaseUser = 'root';
$databasePassword = 'root';

/*
 * CREATE THE DATABASE
 */
$pdoDatabase = new PDO('pgsql:host=localhost;port=5435;dbname='.$databaseName, $databaseUser, $databasePassword);
$pdoDatabase->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

/*
 * CREATE THE TABLE
 */
$pdo = new PDO('pgsql:host=localhost;port=5435;dbname='.$databaseName, $databaseUser, $databasePassword);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// initialize the table
$pdo->exec('DROP TABLE IF EXISTS ship;');

$pdo->exec('CREATE TABLE ship (
 id serial NOT NULL,
 name character varying(255) NOT NULL,
 weapon_power integer NOT NULL,
 jedi_factor integer NOT NULL,
 strength integer NOT NULL,
 team character varying(10) NOT NULL,
 PRIMARY KEY (id)
) ');

/*
 * INSERT SOME DATA!
 */
$pdo->exec("INSERT INTO ship 
    (name, weapon_power, jedi_factor, strength, team) VALUES 
    ('Jedi Starfighter', 5, 15, 30, 'rebel')");

$pdo->exec("INSERT INTO ship 
    (name, weapon_power, jedi_factor, strength, team) VALUES 
    ('CloakShape Fighter', 2, 2, 70, 'rebel')");

$pdo->exec("INSERT INTO ship 
    (name, weapon_power, jedi_factor, strength, team) VALUES 
    ('Super Star Destroyer', 70, 0, 500, 'empire')");

$pdo->exec("INSERT INTO ship 
    (name, weapon_power, jedi_factor, strength, team) VALUES 
    ('RZ-1 A-wing interceptor', 4, 4, 50, 'empire')");

echo "Ding!\n";

http://localhost:8000/resources/init_db.php

<?php

/*
 * SETTINGS!
 */
$databaseName = 'oo_battle';
$databaseUser = 'root';
$databasePassword = 'root';

/*
 * CREATE THE DATABASE
 */
$pdoDatabase = new PDO('mysql:unix_socket=/Applications/MAMP/tmp/mysql/mysql.sock', $databaseUser, $databasePassword);$pdoDatabase->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdoDatabase->exec('CREATE DATABASE IF NOT EXISTS oo_battle');

/*
 * CREATE THE TABLE
 */
$pdo = new PDO('mysql:host=localhost:3306;dbname='.$databaseName, $databaseUser, $databasePassword);
$pdo = new PDO('mysql:unix_socket=/Applications/MAMP/tmp/mysql/mysql.sock;dbname='.$databaseName, $databaseUser, $databasePassword);
// initialize the table
$pdo->exec('DROP TABLE IF EXISTS ship;');

$pdo->exec('CREATE TABLE `ship` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
 `weapon_power` int(4) NOT NULL,
 `jedi_factor` int(4) NOT NULL,
 `strength` int(4) NOT NULL,
 `team` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci');

/*
 * INSERT SOME DATA!
 */
$pdo->exec('INSERT INTO ship
    (name, weapon_power, jedi_factor, strength, team) VALUES
    ("Jedi Starfighter", 5, 15, 30, "rebel")'
);
$pdo->exec('INSERT INTO ship
    (name, weapon_power, jedi_factor, strength, team) VALUES
    ("CloakShape Fighter", 2, 2, 70, "rebel")'
);
$pdo->exec('INSERT INTO ship
    (name, weapon_power, jedi_factor, strength, team) VALUES
    ("Super Star Destroyer", 70, 0, 500, "empire")'
);
$pdo->exec('INSERT INTO ship
    (name, weapon_power, jedi_factor, strength, team) VALUES
    ("RZ-1 A-wing interceptor", 4, 4, 50, "empire")'
);

echo "Ding!\n";

Hello, after MANY tries, this code worked for me.

I use MAMP on a M1 macbook pro.

This is my MAMP config

Host	localhost / 127.0.0.1 (depending on language and/or connection method used)
Port	3306
Username	root
Password	root
Socket	/Applications/MAMP/tmp/mysql/mysql.sock

You must check the password of course but Socket and Port too because only 'localhost:3306' worked for me, without the port I have a weird error.

Is there some setup required for the db outside of this course? When I move the init_db.php file into my project root and try to access it in the browser I get the following error:

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /Users/thingybob/code/oo/init_db.php:13 Stack trace: #0 /Users/thingybob/code/oo/init_db.php(13): PDO->__construct('mysql:host=loca...', 'root', '') #1 {main} thrown in /Users/thingybob/code/oo/init_db.php on line 13

And I can't just access localhost:306 to get to PMA like in the video

On Ubuntu 22.04:

Xampp, place your project in folder opt/lampp/htdocs

Run xampp: sudo /opt/lampp/xampp start

Then in the browser start your project with http://localhost/your_project_folder

To see you DB in the browser with PHPMyAdmin: http://localhost/phpmyadmin/

In ShipLoader class:

        $pdo = new PDO('mysql:host=localhost:3306;dbname=oo_battle;charset=utf8mb4', 'root', '');
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        $statement = $pdo->query('SELECT * FROM ship');
        $statement->execute();
        $shipsArray = $statement->fetchAll(PDO::FETCH_ASSOC);

Hi there - I've read through the comments below and am not able to resolve this error:

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /Users/ivana.abreu/sites/code-oo/oo/init_db.php:13 Stack trace: #0 /Users/ivana.abreu/sites/code-oo/oo/init_db.php(13): PDO->__construct('mysql:host=loca...', 'root', '') #1 {main} thrown in /Users/ivana.abreu/sites/code-oo/oo/init_db.php on line 13

The init_db.php is in the root folder so I don't know why I am getting this error.

I have mysql installed.
Please assist, thanks.

For some reason I am getting this error if I try using the Jedi Fighter. I am inputting a value for the number of ships for both/ I have filled in the entire form correctly.
~~~~~~~~~~~~~~~~
Don't forget to select some ships to battle!
~~~~~~~~~~~~~~~~

It works without error for all other ships and this problem did not show up until the database connection was added to the program.
All ships are showing up correctly in the ship selection area of the main page.

Lines 13 & 20 are explicitly using the string 'root' instead of referencing $databaseUser in the init_db.php file.