PHP getting data from SQL from database

Question

Hey I'm wanting to retrieve some data from the a database. But it seems whenever I enter my credentials into the SQL database to retrieve the data I get the following error:

At the very least, you could identify which line is 39.

Gordon Linoff
– Gordon Linoff

2014-10-05 12:56:00 +00:00
Commented Oct 5, 2014 at 12:56 — Gordon Linoff
– Gordon Linoff, Commented Oct 5, 2014 at 12:56
Where is $connect?? Why using md5?

Mike M.
– Mike M.

2014-10-05 13:01:36 +00:00
Commented Oct 5, 2014 at 13:01 — Mike M.
– Mike M., Commented Oct 5, 2014 at 13:01

Community · Accepted Answer · 2017-05-23 10:25:23Z

1

Since i presume this is a similar use case as your last question

Your php file is missing the configuration of the connection:

<?php
$dbuser = "******"; 
$dbpass = "*******"; 
$db = "SSID";
$connect = OCILogon($dbuser, $dbpass, $db);



if (!$connect) {
echo "An error occurred connecting to the database";
exit;
}

So it knows which connection you are using and passing to the checkUserPass() function.

UPDATE:

For the table name you need to pass $dbtable as you can see in the function declaration

function checkUserPass($connect,$username, $password, $dbtable)

so either set a $dbtable variable before calling the function:

$dbtable="register_table";

or send it immediately as a string:

function checkUserPass($connect,$username, $password, "register_table")

edited May 23, 2017 at 10:25

CommunityBot

11 silver badge

answered Oct 5, 2014 at 13:03

Kypros

2,9865 gold badges23 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user2857301 Over a year ago

ok thanks again for that. I'm still having some errors but I think you've put me on the right track.

user2857301 Over a year ago

I know this isn't you job and its okay if you CBF. But I'm getting the errors: ociexecute() ORA-00903: invalid table name on line 37 where there seems to be no code on that line? Also i'm getting one other error of: ocifetch() ORA-24374: define not done before fetch or execute and fetch on line 39 :/

Kypros Over a year ago

I updated the question to address this but i suggest you read some beginner tutorials on PHP/MySQL before moving on with development.

Collectives™ on Stack Overflow

PHP getting data from SQL from database

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related