PHP MySQL database problem
- by Jordan Pagaduan
Code 1:
<?php
class dbConnect {
var $dbHost = 'localhost',
$dbUser = 'root',
$dbPass = '',
$dbName = 'input_oop',
$dbTable = 'users';
function __construct() {
$dbc = mysql_connect($this->dbHost,$this->dbUser,$this->dbPass) or die ("Cannot connect to MySQL : " . mysql_error());
mysql_select_db($this->dbName) or die ("Database not Found : " . mysql_error());
}
}
class User extends dbConnect {
var $name;
function userInput($q) {
$sql = "INSERT INTO $this->dbTable set name = '".$q."'";
mysql_query($sql) or die (mysql_error());
}
}
?>
Code 2:
<?php
$q = $_GET['q'];
$dbc=mysql_connect("localhost","root","") or die (mysql_error());
mysql_select_db('input_oop') or die (mysql_error());
$sql = "INSERT INTO users set name = '".$q."'";
mysql_query($sql) or die (mysql_error());
?>
My Code 1 save in my database:
Saving Multiple!
My Code 2 save in my database:
What is wrong with my code 1?
