Our today post will focus on how to retrieve information from our database and print it in json file

Opening database retrieve user profile and print in json file

In our previous discussion we showed you how to store information in database and display it on html stream. Now, we will implement how to print users details to json file. The below code, you can copy and paste or write it manually for your testing. Copy the below code save it as jsontest.php and run it. if you see message "Success!" this means our profile details was successfully created and printed to json file.

connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM webdesign"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $profile = array( 'id' => $row["id"], 'image' => $row['image'], 'fullname' => $row["fullname"], 'fulladdress' => $row["fulladdress"], 'emailaddress' => $row["emailaddress"], 'phonenumber' => $row["phonenumber"], 'username' => $row["username"], 'password' => $row["password"], 'project' => $row["project"], 'subscription' => $row["subscription"], 'gender' => $row["gender"], 'reg_date' => $row["reg_date"] ); $json = json_encode($profile); $fp = fopen('data.json', 'w'); fwrite($fp, $json); fclose($fp); echo "Success!"; } } else { echo "0 results"; } $conn->close(); ?>

Json data contains our user profile details from database

Now, in the current folder locate the created file "data.json" right-click and open it in notepad. This is our profile information from our database table. Today you have had experience on how to generate user information and store it in json file.

{ "id": "1", "image": "image\/chiquado.jpg", "fullname": "Kenan Chiquado", "fulladdress": "Udah, Igbo-eze North LGA, Enugu state, Nigeria", "emailaddress": "presschiquado@gmail.com", "phonenumber": "2348130802790", "username": "Chikwado", "password": "web@design&33", "project": "Local and public network developer", "subscription": "0.00", "gender": "Male", "reg_date": "2023-03-27 10:18:48" }

Summary

While following our tutorials, if our code spot error, don't hesitate to get in touch you can also request a certain some piece of code and we will craft it for you. In our shop we focus on creating, testing and debugging. Thanks for reading this article.

Comments

Latest post

We will take a closer look on how to bind webpage in python programming language

Today we will take a closer look on how to run python in your webpage under windows operating system. Let's assume you have installed xampp in your windows operating system and have python program installed as well. If you have not done so, then go on to installed xampp in your computer together with python program. Remember to select software version compactible to your computer. When you are ready with these two software, then copy the code below: #!"C:\Users\Administrator\AppData\Local\Programs\Python\Python311-32\python.exe" print ("Content-Type: text/html\n") print (" ") print (" ") print (" ") print (" ") print (" Hello world! ") print (" Welcome to my first python webpage ") print (" ") print (" ") Save the above code as index.py in C:\xampp\htdocs the path should be: C:\xampp\htdocs\index.py On your browser address bar you can type http://localhost/index.py, ...

Our today post will focus on how to implement php class and method

A class is a container for objects, and object is items in class. Class is container that we can store all kinds of obejects, such as variable, function etc. Today we will implement class and objects , property, set, get and the rest. If you look at the php class below, this is exactly how to declare empty php class. Php class container with public objects, function set parameters and gets parameters. In php class below, we created two functions, one to set a value and one to get the value, pass the instance object and its value. Now you can copy the below code for your testing. name = $name; } function getname() { return $this->name; } } $username = new KcFuns(); $username->setname('Kenan Chiquado'); echo "Output:"; echo "Username is: ".$username->getname(); echo "----------------------------------"; ?> Php class several objects function and parameters In our second php class implementation, we will lo...

Today we will look into how to implement cUrl in php application

Passing json file via cUrl in php We will implement passing json file via cUrl and submit to next server. cUrl is all about special communication between two or more server. Such as server1.com sending data to server2.com. A lot of beginner had always ask endless question about what is cUrl and what cUrl actually does. A simple answer there is: cUrl is a special communication between two or more server. Now, if you look at json code below, it has been neatly written and indented and ready for testing. Launch your notepad copy the json data below and save it as data.json place it in a folder where you saved other php file. { "id": "1", "image": "image\/chiquado.jpg", "fullname": "Kenan Chiquado", "fulladdress": "Udah, Igbo-eze North LGA, Enugu state, Nigeria", "emailaddress": "2348130802790", "phonenumber": "presschiquado@gmail.com...

Our today post will focus on how to implement php hits counter

PHP counter step 1: Have you ever wonder how you can monitor, view or learn how many times your website is been processed by visitors. How many times your website is been browse by your visitors? If your answer is 'no', then it's time to learn all these. You can learn how many times browser processed your website by binding certain php script on top of your webpage. Now, if you look at our php script below, this script will help you count how many times your website was processed at any given moment. To apply our php script below, you can copy and paste this script on top of your webpage before html declaration. PHP counter step 2: Again, the below script, you can copy and put it in a separate file. All you need to do is check time to time and see the digits number your script return. That's exactly how many times your website was processed. Example of the counter: Hits counter While applying our tutorials, if our code spot error, don't hesit...

In today post we will focus on how to create php script that could upload picture to server

Before writing script to upload files to server, you have to check ensure that php file upload is set to 'On' in php.ini. Open C:\xampp\php\php.ini file locate the line that says upload_file = On and also change the php upload max setting, example: php_max_upload = 100m. Now save the file, restart the server and start writing php script to upload your file. Step 1: Below is the html code to implement our practice of file upload. You can write it manually or copy and paste. " enctype="multipart/form-data" method="POST"> Uploader Step 2: Php command to target the upload folder, php comman to get file name, php command to check upload status, and php command to validate file extension. Below is our sample code: Step 3: We will use php global object called $_POST to get the image object. And check if the file is image or not, if it's not image the upload status will be set to zero. Below is our sample code: if(isset(...

Kc Funs

Search This Blog