Newbie - Insert Record from one form
Posted: Sun Jan 17, 2010 12:25 pm
Hi
I have one form, named, exemplo.html with one form and action=teste.php
In my file teste.php i need to insert one record in my table with one sql statment. I have one error, please help me. Here is my code:
<?php
//----liga a abase de dados
/* conexão à base de dados vendas*/
$mysql_id = mysql_connect('localhost', 'curso', '123');
mysql_select_db('vendas',$mysql_id);
if(!mysql_select_db('vendas',$mysql_id)){
die ('Erro'.mysql_error());
}
//--
$query='insert into negocios set cliente=$_GET["nome"]';
$result=mysql_query($query);
if(!$result){
echo(mysql_error());
}
else{
echo("Adicionado o Registo");
}
?>
I have one form, named, exemplo.html with one form and action=teste.php
In my file teste.php i need to insert one record in my table with one sql statment. I have one error, please help me. Here is my code:
<?php
//----liga a abase de dados
/* conexão à base de dados vendas*/
$mysql_id = mysql_connect('localhost', 'curso', '123');
mysql_select_db('vendas',$mysql_id);
if(!mysql_select_db('vendas',$mysql_id)){
die ('Erro'.mysql_error());
}
//--
$query='insert into negocios set cliente=$_GET["nome"]';
$result=mysql_query($query);
if(!$result){
echo(mysql_error());
}
else{
echo("Adicionado o Registo");
}
?>