today I encounter a problem concerning the inserting of data into my database.
I've created a module to insert data into a table. There are two locations to complete the fields, the first one is on an article and second one is in the admin's menu.
<?php
defined( '_JEXEC' ) or die;
function add_Age_row($label)
{
$db = &JFactory::getDBO();
$query = "INSERT INTO '#__module_age' (label_age) VALUES (".$label."')";
print_r($label);
print_r($query);
$db->setQuery( $query );
$db->query();
}
function get_Age()
{
$database = &JFactory::getDBO();
$query = "SELECT label_age FROM module_age ORDER BY id_age";
$database->setQuery($query);
$rows = $database->loadAssocList();
foreach($rows as $key=>$row)
{
echo "<br/>";
echo $row['label_age'];
echo "<br/>";
}
}
if (isset($_POST['age']))
{
echo "passe là";
add_Age_row($_POST['age']);
}
get_Age();
?>
<form method="POST" action ="<?php echo JURI::current(); ?>">
<p><label> Age :</label></p>
<p><input type="text" name="age"></p>
<p><input id="submit" name="submit" type="submit" value="Submit Names" /></p>
</form>
The selection works but not the insertion.
I've tried with the PDO Method and it's the same, selection works but insertion not.
