I am developing a voting application using blockchain (ganache). So basically i am registering the candidates by a web form and storing the data in phpmyadmin database. Now i want to access this data in my smart contract(written using solidity) to give a drop down of the candidates contesting for the elections. I need a way to access my database tables in my smart contract written in solidity
If you need to access data outside the blockchain, you can use an oracle. Here is a tutorial walk-through of how to do it: https://www.toptal.com/ethereum/ethereum-oracle-contracts-tutorial-pt1
The other possibility is to store the candidate information on the blockchain and updating the blockchain from your app.