Help Please - Convert from MySQL to ODBC

cheese

Good morning all,

I know that is code is probably not very good, but it does produce what I want at the end....... a graph......

It was written to work with MySQL, but now I need to get it to work with ODBC connections. I have struggled along, but really don't think I am getting very far.

Obviously it is very repetative and once the first section works it can all be converted to work.

Any pointers would be appreciated.

Thanks,

Neil

Code below;

<html><head><LINK REL="stylesheet" href="main.css" type="text/css"></head>
<body>
<CENTER>
<?php

require("./graphs/html_graphs.php");
    $link = mysql_connect("localhost", "root", "")
        or die("Could not connect");
    mysql_select_db("birding") or die("Could not select database");

$query = "SELECT * FROM birdsightingstable WHERE `EnglishBirdName` = '$_GET[EnglishName]' AND MID(`DateOfRecord`,6,2) ='01'"; 
$query_result_handle = mysql_query ($query)

or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_jan = mysql_num_rows ($query_result_handle)
or 0;

mysql_free_result($query_result_handle);

$query = "SELECT * FROM birdsightingstable WHERE `EnglishBirdName` = '$_GET[EnglishName]' AND MID(`DateOfRecord`,6,2) ='02'"; 
$query_result_handle = mysql_query ($query)

or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_feb = mysql_num_rows ($query_result_handle)
or 0;

mysql_free_result($query_result_handle);

$query = "SELECT * FROM birdsightingstable WHERE `EnglishBirdName` = '$_GET[EnglishName]' AND MID(`DateOfRecord`,6,2) ='03'"; 
$query_result_handle = mysql_query ($query)

or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_mar = mysql_num_rows ($query_result_handle)
or 0;

mysql_free_result($query_result_handle);

$query = "SELECT * FROM birdsightingstable WHERE `EnglishBirdName` = '$_GET[EnglishName]' AND MID(`DateOfRecord`,6,2) ='04'"; 
$query_result_handle = mysql_query ($query)

or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_apr = mysql_num_rows ($query_result_handle)
or 0;

mysql_free_result($query_result_handle);

$query = "SELECT * FROM birdsightingstable WHERE `EnglishBirdName` = '$_GET[EnglishName]' AND MID(`DateOfRecord`,6,2) ='05'"; 
$query_result_handle = mysql_query ($query)

or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_may = mysql_num_rows ($query_result_handle)
or 0;

mysql_free_result($query_result_handle);

$query = "SELECT * FROM birdsightingstable WHERE `EnglishBirdName` = '$_GET[EnglishName]' AND MID(`DateOfRecord`,6,2) ='06'"; 
$query_result_handle = mysql_query ($query)

or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_jun = mysql_num_rows ($query_result_handle)
or 0;

mysql_free_result($query_result_handle);

$query = "SELECT * FROM birdsightingstable WHERE `EnglishBirdName` = '$_GET[EnglishName]' AND MID(`DateOfRecord`,6,2) ='07'"; 
$query_result_handle = mysql_query ($query)

or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_jul = mysql_num_rows ($query_result_handle)
or 0;

mysql_free_result($query_result_handle);

$query = "SELECT * FROM birdsightingstable WHERE `EnglishBirdName` = '$_GET[EnglishName]' AND MID(`DateOfRecord`,6,2) ='08'"; 
$query_result_handle = mysql_query ($query)

or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_aug = mysql_num_rows ($query_result_handle)
or 0;

mysql_free_result($query_result_handle);

$query = "SELECT * FROM birdsightingstable WHERE `EnglishBirdName` = '$_GET[EnglishName]' AND MID(`DateOfRecord`,6,2) ='09'"; 
$query_result_handle = mysql_query ($query)

or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_sep = mysql_num_rows ($query_result_handle)
or 0;

mysql_free_result($query_result_handle);

$query = "SELECT * FROM birdsightingstable WHERE `EnglishBirdName` = '$_GET[EnglishName]' AND MID(`DateOfRecord`,6,2) ='10'"; 
$query_result_handle = mysql_query ($query)

or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_oct = mysql_num_rows ($query_result_handle)
or 0;

mysql_free_result($query_result_handle);

$query = "SELECT * FROM birdsightingstable WHERE `EnglishBirdName` = '$_GET[EnglishName]' AND MID(`DateOfRecord`,6,2) ='11'"; 
$query_result_handle = mysql_query ($query)

or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_nov = mysql_num_rows ($query_result_handle)
or 0;

mysql_free_result($query_result_handle);

$query = "SELECT * FROM birdsightingstable WHERE `EnglishBirdName` = '$_GET[EnglishName]' AND MID(`DateOfRecord`,6,2) ='12'"; 
$query_result_handle = mysql_query ($query)

or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db');

$num_dec = mysql_num_rows ($query_result_handle)
or 0;

mysql_free_result($query_result_handle);

$names   = array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
$values  = array($num_jan+1, $num_feb+1, $num_mar+1, $num_apr+1, $num_may+1, $num_jun+1, $num_jul+1, $num_aug+1, $num_sep+1, $num_oct+1, $num_nov+1, $num_dec+1);
$largest = max($values)+1;
$totals  = $num_jan+$num_feb+$num_mar+$num_apr+$num_may+$num_jun+$num_jul+$num_aug+$num_sep+$num_oct+$num_nov+$num_dec;

How to write a horizontal graph

#for ($i = 0; $i <= 11; $i++) {
#print "<TABLE WIDTH=325 CLASS=NOBORDER><TR><TD WIDTH=75><FONT SIZE=-2>";
#print $names[$i];
#print "</FONT></TD><TD><TABLE CLASS=NOBORDER><TR><TD BGCOLOR=#0000FF WIDTH=";
#if ($values[$i] > 1) print $values[$i]/$largest*250;
#if ($values[$i] < 2) print $values[$i];
#print " HEIGHT=10></TD></TR></TABLE></TD></TR>";
#}
#print "</TABLE>";
#print "<P><FONT SIZE=-2 COLOR=BLUE>Number of records = ";
#print $totals;
#print "</FONT></P>";

How to write a vertical graph

print "<TABLE CLASS=NOBORDER><TR>";
for ($i = 0; $i <= 11; $i++) {
print "<TD CLASS=BOTTOM><TABLE CLASS=NOBORDER><TR><TD BGCOLOR=#0000ff WIDTH=22 HEIGHT=";
if ($values[$i] > 1) print $values[$i]/$largest*250;
if ($values[$i] < 2) print $values[$i];
print "></TD></TR></TABLE></TD>";
}
print "</TR><TR>";
for ($i = 0; $i <= 11; $i++) {
print "<TD><FONT SIZE=-1>";

$month = substr($names[$i], 0, 3);

print $month;
print "</FONT></TD>";
}
print "</TR></TABLE>";
print "<P ALIGN=CENTER>Sightings by month<BR><FONT SIZE=-2 COLOR=BLUE>Number of records = ";
print $totals;
print "</FONT></P>";
?>
</body>
</html>

kevinsequeira

well no easy way of doing it, since u know how to do it on mysql all u need to do is to get the corresponding functions for odbc.

take a look here and u will find them

http://ca.php.net/manual/en/function.odbc-connect.php

reg
kevin

cheese

🙁
Just when I got the hang of one way of doing I have to learn another..... it's not easy for us 40+ lot..... brin cells are not what they were!!

Thanks anyway. I will give it a look over the weekend.

I think I shall clear up, go home for the weekend and go and enjoy some time with the family.

Good weekend to one and all.

Neil.

kevinsequeira

its pretty easy, u just need to replace the mysql function names with the odbc ones
eg
mysql_connect() --> odbc_connect()

there might be slight variations but the manual will help u out

once u get started and face problems post and we could help u out.

reg
kevin