Extracting data from relational databases

Wozzer · Jul 9, 2012, 10:02 PM

Hi,

New to phpmyadmin, PHP, MySQL, etc - so please excuse me if the answer to the question is simple.

I've built a database using XAMPP called "evidence db". Within that database, I have a table called "m cases". This table has 11 columns.

I currently have the following code:

Code:

<html>
<head>
<title>Search data</title>
</head>
<body>
<table>
  <tr>
    <td align="center">EMPLOYEES DATA</td>
  </tr>
  <tr>
    <td>
      <table border="1">
      <tr>
        <td>Case ID</td>
      </tr>
<?

mysql_connect("localhost","root","");//database connection
mysql_select_db("evidence db");
				
$order = "SELECT * FROM m cases";
				
$result = mysql_query($order);	

while($data = mysql_fetch_row($result)){
$field1= $row["Case ID"];
  echo("$field1");
}
?>
    </table>
  </td>
</tr>
</table>
</body>
</html>

Error:
Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\helloworld.php on line 25

Thanks in advanced.

PS - If anyone can recommend PHP/Phpmyadmin tutorials - i'd be interested in reading them.

digibucc · Jul 9, 2012, 11:17 PM

i recommend checking out http://www.phpfreaks.com/, not to advert other forums but they are dedicated to php coding and will likely get you solved much faster than here, unless one of the few gurus happen to post.

also, all you ever need other than a forum is the manual pages
http://php.net/manual/en/index.php

more specifically, the man page for mysql_fetch_row(), here:
http://php.net/manual/en/function.mysql-fetch-row.php

as it says, it is recommend with current php versions to use a different mysql extension entirely, with good reason. you may want to consider that. good luck.

Jizzler · Jul 11, 2012, 01:34 PM

There's a space in that table name, so it needs to be escaped with backticks.

Code:

$order = "SELECT * FROM `m cases`";

In the future, don't put spaces in your table or column names. Use an underscore (m_cases) or go camel case (mCases).

Also, if you're just starting to learn, I'd suggest going with their PDO interface instead of the database specific functions.

http://www.php.net/pdo

Been meaning to put together a small intro to PDO for the forum, with the recent rise in PHP/database questions. Maybe I'll get around to doing it now that I said I would...

Wozzer · Jul 11, 2012, 09:56 PM

Did put the backticks and have also updated the DB name to have no spaces - still no luck. Will have a better look at it tomorrow. Thanks for the input.

Easy Rhino · Jul 12, 2012, 12:50 AM

just FYI, technically evidence db is a schema and not a database.

Mindweaver · Jul 12, 2012, 09:45 PM

You don't have a password setup for "root"? I would set a password or actually go one step further and change the "root" user id to something else completely, but that's just me.

EDIT: Nice catch Easy Rhino!

Aquinus · Jul 12, 2012, 10:10 PM

You need error checking, my friend.

Change this:

PHP Code:


			
mysql_connect("localhost","root","");//database connection

mysql_select_db("evidence db");

                

$order = "SELECT * FROM m cases";

                

$result = mysql_query($order);

To this:

PHP Code:


			
$conn = mysql_connect("localhost","root","");//database connection

if(!$conn) {

    throw new Exception('Unable to connect');

}



$dbname = 'evidence db';

if(!mysql_select_db($dbname)) {

    throw new Exception('Unable to use db: {$dbname}');

}

                

$order = "SELECT * FROM `m cases`";

                

if(!$result = mysql_query($order, $conn)) {

    throw new Exception("Query failed.\n".mysql_error($conn));

}

Since your table also has a space in it, you need to denote the table name using back ticks. It may allow double quotes for table names as well, but I don't recall (I use PostgreSQL too often.)

Quote:

Originally Posted by Wasley

Error:
Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\helloworld.php on line 25

Your query is throwing an error (mysql_query(), must be returning a non-object and the only non-object it returns is false on an error.) Try out the back-ticks, that probably will fix it.

PHP Code:


			
$order = "SELECT * FROM `m cases`";

Lastly, the mysql functions you are using are deprecated. Look into MySQLi or ADODB.

Wozzer · Jul 14, 2012, 12:18 PM

Thanks for the input. It's now working

Wozzer · Jul 15, 2012, 08:53 PM

Has anyone ever had problems with dreamweaver displaying the page layout differently to that shown on a web browser?

Kreij · Jul 15, 2012, 09:00 PM

I haven't but that probably because I never used Dreamweaver.

Okay, I'm not trolling. I've noticed that in several IDE environments that what the IDE shows is not always the same as when it runs in a browser or as an application. For instance, working with WPF in VS2010, what is shown in the IDE is not always the same as when you run the app outside of the IDE.
Minor emulation differences I assume.

Best to check everything in its final resting place (like in a browser) than count on the display in the tools to be accurate.

Aquinus · Jul 15, 2012, 09:44 PM

Dreamweaver has its own HTML render. You will find that with certain setting, they will look a little different between different browsers, be it Firefox, Chrome, IE, etc. When testing, you really should check all the different browsers that you're planning to support. That's the only way to make sure it works on all of them the way you have your HTML and CSS configured because two browsers might handle padding, margins, and borders differently depending on the settings.

My rule of thumb is: Don't use Dreamweaver.

Wozzer · Jul 16, 2012, 05:34 PM

Just out of interest - What do you guys use?

W1zzard · Jul 16, 2012, 05:42 PM

Quote:

Originally Posted by Wasley

Just out of interest - What do you guys use?

i use dreamweaver for the rough layouting. any text editor (ultraedit in my case) + firefox firebug for the details

if you are asking what database: tpu uses mysql everywhere, memcached for caching

digibucc · Jul 16, 2012, 06:57 PM

i use jetbrains phpstorm. if i were to use a wysiwyg it would be dreamweaver, but i don't do much real layout work, and stick to coding.

Aquinus · Jul 17, 2012, 02:48 AM

I use vim to edit PHP, my database of choice is PostgreSQL. Even when I do layout, I usually write the CSS by hand and I use various browsers to test it. I prefer Chrome, but not everyone uses Chrome, so I keep Firefox and IE handy as the most commonly used.

Jul 9, 2012, 10:02 PM	#1
Wozzer Join Date: Jun 2008 Location: England Posts: 990 (0.55/day) Thanks: 166 Thanked 76 Times in 72 Posts System Specs	Extracting data from relational databases Hi, New to phpmyadmin, PHP, MySQL, etc - so please excuse me if the answer to the question is simple. I've built a database using XAMPP called "evidence db". Within that database, I have a table called "m cases". This table has 11 columns. I currently have the following code: Code: <html> <head> <title>Search data</title> </head> <body> <table> <tr> <td align="center">EMPLOYEES DATA</td> </tr> <tr> <td> <table border="1"> <tr> <td>Case ID</td> </tr> <? mysql_connect("localhost","root","");//database connection mysql_select_db("evidence db"); $order = "SELECT * FROM m cases"; $result = mysql_query($order); while($data = mysql_fetch_row($result)){ $field1= $row["Case ID"]; echo("$field1"); } ?> </table> </td> </tr> </table> </body> </html> Error: Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\helloworld.php on line 25 Thanks in advanced. PS - If anyone can recommend PHP/Phpmyadmin tutorials - i'd be interested in reading them.

System Name:	Wasleys PC
Processor:	Intel i5 2400 3.10GHz
Motherboard:	Asus P8z68-V
Cooling:	AC Freezer Pro
Memory:	Kingston 4GB (2x2GB) DDR3 Hyperx Memory
Video Card:	HIS ATi 6850 1GB DDR3
Hard Disk:	Seagate ST3500320AS 500GB Hard Drive SATA II 7200rpm 32MB Cache
Case:	Antec 900 with mods
Sound Card:	On Board
PSU:	OCZ Stealth Xtream 500W
Software:	Windows 7

Jul 9, 2012, 11:17 PM	#2
digibucc Join Date: May 2009 Location: In the mountains :) Adirondacks in NY (US) Posts: 3,709 (2.49/day) Thanks: 4,547 Thanked 1,449 Times in 1,040 Posts System Specs	i recommend checking out http://www.phpfreaks.com/, not to advert other forums but they are dedicated to php coding and will likely get you solved much faster than here, unless one of the few gurus happen to post. also, all you ever need other than a forum is the manual pages http://php.net/manual/en/index.php more specifically, the man page for mysql_fetch_row(), here: http://php.net/manual/en/function.mysql-fetch-row.php as it says, it is recommend with current php versions to use a different mysql extension entirely, with good reason. you may want to consider that. good luck. __________________ Donate to TPU TeamSpeak Server TPU TS: ts21.gameservers.com:9207 PSN / XBL / Steam = digibucc \| Origin / BF3 = digibuc

Processor:	i7 3820 / Phenom II 940
Motherboard:	GIGABYTE G1.ASSASSIN2 / M3A79-T Deluxe
Cooling:	Corsair Hydro H100i / Scythe II (HS only)
Memory:	G.SKILL Trident X Series 8GB (2 x 4GB) DDR3 1600mhz / 2GB DDR2 1066 (@800) Corsair Dominator
Video Card:	2x GB Radeon HD 7950s 3GB XFire / 5750
Hard Disk:	2x 80GB Intel X-25, 2x600gb SATA, 1x1tb 5400RPM storage /1x600GB, 3x500GB,1x160,1x120 SATA
Optical Drive:	24x cd/dvd burner
CRT/LCD Model:	1x 27" Yamakasi / Vizio 42" HDTV+22" Acer
Case:	Lian Li Lancool PC-K58 / Antec 900
Sound Card:	Creative XFI Onboard / HDMI from ATi Card
PSU:	PC Power & Cooling 750W / 610W
Software:	Windows 7 HP / PHPStorm / Gaming

Jul 11, 2012, 01:34 PM	#3
Jizzler Join Date: Aug 2007 Location: Geneva, FL, USA Posts: 3,010 (1.41/day) Thanks: 567 Thanked 606 Times in 487 Posts System Specs	There's a space in that table name, so it needs to be escaped with backticks. Code: $order = "SELECT * FROM `m cases`"; In the future, don't put spaces in your table or column names. Use an underscore (m_cases) or go camel case (mCases). Also, if you're just starting to learn, I'd suggest going with their PDO interface instead of the database specific functions. http://www.php.net/pdo Been meaning to put together a small intro to PDO for the forum, with the recent rise in PHP/database questions. Maybe I'll get around to doing it now that I said I would...

Processor:	AMD FX-8120
Motherboard:	ASRock Fatal1ty 990FX Professional
Cooling:	Scythe Ninja 3
Memory:	G.Skill DDR3-1866 8GB x 2
Video Card:	Gigabyte GTX 660 2GB
Hard Disk:	Crucial M4 128GB, WD 640GB x 4, 2TB Seagate
Optical Drive:	Asus SATA DVD-RW
CRT/LCD Model:	Asus 24" HD+ (1920x1200)
Case:	Lian Li PC-A17B
Sound Card:	Onboard
PSU:	OCZ GameXtreme 700w
Software:	Windows 7 Ultimate

Jul 11, 2012, 09:56 PM	#4
Wozzer Join Date: Jun 2008 Location: England Posts: 990 (0.55/day) Thanks: 166 Thanked 76 Times in 72 Posts System Specs	Did put the backticks and have also updated the DB name to have no spaces - still no luck. Will have a better look at it tomorrow. Thanks for the input.

Jul 12, 2012, 12:50 AM	#5
Easy Rhino Linux Advocate Join Date: Nov 2006 Posts: 10,284 (4.27/day) Thanks: 1,219 Thanked 2,789 Times in 1,801 Posts System Specs	just FYI, technically evidence db is a schema and not a database.

System Name:	The Rhinoceros
Processor:	Intel i7 980x @ 3.5 ghz
Motherboard:	Gigabyte EX-58 Extreme
Cooling:	Swiftech Polaris 120
Memory:	6 x 4 GB Corsair Vengence @ 1333mhz
Video Card:	EVGA GTX 570 @ 800/2000
Hard Disk:	3x 320GB SATA Software RAID 5 + 4x 1TB SAS Hardware RAID 5 LSI 512mb
Optical Drive:	LG DVD-RW
CRT/LCD Model:	Samsung 2494 HM 24" 1920x1080
Case:	Lancool PC-K60
Sound Card:	Onboard
PSU:	Seasonic X Series 750 Watt Gold
Software:	CentOS 6.4 + libvirtd(CentOS 6.4,CentOS 6.4,OEL 6,OEL 6,Windows 7)

Jul 12, 2012, 09:45 PM	#6
Mindweaver Moderato®™ Join Date: Apr 2009 Location: Statesville, NC Posts: 3,887 (2.55/day) Thanks: 4,379 Thanked 2,365 Times in 1,183 Posts System Specs	You don't have a password setup for "root"? I would set a password or actually go one step further and change the "root" user id to something else completely, but that's just me. EDIT: Nice catch Easy Rhino! __________________ “As long as I feel the warmth from the sun and breathe precious air…. I must ask questions to feed the Mind!” Battletag: Mindweaver#1523

System Name:	Sechs / EyeSeven
Processor:	I7 970 @ 4.0ghz / I7 2600k @ 4.5Ghz
Motherboard:	P6X58D-E / ASRock Z68 Extreme3 Gen3
Cooling:	CM Hyper 212 Plus push-pull / Corsair H50
Memory:	Corsair 30GB DDR3 1600 / G.Skill DDR3 1600 8gb 2x4GB
Video Card:	EVGA 480 / MSI GTX 680 PE 2Gb
Hard Disk:	GSkill 120GB SSD & OCZ RevoDrive 3 X2 240GB / Corsair 60gb SSD, 3x250 WD RAID0 avg 170mb\sec
Optical Drive:	Asus 24x / Ext. Samsung Writemaster 22x
CRT/LCD Model:	2x Samsung SyncMaster 2243 22" / 3x Acer 22" Nvidia surround
Case:	COOLER MASTER HAF 912 / Cooler Master Storm Scout
Sound Card:	On board / SB X-Fi Gamer
PSU:	Corsair tx650w / Corsair tx750w
Software:	Windows 7 Pro x64 / Windows 7 ultimate x64

System Name:	Kratos
Processor:	Intel Core i7 3820 @ 4.50Ghz (125.0x36) 1.41v
Motherboard:	ASUS P9X79 Deluxe
Cooling:	Zalman CPNS9900MAX 130mm
Memory:	G.Skill DDR3-2333, 16gb (4x4gb) @ 10-11-10-30-108-1T 1.65v
Video Card:	2x AMD (MSI branded) Radeon HD 6870 (Crossfire)
Hard Disk:	2x120Gb SATA3 Corsair Force GT Raid-0, 3x1Tb SATA2 RAID-5
Optical Drive:	Asus DVD Burner on Marval SATA3 Controller
CRT/LCD Model:	28" Hanspree (HDMI), 22" MAG Innovision (DVI)
Case:	Antec 1200
Sound Card:	Realtek® ALC898 8-Channel High Definition Audio
PSU:	Seasonic 1000-watt 80 PLUS Platinum
Software:	Windows 7 x64 Professional

Jul 14, 2012, 12:18 PM	#8
Wozzer Join Date: Jun 2008 Location: England Posts: 990 (0.55/day) Thanks: 166 Thanked 76 Times in 72 Posts System Specs	Thanks for the input. It's now working

Jul 15, 2012, 08:53 PM	#9
Wozzer Join Date: Jun 2008 Location: England Posts: 990 (0.55/day) Thanks: 166 Thanked 76 Times in 72 Posts System Specs	Has anyone ever had problems with dreamweaver displaying the page layout differently to that shown on a web browser?

Jul 15, 2012, 09:00 PM	#10
Kreij Hardcore Monkey Moderator Join Date: Feb 2007 Location: Cheeseland (Wisconsin, USA) Posts: 12,254 (5.27/day) Thanks: 591 Thanked 5,510 Times in 2,948 Posts System Specs	I haven't but that probably because I never used Dreamweaver. Okay, I'm not trolling. I've noticed that in several IDE environments that what the IDE shows is not always the same as when it runs in a browser or as an application. For instance, working with WPF in VS2010, what is shown in the IDE is not always the same as when you run the app outside of the IDE. Minor emulation differences I assume. Best to check everything in its final resting place (like in a browser) than count on the display in the tools to be accurate. __________________ Cloud (noun, singular): A dynamic arrangement of multiple potential single points of failure, with a user at one end and their data at the other. Get more tech news on a wide variety of topics at NextPowerUp

Processor:	Intel Core 2 Quad QX9650 Extreme @ 3.0 GHz
Motherboard:	Asus Rampage Formula
Cooling:	ZeroTherm Nirvana NV120 Premium
Memory:	8GB (4 x 2GB) Corsair Dominator PC2-8500
Video Card:	2 x Sapphire Radeon HD6970
Hard Disk:	2 x Seagate Barracuda 320GB in RAID 0
Optical Drive:	Sony DRU-120C DVD-RW
CRT/LCD Model:	Dell 3007WFP 30" LCD (2560 x 1600)
Case:	Thermaltake Armor w/ 250mm Side Fan
Sound Card:	SupremeFX 8ch Audio
PSU:	Thermaltake Toughpower 750W Modular
Software:	Win8 Pro x64 / Cat 12.10

Jul 15, 2012, 09:44 PM	#11
Aquinus Join Date: Jan 2012 Location: Dover, New Hampshire, USA Posts: 4,505 (8.87/day) Thanks: 1,441 Thanked 1,423 Times in 1,063 Posts System Specs	Dreamweaver has its own HTML render. You will find that with certain setting, they will look a little different between different browsers, be it Firefox, Chrome, IE, etc. When testing, you really should check all the different browsers that you're planning to support. That's the only way to make sure it works on all of them the way you have your HTML and CSS configured because two browsers might handle padding, margins, and borders differently depending on the settings. My rule of thumb is: Don't use Dreamweaver. __________________ MyHeat

Jul 16, 2012, 05:34 PM	#12
Wozzer Join Date: Jun 2008 Location: England Posts: 990 (0.55/day) Thanks: 166 Thanked 76 Times in 72 Posts System Specs	Just out of interest - What do you guys use?

Processor:	Intel Core i7-2600K @ 3.4 GHz
Motherboard:	ASUS P8Z68-V Pro
Memory:	3x 2048 MB Mushkin DDR3
Video Card:	ASUS GeForce GTX 670 Direct CU II TOP
Hard Disk:	Crucial C300 128 GB, WD6400AAKS 640 GB, WD15EADS 1.5 TB
Optical Drive:	BenQ DW1640
CRT/LCD Model:	Dell U3011 30", 2560x1600 + 19" 1280x1024
Case:	NZXT H2
Sound Card:	On-board Realtek HD
PSU:	Kingwin Absolute Platinum 550 W
Software:	Windows 7 64-bit

Jul 16, 2012, 06:57 PM	#14
digibucc Join Date: May 2009 Location: In the mountains :) Adirondacks in NY (US) Posts: 3,709 (2.49/day) Thanks: 4,547 Thanked 1,449 Times in 1,040 Posts System Specs	i use jetbrains phpstorm. if i were to use a wysiwyg it would be dreamweaver, but i don't do much real layout work, and stick to coding. __________________ Donate to TPU TeamSpeak Server TPU TS: ts21.gameservers.com:9207 PSN / XBL / Steam = digibucc \| Origin / BF3 = digibuc

Jul 17, 2012, 02:48 AM	#15
Aquinus Join Date: Jan 2012 Location: Dover, New Hampshire, USA Posts: 4,505 (8.87/day) Thanks: 1,441 Thanked 1,423 Times in 1,063 Posts System Specs	I use vim to edit PHP, my database of choice is PostgreSQL. Even when I do layout, I usually write the CSS by hand and I use various browsers to test it. I prefer Chrome, but not everyone uses Chrome, so I keep Firefox and IE handy as the most commonly used. __________________ MyHeat

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extracting video BIOS from main BIOS	WaroDaBeast	Motherboards & Memory	6	Dec 25, 2011 12:40 AM
Online databases?	<<Onafets>>	Programming & Webmastering	2	Jan 3, 2011 07:59 AM
Extracting a swollen battery from a UPS	twilyth	General Hardware	8	Aug 10, 2010 07:48 PM
Extracting audio from youtube videos in Linux- Solution	crazy pyro	Linux / BSD / Mac OS X	9	Jul 31, 2009 05:55 PM
SQL Relational algebra	new_rez	Programming & Webmastering	2	Mar 18, 2008 06:02 PM