Jump to content

[SOLVED] how to insert data to mysql

leegreaves

By leegreaves
in PHP Coding Help

Recommended Posts

leegreaves Newbie

leegreaves

Posted
Posted

At the moment im creating a "registration" page using php. At the start ive created my initial connection to the mysql database; the html body of it begins underneath this, my conundrum is where should i put the code that actually enters the data into the database at. Should this also be placed at the beginning of my page or should it go after the html section. I do know I was told b4 that any php should go at the beginning of the page before any html code, so from this i must assume that it should go at the start as well. Also, after connecting, what code do i use to insert the "entry" into my database. would be VERY grateful for all pointers.

 

Heres the code from my registration.php:

 

<?php

define('DB_HOST', 'localhost');

define('DB_USER', 'tastscou_admin');

define('DB_PASSWORD', 'pentium');

define('DB_DATABASE', 'tastscou_members');

 

//Array to store validation errors

$errmsg_arr = array();

 

//Validation error flag

$errflag = false;

 

//Connect to mysql server

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

if(!$link) {

die('Failed to connect to server: ' . mysql_error());

}

 

//Select database

$db = mysql_select_db(DB_DATABASE);

if(!$db) {

die("Unable to select database");

}

?>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Page Title</title>

<style type="text/css">

a:active

{

  color: #0000FF;

}

</style>

</head>

<body bgcolor="#FFFFFF" text="#000000">

<div id="wb_Form1" style="position:absolute;left:100px;top:150px;width:773px;height:594px;z-index:20;" align="left">

<form name="register" method="post" action="/register.php" id="wb_form1">

<div id="wb_Text1" style="position:absolute;left:7px;top:7px;width:269px;height:26px;z-index:0;" align="left">

<font style="font-size:10pt;" color="#000080" face="Batang">                      User Name <br>                         (public) </font></div>

<input type="text" id="Editbox1" style="position:absolute;left:180px;top:30px;width:155px;font-family:Courier New;font-size:16px;z-index:1" name="username" value="">

<div id="wb_Text3" style="position:absolute;left:7px;top:69px;width:269px;height:26px;z-index:2;" align="left">

<font style="font-size:10pt;" color="#000080" face="Batang">                  Email address <br>                    (private) </font></div>

<input type="text" id="Editbox2" style="position:absolute;left:180px;top:70px;width:155px;font-family:Courier New;font-size:16px;z-index:3" name="email" value="">

<div id="wb_Text4" style="position:absolute;left:7px;top:130px;width:269px;height:13px;z-index:4;" align="left">

<font style="font-size:10pt;" color="#000080" face="Batang">                        Password</font></div>

<input type="password" id="Editbox3" style="position:absolute;left:180px;top:130px;width:147px;font-family:Courier New;font-size:16px;z-index:5" name="password" value="">

<div id="wb_Text5" style="position:absolute;left:7px;top:176px;width:269px;height:13px;z-index:6;" align="left">

<font style="font-size:10pt;" color="#000080" face="Batang"> You are on the site as a...</font></div>

<div id="wb_Text6" style="position:absolute;left:173px;top:203px;width:249px;height:108px;z-index:7;" align="left">

<font style="font-size:16px;background-color:#FFFFFF" color="#000000" face="Arial">Male<br>

Female<br>

Couple (MF)<br>

Couple (MM)<br>

Couple (FF)<br>

TV/TS/CD</font></div>

<input type="radio" id="RadioButton1" name="RadioButton1" value="m" style="position:absolute;left:282px;top:197px;font-family:Arial;font-size:13px;z-index:8">

<input type="radio" id="RadioButton2" name="RadioButton2" value="f" style="position:absolute;left:282px;top:217px;font-family:Arial;font-size:13px;z-index:9">

<input type="radio" id="RadioButton3" name="RadioButton3" value="c" style="position:absolute;left:282px;top:237px;font-family:Arial;font-size:13px;z-index:10">

<input type="radio" id="RadioButton4" name="RadioButton4" value="mm" style="position:absolute;left:282px;top:257px;font-family:Arial;font-size:13px;z-index:11">

<input type="radio" id="RadioButton5" name="RadioButton5" value="ff" style="position:absolute;left:282px;top:277px;font-family:Arial;font-size:13px;z-index:12">

<input type="radio" id="RadioButton6" name="RadioButton6" value="t" style="position:absolute;left:282px;top:297px;font-family:Arial;font-size:13px;z-index:13">

<div id="wb_Text7" style="position:absolute;left:7px;top:340px;width:269px;height:13px;z-index:14;" align="left">

<font style="font-size:10pt;" color="#000080" face="Batang">                    Date of birth</font></div>

<select name="day" id="Combobox1" style="position:absolute;left:289px;top:342px;width:62px;font-family:Courier New;font-size:16px;z-index:15">

<option selected>Day...</option>

<option value="1">1</option>

<option value="2">2</option>

<option value="3">3</option>

<option value="4">4</option>

<option value="5">5</option>

<option value="6">6</option>

<option value="7">7</option>

<option value="8">8</option>

<option value="9">9</option>

<option value="10">10</option>

<option value="11">11</option>

<option value="12">12</option>

<option value="13">13</option>

<option value="14">14</option>

<option value="15">15</option>

<option value="16">16</option>

<option value="17">17</option>

<option value="18">18</option>

<option value="19">19</option>

<option value="20">20</option>

<option value="21">21</option>

<option value="22">22</option>

<option value="23">23</option>

<option value="24">24</option>

<option value="25">25</option>

<option value="26">26</option>

<option value="27">27</option>

<option value="28">28</option>

<option value="29">29</option>

<option value="30">30</option>

<option value="31">31</option>

</select>

<select name="month" id="Combobox2" style="position:absolute;left:348px;top:342px;width:90px;font-family:Courier New;font-size:16px;z-index:16">

<option selected>Month...</option>

<option value="1">January</option>

<option value="2">February</option>

<option value="3">March</option>

<option value="4">April</option>

<option value="5">May</option>

<option value="6">June</option>

<option value="7">July</option>

<option value="8">August</option>

<option value="9">September</option>

<option value="10">October</option>

<option value="11">November</option>

<option value="12">December</option>

</select>

<select name="year" id="Combobox3" style="position:absolute;left:437px;top:342px;width:66px;font-family:Courier New;font-size:16px;z-index:17">

<option selected>Year...</option>

<option value="1993">1993</option>

<option value="1992">1992</option>

<option value="1991">1991</option>

<option value="1990">1990</option>

<option value="1989">1989</option>

<option value="1988">1988</option>

<option value="1987">1987</option>

<option value="1986">1986</option>

<option value="1985">1985</option>

<option value="1984">1984</option>

<option value="1983">1983</option>

<option value="1982">1982</option>

<option value="1981">1981</option>

<option value="1980">1980</option>

<option value="1979">1979</option>

<option value="1978">1978</option>

<option value="1977">1977</option>

<option value="1976">1976</option>

<option value="1975">1975</option>

<option value="1974">1974</option>

<option value="1973">1973</option>

<option value="1972">1972</option>

<option value="1971">1971</option>

<option value="1970">1970</option>

<option value="1969">1969</option>

<option value="1968">1968</option>

<option value="1967">1967</option>

<option value="1966">1966</option>

<option value="1965">1965</option>

<option value="1964">1964</option>

<option value="1963">1963</option>

<option value="1962">1962</option>

<option value="1961">1961</option>

<option value="1960">1960</option>

<option value="1959">1959</option>

<option value="1958">1958</option>

<option value="1957">1957</option>

<option value="1956">1956</option>

<option value="1955">1955</option>

<option value="1954">1954</option>

<option value="1953">1953</option>

<option value="1952">1952</option>

<option value="1951">1951</option>

<option value="1950">1950</option>

<option value="1949">1949</option>

<option value="1948">1948</option>

<option value="1947">1947</option>

<option value="1946">1946</option>

<option value="1945">1945</option>

<option value="1944">1944</option>

<option value="1943">1943</option>

<option value="1942">1942</option>

<option value="1941">1941</option>

<option value="1940">1940</option>

<option value="1939">1939</option>

<option value="1938">1938</option>

<option value="1937">1937</option>

<option value="1936">1936</option>

<option value="1935">1935</option>

<option value="1934">1934</option>

<option value="1933">1933</option>

<option value="1932">1932</option>

<option value="1931">1931</option>

<option value="1930">1930</option>

<option value="1929">1929</option>

<option value="1928">1928</option>

<option value="1927">1927</option>

<option value="1926">1926</option>

<option value="1925">1925</option>

<option value="1924">1924</option>

<option value="1923">1923</option>

<option value="1922">1922</option>

<option value="1921">1921</option>

<option value="1920">1920</option>

<option value="1919">1919</option>

<option value="1918">1918</option>

<option value="1917">1917</option>

<option value="1916">1916</option>

<option value="1915">1915</option>

<option value="1914">1914</option>

</select>

<input type="submit" id="Button1" name="Button1" value="I'm over 18 - create my account" style="position:absolute;left:17px;top:435px;width:271px;height:24px;font-family:Arial;font-size:13px;z-index:18">

<div id="wb_Text2" style="position:absolute;left:180px;top:10px;width:249px;height:28px;z-index:19;" align="left">

<font style="font-size:13px;background-color:#FFFFFF" color="#000000" face="Batang">DO NOT use your real name! </font><font style="font-size:8px" color="#000000" face="Batang"><br>

</font></div>

</form>

</div>

<div id="wb_Text134" style="position:absolute;left:0px;top:10px;width:1009px;height:40px;z-index:21;" align="center">

<font style="font-size:16px" color="#000000" face="Arial"><br>

</font><font style="font-size:19px;background-color:#FFFFFF" color="#000000" face="Arial">Join Tasty Swingers today</font></div>

<div id="wb_Text135" style="position:absolute;left:0px;top:67px;width:1009px;height:0px;z-index:22;" align="center">

<font style="font-size:19px;" color="#000000" face="Arial">Just submit the form below</font></div>

</body>

</html>

Link to comment
https://forums.phpfreaks.com/topic/177344-solved-how-to-insert-data-to-mysql/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.