[faxxgrid]

I need help using SQL commands and insert the values into the database of a webpages. Can someone tell me Software to download/and use and steps to take.

[youlded - has1]

I need help using SQL commands and insert the values into the database of a webpages. Can someone tell me Software to download/and use and steps to take.

Which steps did you take so far? Have you tried google yet? Which part are you stuck at?

[Charger]

Install php
Install MySQL
Google pdo code
Copy pdo
Paste pdo

Bam

[faxxgrid]

Install php
Install MySQL
Google pdo  code
Copy pdo
Paste pdo

Bam

Thank you Charger. Are these softwares free??

[Charger]

Thank you Charger. Are these softwares free??

Yes, all of it is.

[faxxgrid]

Which steps did you take so far? Have you tried google yet? Which part are you stuck at?

Yes I have tried google and found the codes I need to insert in page to get the functionality I am looking for but does have a clue of how to begin.

I have now received advice from Charger on softwares to install for this process. Let me try them now.

---

Yes, all of it is.

Thanks alot

---

Yes, all of it is.

I found the following below on this website - https://windows.php.net/download#php-7.4. Did I download only the source code or both

PHP 7.4 (7.4.5)
Download source code [23.21MB]

Download tests package (phpt) [13.34MB]

[Gerira]

You need to provide more details

1) what do you want to accomplish?
2) what environment are you working on (win/linux)?
3) have you setup (installed and configured) the database?
4) have you installed php?

[faxxgrid]

You need to provide more details

1) what do you want to accomplish? need help using SQL commands and insert the values into the database of a webpages.
2) what environment are you working on (win/linux)?
3) have you setup (installed and configured) the database?
4) have you installed php?

1) what do you want to accomplish? I want to accomplish inserting new values/codes in a database of a webpage
2) what environment are you working on (win/linux)? Windows
3) have you setup (installed and configured) the database? I have downloaded the database of the webpage
4) have you installed php? No, I dont know which version to choose or where to find and download free php. Can you advise and send link

[01010101]

HI mate. I don't understand very well what you really need.

If you need a client to connect to connect to a already running database you can use
- Navicat (Free version)

If you want to run the datebase on your local machine. I recommand you install XAMPP (includes: apache, php, mysql server + phpmyadmin)
After you install XAMPP. You can access phpmyadmin (localhost/phpmyadmin) and import your database.

[faxxgrid]

HI mate. I don't understand very well what you really need.

If you need a client to connect to connect to a already running database you can use
- Navicat (Free version)

If you want to run the datebase on your local machine. I recommand you install XAMPP (includes: apache, php, mysql server + phpmyadmin)
After you install XAMPP. You can access phpmyadmin (localhost/phpmyadmin) and import your database.

Thank you mate. Are you on skype?

---

HI mate. I don't understand very well what you really need.

If you need a client to connect to connect to a already running database you can use
- Navicat (Free version)

If you want to run the datebase on your local machine. I recommand you install XAMPP (includes: apache, php, mysql server + phpmyadmin)
After you install XAMPP. You can access phpmyadmin (localhost/phpmyadmin) and import your database.

This is what I want to accomplish -

1) what do you want to accomplish? I want to accomplish inserting new values/codes in a database of a webpage
2) what environment are you working on (win/linux)? Windows
3) have you setup (installed and configured) the database? I have downloaded the database of the webpage
4) have you installed php? No, I dont know which version to choose or where to find and download free php. Can you advise and send link

[01010101]

ok! XAMPP will work for you.

this will install a mysql server and give you a client to connect to it.

[faxxgrid]

ok!  XAMPP will work for you.

this will install a mysql server and give you a client to connect to it.

Hello Mate

XAMPP installed watched some SQL beginner's tutorials but not confident.

Are you on skype just need a guide to assist me in real time whilst trying to insert new values in the DB. Can you be of help please?

[Charger]

Hello Mate

XAMPP installed watched some SQL beginner's tutorials but not confident.

Are you on skype just need a guide to assist me in real time whilst trying to insert new values in the DB. Can you be of help please?

wym. It's stupid easy

PHP Code


<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDBPDO";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "INSERT INTO MyGuests (firstname, lastname, email)
    VALUES ('John', 'Doe', '[email protected]')";
    // use exec() because no results are returned
    $conn->exec($sql);
    echo "New record created successfully";
    }
catch(PDOException $e)
    {
    echo $sql . "<br>" . $e->getMessage();
    }

$conn = null;
?>

[Disease]

Hello Mate

XAMPP installed watched some SQL beginner's tutorials but not confident.

Are you on skype just need a guide to assist me in real time whilst trying to insert new values in the DB. Can you be of help please?

You should honestly pick up a book or start in on an online tutorial. What you're looking to do is elementary PHP. This sort of stuff is covered very early on in any structured leanring material. If you have at least basic web development experience (HTML & CSS anyways), then Practical PHP 7, MySQL 7, and MariaDB Website Databases will have you doing what you're trying to learn now almost right away.

[Saul]

Simply Google it, or use Youtube where there are tons of awesome videos answering your question in the best way.