HOW TO USE MYSQL in PhpDesktop?

[Michael Joseph Palencia]

Im having trouble using sqlite and other query language can anyone help me how to configure phpdesktop in using mysql database?
ive been doing a project not for distribution but for personal use only..
much help is more appreciated
thank you

[Czarek Tomczak]

Mysql is not recommended to use with phpdesktop, as it is not portable, user needs to install it manually. There is nothing special with using mysql with phpdesktop, just connect to the database in php scripts as you normally do.

[David]

I have successfully integrated mysql into phpdesktop how ever i am getting a 404 error on page links. 

if i use the code

<?php echo base_url("/product_categories");?>"><img src="<?php echo base_url("uploads/admin/examples/banner.gif");?> 

i get a 404 error any ideas am i missing something?

[chav...@gmail.com]

Can you help me? How can I integrate mysql in phpDesktop?

Thanks in advance!!!

[David]

Send me an email and I'll send you a download link

[aate...@gmail.com]

please can you send me the download link aate...@gmail.com

[eng.usa...@gmail.com]

@David please can you send me the download link eng.usa...@gmail.com

[c.a...@gmail.com]

Please could you send me a link also? to c.a...@gmail.com
Thanks.

[dver...@googlemail.com]

For singleuser applications is MySQL to big and heavy. In this case use SQLite. You can MySQL for use in a multiuser environment. In this case install the MySQL-Server on a central servermashine and connect on it with the established way in php. But remember the accessdata to your database are stored in plaintext in the php-files. Encrypt the data in extra files, if you are using the software with other users.

Have you updated your PHP-Version with a newer from http://windows.php.net/ , then change the extension_dir option in the php.ini to "ext" and uncomment every databaseextension you need. For SQLite extension=php_pdo_sqlite.dll or extension=php_sqlite3.dll. For MySQL extension=php_pdo_mysql.dll or extension=php_mysqli.dll. For PostgreSQL extension=php_pdo_pgsql.dll or extension=php_pgsql.dll.

Sorry for my bad english. But i hope that i could help and we have a central answer as reference.

[raviar...@gmail.com]

how can i establish database connection on it through mysql ??

[Tiago Luis]

please can you send me the download link tiago.c...@hmail.com

[quadri...@gmail.com]

Please send the download link to gani...@gmail.com too. Thanks in anticipation.

[bingo....@gmail.com]

David Please send me a download link - bingo....@gmail.com

[Czarek Tomczak.]

Please do not post tiny urls on this forum. Also do not paste direct links to downloads, instead post a link to a page that describes what is to be downloaded.

[iasociados...@gmail.com]

Sorry, I correct my post...
===============================

mysql drivers is included in php ... then..

connect to mysql in php desktop is very easy ..

1. download mysql server and install
original server here..
https://mysql.com/

or this other... Apache friends include a portable mysql distro
with batch files to start and stop service..
https://www.apachefriends.org/

2. replace php.ini file in /php/ directory for this code:

; ==================================

; Extensions
extension_dir = "./ext"
extension=php_curl.dll
extension=php_gd2.dll
extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_openssl.dll
extension=php_pdo_mysql.dll
extension=php_pdo_pgsql.dll
extension=php_pdo_sqlite.dll
extension=php_pgsql.dll
extension=php_sqlite3.dll
extension=php_com_dotnet.dll
extension=php_mbstring.dll

; Date
date.timezone=Europe/Berlin

; Errors
error_reporting=E_ALL
display_errors=On
display_startup_errors=On
log_errors=Off
report_memleaks=On
report_zend_debug=On

; General
short_open_tag=On
ignore_user_abort=Off
implicit_flush=Off
output_buffering=0
default_charset = "UTF-8"

; Execution time
max_execution_time=30

; Memory
memory_limit=256M

; File uploads
; "post_max_size" must be equal or bigger than "upload_max_filesize"
max_file_uploads=20
upload_max_filesize=2048M
post_max_size=2048M

; ==================================

3. connect to mysql .. using PDO php (very very portable code)
https://phpdelusions.net/pdo

Note: Mysql haves a restrictive license.

Other sql engine is postgresql
and you license is very friendly with comercial projects..

download postgresql portable...
http://gareth.flowers/postgresql-portable/

to connect use a default settings..

host: localhost port: 5432
user : postgres
password:

The best tool to manage SQL databases is...
Dbeaver

https://github.com/serge-rider/dbeaver/

[contact.one...@gmail.com]

It is a little late, but can y send me an email to contact.one...@gmail.com ? thanks in advance!

[devdu...@gmail.com]

devdu...@gmail.com please send me the link

[robbykurn...@gmail.com]

Hello David.. me too, can u send to my email. this robikurn...@gmail.com .. thanks.

[Midhun Puthenpurackal]

please send email with the link, midhun.put...@gmail.com. I need to connect with database in my application.

[akhil...@gmail.com]

Send me download link : akhil...@gmail.com

[tahseen...@gmail.com]

hello david please send me the download link.i really need it. thanks

[svtpa...@gmail.com]

Hi,
I was using php desktop for one of my client.
he had the website developed in code igniter with mysql.

We tried to port the website to use sqlite but most of the queries had issues.

finally I found the solution to embedded the mysql into the distribution.
Had to write new startup exe that first start mysql server and then start the php chrome.

We were able to bundle the app into a single installer using nsis scripts.

I will publish details when i could find time.

my email is: svtpa...@gmail.com

[chanders...@gmail.com]

Please send me download link on chanders...@gmail.com
because i want to learn how to convert in .exe file with mysql database from
php web application.

Thank you so much

[chanders...@gmail.com]

Please share me your knowledge about php web application convert into .exe file.

[aul...@gmail.com]

Can you send me a link about how to integrate mySQL to php desktop

[zape...@gmail.com]

@David

Could you please send me the link for the mysql download?

[patelj...@gmail.com]

https://groups.google.com/forum/#!topic/phpdesktop/E4Rl32sWrqM

Please let me know how can I do this.

Thanks.

[jenil patel]

please send me the link

[Czarek Tomczak]

Just stumbled upon PHPBrowserBox which embeds Apache/PHP/MySQL in a standalone app, anyone been using it? It's not open source, but seems to be free, see: http://phpbrowserbox.com/

[TW]

Been using phpbrowserbox from Africoders for few years. Updated fairly often and pretty solid.

[abhima...@gmail.com]

hi David would you like to send me the link to my email id abhima...@gmail.com

[mehmetk...@gmail.com]

please can you send me the download link

[tego...@gmail.com]

Hello David please can you send the link to my mail teg...@gmail.com. Thanks

[shashi...@gmail.com]

Hello David please can you send the link to my mail shashi...@gmail.com Thanx..

[f.ainfo...@gmail.com]

basta instalar o mysql versão comunidade que roda perfeitamente! eu uso assim!

[rajeev...@gmail.com]

Hello David please can you send the link to my mail ra...........@gmail.com.

Thanks