1
Friends I’m new in PHP + sql help me here :
--
-- Estrutura da tabela `verified_user`
--
CREATE TABLE IF NOT EXISTS `verified_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` text NOT NULL,
`password` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
-- --------------------------------------------------------
--
-- Estrutura da tabela `verify`
--
CREATE TABLE IF NOT EXISTS `verify` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` text NOT NULL,
`password` text NOT NULL,
`code` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;
From the Table above I’m making the call below to try to get the code registered code
corresponding, validate , once validated redirect the user to another index2.php page ,,, how can I do this simply in php ? help me if you can
<form method="post" action="verification.php">
<input type="text" name="email">
<input type="password" name="code">
<input type="submit" name="register" Value="Register">
</form>
thanks friend, I returned the error in the following lines , could you guide me ? Warning: mysql_query(): Access denied for user 'nobody'@'localhost' (using password: NO) in /home/West/public_html/query/confirma.php on line 40 Warning: mysql_query(query): A link to the server could not be established in /home/West/public_html/query/confirma.php on line 40 Warning: mysql_num_rows() expects Parameter 1 to be Resource, Boolean Given in /home/West/public_html/query/confirma.php on line 41
– user22753
$result = mysql_query($sql); $total = mysql_num_rows($result);
– user22753
I decided here thanks very much friend
– user22753