retreive data using php

is it possible to pull data form HeidiSQL using php?

Not from HeidiSQL, but from MySQL.

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

I posted

Not from HeidiSQL, but from MySQL"

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

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

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.