convert a PHP/Javascript website to a windows application using phpdesktop, SQlite and Innosetup
HTML-код
- Опубликовано: 6 июл 2024
- Learn hop to make a desktop app using web design tools like php, javascript and HTML.
links to used software:
github.com/cztomczak/phpdesktop
sqlitebrowser.org/
jrsoftware.org/isinfo.php
#PHP #WINDOWS_APP #HTML #JAVASCRIPT
bro i have no words for you. never stop yourself.. U r such a inspiration
Thank you for the awesome comment! i'll continue
thank you very much.i struggle more than 2 month to set the php desktop application now i clear understanding about that and once again thank you very much.
The best class about PHP executable that I saw !!! Thanks for sharing!
thanks
The most underrated RUclipsr on RUclips. Keep up the great work!!
Thank you so much for the encouragement. I'll keep at it!
@@QuickProgramming i am working with php 8.2.13 will it cause a problem ?
Wow... This video is really amazing... I will consider doing this on Linux too. Thank you so much and great teaching style... So simple and direct to the point...
Thanks for the awesome feedback☺️
This a good quality video with knowledge thank you so much
You are welcome :)
wow.. excellent this video. thanks 100%
Great 👍
Brilliant ! Thanks a lot !
Really Great, Thanks, god bless you
Nice tutorial, Thanks vv much my Shifu
Most welcome☺️
Great I love it no words to say awesome!!! ❤❤❤
Thanks 😆 am glad you found it useful
You are the best bro, i just can't love this any better. Thanks so much.
you're most welcome and thanks for the feedback too
You have become my University surely. Do you have any tutorial on CRUD with Sqlite? I would like to learn some Sqlite syntax. Thanks
@@mubeziarthur1229 you're most welcome. try this playlist below. i used sqlite and a portable server. sqlite is very similar to mysql when it comes to CRUD. the only major difference is when making a connection.
ruclips.net/video/KOR_W5j-wXw/видео.html
Great Video Thanks
OMG, Sir You blessed me alot, thanks 🙏🙏
my pleasure :)
Quick Programming you're the best!
Thanks😊
Awesome
BIG BIG Thanks to You ♥♥
Great 👍 this is amazing. Thank you
you're most welcome :)
you are the best ❤️❤️❤️❤️
It is actually awesome video with description. But can you tell me anyway there around to support mp4 and mp3 on phpdesktop? if phpdesktop does not support media codec like this, it wont be so useful.
I want to know if the database you used to in creation of Mychat website also was deployed during creation of that setup
Nice video, i'll watch it tommorow.good night
thanks. a good night to you as well
thank you it's really helpfull
Great
cool
This was very helpful, thank you ...
You're most welcome and thanks for the feedback☺️
@@QuickProgramming also, i have a question, i created some web application using php and xampp. Now, could you help me know the difference between xampp and sqllite, do they perform different actions?
Very Nice
Thank you😊😀
You just made my day.. God bless you
am glad to hear that :) you're most welcome
@@QuickProgramming I have an hotel management system I want to convert to a desktop app... This awesome
that's great coz this is the perfect solution
I have already my website but it's offline that's why I want to convert it as desktop app. But I used PDO not mysqlite, is it okay to convert it?
Amazing tutorial keeping everthing simple and clear. However, I have a few questions. After providing the final app to the client, does the client need to have xampp installed or it is whole of app in itself. Because the more users would be entered in the future. So does this app will keep all the users? plus what can we expect if client has entered let's say 100 users and due to some problem the app got removed from the computer. Upon installing again, will the app still have those 100 users records? Would really appreciated answers to my questions. Thanks!
the users are stored in the database, so if the database is not removed then even if you remove the app, the users will remain in the DB. you dont need to install xampp. you can instal mysql on its own and use command line to create the database(no phpmyadmin). also you dont even need mysql as the database, you can use sqlite, which is just a single file you copy and paste as your database. i show how to do in this same tutorial. but if you use sqlite then the users will be lost if the app is removed since the database will be just a file in the app folder as well
So I have a couple of questions:
1. Assuming the first version has been installed and there is a version 2 with more PHP HTML CSS and sqlite contents, is there a way to Programming it not the replace but add more the columns in the DB and the files in the Program files or it's gonna be a major wipe to start all over again from versions two.
2. Can I create and API and fetch the data with this desktop installer?
Thanks alot.
I've actually never tried installing several versions since I've only used this for a few clients. However I do know that there is an option to choose the version number of your app, and a different folder to install to. So am sure if you chose different options, it would install to a different folder entirely.
But if you do install to the same folder, it will replace the old database. There is no way to get the old data and add it to the new. This is for sqlite only. If you're using mysql, it will always keep the old database and continue, since the installer won't touch the database.
But even with sqlite, you can add a php script that users can run just before installing a new copy. This can save the database to an external file, then they can import the data after the new installation or update
@@QuickProgramming thanks
Best tutorial
thank you :)
are you god or something ? man i really appreciate your content .you are a php legend hats off
Thanks for the compliment😁😊
@@QuickProgramming I have a doubt sir. I just started learning php and it seems interesting so should I learn php for server-side or node.js? Is there any scope of php in the future?
@@AnimeSyncInfinite
2% of websites use node.js while 80% of websites use php. So if you want to make money as a coder then use php
Amazing tutorial sir. But could you 1doubt sir?
After setting inno setup what I need to share to my client? Whole folder or just "my chat setup.exe" With your admin.ico ?
i dont remember coz its been a while but test it on another computer and see what happens before sending to a client. you can even test on your own computer
Thank you so much for this wonderful video. Is there anyway to protect or encrypt the source codes and files?
theres no way to truly stop someone fro reading your code. if a person really wants to read your code, they will read it no matter what you do, no matter what language you used to code. but if you want to make it harder for them to read it, you can make a script to remove all spaces and carriage returns from your code and change function names to unreadable ones like 'gbadbdbad()'. however its not worth it because like i said, when someone is determined, they will still read it no matter what you do
Great job bro!!!
Appreciate it!, thanks!
How to Import your own database and make it local like how you created a new one?
Wow this is very nice video. 1 question .. what if i want to install my app to a server and share it other computer?
Is it support for codeigniter or laravel??
Great video. How to build with laravel? Thank you.
HELLO GREAT TUTORIAL BUT WHEN REFRESHING THE PAGE ALL CSS ARE LOST !! IS THERE ANY IDEAS TO FIX THAT ISSUE ... MAYBE ITS RELATED TO CHROME VERSION ??? MANY THANKS
Thank you so much!!
you're most welcome :)
Hi, I have a problem the PHPDesktop that software is in (.sln) format what can i do
Great video thx it's very useful. I tried copying the htdocs files i have on my xampp installation but I keep getting an error when trying to run the app from the php file (i have a wordpress site on local server), do you know If I need to copy it differently or if there's some files that I need to modify first?
i think i may not have mentioned but the server in phpdesktop is not apache, i think it uses mongoose server. which is common;y used for sites like wordpress. this means any htaccess files will not work in phpdesktop and i think wordpress relies on it for routing. so you may need to search how to translate htaccess files for mongoose server
but i could be wrong since ive never tried to use wordpress on this desktop app. i'll test it when i get some time
@@QuickProgramming ok man thanks for your help I'll try to translate it
does this work for python backend also?
Nice tutorial. Thank you so much. Please will it work if I build the frontend with react js?
yes it will work. React is javascript, so as long as javascript can run, it will work
wow this is great, but is there a way to make it work on two machines but with a same database. example a POS software running on two machines , with xampp you install the xampp on one machine and the other machine connects to it through virtual host, is that possible with this?
Yes it's possible. The same way you connect to another machine when using a normal browser is the same way you connect on this, nothing different. Just add the host name in the connection and it will work
@@QuickProgramming thanks i will try that
First of all, this is amazing and brilliant for college students like me, and thanks for your knowledge and dedication, and I have a question, lets say I create an app for inventory data, does the database will be the same for all and updated if someone add data into it, or it will be different data to each pc, once again, Thankyou very much appreciate it.
If you want data to be the same across multiple computers, then you must out the database online on a live server
GOOD and Thanks for All....
Most welcome
This gonna work in 2024? thanks for the video!
Thanks for your Amazing explantion , although My application not able to login in the same time on Localhost is working fine but in the Phpdisktop not login?
What error are you getting?
@@QuickProgramming It is simply not login there no error shown but the login wonot happens
can we run .exe files with hyperlinks?
Here, it is showing me js and css error dialog box, how do i fix it? pls
Very nice tutorial. i tried following your instructions except I could not get my links to work. I tried browsing to other pages but I cannot. Can you point out what I am doing wring?
Paste one of your link code here
Please make a video about online and offline feature in live chat web application.
ok
Any tools for convert php to mobile application ?
Desktop application works well using this method in machine a which has xampp. Able to fetch data when xampp mysql start and stops..Same software installed and tested in machine b it is not working.machine b doesn't have xampp control panel..How to resolve to make it work in machine b? Do we have to install xampp in machine b too?
Throwing error in mysqli statement
no connection could be made because the target machine actively refused it xampp
Xampp comes with mysql, that's why it works on the PC with xampp. You can either install mysql on the other PC or install xampp. This is why in the tutorial I show how to use sqlite database. That way you don't need to install xampp it mysql. But if you want to use mysql, there is no option but to install it, either directly or through xampp
@@QuickProgramming Thanks for the response. If I manage to convert mysqli queries to sqllite DB syntaxes then I don't need to install mysql or xampp.. Desktop application runs stand alone.. Correct?
please do one for codeigniter project to a windows application
Well served, thanks greatly dude, but how do i run the app remotely on same network
as long as you put the correct host name for the database, you can run the app anywhere, even through the internet
I am using a mysql database but it requires XAMPP to run. Will the codes work if I replace with sqlite?
yes it will work
@@QuickProgramming after converting mysql db to sqlite db. I need to change the code for my database connection right?
Hey. This is nice. I was wondering.... Is it possible to convert a website to and android app that can be downloaded from google playstore? I have a small website that I want to create an app for
The website is responsive by the way so it has a mobile view too
@@kylieamber4998 yes its possible. what this phpdesktop app actually is, is a web browser that is set to only run one website. you can use the same concept on android. create a new app in android studio, add a browser, its called a webview. then link your website to it by setting the home page to your website. thats it. however if you need users to upload or download content, it gets a little complicated but am sure you can find a tutorial online to guide you. hopefully i will make a tutorial on it if time allows
@@QuickProgramming okay I'd really appreciate if you made a tutorial on that. I've been searching everywhere for weeks but can't seem to find anything reasonable.
@@kylieamber4998 ok, i will. i have a few tutorials requested by patrons to make first, then i'll get to that one
@@QuickProgramming okay. Thanks very much. You're the best
Hi, Great tutorial, i have an issue, if you click twice a shortcut, it open two windows, or more depending of clicks, do you know is there any way to open one single windows of the application? thankyou
i think the app comes with a settings.json file where you can set links to open in a new window or not. check if that setting exists and change it
@@QuickProgramming Thanks, there is an option called single_instance_guid inside setting.json, it must have a string ID, and now it works fine, thanks
@@rextreb nice🙂
Only 1 issue here not sure why, after compile using the inno setup. The setup files that run on any desktop windows 10 or 11, the windows defender or even antivirus software will detect the installation file as suspicious and deleted immediately before even able to install on other pc.
try and get their latest version, but windows does this sometimes even on other software. if it becomes a problem, there are other similar softwares but you have to buy. or if you cant, simply ip your project and put instructions on where to add the folders for installation. this way you wont need to use the inno setup
@@QuickProgramming thanks for the response. Did download the latest version, and the one that delete it is AntiVirus not by windows. Guess the best choice is to get a paid version. Thanks. Nice guide by the way
@@davidcheong2187 thanks, am glad to have helped🙂
can it also install to other pc? like there is multiple user?
yes it can but you have to decide whether or not the users all connect to the same database
hey bro is still work on windows 10
When the application will be installed on the client system. The client can see the code in the application setup folder or www folder. Is there any possibility to keep things at an abstract level for the client? The code should be hidden from the client.
there is no way to protect your code in this application. unfortunately if someone is curious enough to check the folder for the code then they can also counteract any measures you try to put to hide the code. another approach is to use compiled languages like java to create desktop apps. i'll start teaching java soon so we can create desktop apps like POS with it when combined with mysql. PHP is meant to live on the server where its beyond reach to its users, not on the users computer, so to an extent, this is just a hack
@@QuickProgramming Thanks for answer🥰
Thanks!!!!!!!
Happy to help. you're most welcome!
@@QuickProgramming I downloaded the phpmydesktop from the link you provided, I didn't find the phpmydesktop.exe file.
Moreover, it looks slightly different from what I watched here
@@QuickProgramming it has
.github
SRC
.gitattributes
Is it possible to use PHP 8 in PHP Desktop? The Downloader comes with PHP 7.1.3.
i explain how to do that in the video
@@QuickProgramming Oh man, i didn't even notice because of all the searching in multiple tabs. Thx dude, i try my luck with this :)
Awesome
@@QuickProgramming Works great, it's a pity that htaccess doesn't work, but a few ideas can be implemented anyway :)
hi sir I have downloaded files from GitHub but the file format is phpdesktop-chrome.sln not in exe extension how i can run sln format ?
you downloaded the source code. scroll down and download the windows release
Sir how to laravel8 project convert in desktop Application
Hi, is there anyway i can change the app name like once you installed it and launch it it comes php destop is it possible to change it the the name i want?
yes you can, just rename the actual file name from php desktop to any name you want. also you there is a settings.json file in the same folder which you can edit to change such settings
I have a wordpress website which i want to create an app for it i am starting with pc how do i make a pc software (downloadable) and it has to like give notification my website is like an event thing so i want to give notification when an event is happening. I hope you can help
Thanks for this tutorial. does it work for Wordpress ?
You're most welcome. Yes it would work for any php website
Hey did you ever try it on Wordpress?
Great video. But one part you did not explain well is how do I make my app to read from msqlite rather than from PHP myadmin mysql
i dont understand. in the video i show how to create an sqlite database, which software to use and where to get it, how to connect to it and read data. all that starts at around16:30 timestamp
sir,am facing problem where those part that consist javascript do not work when convert in php desktop
try and remove all code from the index.php page and add only javascript the code below and see if it works.
alert("hello");
Awesome but i have ErrorFatal error: Uncaught PDOException: SQLSTATE[HY000] [14] unable to open database
when I run the setup, it shows me the home page of my site in a desktop screen, but when I click on the connection button, the application sends me an error: Error 404: Not Found
File not found. please guide me
this is a linking problem, usually caused by missing files. is your site using an htaccess file? the server that comes with this doesnt use htaccess files, its mongoose server. if thats not the case, then make sure the files you're linking to exist on the same folders or subfolders in your application
It has .github
SRC
.git attributes
I have one doubt without xampp directly run phpdesktopchrome is it possible?
you dont need xampp to run this. it comes with its own server and you can use sqlite to make a portable database as described in the tutorial
If if setup on customer pc how i can secure conf.php file to prevent show database password
If you want to secure your code on a client's pc then php is not the right language to use because you can't do that. It's meant to run on a server that only you have access to, not on customers pc. You're better off with java since the code is compiled
How to change the language to Portuguese?
Is the latest version of phpdesktop support PHP 7.4?
As it shows in the tutorial, it doesn't matter because you can put whatever version you need
@@QuickProgramming I asked because am seeing PHP 7.1 on the one you used, sorry are you saying I can use the same phpdesktop for PHP 7.4 application?
Does it support jquery if yes how to I configure it
yes it supports jquery since jquery is simply javascript. simply link the file normally like you would do any js file
Can it read directly from my website url
Yes it can. What exactly are you trying to do? Give an example so I can help better
Thanks a lot but how we can encrypt the source code?
Unfortunately you can't encrypt the code. You can use some tools to do that but it's a waste of time. Even compiled code from other software can be decoded easily, that's how cracks for software are made. So trying to hide your code is a waste of time. If someone really wants it, they'll get it no matter what you do
How can we use offline db and then update the online db when there is internet
its a little bit complex but the short story is that you need to make some sort of API for your local server to communicated with the remote one in a structured manner, otherwise there will be loss of data or a mixup. its easy to get javascript to run a function every 5 minutes or so, then it can make a request to the server. there are response codes to use to check if the call was successful or not, then the data transfer can start. it must also keep track of which rows were already sent in a previous request. after that, verification is required to ensure the data was correctly sent. am making a series on APIs, after that, i'll make a tutorial for such a system since the concepts from there will be similar
Thanks
Please sir when will I b expecting the system
bro there is not .exe file kindly guide now what to do
If the innosetup would have compiled php files too, that would have been epic to hide the source code
you cant hide scripting language code. even compiled code can be taken, thats why we have cracked versions of software. dont waste time trying to hide code. spend that time learning to write better code
@@QuickProgramming I am trying to sell my PHP POS. But I also want to protect my source code so that it does not get distributed.
@@ibrahimbutt738 like i said, you cant stop your code from being distributed. even large companies like adobe cant stop that, thats why we have pirated software. its not possible to stop people from getting your code even if you compile it, so dont waste your time on it
@@QuickProgramming visual basic compiles to .exe which cannot be reversed
@@QuickProgramming hello my friend i am facing some issues when i refresh page by f5 the css style is lost ... any ideas how to fix that ??? thanks in advance
Is it possible to make go online instead of local?
Yeah, just put the correct database connection details like when connecting to a mysql database normally
@@QuickProgramming I don't need to put the URL of the website on the settings.json file?
$connnection = mysqli_connect('localhost','username','password','dbname');
@@QuickProgramming I should put that code on the index.php and I will be able to have my website on the app?
how to update php version in this application??
i explain how to do that in the video. replace the php folder with a newer version
Hahahahaha I love the east African accent
😂😂😂
Thankyou very much for the very nice explanition but my system is not loading any css files
did you manage with this error?
@@QuickProgramming yeah except my script to open the sidebar menu on click seems to be not working at all. apart from that everything is working just fine
@@djngarari it must simply be an issue of an error in your javascript. check the console for errors by right clicking and clicking "inspect", then click on the console tab. if there is any error when you click, it will show there. you can copy and paste it here
@@QuickProgramming already did that but the funny thing is that no errors are showing and in the online browser its working just fine
@@djngarari try and add the simple script below and see if you get an alert:
alert('hello')
php desktop not able to connect with MYSQL workbench
what error do you get?
MySQL ??????
Yes, you can use mysql also. Just add some connection code as normal
the github link doesnt have the phpdesktopchrome.exe
How can I create phpdesktop app with mysql
if you have mysql already installed then just make a normal connection and it will work:
$connection = mysqli_connect("localhost","root","","your_db_name");
thats all you have to do to make a connection
@@QuickProgramming i tried after installing mysql server, and worked. Looking for portable mysql now. Thx