Registration form hait insert data katika table za database

[Deejay nasmile]

Wakuu habari,nimejaribu kutengeneza php reg form, pia niwetengeneza database yenye table na field zote kama
nilizo create ktk forms. sasa nashindwa kutengeneza connection ili mtu akishajaza ile form,data ziende ktk db nilizocreate.afu pia ziweze kuonekana ktk page ya user panel. Natumia xamp server

 

[willy ze great]

Wakuu habari,nimejaribu kutengeneza php reg form, pia niwetengeneza database yenye table na field zote kama
nilizo create ktk forms. sasa nashindwa kutengeneza connection ili mtu akishajaza ile form,data ziende ktk db nilizocreate.afu pia ziweze kuonekana ktk page ya user panel. Natumia xamp server

Weka code zako hapa tukuchapie

 

[Investaa]

Database connection:
<?php $connect = new Mysqli($hostname,$username,$password,$dbname);

//test connection if
if($connect->error){
print "Database connection failed";
}
else{
print "Database connection is made!!!!";
}

 

[Deejay nasmile]

Weka code zako hapa tukuchapie

Poa mkuu,saiv natumia simu!! Kesho nitaandika kwa urefu

 

[Deejay nasmile]

Database connection:
<?php $connect = new Mysqli($hostname,$username,$password,$dbname);

//test connection if
if($connect->error){
print "Database connection failed";
}
else{
print "Database connection is made!!!!";
}

Mkuu hiyo ni file linalojitegemea au naunganisha ndani ya file la register.php???? Sehemu gani

 

[Investaa]

Mkuu hiyo ni file linalojitegemea au naunganisha ndani ya file la register.php???? Sehemu gani

Linajitegemea then unaweza kuritumia sehemu yoyote unapotaka kutumia database. Unaweza kutumia ata kwenye file lako la register kwa kutumia require_once("dbconnection.php") juu ya file lako ya register.php

 

[Investaa]

Linajitegemea then unaweza kuritumia sehemu yoyote unapotaka kutumia database. Unaweza kutumia ata kwenye file lako la register kwa kutumia require_once("dbconnection.php") juu ya file lako ya register.php

Kwa mfano kwenye file lako la register

<?php

require_once("dbconnection.php");
//dbconnection save as separate file

$username = $connect->real_string_escape($_POST["username"]);
$password = $connect->real_string_escape($_POST["password"]);

$query = $connect->query("INSERT INTO members VALUES(username = '$username', password = '$password'");

if($query){

print "Successfully";
}

else{
print "Failed to insert member";

}


?>

 

[Deejay nasmile]

Okey nimekupata bosi

 

[Deejay nasmile]

Kwa mfano kwenye file lako la register

<?php

require_once("dbconnection.php");
//dbconnection save as separate file

$username = $connect->real_string_escape($_POST["username"]);
$password = $connect->real_string_escape($_POST["password"]);

$query = $connect->query("INSERT INTO members VALUES(username = '$username', password = '$password'");

if($query){

print "Successfully";
}

else{
print "Failed to insert member";

}


?>

Bado ni mziki mnene!!! Kila nikisubmit inakuja blank page au nikienda kwenye db hamna new record yoyote