Ben op dit moment bezig met een edit account class. Waar iemand dus geregistreerd is, een account heeft maar dat ook aan kan passen. Maar nu kom ik er even niet meer uit. Dus hoop dat iemand mij beetje op weg kan helpen en/of suggesties heeft!
Alvast bedankt!! (zal hieronder het script posten)
<?php
error_reporting(E_ALL | E_STRICT);
require_once ("index.php");
class ManageAccount
{
private $m_sField;
private $m_aAccountData;
private $oForm;
public function __construct($p_sFormName, $p_sFormType, $p_sFormAction)
{
$this->oForm = new Form($p_sFormName, $p_sFormType, $p_sFormAction);
}
public function getAccountData($p_sTableName, $p_aFieldNames, $p_aPostValues, $p_sWhereField,
$p_vWhereValue, $p_sAndStatement = "")
{
if (!empty($p_sTableName) && !empty($p_aFieldNames) && !empty($p_aPostValues) &&
!empty($p_sWhereField) && !empty($p_vWhereValue)) {
if ((count($p_aPostValues) - 1) == count($p_aFieldNames)) {
$sQuery = "UPDATE " . mysql_real_escape_string($p_sTableName) . " SET ";
for ($nCount = 0; $nCount <= (count($p_aPostValues) - 1); $nCount++) {
$sQuery .= mysql_real_escape_string($p_aFieldNames[$nCount]) . " = '" .
mysql_real_escape_string($p_aPostValues[$nCount]) . "', ";
}
$sQuery = substr($sQuery, 0, -2);
$sQuery .= " WHERE " . mysql_real_escape_string($p_sWhereField) . " = '" .
mysql_real_escape_string($p_sWhereValue) . "'";
if (!empty($p_sAndStatement)) {
$sQuery .= $p_sAndStatement;
}
mysql_query($sQuery) or die("Database error: " . mysql_error() . "<br />");
$statusMessage = "De account is bewerkt.";
return $statusMessage;
} else {
$statusMessage = "Het aantal opgegeven waardes van de meegestuurde variabelen en veldnamen kwamen niet overeen.";
return $statusMessage;
}
} else {
$statusMessage = "Onvoldoende informatie meegegeven.";
return $statusMessage;
}
}
private function makeForm(){
echo 'Username: ';
$this->m_sField = $this->oForm->makeField("username","text","",$this->m_aAccountData['username']);
echo '<br />';
echo 'Password: ';
$this->m_sField .= $this->oForm->makeField("password","password","",$this->m_aAccountData['password']);
echo '<br />';
echo 'E-mail: ';
$this->m_sField .= $this->oForm->makeField("email","text","",$this->m_aAccountData['email']);
echo '<br />';
echo 'Telefoon: ';
$this->m_sField .= $this->oForm->makeField("telefoon","text","",$this->m_aAccountData['telefoon']);
echo '<br />';
$this->m_sField .= $this->oForm->makeField("submit","wijzig","Wijzig");
}
public function showForm() {
$this->makeForm();
return $this->m_sField;
}
}
$m = new ManageAccount("test", "POST", "");
echo $m->showForm();
?>
