Discover @Preshy-Jones Open Source projects

Precious Adedibu (@Preshy-Jones)

Preshy-Jones

Stars
11
Global Rank 920,445 (Top 32 %)
Followers 11
Following 22
Registered over 6 years ago
Most used languages

JavaScript
60.0 %

PHP
20.0 %

TypeScript
20.0 %
Location 🇳🇬 Nigeria
Country Total Rank 3,229
Country Ranking

PHP
1,380

TypeScript
1,452

JavaScript
1,868

SQL-that-is-mine-sorry-msql

The api "http://jsonplaceholder.typicode.com/users" when visited, returns an array of 10 users in json form(I advise you visit the adress in your browser to see and study the file structure). Task: 1. Create a remote MySQL database with a table called Users. 2. Write and deploy a script that connects to the database. When the api endpoint "/populate" is accessed, a function that would create columns for id, name, username, and email then populate the columns with the respective data for each user gotten from the users api provided. 3. Create an api end point such that when the "/delete" route is accessed, the last row in the database is deleted. Note 1. Apart from ID, all other Columns are strings. Note 2. The datafrom the users api is to be fetched each time the scripts api endpoint is accessed. Note 3. When you submit, ensure that the database is empty. It is when the api endpoint is accessed that your script would populate the database In the read me file, along with the api endpoint for your script, the following information about your database should be provided. Database Host Database Username Database Password Database Port Hint, Heroku has a free MySQL hosting service called clearDB. You may learn to use that.

Mysql-is-frustrating

The api "http://jsonplaceholder.typicode.com/users" when visited, returns an array of 10 users in json form(I advise you visit the adress in your browser to see and study the file structure). Task: 1. Create a remote MySQL database with a table called Users. 2. Write and deploy a script that connects to the database. When the api endpoint "/populate" is accessed, a function that would create columns for id, name, username, and email then populate the columns with the respective data for each user gotten from the users api provided. 3. Create an api end point such that when the "/delete" route is accessed, the last row in the database is deleted. Note 1. Apart from ID, all other Columns are strings. Note 2. The datafrom the users api is to be fetched each time the scripts api endpoint is accessed. Note 3. When you submit, ensure that the database is empty. It is when the api endpoint is accessed that your script would populate the database In the read me file, along with the api endpoint for your script, the following information about your database should be provided. Database Host Database Username Database Password Database Port Hint, Heroku has a free MySQL hosting service called clearDB. You may learn to use that.

Laravel-Blog-with-image-and-text

Burjtech-React

kawwo