Untitled

 <?php


 $dbhost = 'localhost';

 $dbuser = 'root';

 $dbpass = 'rsdfsfdsf';

 $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');


 $dbname = 'goalboas_joomla';

 mysql_select_db($dbname);


$user =& JFactory::getUser();

$id = $user->id;

ereg("^[0-9]{3}-[0-9]{3}-[0-9]{4}$", $_POST['phonesms']) && $_POST['phonesms'] != "")

mysql_query("INSERT INTO `phonenumbersms` (`number`,`user_id`) VALUES (" . mysql_real_escape_string($_POST['phonesms']) .",'$id')");


 ?>


<!DOCTYPE html>

<html>

<body>

<br/><br/><br/>

<center><font size="10">Add phone number <br><br><br>( Short Message Service - SMS )</font></center>


<br/><br/>

<center><label for="phoneSMS">Your current 10 digit phone number is:


<?php


$user =& JFactory::getUser();

$id = $user->id;

list($number) = mysql_fetch_row(mysql_query("SELECT number, user_id FROM phonenumbersms WHERE user_id = $id")); echo $number;

?>


</label></center><br/><br/>


<br/>


<form id="form1" name="form1" method="post" action="">

<center>


<label for="phonesms">Enter your 10 digit phone number. <br/><br/>( Example: "8888888888" )</label><br/><br/>

<input type="text" name="phonesms" id="phonesms" />


<br/><br/>

<input style="color: #000000" name="submit" type="submit" value='Submit' />

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

<input style="color: #000000" name="reset" type="reset" value='Reset' />

</center>

</form>


</body>

</html>