Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

retreive data using php

moh786's profile image moh786 posted 4 years ago in Import/Export Permalink

is it possible to pull data form HeidiSQL using php?

ansgar's profile image ansgar posted 4 years ago Permalink

Not from HeidiSQL, but from MySQL.

moh786's profile image moh786 posted 4 years ago Permalink

thanks for confirming. so what would be the best way to pull data from the HeidiSQL? using javascript and html?

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 4 years ago Permalink

I posted

Not from HeidiSQL, but from MySQL"

and now you're again asking for a way to pull data from HeidiSQL???

moh786's profile image moh786 posted 4 years ago Permalink

can you show me an example how this is done? thanks

TTSneko's profile image TTSneko posted 4 years ago Permalink

Interaction between PHP and MySQL databases has nothing to do with HeidiSQL at all. You should start reading up on MySQL structure and access parameters, then read the PHP documentation on database access scripting and additional server-side security measures. Then find out how your host/server handles permissions, does he/it allow certain access methods, etc. etc. etc.

It's not Anse's job - nor that of the users here - to hold your hand or present you a snippet of code you would never truly understand, especially as solutions to most problems require background knowledge that you are obviously missing; at the moment you could not even provide the basic information people would ask for.

Get hold of a free-of-charge server package you can use locally (XAMPP, for example) and set up a running PHP server with MySQL access locally. Such a virtual server surrounding allows you to easily (re)produce and try the examples noted in the documentation of MySQL and PHP, Next to allowing you to try things on backups first (instead of letting you fiddle around with live data).

If you find that way too complicated then PHP/SQL is nothing for you as there is no simple universal solution. In fact what I mentioned above are the basics you need to later operate/check/script whatever you have in mind anyway, meaning that you will never be able to get stuff done if you don't have the tools set up and feel comfortable with their use.

Please login to leave a reply, or register at first.