· 9 years ago · Jul 22, 2017, 06:00 AM
1<?php
2 function dbconnect()
3 {
4 $db_host = "localhost";
5 $db_user = "db_user";
6 $db_password = "password";
7 $db_database = "test";
8
9 $db_connect = mysql_connect($db_host,$db_user,$db_password)
10 or die("ERROR: Could not connect to the database!<br>MySql Error: " . mysql_error());
11 mysql_select_db($db_database, $db_connect)
12 or die("ERROR: Could not select database!<br>MySql Error: " . mysql_error());
13 return $db_connect;
14 }
15
16 function sqlquery($sql_query)
17 {
18 $link = dbconnect();
19 $result = mysql_query($sql_query);
20 return $result;
21 }
22//-----
23 echo "<h2>Sletter gammel tabell</h2>";
24 $res = sqlquery("DROP TABLE temptest");
25
26 $res = sqlquery("
27 CREATE TABLE IF NOT EXISTS `temptest` (
28 `id` int(11) NOT NULL auto_increment,
29 `bestiller` varchar(10),
30 `bestnr` varchar(4),
31 PRIMARY KEY (`id`) )
32 ",FALSE);
33
34 echo "<H2>Oppretter testdata</H2>";
35 $res = sqlquery("
36 INSERT INTO temptest
37 (bestiller, bestnr)
38 VALUES
39 ('Test','0001')
40 ");
41
42 echo "<H2>Vise data fra tabell</H2>";
43
44 $bnr="0001";
45 $res=sqlquery("SELECT * from temptest WHERE bestnr='$bnr'");
46 $res_num = mysql_num_rows($res);
47
48 echo "<i>Antall poster i select:</i> $res_num<br/>";
49
50 $row = mysql_fetch_row($res);
51
52 $bestnr = $row['bestnr']; // FEILER - Feilmelding: Notice: Undefined index: bestnr in D:\wamp\www\test.php on line 52
53 echo "<i>bestnr:</i> $bestnr";
54
55
56?>