connection to two database and query for if data is recorded

[Diipora]

Hi

I want to make a time reservation system. And for that I have one form, which is connected to two databases on the same host. Form gets data from one(datetime table on calendar db) and after user submitted data stores on another one(is_availble table on college db).

Every thing work good. I use checkboxs as calendar, so each checkbox is one time, and I want that make checkbox unavailble if it is has been selected once!

I use this cods but it doesn't work. Could anyone tell me where is the problem

this is how my form looks like:

And this is my code for the first checkbox:

 
 
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("college",$con);
$v_datetime = 'datetime';
 
 
mysql_select_db("calendar", $con);
$result = mysql_query("SELECT * FROM datetime  ORDER BY id DESC LIMIT 1");
while($row = mysql_fetch_array($result))
  {
 
 
 
echo"<div class='month' align='center'><input type='hidden' name='month' value='".$row['month']."' ><l>".$row['month']."</l></div>";
 
 
//---------------------------------- choeckbox 1(bookable time 1)------------------------\\
 
$sql="SELECT college FROM is_availble WHERE datetime=".$v_datetime;
$r = mysql_query($sql);
echo"<div  class='box'>
<div class='boxbut'>";
if ($v_datetime == "$row[day1]   $row[time1]") {
 
 echo"
<d>". $row['day1'] ,"</d><br/><t>". $row['time1'] ."</t> <br/>is booked";
}
else{
echo"<input type='radio' name='datetime' value='". $row['day1']."&nbsp;&nbsp;&nbsp;".$row['time1']."'>
<d>". $row['day1'] ,"</d><br/><t>". $row['time1'] ."</t>
 
</div>
</div>";
 
 }
 
 

Regards

[Dormilich]

the problem is that you need two connections because mysql_select_db() only changes the default database on the given connection. hence you can’t use two databases on one connection.

additionally, never connect as root, that’s for DB administration. should someone find an exploit (SQL Injection), you’re doomed. a restricted user may only select, but root can alter, delete and create.

note, with PDO/MySQLi this would be easier to handle:

$college = new PDO("mysql:host=localhost;dbname=college", $user, $pass);
$calendar= new PDO("mysql:host=localhost;dbname=calendar", $user, $pass);
 
// using
$result1 = $college->query($sql_1);
// ...
 
$result2 = $calendar->query($sql_2);
foreach ($result2 as $row)
{
    // ...
}

[Diipora]

Thank you for you help

I have now this code, actually making connection is still not possible. I also tried your code, but no reasult!

$host='localhost';
$user='valvoja';
$passoerd='test123';
$con = mysql_connect($host,$user,$password);
$con2=mysql_connect($host,$user,$password);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("college",$con);
$v_datetime = 'datetime';
 
 
mysql_select_db("calendar", $con2);
$result = mysql_query("SELECT * FROM datetime  ORDER BY id DESC LIMIT 1");
while($row = mysql_fetch_array($result))
  {
    $sql="SELECT college FROM is_availble WHERE datetime=".$v_datetime;
$r = mysql_query($sql);
echo"<div  class='box'>
<div class='boxbut'>";
if ($v_datetime == "$row[day1]   $row[time1]") {
 
 echo"
<d>". $row['day1'] ,"</d><br/><t>". $row['time1'] ."</t> <br/>is booked";
}
else{
echo"<input type='radio' name='datetime' value='". $row['day1']."&nbsp;&nbsp;&nbsp;".$row['time1']."'>
<d>". $row['day1'] ,"</d><br/><t>". $row['time1'] ."</t>
 
</div>
</div>";
 
 }
 
 

Actually the most importand thing, that I want to do, is that query, which check if checkbox's value exist on database.

thanx