Extracting data from relational databases

Wozzer · Jul 9, 2012

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 10, 2012

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.

Disparia · Jul 11, 2012

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

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

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

Mindweaver · Jul 12, 2012

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. :toast:

EDIT: Nice catch Easy Rhino! :toast:

Aquinus · Jul 12, 2012

You need error checking, my friend.

Change this:

PHP:

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

To this:

PHP:

$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.)

Wasley said:
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:

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

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

Wozzer · Jul 14, 2012

Thanks for the input. It's now working

:toast:

Wozzer · Jul 15, 2012

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

Kreij · Jul 15, 2012

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

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

Just out of interest - What do you guys use?

W1zzard · Jul 16, 2012

Wasley said:
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

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

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.

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(s)	HIS ATi 6850 1GB DDR3
Storage	Seagate ST3500320AS 500GB Hard Drive SATA II 7200rpm 32MB Cache
Case	Antec 900 with mods
Audio Device(s)	On Board
Power Supply	OCZ Stealth Xtream 500W
Software	Windows 7

System Name	i7-PC / HTPC / iMac
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 / 4GB DDR2 1066 (@800) Corsair Dominator
Video Card(s)	GB Radeon HD 7950s 3GB / GB Radeon HD 7950s 3GB
Storage	2x 80GB Intel X-25, 2x600gb SATA, 1x1tb 5400RPM storage /1x600GB, 3x500GB,1x160,1x120 SATA
Display(s)	1x 27" Yamakasi / Vizio 42" HDTV
Case	Lian Li Lancool PC-K58 / Antec 900
Audio Device(s)	HT Omega Striker 7.1 / Onboard and HDMI from ATi Card
Power Supply	PC Power & Cooling 750W / 610W
Software	Ubuntu / Windows 8.1 Pro / OS X / PHPStorm / Gaming

Processor	Intel i5-6600
Motherboard	ASRock H170M-ITX
Cooling	Cooler Master Geminii S524
Memory	G.Skill DDR4-2133 16GB (8GB x 2)
Video Card(s)	Gigabyte R9-380X 4GB
Storage	Samsung 950 EVO 250GB (mSATA)
Display(s)	LG 29UM69G-B 2560x1080 IPS
Case	Lian Li PC-Q25
Audio Device(s)	Realtek ALC892
Power Supply	Seasonic SS-460FL2
Mouse	Logitech G700s
Keyboard	Logitech G110
Software	Windows 10 Pro

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(s)	HIS ATi 6850 1GB DDR3
Storage	Seagate ST3500320AS 500GB Hard Drive SATA II 7200rpm 32MB Cache
Case	Antec 900 with mods
Audio Device(s)	On Board
Power Supply	OCZ Stealth Xtream 500W
Software	Windows 7

System Name	Desktop
Processor	i5 13600KF
Motherboard	AsRock B760M Steel Legend Wifi
Cooling	Noctua NH-U9S
Memory	4x 16 Gb Gskill S5 DDR5 @6000
Video Card(s)	Gigabyte Gaming OC 6750 XT 12GB
Storage	WD_BLACK 4TB SN850x
Display(s)	Gigabye M32U
Case	Corsair Carbide 400C
Audio Device(s)	On Board
Power Supply	EVGA Supernova 650 P2
Mouse	MX Master 3s
Keyboard	Logitech G915 Wireless Clicky
Software	The Matrix

Extracting data from relational databases

Wozzer

digibucc

Disparia

Wozzer

Easy Rhino

Linux Advocate

Mindweaver

Moderato®™

Aquinus

Resident Wat-man

Wozzer

Wozzer

Kreij

Senior Monkey Moderator

Aquinus

Resident Wat-man

Wozzer

W1zzard

Administrator

digibucc

Aquinus

Resident Wat-man

System Name	Tower of Power / Sechs
Processor	i7 14700K / i7 5820k @ 4.5ghz
Motherboard	ASUS ROG Strix Z690-A Gaming WiFi D4 / X99S GAMING 7
Cooling	CM MasterLiquid ML360 Mirror ARGB Close-Loop AIO / CORSAIR Hydro Series H100i Extreme
Memory	CORSAIR Vengeance LPX 32GB (2 x 16GB) DDR4 3600 / G.Skill DDR4 2800 16GB 4x4GB
Video Card(s)	ASUS TUF Gaming GeForce RTX 4070 Ti / ASUS TUF Gaming GeForce RTX 3070 V2 OC Edition
Storage	4x Samsung 980 Pro 1TB M.2, 2x Crucial 1TB SSD / Samsung 870 PRO 500GB M.2
Display(s)	Samsung 32" Odyssy G5 Gaming 144hz 1440p, ViewSonic 32" 72hz 1440p / 2x ViewSonic 32" 72hz 1440p
Case	Phantek "400A" / Phanteks “Enthoo Pro series”
Audio Device(s)	Realtek ALC4080 / Azalia Realtek ALC1150
Power Supply	Corsair RM Series RM750 / Corsair CXM CX600M
Mouse	Glorious Gaming Model D Wireless / Razer DeathAdder Chroma
Keyboard	Glorious GMMK with box-white switches / Keychron K6 pro with blue swithes
VR HMD	Quest 3 (128gb) + Rift S + HTC Vive + DK1
Software	Windows 11 Pro x64 / Windows 10 Pro x64
Benchmark Scores	Yes

System Name	Apollo
Processor	Intel Core i9 9880H
Motherboard	Some proprietary Apple thing.
Memory	64GB DDR4-2667
Video Card(s)	AMD Radeon Pro 5600M, 8GB HBM2
Storage	1TB Apple NVMe, 4TB External
Display(s)	Laptop @ 3072x1920 + 2x LG 5k Ultrafine TB3 displays
Case	MacBook Pro (16", 2019)
Audio Device(s)	AirPods Pro, Sennheiser HD 380s w/ FIIO Alpen 2, or Logitech 2.1 Speakers
Power Supply	96w Power Adapter
Mouse	Logitech MX Master 3
Keyboard	Logitech G915, GL Clicky
Software	MacOS 12.1

Processor	Ryzen 7 5700X
Memory	48 GB
Video Card(s)	RTX 4080
Storage	2x HDD RAID 1, 3x M.2 NVMe
Display(s)	30" 2560x1600 + 19" 1280x1024
Software	Windows 10 64-bit