Linking SQL database to website and visa versa

24-11-2014 10:22AM #1

Basically I think my terminology when searching is a bit detailed and not finding what I am looking for online.

So hopefully someone can help.

I'm looking to have a form where people can enter their details on a web page and their details are then stored and added to database.

Also, how do you have a database somewhere, and, when required is accessible through a website? So say for example I've a list of houses for sale and someone could search based on location and price to distinguish from a list of thousands available.

Any help appreciated.

The Corinthian · 24-11-2014 03:36PM

Read this section, which uses PHP and MySQL.

minion35 · 24-11-2014 03:38PM

This would all depend on the following:

*Programming language that you are using for backend development.
*Size of the database and the amount of fields you think you'll need.
*Are you using a form of content management system?

24-11-2014 04:08PM

The Corinthian wrote: »

Read this section, which uses PHP and MySQL.

Thanks. I am familiar enough with the two of them, it's just linking I have been having difficulty with and I am not in a situation to test code because of the devise I am using just isn't compatible. However I'm hoping this might be a good example:

<html>
	<head>
	<title>Retrieve data from database </title>
	</head>
	<body>

	<?php
	// Connect to database server
	mysql_connect("mysql.myhost.com", "user", "sesame") or die (mysql_error ());

	// Select database
	mysql_select_db("mydatabase") or die(mysql_error());

	// SQL query
	$strSQL = "SELECT * FROM people";

	// Execute the query (the recordset $rs contains the result)
	$rs = mysql_query($strSQL);
	
	// Loop the recordset $rs
	// Each row will be made into an array ($row) using mysql_fetch_array
	while($row = mysql_fetch_array($rs)) {

	   // Write the value of the column FirstName (which is now in the array $row)
	  echo $row['FirstName'] . "<br />";

	  }

	// Close the database connection
	mysql_close();
	?>
	</body>
	</html>

minion35 wrote: »

This would all depend on the following:

*Programming language that you are using for backend development.
*Size of the database and the amount of fields you think you'll need.
*Are you using a form of content management system?

I will be using html.
5 columns x 500 rows
There will be a CMS alright, Terminal 4 but as yet I have to produce raw html version as a demonstration. Do you have any info as to how it might work with Terminal 4? (Although even these questions have triggered thoughts for me, thanks!)

The Corinthian · 24-11-2014 04:19PM

Jay D wrote: »

I will be using html.
5 columns x 500 rows
There will be a CMS alright, Terminal 4 but as yet I have to produce raw html version as a demonstration. Do you have any info as to how it might work with Terminal 4? (Although even these questions have triggered thoughts for me, thanks!)

You won't be programming anything with html, just re-skinning the CMS output; in reality the CMS will be handling all the DB transactions. I suggest your read the Terminal 4 documentation on the subject.

24-11-2014 04:21PM

The Corinthian wrote: »

You won't be programming anything with html, just re-skinning the CMS output; in reality the CMS will be handling all the DB transactions. I suggest your read the Terminal 4 documentation on the subject.

Sorry I thought web development on this section catered for html and not solely programming elements. As yet I will not have access to T4 but suppose a spiel on it could be useful, thanks.

The Corinthian · 24-11-2014 04:25PM

Jay D wrote: »

Sorry I thought web development on this section catered for html and not solely programming elements. As yet I will not have access to T4 but suppose a spiel on it could be useful, thanks.

It does, but that does not change the fact that you're using a CMS and it will be this and not anything you code yourself that will be accessing the database - after all, the database, being on the server, needs to be accessed on the server, which is a bit difficult to do with html which executes in the client.

And so as you're using a third party CMS to do this, then you ultimately have to read the manual on how it needs to be configured to do so.

25-11-2014 08:49AM

Had completely forgotten about this which I used before, should someone stumble upon this thread looking for something similar.

Linking SQL database to website and visa versa

Comments