Create a Video/Audio To Text AI App- PHP, MySQL Whisper AI

Create the main page for the video/audio to text app by integrating template files and editing index.html and index.php, loading the front-end folders.

Develop a JavaScript function with jQuery to auto-submit a form when a user selects a file, then send it to PHP for validation and converting to text.

Validate the image form using post requests, check file presence with $_FILES, capture the file type (video mp4) in PHP for database storage.

Create a PHP class named whisper with an upload method to handle file uploads, store and manage files, using object-oriented principles and public visibility.

Create a PHP file upload method that validates mime type and 20 mb size, extracts file name and extension, and saves to files folder with md5-based unique name via move_uploaded_file.

Create a MySQL database named my whisper and a five-column table to store uploaded files, including id, file name, file URL, location, and translated text with language and media type.

Create a php db class with a connect method using pdo to link to a mysql database named whisper on localhost with root access, then test connection and echo connected.

Create a free OpenAI account to generate an API key, copy the secret key, and define a non-modifiable API token constant for global use in your project.

Define a new property data type to indicate whether to convert video audio to text or translate text into other languages, and implement getApiURL to return the correct API endpoint.

Create a method to send data to the api, handling the file, model (whisper-1), and header from the speech-to-text docs, and prepare translation using chat completion.

Create a PHP method to send a curl post request to an API that converts video or audio to text and supports translation, decoding the JSON response.

Implement a PHP PDO save method to store uploaded video or audio content in a MySQL database, using prepared statements and binding parameters, returning the last insert id.

Create a page to display recently generated files with a video/audio player and AI-written text, fetch and show the latest files from the database in descending order.

Create a PHP method cat file by id to fetch file data by ID, then display the file content and conditionally render audio or video players.

Develop a Whisper class method to update a file's translated content in the database, using file id, content, and language to run an update query.

Build a post-backed translate function that uses a language dropdown to translate a file's content via whisper, validates allowed languages, updates the file with the translation, and displays the result.

Implement a jquery function that shows a loader image while translating content, hides the translator content, and displays API errors when they occur.