1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
|
<?php require_once('../Connections/OnePageWebsite.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_OnePageWebsite, $OnePageWebsite);
$query_rsKeyNav1 = "SELECT `key` FROM frutas ORDER BY `key` ASC";
$rsKeyNav1 = mysql_query($query_rsKeyNav1, $OnePageWebsite) or die(mysql_error());
$row_rsKeyNav1 = mysql_fetch_assoc($rsKeyNav1);
$totalRows_rsKeyNav1 = mysql_num_rows($rsKeyNav1);
mysql_select_db($database_OnePageWebsite, $OnePageWebsite);
$query_rsKeyNav2 = "SELECT `key` FROM fruta2 ORDER BY `key` ASC";
$rsKeyNav2 = mysql_query($query_rsKeyNav2, $OnePageWebsite) or die(mysql_error());
$row_rsKeyNav2 = mysql_fetch_assoc($rsKeyNav2);
$totalRows_rsKeyNav2 = mysql_num_rows($rsKeyNav2);
mysql_select_db($database_OnePageWebsite, $OnePageWebsite);
$query_rsCarrosNav = "SELECT `Key` FROM carros ORDER BY `Key` ASC";
$rsCarrosNav = mysql_query($query_rsCarrosNav, $OnePageWebsite) or die(mysql_error());
$row_rsCarrosNav = mysql_fetch_assoc($rsCarrosNav);
$totalRows_rsCarrosNav = mysql_num_rows($rsCarrosNav);
$colname_rsVariCont1 = "-1";
if (isset($_GET['pagkey'])) {
$colname_rsVariCont1 = $_GET['pagkey'];
}
mysql_select_db($database_OnePageWebsite, $OnePageWebsite);
$query_rsVariCont1 = sprintf("SELECT variables FROM frutas WHERE `key` = %s", GetSQLValueString($colname_rsVariCont1, "text"));
$rsVariCont1 = mysql_query($query_rsVariCont1, $OnePageWebsite) or die(mysql_error());
$row_rsVariCont1 = mysql_fetch_assoc($rsVariCont1);
$totalRows_rsVariCont1 = mysql_num_rows($rsVariCont1);
$colname_rsVariCont2 = "-1";
if (isset($_GET['pagkey'])) {
$colname_rsVariCont2 = $_GET['pagkey'];
}
mysql_select_db($database_OnePageWebsite, $OnePageWebsite);
$query_rsVariCont2 = sprintf("SELECT variables FROM fruta2 WHERE `key` = %s", GetSQLValueString($colname_rsVariCont2, "text"));
$rsVariCont2 = mysql_query($query_rsVariCont2, $OnePageWebsite) or die(mysql_error());
$row_rsVariCont2 = mysql_fetch_assoc($rsVariCont2);
$totalRows_rsVariCont2 = mysql_num_rows($rsVariCont2);
$colname_rsCarros = "-1";
if (isset($_GET['pagKey'])) {
$colname_rsCarros = $_GET['pagKey'];
}
mysql_select_db($database_OnePageWebsite, $OnePageWebsite);
$query_rsCarros = sprintf("SELECT variables FROM carros WHERE `Key` = %s", GetSQLValueString($colname_rsCarros, "text"));
$rsCarros = mysql_query($query_rsCarros, $OnePageWebsite) or die(mysql_error());
$row_rsCarros = mysql_fetch_assoc($rsCarros);
$totalRows_rsCarros = mysql_num_rows($rsCarros);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>
<body>
<p><a href="Untitled-4.php?pagkey=<?php echo $row_rsKeyNav1['key']; ?>">Key1</a></p>
<p><a href="Untitled-4.php?pagkey=<?php echo $row_rsKeyNav2['key']; ?>">Key2</a> </p>
<p><a href="Untitled-4.php?pagkey=<?php echo $row_rsCarrosNav['Key']; ?>">Carros</a></p>
<p> </p>
<p> </p>
<?php echo $row_rsVariCont1['variables']; ?><?php echo $row_rsVariCont2['variables']; ?><?php echo $row_rsCarros['variables']; ?>
</body>
</html>
<?php
mysql_free_result($rsKeyNav1);
mysql_free_result($rsKeyNav2);
mysql_free_result($rsCarrosNav);
mysql_free_result($rsVariCont1);
mysql_free_result($rsVariCont2);
mysql_free_result($rsCarros);
?>
____________________________________________________________
Here is the Table information:
-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 09, 2008 at 07:49 AM
-- Server version: 5.0.41
-- PHP Version: 5.2.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `onepage_website`
--
-- --------------------------------------------------------
--
-- Table structure for table `carros`
--
CREATE TABLE `carros` (
`Key` varchar(50) NOT NULL,
`variables` varchar(100) NOT NULL,
PRIMARY KEY (`Key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `carros`
--
INSERT INTO `carros` VALUES ('carro1', 'Ford');
INSERT INTO `carros` VALUES ('carro2', 'Cadilac');
INSERT INTO `carros` VALUES ('carro3', 'Chevrolet');
INSERT INTO `carros` VALUES ('carro4', 'Toyota');
-- --------------------------------------------------------
--
-- Table structure for table `fruta2`
--
CREATE TABLE `fruta2` (
`key` varchar(50) NOT NULL,
`variables` varchar(100) NOT NULL,
PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `fruta2`
--
INSERT INTO `fruta2` VALUES ('key1', 'ROJO');
INSERT INTO `fruta2` VALUES ('key2', 'AMARILLO');
INSERT INTO `fruta2` VALUES ('key3', 'NARANJA');
INSERT INTO `fruta2` VALUES ('key4', 'VILETA');
-- --------------------------------------------------------
--
-- Table structure for table `frutas`
--
CREATE TABLE `frutas` (
`key` varchar(50) NOT NULL,
`variables` varchar(100) NOT NULL,
PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `frutas`
--
INSERT INTO `frutas` VALUES ('manzana', 'roja');
INSERT INTO `frutas` VALUES ('guineo', 'amarillo');
INSERT INTO `frutas` VALUES ('china', 'anaranjada');
INSERT INTO `frutas` VALUES ('Uvas', 'violetas');
|
