I’m fairly new with these website development and would like to ask how we can connect database data into our website and update database based on website input.
In addition, i saw in forum and understand that it seems we can custom code on PHP. If so how do I access into the source code and where should the PHP code goes etc.
You can access your website content through our File Manager. You can connect to it using a FTP client as well (host is files.000webhost.com)
You can create a MySQL database by going to cPanel > Manage Databases > Create. Please note that you have no root privileges for your database on free plan.
When you upload files, make sure you upload them to /public_html, in order to make them accessible via browser. Everything outside /public_html is private, and not shown to the browser (unless you create a script to do so).
You can use one of our free website builder to ease your work: cPanel > Website building > Zyro or Wordpress, at your choice
Finally, you can get a lot of useful information from php.net, bitdegree.org/learn/, and BitDegree MySQL and PHP. We must not forget about http://stackoverflow.com, the greatest community of programmers on the internet. All of these offer great help which can guide you to create powerful websites and/or web applications.