تسجيل الدخول | التسجيل | الأسئلة المتكررة
Anonymous

PHP Code for retrieve and write data from a table

+ إضافة رد

4 مشاركة صفحة 1 من 1


PHP Code for retrieve and write data from a table

بواسطة Shanmugalingam » الاثنين يونيو 08, 2015 8:11 am

Hi,
I want some php codes to check, the index No in the database, if the index No available again check the registered column to check whether he or she already registered, If not, write to that column "yes" and show his/her details, If that column says yes show a message "You are already registered"
I already created a database with necessary fields. and their is field called status. in that field the program automatically should fill "yes" or a massage like " You are already registered".
صورة العضو الشخصية

Shanmugalingam

  • مشاركات: 2
  • اشترك في: الأربعاء إبريل 08, 2015 6:23 am

Re: PHP Code for retrieve and write data from a table

بواسطة XainPro » الثلاثاء يونيو 09, 2015 1:21 pm

By all of your detail i think you are trying to build a login system
check login system simple tutrial here


http://www.wikihow.com/Create-a-Secure- ... -and-MySQL
صورة العضو الشخصية

XainPro

  • مشاركات: 3933
  • اشترك في: الجمعة فبراير 17, 2012 8:10 pm

Re: PHP Code for retrieve and write data from a table

بواسطة softinx » الجمعة سبتمبر 25, 2015 11:42 am

Thanks for asking the nice question. I also faced the same problem because at that time I was preparing for my job interview so I go the solution
CODE: تحديد الكل
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
    }
} else {
    echo "0 results";
}
$conn->close();
?>
from http://www.w3schools.com/php/php_mysql_select.asp
For best interview questions of php with answer I got the help and crack my interview..Hope it will help you also https://intellipaat.com/interview-question/php-interview-questions/
صورة العضو الشخصية

softinx

  • مشاركات: 1
  • اشترك في: الجمعة سبتمبر 25, 2015 11:33 am

Re: PHP Code for retrieve and write data from a table

بواسطة tekclasses » الثلاثاء ديسمبر 27, 2016 11:43 am

CODE: تحديد الكل
<?php
$connect=mysql_connect('localhost', 'root', 'password');

mysql_select_db("name");
//here u select the data you want to retrieve from the db

$query="select * from tablename";

$result= mysql_query($query);

//here you check to see if any data has been found and you define the width of the table

If($result){

echo "<table width ='340' align='left'>
      <tr color ='#5D9951>";
$i=0;

    If(mysql_num_rows($result)>0)
    {
         //here you fetch the data from the database and print it in the respective columns   
        while($i<mysql_num_fields($result))
        {   
             echo "<th>".mysql_field_name($result, $i)."</th>";
             $i++;
        }
        echo "</tr>";

        $color=1;

        while($rows=mysql_fetch_array($result, MYSQL_ASSOC))
        {   
            If ($color==1){
                echo "<tr color='#'#cccccc'>";

                foreach ($rows as $data){
                    echo "<td align='center'>".$data. "</td>";
                }

                $color=2;
            }
            $color=1;
        }
     } else {
        echo"no results found";
        echo "</table>";
    } else {
        echo "error running query:".MYSQL_error();
}
?>


For More Info https://goo.gl/Qgg02u
صورة العضو الشخصية

tekclasses

  • مشاركات: 1
  • اشترك في: الثلاثاء ديسمبر 27, 2016 11:37 am


+ إضافة رد

صفحة 1 من 1