Jump to content

akhilkumar332

Members
 View Profile  See their activity

  • Posts

    20

  • Joined

  • Last visited

 Content Type 

Posts posted by akhilkumar332

    PHP help mysqli_query ()expects at least 2 parameters, 1 given

    in PHP Coding Help

    Posted

    I'm getting these error plz help!!!

     

     

    Warning: mysqli_query() expects at least 2 parameters, 1 given in /storage/h2/401/535401/public_html/register.php on line 80

    Warning: mysqli_error() expects exactly 1 parameter, 0 given in /storage/h2/401/535401/public_html/register.php on line 80

    <?php

$con= new mysqli('localhost','id535401_root','Patch201796','id535401_kickednetwork')or die("Could not connect to mysql".mysqli_error($con));

function NewUser()
{
$username = $_POST['username'];
$email = $_POST['useremail'];
$password = $_POST['password'];
$query = "INSERT INTO members (username,email,password) VALUES ('$username','$email','$password')";
$data = mysqli_query ($query)or die(mysqli_error());
if($data)
{
echo "YOUR REGISTRATION IS COMPLETED...";
}
}

function SignUp()
{
if(!empty($_POST['username'])) //checking the 'user' name which is from Sign-Up.html, is it empty or have some text
{
$query = mysqli_query("SELECT * FROM members WHERE username = '$_POST[username]' AND password = '$_POST[password]'") or die(mysqli_error());

if(!$row = mysqli_fetch_array($query) or die(mysqli_error()))
{
newuser();
}
else
{
echo "SORRY...YOU ARE ALREADY REGISTERED USER...";
}
}
}
if(isset($_POST['submit']))
{
SignUp();
}
?>

    auto change of quotes...in php urgent help!

    in PHP Coding Help

    Posted

    As of now when i refresh...then only the "quote" changes..... but it i want "quotes" to change automatically on its own...m new at this..plz help!!!

     

     

    <?php

        $quotes[] = "quote1";

        $quotes[] = "quote2";

        $quotes[] = "quote3";

        $quotes[] = "quote4";

     

        srand ((double) microtime() * 1000000);

        $randomquote = rand(0,count($quotes)-1);

        echo "<p>" . $quotes[$randomquote] . "</p>";

     ?>

     

     

     

     

     

    Thank you

    PHP help need urgently

    in PHP Coding Help

    Posted

    Now it working fine after little modification

     

    bt one last problem is.....i should get "No Such Data Found" if i enter a wrong value(wrong admission no)

    Plz help me...!!!

    Thank you 

    <?php
include_once("bg.php");
ob_start();
session_start();

if(isset($_POST['submit'])){
	//Connect to dataBase
	$mysqli=mysqli_connect("localhost","akhil","qwerty123","u761479816_bdata");
	
	$search = $mysqli->real_escape_string($_POST['search']);
	
	//query the Database
	$resultSet = $mysqli->query("SELECT * FROM stud_adm WHERE adm_no = '$search'");
	
	$row= mysqli_fetch_array($resultSet);
}
	?>			
<center><img draggable='false' width='100' height='100' src=imagess/background/logo.png>
<center>
<h1>Techwell Institute</h1>
<center>
<form action="qwerty.php" method="POST">
<input type="TEXT" name="search" autofocus placeholder="Admission no." />
<input type="SUBMIT" name="submit" value="Verify">
<br /><br />
<input type="button" value="Search Another" style="width:120px; height:20px" onclick="window.location ='qwerty.php'">
</center>
<br />
<?php
if(isset($_POST['submit'])){
?>
<center>
<table border="10" height="100" cellspacing="5" cellpadding="5" bordercolor='#21DBD9' bgcolor='#E5F4F4'>
<TR>
<TD><b>ADMISSION NO.</b></TD>
<TD><center>
 <?php echo $row['adm_no'];?>
 </TR>
 <TR>
<TD><b>NAME</b></TD>
<TD><center>
 <?php echo $row['name'];?>
 </TR>
<TR>
<TD><b>PHOTO</b></TD>
<TD><center>
<?php echo "<center><img width='120' height='120' src=imagess/student/".$row['img'].">";?>
</TD>
</TR>
<TR>
<TD><b>DATEOFBIRTH</b></TD>
<TD><center>
 <?php echo $row['dob'];?>
 </TR>
  <TR>
<TD><b>FATHER/GURDIAN</b></TD>
<TD><center>
 <?php echo $row['fname'];?>
 </TR>
  <TR>
<TD><b>MOBILE NO</b></TD>
<TD><center>
 <?php echo $row['mb_no'];?>
 </TR>
  <TR>
<TD><b>EMAIL</b></TD>
<TD><center>
 <?php echo $row['email'];?>
 </TR>
<TR>
<TD><b>CORE</b></TD>
<TD><center>
<?php echo $row['core'];?>
</center>
</TD>
</TR>
<TR>
<TD><b>DATEOFPASSING</b></TD>
<TD><center>
 <?php echo $row['d_passing'];?>
 </TR>
 <TR>
<TD><b>GRADE</b></TD>
<TD><center>
 <?php echo $row['grade'];?>
 </TR>
 <TR>
<TD><b>REMARK</b></TD>
<TD><center>
 <?php echo $row['remark'];?>
 </TR>
 <TR>
<TD><b>CERTIFICATE</b></TD>
<TD><center>
 <?php echo $row['c_issue'];?>
 </TR>
</table>
</form>
<br />
</center>
<?php
}		 	
?>

    PHP help need urgently

    in PHP Coding Help

    Posted

    one more problem

    if i enter the value...which is present in database....if gives me the output correctly

     

    But when i enter some other value it gives message "Undefined Variable" for all the rows

     

    Notice: Undefined variable: adm_no in C:\xampp\htdocs\bypass-student-enroll\qwerty.php on line 59

     

    Just give me the format to  define the variable for the data present in table and i will do 

    PHP help need urgently

    in PHP Coding Help

    Posted

     i got few problems on my php file... the prob is i can able to search and retrieve data using adm_no value on my php bt when i enter...some other value which is not in my database....it should give me an arror "No Such Data Found".........this is my prob.....below is php file scripts ...plz look into it and solve my problem...m noob at this joy.png?v=3 ....i just managed to get till here

    note: I want all the data to shown up in the Table only not anywhere else!!!

    plz help 

    Thank you!!!

     

    <?php

    include_once("bg.php");
    ob_start();
    session_start();
     
    $output = NULL;
     
    if(isset($_POST['submit'])){
    //Connect to dataBase
    $mysqli=mysqli_connect("localhost","akhil","qwerty123","u761479816_bdata");
     
    $search = $mysqli->real_escape_string($_POST['search']);
     
    //query the Database
    $resultSet = $mysqli->query("SELECT * FROM stud_adm WHERE adm_no = '$search'");
     
     
    if($resultSet->num_rows > 0){
    while($rows = $resultSet->fetch_assoc())
    {
    $adm_no = $rows['adm_no'];
    $name = $rows['name'];
    $img = $rows['img'];
    $dob = $rows['dob'];
    $fname = $rows['fname'];
    $mb_no = $rows['mb_no'];
    $email = $rows['email'];
    $core = $rows['core'];
    $d_passing = $rows['d_passing'];
    $grade = $rows['grade'];
    $remark = $rows['remark'];
    $c_issue = $rows['c_issue'];
     
     
    $output = "
    Admission No: $adm_no<br />
    Name: $name<br />
    Photo: <img src='./imagess/student/".$rows ['img']."' height='70' width='70'><br />
    Date of Birth: $dob<br />
    Father/Gurdian Name: $fname<br />
    Mobile No: $mb_no<br />
    Email: $email<br />
    Core: $core<br />
    Date of Passing: $d_passing<br />
    Grade: $grade<br />
    Remark: $remark<br />
    Certificate: $c_issue";
    }
    }else{
    $output = "No Data Found";
    }
    }
    ?>
    <center><img draggable='false' width='100' height='100' src=imagess/background/logo.png>
    <center>
    <h1>Techwell Institute</h1>
    <center>
    <form action="Verification.php" method="POST">
    <input type="TEXT" name="search" />
    <input type="SUBMIT" name="submit" value="Verify">
    <br /><br />
    <table border="10" height="100" cellspacing="5" cellpadding="5" bordercolor='#21DBD9' bgcolor='#E5F4F4'>
    <TR>
    <TD><b>ADMISSION NO.</b></TD>
    <TD><center>
     <?php echo $adm_no ?>
     </TR>
     <TR>
    <TD><b>NAME</b></TD>
    <TD><center>
     <?php echo $name ?>
     </TR>
    <TR>
    <TD><b>PHOTO</b></TD>
    <TD><center>
    <?php echo "<img width='70' height='70' src=./imagess/student/".$img.">";?>
    </TD>
    </TR>
    <TR>
    <TD><b>DATEOFBIRTH</b></TD>
    <TD><center>
     <?php echo $dob ?>
     </TR>
      <TR>
    <TD><b>FATHER/GURDIAN</b></TD>
    <TD><center>
     <?php echo $fname ?>
     </TR>
      <TR>
    <TD><b>MOBILE NO</b></TD>
    <TD><center>
     <?php echo $mb_no ?>
     </TR>
      <TR>
    <TD><b>EMAIL</b></TD>
    <TD><center>
     <?php echo $email ?>
     </TR>
    <TR>
    <TD><b>CORE</b></TD>
    <TD><center>
    <?php echo $core ?>
    </center>
    </TD>
    </TR>
    <TR>
    <TD><b>DATEOFPASSING</b></TD>
    <TD><center>
     <?php echo $d_passing ?>
     </TR>
     <TR>
    <TD><b>GRADE</b></TD>
    <TD><center>
     <?php echo $grade ?>
     </TR>
     <TR>
    <TD><b>REMARK</b></TD>
    <TD><center>
     <?php echo $remark ?>
     </TR>
     <TR>
    <TD><b>CERTIFICATE</b></TD>
    <TD><center>
     <?php echo $c_issue ?>
     </TR>
    </table>
    </form>
    <input type="button" value="Search Another" style="width:120px; height:30px" onclick="window.location ='Verification.php'">
    <br /><br />
    </center>
    <?php echo $output; ?>
     
     
    I have also attached my  php file!!!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.