How to get the output of a function in db-connect file to another file which includes a html table?

Question

0.00/5 (No votes)

See more:

Hi, I'm not much familiar with PHP. So its really difficult to find the best way to do my work. However I did the task. But I couldn't design this table using css. Think there's something wrong in my code. Please help me.

I want to write the table tags in html, inside the abc.php file without designing it inside db_connect file using php tags.

The file(abc) which I have calling the function in db_connect file

PHP

<?php


include('a_header.php');
include_once('classes/class.database.php');
	$db = new db();
	?>

<div id="table1 >

    <?php
    echo "<table border='1' width='300px' >
        <tr>
            <th>Name</th>
            <th>Email</th>
        </tr>";
   
    ?>
    
</div>


        <?php
	$res2 = $db->get_patients();
        
	
include('a_footer.php');?>

This is the function I have written inside the db_connect file.

PHP

<?php
class db{
	private $con;
	function __construct(){
		$this->con = mysql_connect('localhost','root','');
		mysql_select_db('mask',$this->con);
	}

         function get_patients($name=NULL,$email=NULL,$username='gayani'){
            $query2 = "select distinct a.name, a.email from patient a,doctor_patient b, doctor c where c.username='".$username."' and c.username=b.doc_name and b.serial_no=a.serial_no" ;
                    . "  and name='".$name."';";

	    $res2 = mysql_query($query2,$this->con);
                
            while($row2 = mysql_fetch_array($res2)){
                    echo "<tr>";
                    echo "<td> <a href='v_patient.php'/>" . $row2['name'] . "</td>";
                    echo "<td>" . $row2['email'] . "</td>";
                    echo "</tr>";      
		}
                
            echo "</table>";
	}

I want to write the table tags in html, inside the abc.php file without designing it inside db_connect file using php tags. I tried it. But its not working. Help me guys.

Posted 21-May-14 15:30pm

gayani dassa

Updated 21-May-14 15:32pm

v2

Add a Solution

Comments

Peter Leow 21-May-14 21:56pm

What errors have you encountered? already I have spotted some syntax errors?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2014-05-21T16:27:00

Try the following:
in the db_connect.php file

class db
{
     private $con;
     function __construct()
    {
        $this->con = mysql_connect('localhost','root','');
        //mysql_select_db('mask',$this->con);
    }

    public function getDbConnection(){
        return $this->con;
    }
}

in the abc.php file, syntax errors corrected in $query2 and href

<?php
// $res2 = $db->get_patients();

    require_once 'db_connect.php';
    $db = new db();
    $con = $db->getDbConnection();

    mysql_select_db('mask', $con );

    // How you get the value for $name, $username ??????

            $query2 = "select distinct a.name, a.email from patient a,doctor_patient b, doctor c where c.username='".$username."' and c.username=b.doc_name and b.serial_no=a.serial_no and name='".$name."'";
 
	    $res2 = mysql_query($query2,$con);
                
            while($row2 = mysql_fetch_array($res2)){
                    echo "<tr>";
                    echo "<td> <a href="v_patient.php">" . $row2['name'] . "</a></td>";
                    echo "<td>" . $row2['email'] . "</td>";
                    echo "</tr>";      
           }
                
            echo "";
	}

// other code
?>

However, you should upgrade your php to version 5 and above and use mysqli and prepared statement for your sql query: prepared-statements-in-php-and-mysqli/[^] to prevent sql injection.