PHP Tutorial

  • How to Export MySQL Data in CSV/Excel File using PHP/MySQL

    Submitted by: 
    joken
    This tutorial is a continuation of our last topic called “ How to Import CSV/Excel File into MySQL Database using PHP ”. But this time, we will be focusing on how to Export MySQL Data into Excel file. To do this application open our last project called “excel”. At this time, we will modify the index file. To do this, open the “index.php” and add the following code above the table tag. And here’s...

  • How to Import Excel/CSV file to MySQL Database Using PHP

    Submitted by: 
    joken
    In this tutorial im going to show you how to create n application that can be used to import CSV/Excel file using PHP. To start with this project create a Database in your phpmyadmin named “studentdb” then execute this SQL query to create a new table called subject. CREATE TABLE IF NOT EXISTS `subject` ( `SUBJ_ID` INT ( 11 ) NOT NULL AUTO_INCREMENT , `SUBJ_CODE` VARCHAR ( 30 ) NOT NULL , `...

  • Ticket System in PHP - #5 Ticket Processing

    Submitted by: 
    Yorkiebar
    Introduction: This tutorial is the final part in my ticket system via PHP tutorial. This part will be covering processing the ticket. Ticket Information: We are already sending the email to the entered 'forgot password' reset form containing the ticket ID. This ticket ID links to the customer account through the column value of 'User'. It should also be noted that the email address only receives...

  • Ticket System in PHP - #4 Ticket Creation

    Submitted by: 
    Yorkiebar
    Introduction: This tutorial is the fourth part in my series of how to create a PHP based ticket system. This part will be covering inserting the generated ticket/random string in to the 'tickets' table within your database. Event: We only want to insert a new ticket when a certain event occurs, this event will be when the 'Forgotten Password' link or button is clicked/selected. Are you can see...

  • PHP Record Fetching Functions

    Submitted by: 
    thusitcp
    PHP Record Fetching Functions Today world wide web is dominated by php applications. Over 250M sites use php on the web and php 5 used 98% sites who use php. Most of php based application use mysql database server to store application related data. Nowadays software application contained millions of records because of that data retrieval is getting complex. In this tutorial I am going to explain...

  • Ticket System in PHP - #3 Email Validation

    Submitted by: 
    Yorkiebar
    Introduction: This tutorial is the third part on how to create a ticket system in PHP. This ticket system allows for more secured reset password options, and other complex or private data exchange on a community website. Previous HTML: The current HTML we have for this process is the password reset form, found below: < form action = 'reset.php' method = 'POST' > < input type = 'password...

  • Ticket System in PHP - #2 Generating Tickets

    Submitted by: 
    Yorkiebar
    Introduction: This tutorial is a continuation from my previous tutorial in which I covered the database design and HTML password reset form scripting for this password reset ticket system. Part Two - Fake Data: Before we can even think of making a password reset ticket system, we need to create a fake user to which we can reset their password. This series isn't on how to make a register or login...

  • API JSON Parsing in PHP

    Submitted by: 
    Yorkiebar
    Introduction: This tutorial will be on how to use an API which returns a JSON format of information in PHP. API? JSON? An API stands for an Application Program Interface and is used by external applications to connect with prebuilt libraries or sources of information via the API making the connection between the two. JSON is a form of information formatting, and stands for JavaScript Object...

  • How To Use a REST API in PHP

    Submitted by: 
    Yorkiebar
    Introduction: This tutorial is on how to use an API in PHP. What Is An API? An API is an Application Programming Interface and is used as a middle stepping stone for external applications to use the functions of an internal application. An example of this would be the Skype API. The Skype API allows external applications on the users computer to access their Skype account via the Skype4ComLib API...

  • Email Subscription List (2 - Sending Emails) in PHP/HTML

    Submitted by: 
    Yorkiebar
    Introduction: This is a second part to my previous tutorial - 'Creating an Email Subscription List in PHP/MySQLi', found here; https://www.sourcecodester.com/tutorials/php/7813/email-subscription-lis... Mail Function: Before we can begin with our actual email subscription email sending script, we need to know exactly how we are going to be sending our emails. Luckily enough, there is a built in...

Pages