Learn VBA & Macros in 1 Week!

PHP - Connecting To Two Mysql Databases Simultaneously

Full Excel VBA Course - Beginner to Expert

Connecting To Two Mysql Databases Simultaneously	View Content

is it possible to have two open connections to two different mysql dbs at the same time? when i tried it, only the one on the bottom of the list was active.

my config file looks like this:

//---------------------------------------------//

$dbname = 'xxx'; # Database Name
$dbuser = 'xxx'; # Database Username
$dbpass = 'xxx'; # Database Password
$dbhost = 'xxx'; # Database Host

$conn2 = mysql_connect($dbhost,$dbuser,$dbpass) or die ("Could not connect to $dbname: ".mysql_error());
mysql_select_db($dbname) or die ("Could not access the database: ".mysql_error());

$dbname5 = 'yyy'; # Database Name
$dbuser5 = 'yyy'; # Database Username
$dbpass5 = 'yyy'; # Database Password
$dbhost5 = 'yyy'; # Database Host

$conn = mysql_connect($dbhost5,$dbuser5,$dbpass5) or die ("Could not connect to $dbname5: ".mysql_error());
mysql_select_db($dbname5) or die ("Could not access the database: ".mysql_error());

//--------------------------------------//

so i want to be able to do

mysql_query($query,$conn2) when i need to access xxx db, but it doesn't seem to work that way. am i doing something incorrectly? any help would be greatly appreciated.

Full Excel VBA Course - Beginner to Expert

Connecting 2 Databases On Different Hosts

Similar Tutorials

View Content

Dear All,

I am having 2 different DB on 2 different hosts.

I am running MySQL Server on my local PC where the user is entering data in the tables. I have a website which has the identical DB on the web. I am able to connect to the database by using the codes on the server.

I want to update the server DB with the local system DB by running one update command. I get the error "-SELECT command denied to user 'localusername'@'localhost' for table 'pst_data'"

Given below is the code used for the process :

//connecting the remote system DB
$link = mysql_connect('IPAddress:3306', 'remoteusername', 'Password');
if (!$link) {
die('Not connected : ' . mysql_error());
}

$db_selected = mysql_select_db('remotedb', $link);
if (!$db_selected) {
die ('Can\'t use Remote System DB: ' . mysql_error());
}

//connecting the local database on the webstite
$weblink = mysql_connect("localhost","localusername","password");
if (!$weblink) {
die('Not connected : ' . mysql_error());
}
$webdb_selected = mysql_select_db('localwebdb', $weblink);
if (!$webdb_selected) {
die ('Can\'t use WebServer Database : ' . mysql_error());
}

//query to fetch the records from remote ystem and insert into local website database
$upd_Query=mysql_query("INSERT INTO localwebdb.`table` SELECT * FROM remotedb.`table` where field=' some condition' ");
---------------------------------------------------

I have tested that I have connected the remote DB by running queries on the webserver.

Could anyone bail me out so that i can copy the DB from remote to local

Any help would be appreciated

Connecting To Two (2) Databases At The Same Time

Similar Tutorials

View Content

Hello again guys!

What if i have 2 databases, db1 and db2. i want to read raw data from db1 and match it's content with data from db2, then produce some information. How can i do it at the same time? I know that to be able to access mysql data, we have to use the mysql_connect() and mysql_select_db(). mysql_select_db() only allows to connect to single database. what should i do?

thanks for your help in advance.

Issue Connecting To Multiple Databases

Similar Tutorials

View Content

Hello,

I'm using this code in a php file to connect to 2 databases (something that I need to do):
$conn_local = mysql_connect('localhost','root','',TRUE);
$conn_local2 = mysql_connect('localhost','root','');
mysql_select_db('db1',$conn_local);
mysql_select_db('db2',$conn_local2);

I'm then trying to use this code to call it from the 1st Database:
$sql = "SELECT * FROM news_items ORDER BY news_date DESC LIMIT 0,$limit";
    $result = mysql_query($sql,$conn_local);
    if(mysql_num_rows($result)!=0){
    while($row = mysql_fetch_array($result))
...etc

Although I am getting this error:
Quote

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\test\includes\function.php on line 17

If I ONLY include the 1 database and don't bother putting the ',$conn_local' into the mysql_query it will work fine and return the records needed. It only seems to be when I try and include more than 1 database.

Any ideas where I'm going wrong?

Thanks.

Moved: Searching 2 Mysql Tables Simultaneously

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=322398.0

Linking 2 Mysql Databases.

Similar Tutorials

View Content

hi all,

I am trying to link 2 mysql tables and display some information from each of them.

I have a list of all the possible items for sale in table1 and I am trying to count the number of rows in the other table2 where the items exist.

E.g. 'table1'
manufacturer model
man1 item1
man1 item2
man1 item3

'table2'
id model
1 item3
2 item3
3 item2

And the result would show:
item1(0)
item2(1)
item3(2)
It would list all the items from table1 and show next to it how many rows are related to that item from table2.

I have inserted a quote where I have tried many times to enter something similar to that show in the note below - but I can not get it to work - it just shows the total number of models in table1 for a given manufacturer.

The php I have made so far is:

<?php
    case 'manufacturer':
        $query = "
            SELECT *
            FROM table1";
        $query .= "
            WHERE manufacturer = '".$data."' ";
        $query .= "
            ORDER BY model ";

        $result = mysqli_query($cxn,$query);
        $returnData[''] = "Select a Model...";
        while($row = mysqli_fetch_assoc($result)){
// I THINK I NEED TO INSERT SOMETHING LIKE $query2 = "SELECT * FROM table2 WHERE model = table1.model";
    $k=$row['model'];
    $k2=$row2['model'];
            $counter[$k]+=1;
            $returnData[$k]=$k;
        }

        foreach($counter as $k => $row)
        {
            $returnData[$k] .= " ($row)";
        }

        break;
?>

How To Create A Blog (not Use Mysql Or Any Other Databases)?

Similar Tutorials

View Content

I want to create a text file based blog ( not using MySQL or other databases).
I have tried to google for tutorials but I couldn't find anything.
is there anyone who can help me and give me some tips?
is there any tutorials about this because I found nothing?
Any good books?

This is an assignment that I have to do and I am using this book:
Spring into PHP 5 by Addison Wesley.

I am a newbie in php and really want to do this because this is my last task and I really want to learn. So I'm grateful if anyone can help me.

How To Create A Monthly Archive (no Mysql Och Any Databases)?

Similar Tutorials

View Content

I would like some tips on how to create a monthly archive for my weblog.
I am not using MySQL or any databases. Everything is saved on file.
any tips or tutorials?

Thanks

Connecting Mysql With Php

Similar Tutorials

View Content

So I'm currently watching this tutorial : http://youtu.be/9E0s4gsUeU0
And am trying to build the sample application shown there. However I do seem to run into some problems, so if someone could take the time to help me out; I would be very grateful!

---
The application is a simple HTML form, which takes the data input and stores it into a MySQL database table.

My project is organized as this :

The actual form is stored on the insert.php file.
Code: [Select]
<?php

include_once('resources/init.php');

if (isset($_POST['title'], $_POST['post'])) {

// functions go here!

}

?>

<html>
<head>
<title>
Post something!
</title>
</head>

<body>

<div id="form">
<form method="POST" action= " ">
<label for="title">Title:</label><br>
<input type="text" name="title" id="title" /><br>
<label for="post">Post:</label><br>
<textarea name="post" id="post" rows="15" cols="50"></textarea><br>

</form>
</div>

</body>
</html>

The config.php and init.php are the configuration and initialize files.

config.php
Code: [Select]
<?php

$config['DB_HOST'] = 'localhost';
$config['DB_USER'] = 'root';
$config['DB_PASS'] = '';
$config['DB_NAME'] = 'form';

//foreach ( $config as $k => $v ) {
// define(strtouper($k), $v);
//}

?>

init.php
Code: [Select]
<?php

include_once('config.php');

mysql_connect(DB_HOST, DB_USER, DB_PASS);
mysql_select_db(DB_NAME);

?>
---

When I try this in my browser I get the error :
Code: [Select]
Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'DB_HOST' (11004) in C:\xampp\htdocs\form\resources\init.php on line 5

Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\form\resources\init.php on line 6

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in C:\xampp\htdocs\form\resources\init.php on line 6

Could someone tell me what is wrong?

Thanks in advance!

Need Help On Connecting To Mysql Database From Php.

Similar Tutorials

View Content

Im trying to connect to a database from php. Heres the code:
<?php
$dbc = mysqli_connect('192.168.0.122', 'boyyo', 'KiaNNa11', 'aliendatabase')
or die('Error connecting to MySQL server.');


$query = "INSERT INTO aliens_abduction (first_name, last_name, " .
"when_it_happened, how_long, how_many, alien_description, " .
   "what_they_did, fang_spotted, other, email) " .
   "VALUES ('Sally', 'Jones', '3 days ago', '1 day', 'four', " .
   "green with six tentacles', 'We just talked and played with a dog', " .
   "'yes', 'I may have seen your dog. Contact me.', " .
   "'sally@gregs-list.net')";

   $result = mysqli_query($dbc, $query)
   or die('Error querying database.');
   ?>

I think i have a theory that my MySQL server location is wrong but i dont know. I use HostGator to do this and im using Phpmyadmin. But everytime i type in a form that i created it says Error querying database. Can someone tell me whats wrong with this code. Oh by the way im using head first into PHP and MySQL

Error Connecting To Mysql

Similar Tutorials

View Content

when I try to connect to my database with CLI I get this error

Code: [Select]

Access denied for user 'bommobco_cwbtest'@'cpe-123.45.789.123.neo.res.rr.com' (using password: YES)

123.45.789.123 being my ip address, how can I fix this issue so I can connect?

Problem Connecting To Mysql

Similar Tutorials

View Content

<?php
$username="a7564065_si";
$password="*****";
$database="a7564065_food";

mysql_connect(mysql4.000webhost.com,$username,$password);
...

I am trying to connect to mysql but having trouble.
The host name: mysql4.000webhost.com

I get the error:

Parse error: syntax error, unexpected T_DNUMBER in /home/a7564065/public_html/Index.html on line 17

Any ideas?

Php Connecting To Mysql But Not Authenticating Me In Php

Similar Tutorials

View Content

I am moving a site from another server to a new one. I have changed all the code snippets to reflect the new server and the new database but for some reason when I come to login it will not take me further. I know that the code has connected to the database as I have a userlog table on there telling me I when I logged in last.

elow is my login.php (there is obviously more than the code included)

Code: [Select]
<?
require 'include/common.inc.php';
require 'include/session.inc.php';

if(($u_username != "") || ($u_password != "")) {
$funcResult = authenticateUser($u_username, $u_password, $chkRemember);
if(!$funcResult->returnValue) {
header("Location: login.php?msg=" . $funcResult->errorMessage);
echo "ERROR: " . $funcResult->errorMessage;
} else {
if($artid!="") {
header("Location: news/readarticle.php?artid=$artid");
} else {
if($funcResult->errorMessage == "M") {
header("Location: members/index.php");
exit;
} elseif($funcResult->errorMessage == "B") {
header("Location: business/index.php");
exit;
}
$msg = "Invalid UserName/Password";
}
}
}

?>
<html>
<head>
<title>Welcome to Newquay Uncovered</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="images/style.css" rel="stylesheet" type="text/css">
<script language="Javascript">

</script>
Here is Common
Code: [Select]
<?
require '/home/xmasphot/public_html/www.newquayuncovered.com/include/db.inc.php';
// require '/dump/ldev/newquayuncovered/revamped/include/db.inc.php';

// USER UPLOAD FOLDER
$uploaddir = "/home/xmasphot/public_html/www.newquayuncovered.com/members/uploads/";
// $uploaddir = "/dump/ldev/newquayuncovered/revamped/members/uploads/";
$pic_path = "/members/uploads/";
$nophoto = "/images/nophoto.jpg";
$pending = "/images/pending.jpg";
$fromemailaddresss = "help@newquayuncovered.com";
global $sportspicpath;
global $sports_rpicpath;

// $sports_rpicpath = "/dump/ldev/newquayuncovered/revamped/admin/sports/images/";
// $sports_picpath = "/newquayuncovered/revamped/admin/sports/images/";

$sports_rpicpath = "/home/xmasphot/public_html/www.newquayuncovered.com/admin/sports/images/";
$sports_picpath = "/admin/sports/images/";

if ($uid == "") {
$uid = 0;
}

function sendErrorPage($mesg) {
echo "Error Generated: <BR>$mesg";
exit;
}

function getDateString() {
/* The function getDateString() returns the current date in the
* format YYYY-MM-DD. This function is used when inserting date
* columns into MySQL table
*/
return date(Y-m-d);
}

function getCountry($chk) {
$query = "SELECT c_cid, c_cname FROM nq_country ORDER BY c_cname";
$results = mysql_query($query);
echo "<option value=''><-- Select --></option>";
while($row = mysql_fetch_object($results)) {
if($chk == $row->c_cid) {
echo "<option value='$row->c_cid' selected>$row->c_cname</option>\n";
} else {
echo "<option value='$row->c_cid'>$row->c_cname</option>\n";
}
}
}

function getGender($chk) {
echo "<option value=''><-- Select --></option>\n";
if($chk != "" && $chk == 0) {
echo "<option value=0 selected>Female</option>\n";
} else {
echo "<option value=0>Female</option>\n";
}
if($chk == 1) {
echo "<option value=1 selected>Male</option>\n";
} else {
echo "<option value=1>Male</option>\n";
}
}

function getSexuality($chk, $type="") {
$arrVals = array( "R" => "Rather Not Say", "S" => "Straight",
"O" => "Open Minded", "G" => "Gay/Lesbian",
"B" => "BiSexual"
);

if($type == 1) { echo $arrVals[$chk]; return; }

echo "<option value=''><-- Select --></option>\n";
foreach($arrVals as $abbr=>$val) {
if($abbr == $chk) {
echo "<option value='" . $abbr . "' selected>" . $val . "</option>\n";
} else {
echo "<option value='" . $abbr . "'>" . $val . "</option>\n";
}
}
}

function getDOB_Date($chk) {
echo "<option>--</option>\n";
for($i=1; $i<=31; $i++) {
if($chk == $i) {
echo "<option value=$i selected>$i</option>\n";
} else {
echo "<option value=$i>$i</option>\n";
}
}
}

function getDOB_Month($chk) {
echo "<option>--</option>\n";
$arr_Month = array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
$i = 1;
foreach ($arr_Month as $temp) {
if($chk == $i) {
echo "<option value=$i selected>$temp</option>\n";
} else {
echo "<option value=$i>$temp</option>\n";
}
$i++;
}
}

function getDOB_Year($chk) {
echo "<option>--</option>\n";
for($i=1960; $i<=1999; $i++) {
if($chk == $i) {
echo "<option value=$i selected>$i</option>\n";
} else {
echo "<option value=$i>$i</option>\n";
}
}
}

function getDBConnection() {
global $hostName, $databaseName, $userName, $password, $con;
// Get a persistent database connection
if(!($link = mysql_pconnect($hostName, $userName, $password))) {
return new Function_Result("Internal Error: Could not open database connection", null);
}
// Select mysql database
if(!mysql_select_db($databaseName, $link)) {
return new Function_Result("Internal Error: Could not select database",null);
}
return new Function_Result(null, $link);
}

function logout() {
global $uid;
global $username;
global $isAuthenticated;
global $userType;
session_start();

global $REMOTE_ADDR;

// Get DB Connection
$funcResult = getDBConnection();
if($funcResult->returnValue == null) {
return $funcResult;
}
$link = $funcResult->returnValue;
$updStmt = "UPDATE nq_userlog SET ul_online_status=0 ,ul_last_logout=now() ,ul_last_logon_ip='$REMOTE_ADDR' WHERE ul_ulid='$uid'";
if(!mysql_query($updStmt, $link)) {
return new Function_Result("Cannot update log.", null);
}
session_unregister("uid");
session_unregister("username");
session_unregister("isAuthenticated");
session_unregister("userType");

return new Function_Result(null, true);
}

class Function_Result
{
var $errorMessage;
var $returnValue;

function Function_Result($errMessage, $retValue) {
$this->errorMessage = $errMessage;
$this->returnValue = $retValue;
}
}

function validateusername($u_username){
$u_username = trim($u_username);

$funcResult = getDBConnection();
if($funcResult->returnValue == null) {
return $funcResult;
}
$link = $funcResult->returnValue;
$selectUserStmt = "SELECT u_uid,u_password,u_email FROM nq_user WHERE u_username='$u_username'";

if(!($result = mysql_query($selectUserStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query", null);
}
if(!($row = mysql_fetch_object($result))) {
return new Function_Result("Invalid UserName", null);
}
return new Function_Result(null,$row);
}

function dynamicpictures() {

$funcResult = getDBConnection();
if($funcResult->returnValue == null) {
return $funcResult;
}
$link = $funcResult->returnValue;
$selectUserStmt = "SELECT * FROM nq_pictures LEFT JOIN nq_user on pic_uid=u_uid WHERE pic_approval=1 AND pic_folder=0 AND pic_adult=0 AND pic_filename!='' AND pic_default=1 ORDER BY pic_date DESC LIMIT 5";

if(!($result = mysql_query($selectUserStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query", null);
}
return new Function_Result(null,$result);
}

function msgStatus($uid) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT COUNT(*) FROM nq_message WHERE msg_to_uid=$uid AND msg_status=0";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
if(!($row = mysql_fetch_row($result))) {
return new Function_Result("Internal Error: Could not assign record", null);
}
return new Function_Result(null, $row);
}

function getContact_country() {
$query = "SELECT c_cname FROM nq_country ORDER BY c_cname";
$results = mysql_query($query);
echo "<option value=''><-- Select --></option>";
while($row = mysql_fetch_object($results)) {
echo "<option value='$row->c_cname'>$row->c_cname</option>\n";
}
}

function getState($ud_cid) {

if ($ud_cid==130) { $qry = "limit 0, 54 " ;}
elseif ($ud_cid==127) { $qry= "limit 55, 66"; }
else {
echo "<option value=''><-- Not Applicable --></option>";
return; }

$query = "SELECT s_sid, s_sname FROM nq_state $qry" ;
echo "<option value=''><-- Please Choose --></option>";
$results = mysql_query($query);
while($row = mysql_fetch_object($results)) {
echo "<option value='$row->s_sid'>$row->s_sname</option>\n";
}
}

function selectedstates($ud_cid, $chk) {

if ($ud_cid==130) { $qry = "limit 0, 54 " ;}
elseif ($ud_cid==127) { $qry= "limit 55, 66"; }
else {
echo "<option value=''><-- Not Applicable --></option>";
return; }

$query = "SELECT s_sid, s_sname FROM nq_state $qry" ;
echo "<option value=''><-- Please Choose --></option>";
$results = mysql_query($query);
while($row = mysql_fetch_object($results)) {
if($chk == $row->s_sid) {
echo "<option value='$row->s_sid' selected>$row->s_sname</option>\n";
} else {
echo "<option value='$row->s_sid'>$row->s_sname</option>\n";
}
}
}

function getindexpagecontent($indexpageid) {
$funcResult = getDBConnection();
if($funcResult->returnValue == null) {
return $funcResult;
}
$link = $funcResult->returnValue;
$selectStmt = "Select * from nq_config where con_conid='$indexpageid'";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query $selectStmt", null);
}
return new Function_Result(null,$result);
}

function getTop_latest_news($limit=2) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt_Top_latest_news = "SELECT *, CONCAT(LEFT(nwa_content, 90), '...') AS nwa_content FROM nq_newsarticle WHERE (nwa_topstories in (1,2,3)) and nwa_status='1' ORDER BY nwa_topstories ASC limit 0,". $limit;
if(!($result_Top_latest_news = mysql_query($selectStmt_Top_latest_news, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt_Top_latest_news", null);
}
return new Function_Result(null, $result_Top_latest_news);
}

function Display_Admin_lst_evt() {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;

$selectStmt_lst_evt = "SELECT *, DATE_FORMAT(evt_from_date, '%b %d, %Y %h:%i %p') AS evt_fromdate, DATE_FORMAT(evt_to_date, '%b %d, %Y %h:%i %p') AS evt_todate FROM nq_events WHERE evt_uid=0 order by evt_evtid desc limit 0,2";

if(!($result_lst_evt = mysql_query($selectStmt_lst_evt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query $result_lst_evt", null);
}
return new Function_Result(null, $result_lst_evt);
}

function get_News_links($name,$limit) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt_Newslink = "SELECT *, CONCAT(LEFT(nwa_content, 50), '...') AS content, CONCAT(LEFT(nwa_title, 50), '...') AS title FROM nq_newsarticle left join nq_newscategory on nwc_nwcid=nwa_nwcid WHERE nwc_name='$name' order by nwa_createdate desc limit 0 , ". $limit;
if(!($result_Newslink = mysql_query($selectStmt_Newslink, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt_Newslink", null);
}
return new Function_Result(null, $result_Newslink);
}

function getNightlife_title() {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_nightlife WHERE nl_parent !=0 ORDER BY nl_lastupdated desc";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getNightlife_details($nl_nlid) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_nightlife where nl_parent !=0 AND nl_nlid = '$nl_nlid'";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getNightlife_homepage_details($nl_nlid) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_nightlife where nl_parent !=1 AND nl_nlid = '$nl_nlid'";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getNightlife_title_topten() {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_nightlife where nl_parent !=0 ORDER BY nl_lastupdated desc limit 0,10";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getSection($id) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_section where sec_secid='$id'";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getTop_sectionStories($id) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_sectionstory WHERE ssty_secid='$id' and ssty_position !='0' ORDER BY ssty_sstyid desc limit 0,3";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getTopLink($id) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_sectionlinks WHERE slnk_secid='$id' ORDER BY slnk_lastupdated desc";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getAllStories($id) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_sectionstory WHERE ssty_secid='$id' ORDER BY ssty_lastupdated desc";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getStorydetails($id) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_sectionstory where ssty_sstyid='$id'";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getAllLink($id) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_sectionlinks left join nq_section on sec_secid=slnk_secid WHERE slnk_secid='$id' ORDER BY slnk_slnkid desc";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getLinkdetails($id) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_sectionlinks WHERE slnk_slnkid='$id'";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getTopBeaches($limit) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
if ($limit == "") {
$selectStmt = "SELECT * FROM nq_beaches where bch_position !='0' order by bch_position asc";
} else {
$selectStmt = "SELECT * FROM nq_beaches where bch_position !='0' order by bch_position asc limit 0, $limit";
}

if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getBeachDetails($id) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_beaches where bch_bchid ='$id'";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getTopBeachsafety($limit) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
if ($limit == "") {
$selectStmt = "SELECT * FROM nq_beachsafety where bs_position !='0' order by bs_position asc";
} else {
$selectStmt = "SELECT * FROM nq_beachsafety where bs_position !='0' order by bs_position asc limit 0, $limit";
}

if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getBeachSafetyDetails($id) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_beachsafety where bs_bsid ='$id'";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getTopSectionCategory($id) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_sectioncategory WHERE scat_secid='$id' and scat_position !='0' ORDER BY scat_position asc";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getAllSectionCategory($id) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_sectioncategory left join nq_section on scat_secid=sec_secid WHERE scat_secid='$id' and scat_position !=0 ORDER BY scat_position asc";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getAllSectionArticle($id,$cat) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_sectionlinks left join nq_section on sec_secid=slnk_secid WHERE slnk_secid='$id' and slnk_scatid='$cat' ORDER BY slnk_slnkid desc";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}
return new Function_Result(null, $result);
}

function getUserTypeCheck($name) {
$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;
$selectStmt = "SELECT * FROM nq_user where u_username='$name'";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}

if(!($row = mysql_fetch_object($result))) {
return new Function_Result("Could not assign records.", null);
}
return new Function_Result(null, $row);
}

function getBigAdd($secid) {

$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;

$selectStmt = "SELECT count(*) as rcount FROM nq_assingbanner LEFT JOIN nq_banner ON ban_banid=ab_banid WHERE ban_bannertype=1 AND ab_secid='".$secid."'";
if(!($result = mysql_query($selectStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query. <BR>$selectStmt", null);
}

$rowad = mysql_fetch_object($result);
if ($rowad->rcount > 0) {
$rd = rand(0,$rowad->rcount)-1;
if($rd < 0){
$rd = 0;
}

$sqlad = "SELECT * FROM nq_assingbanner LEFT JOIN nq_banner ON ban_banid=ab_banid WHERE ban_bannertype=1 AND ab_secid='".$secid."' limit $rd,1";
$resultad = mysql_query($sqlad);

if(mysql_num_rows($resultad) > 0) {

$rowad = mysql_fetch_object($resultad);
if($rowad->ban_target == "n"){
$target = "_blank";
} else {
$target = "_self";
}
$ret_value="<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr height=\"18\"><td height=\"62\" align=\"center\" valign=\"middle\"><a href =\"".$rowad->ban_page."\" target=\"".$target."\"><img src=\"";
if($rowad->ban_image !='') { $ret_value.="/admin/images/ads/".$rowad->ban_image; } else { $ret_value.=$rowad->ban_url; }
$ret_value.="\" border=\"0\" alt=\"".$rowad->ban_alttext."\"></a></td>
</tr>
</table>";
}
return new Function_Result(null,$ret_value);
} else {
return new Function_Result(null,"<br>");
}
}

function getTwoSmallAdd($secid) {

$funcResult = getDBConnection();
if(!$funcResult->returnValue) {
sendErrorPage($funcResult->errorMessage);
}
$link = $funcResult->returnValue;

$sqlad = "SELECT * FROM nq_assingbanner LEFT JOIN nq_banner ON ban_banid=ab_banid WHERE ban_bannertype=2 AND ab_secid='".$secid."' order by rand() limit 0,2";
$resultad = mysql_query($sqlad);

$ret_value="<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
while($rowad = mysql_fetch_object($resultad)) {
if($rowad->ban_target == "n"){
$target = "_blank";
} else {
$target = "_self";
}
$ret_value.="<tr><td height=\"20\" valign=\"top\"><img src=\"/images/spcr.gif\" width=\"1\" height=\"1\"></td></tr><tr><td valign=\"top\"><a href=\"".$rowad->ban_page."\" target=\"".$target."\"><img src=\"";
if($rowad->ban_image !='') { $ret_value.="/admin/images/ads/".$rowad->ban_image; } else { $ret_value.=$rowad->ban_url; }
$ret_value.="\" border=\"0\" alt=\"".$rowad->ban_alttext."\"></a></td></tr>";
}
$ret_value.="</table>";
return new Function_Result(null,$ret_value);
}

?>
And finally session

Code: [Select]
<?
function setUserSession($u_uid, $u_username, $type) {
global $uid;
global $username;
global $isAuthenticated;
global $userType;
session_start();
session_register("uid");
session_register("username");
session_register("isAuthenticated");
session_register("userType");
$uid = $u_uid;
$username = $u_username;
$isAuthenticated = true;
$userType = $type;
return true;
}
/***** SESSION HANDLING - ENDS HERE *****/

function authenticateUser($u_username, $u_password, $chkRemember) {
$u_username = trim($u_username);
$u_password = trim($u_password);
$chkRemember=($chkRemember);

if(($u_username == "") || ($u_password == "")) {
sendErrorPage("The username/password you have entered is invalid. Please try again.");
exit;
}
//$cryptPassword = crypt($u_password, CRYPT_STD_DES);

// Get DB Connection
$funcResult = getDBConnection();
if($funcResult->returnValue == null) {
return $funcResult;
}
$link = $funcResult->returnValue;
$selectUserStmt = "SELECT u_uid, u_username, u_type FROM nq_user WHERE u_username='$u_username' AND u_password='$u_password' and u_status!='U'";

if(!($result = mysql_query($selectUserStmt, $link))) {
return new Function_Result("Internal Error: Could not execute SQL Query", null);
}
if(!($row = mysql_fetch_row($result))) {
return new Function_Result("Invalid UserName/Password", null);
} else {

if ($chkRemember==1){
setcookie("newquay",$row[1],time()+60*60*24*30);
} else {
setcookie("newquay","",time()+60*60*24*30);
}

setUserSession($row[0], $row[1], $row[2]);
global $REMOTE_ADDR;
$updStmt = "UPDATE nq_userlog SET ul_last_updated=now(), ul_last_logon_ip='$REMOTE_ADDR', ul_online_status=1 WHERE ul_ulid=$row[0]";
if(!mysql_query($updStmt, $link)) {
return new Function_Result("Cannot update log.<BR>$updStmt", null);
}
return new Function_Result($row[2], true);
}
}

?>

The site isn't doing anything when I enter username and password, just bringing me back to the same page. Also I am unable to access the areas of the site that are only for registered members. Any help here would be greatly apprecaited, I have spent days on this now. Thanks in advance!

There are a few other bugs that need ironing out too. You can view the site at www.newquayuncovered.com

Php Is Not Connecting To Mysql Database?

Similar Tutorials

View Content

For some reason Im not able to connect to mysql database, when i fill in the form and select search, it just basically refreshes the page but does not come up with no error messages or any results from my database. any help is appreciated.

HTML Code

Code: [Select]

<table id="tb1">
<tr>
<td><p class="LOC">Location:</p></td>
<td><div id="LC">
<form action="insert.php" method="post">
<select multiple="multiple" size="5" style="width: 150px;" >
<option>Armley</option>
<option>Chapel Allerton</option>
<option>Harehills</option>
<option>Headingley</option>
<option>Hyde Park</option>
<option>Moortown</option>
<option>Roundhay</option>
</select>
</form>
</div>
</td>

<td><p class="PT">Property type:</p></td>
<td><div id="PS">
<form action="insert.php" method="post">
<select name="property type" style="width: 170px;">
<option value="none" selected="selected">Any</option>
<option value="Houses">Houses</option>
<option value="Flats / Apartments">Flats / Apartments</option>
</select>
</form>
</div>
</td><td>
<div id="ptype">
<form action="insert.php" method="post">
<input type="radio" class="styled" name="ptype" value="forsale"/> For Sale

<p class="increase">
<input type="radio" class="styled" name="ptype" value="forrent"/> To Rent
</p>
<p class="increase">
<input type="radio" class="styled" name="ptype" value="any"/> Any
</p>
</form>
</div>
</td>
</tr>

</table>

<div id="table2">
<table id="NBtable">
<tr>
<td><p class="NBS">Number of bedrooms:</p></td>
<td><div id="NB">
<form action="insert.php" method="post">
<select name="number of bedrooms">
<option value="none" selected="selected">No Min</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select> to

<select name="number of bedrooms">
<option value="none" selected="selected">No Max</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</form>
</div>
</td>

<td><p class="PR">Price range:</p></td>
<td><div id="PR">
<form action="insert.php" method="post">
<select name="price range">
<option value="none" selected="selected">No Min</option>
<option value="50,000">50,000</option>
<option value="60,000">60,000</option>
<option value="70,000">70,000</option>
<option value="80,000">80,000</option>
<option value="90,000">90,000</option>
<option value="100,000">100,000</option>
<option value="110,000">110,000</option>
<option value="120,000">120,000</option>
<option value="130,000">130,000</option>
<option value="140,000">140,000</option>
<option value="150,000">150,000</option>
<option value="160,000">160,000</option>
<option value="170,000">170,000</option>
<option value="180,000">180,000</option>
<option value="190,000">190,000</option>
<option value="200,000">200,000</option>
<option value="210,000">210,000</option>
<option value="220,000">220,000</option>
<option value="230,000">230,000</option>
<option value="240,000">240,000</option>
<option value="250,000">250,000</option>
<option value="260,000">260,000</option>
<option value="270,000">270,000</option>
<option value="280,000">280,000</option>
<option value="290,000">290,000</option>
<option value="300,000">300,000</option>
<option value="310,000">310,000</option>
<option value="320,000">320,000</option>
<option value="330,000">330,000</option>
<option value="340,000">340,000</option>
<option value="350,000">350,000</option>
</select> to

<select name="price range">
<option value="none" selected="selected">No Max</option>
<option value="50,000">50,000</option>
<option value="60,000">60,000</option>
<option value="70,000">70,000</option>
<option value="80,000">80,000</option>
<option value="90,000">90,000</option>
<option value="100,000">100,000</option>
<option value="110,000">110,000</option>
<option value="120,000">120,000</option>
<option value="130,000">130,000</option>
<option value="140,000">140,000</option>
<option value="150,000">150,000</option>
<option value="160,000">160,000</option>
<option value="170,000">170,000</option>
<option value="180,000">180,000</option>
<option value="190,000">190,000</option>
<option value="200,000">200,000</option>
<option value="210,000">210,000</option>
<option value="220,000">220,000</option>
<option value="230,000">230,000</option>
<option value="240,000">240,000</option>
<option value="250,000">250,000</option>
<option value="260,000">260,000</option>
<option value="270,000">270,000</option>
<option value="280,000">280,000</option>
<option value="290,000">290,000</option>
<option value="300,000">300,000</option>
<option value="310,000">310,000</option>
<option value="320,000">320,000</option>
<option value="330,000">330,000</option>
<option value="340,000">340,000</option>
<option value="350,000">350,000</option>

</select>
</form>
</div>
</td>

</tr>

</table>

PHP Code
Code: [Select]

<?php
$server = "";      // Enter your MYSQL server name/address between quotes
$username = "";    // Your MYSQL username between quotes
$password = "";    // Your MYSQL password between quotes
$database = "";    // Your MYSQL database between quotes

$con = mysql_connect($server, $username, $password);       // Connect to the database
if(!$con) { die('Could not connect: ' . mysql_error()); }  // If connection failed, stop and display error

mysql_select_db($database, $con);  // Select database to use

$result = mysql_query("SELECT * FROM tablename");  // Query database

while($row = mysql_fetch_array($result)) {     // Loop through results
  echo "<b>" . $row['id'] . "</b><br>\n";      // Where 'id' is the column/field title in the database
  echo $row['location'] . "<br>\n";            // Where 'location' is the column/field title in the database
  echo $row['property_type'] . "<br>\n";       // as above
  echo $row['number_of_bedrooms'] . "<br>\n";  // ..
  echo $row['purchase_type'] . "<br>\n";       // ..
  echo $row['price_range'] . "<br>\n";         // ..
}

mysql_close($con);  // Close the connection to the database after results, not before.
?>

To connect to my database I an entering mysql database details just at the first top lines server,username,password and database. is thats correct?

Thank You for your help in adavance.

Connecting To Mysql On A Custom Port?

Similar Tutorials

View Content

Hi,

I'm trying to connect to a database on a port other than 3306 to create a database. Here's my connect code:

$connection = new MySQLi($host,$user,$pass)()

But according to the PHP website it says I can lay the code out like so:

new MySQLi($host,$user,$pass,$database,$port)()

But how do I specify the port without the database? I've tried just "" as the database but the connection still fails.

Any help would be much appreciated.

Connecting To Remote Mysql Database

Similar Tutorials

View Content

Good day:

Im doing a login page for a website, but the mysql database is on a server computer and not on the hosting account. It gives me a cannot select db message. Im using the IP address as the host. This is the script:

Code: [Select]
<?php
ob_start();
$host="000.000.000.000"; // Host name
$username="ert4567"; // Mysql username
$password="xxxxxxxx"; // Mysql password
$port="3306";
$db_name="files"; // Database name
$tbl_name="users"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password", "$port")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>

Any help will be appreciated.

Using Php Oop Concept Connecting To Mysql Database

Similar Tutorials

View Content

Hi
I have been getting to know PHP OOP concepts, and I started trying by writing a class and handful of functions to connect to the database and retrieve the information from the tables. I went through previous posts having similar titles, but most of them have written using mysql functions and I am using mysqli functions. I want somebody to through this simple script and let me know where the mistake is.

This is my class.connect.php:

Code: [Select]
<?php

    class mySQL{
        var $host;
        var $username;
        var $password;
        var $database;
        public $dbc;

        public function connect($set_host, $set_username, $set_password, $set_database)
        {
            $this->host = $set_host;
            $this->username = $set_username;
            $this->password = $set_password;
            $this->database = $set_database;

            $this->dbc = mysqli_connect($this->host, $this->username, $this->password, $this->database) or die('Error connecting to DB');
        }

        public function query($sql)
        {
            return mysqli_query($this->dbc, $sql) or or die('Error:'.mysqli_error($this->dbc).', query: '.$sql);
        }

        public function fetch($sql)
        {
            $array = mysqli_fetch_array($this->query($sql));
            return $array;
        }

        public function close()
        {
            return mysqli_close($this->dbc);
        }
    }
    ?>

This is my index.php:

Code: [Select]
<?php
        require_once ("class.connect.php");

        $connection = new mySQL();

        $connection->connect('localhost', 'myDB', 'joker', 'names_list');
        $myquery = "SELECT * FROM list";
        $query = $connection->query($myquery);

        while($array = $connection->fetch($query))
        {
            echo $array['first_name'] . '<br />';
            echo $array['last_name'] . '<br />';
        }

        $connection->close();
?>

I am getting a error message "Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1, query: 1"

Any idea why this is happening?

Thanks

Problem Connecting To Mysql Db Using Included Connect File

Similar Tutorials

View Content

So, I feel like I am running up against some beginner's problem. So I am hoping this should be an easy fix. I have had a bit of trouble finding the right search terms to find a fix for this, so I am sorry ahead of time if there is already a post on this, please point me towards it.

I am running PHP 4.4.9 and MySQL client API 4.1.22, in case that is of use.

I can get the following to work and provide the appropriate output. Note in this first case that the connection info is in the same file as the call to it.

<?php
// set database access information
define ('DB_USER', "*****");
define ('DB_PASSWORD', "*****");
define ('DB_HOST', "localhost");
define ('DB_NAME', "content");

// database connection protocol
$dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) or die ('Could not connect to MySQL: Error #' . mysql_errno() . ' - ' . mysql_error());

mysql_select_db (DB_NAME) or die ('Could not connect to MySQL: Error #' . mysql_errno() . ' - ' . mysql_error());

$query = "SELECT content_element_title FROM content_main";

$result = mysql_query ($query);

while ($row = mysql_fetch_array ($result, MYSQL_ASSOC))

{

echo ("<p>" . $row[content_element_title] . "</p>");

}
unset($dbc);

?>

My problem is, however, that when I separate the connection info into a separate file, I have been having problems. I think I got past the method calling the connection info not being able to see it, but now it isn't returning anything - should be returning

"<p>" . $row[content_element_title] . "</p>",

for which there are three rows in the db.

Here is what the two files look like separated:

kinnect.php

<?php

// set database access information
define ('DB_USER', '*****');
define ('DB_PASSWORD', '*****');
define ('DB_HOST', 'localhost');
define ('DB_NAME', 'content');

//// database connection protocol
$dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) or die ('Could not connect to MySQL: Error #' . mysql_errno() . ' - ' . mysql_error());

mysql_select_db (DB_NAME, $dbc) or die ('Could not connect to MySQL: Error #' . mysql_errno() . ' - ' . mysql_error());

?>
file.php

<?php

require_once ("correctpathto/kinnect.php");

$query = "SELECT content_element_title FROM content_main";

$result = mysql_query ($query, $dbc);

while ($row = mysql_fetch_array ($result, MYSQL_ASSOC))

{

echo ("<p>" . $row[content_element_title] . "</p>");

}
unset($dbc);
?>

So what am I doing wrong? I am getting these error messages now.

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /Users/max/Sites/rdbase-llc/preliminary/connecttroubleshoot.php on line 18

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /Users/max/Sites/rdbase-llc/preliminary/connecttroubleshoot.php on line 20

Thanks ahead of time for any help!

Member Login Not Connecting To Mysql Table Correctly, Help Would Be Appreciated!

Similar Tutorials

View Content

Hey there, First time using MySQL database to connect to a member login. I have a paid subscription site through ccbill which they add the username and logins to. I have setup a database, username and password as well as a table that I have connected correctly "I believe" to my website but get this message: warning: MySQL-fetch_array()expects parameter 1 to be resource, Boolean given in /home.... My table I have setup just has username and password to authenticate the users, which I was told by ccbill is all I need. Maybe I need authentication 1 or 0 etc. Any help on this would be amazing. Spent hours trying to figure this out but nothing. Thanks for your time. Steven

Printing Simultaneously On Two Network Printers

Similar Tutorials

View Content

Hello,

Greetings!

I have php application for restaurant, basically there are two types of orders Kitchen Items and Bar items. A cashier enters a order from customers from computer A (say). We have two computers in kitchen, Computer B and in Bar, Computer C. When cashier from computer A clicks a button, depending upon the order type i need to print a chit on Computer B and/or Computer C. COmputer A, B, C are in same network. All computers have laser printer which can print any type of content.

Well i tried to search the forum, i couldn't find anything that would be of my help. Can anyone tell me what would be the starting point for this??

Thanks
watsmyname

Reading Several Remote Urls Simultaneously

Similar Tutorials

View Content

I'm trying to create a simple search engine bot and have found the biggest issue is that of performance, it takes several hours to index all the links and ideally I need to run it once a day, the bottleneck occurs when pulling the data from the remote urls in terms of network transfer time. This could obviously be reduced massively if I could read from several url's simultaneously. Does anyone know how I could do this. I'm aware that in PHP5 there is thread functionality which may solve the problem but this is only available from the CLI. I heard that it could be done with CURL without having to go down the threaded route, does anyone know how nthis can be done or know of any examples on the net that I could look at?

As a cheeky follow up, I was also thinking a potential problem could be the script getting out of hand and opening too many connections and I don't to cause a DOS attack! Is there a way that the number of connections could be limited to 10 for example. Is there a way of detecting when a CURL connection has finished reading a file so that a connection manager class could then start the next connection asap?

Thanks for any helpn people, I've been looking for this stuff for days!!