Cher bacchus41,
Merci pour ta réponse rapide.
Nous avons entretemps résolu notre soucis avec code :
$query_r = sprintf("SELECT * FROM test WHERE t1 LIKE %s UNION SELECT * FROM test2 WHERE t1 LIKE %s UNION SELECT * FROM test3 WHERE t1 LIKE %s ORDER BY t1 ASC", GetSQLValueString($colname_r, "text"),GetSQLValueString($colname_r, "text"),GetSQLValueString($colname_r, "text"));
Il fallait effectuer un request sur plusieurs tables mais placions mal nos "UNION" !
cependant, nous devons encore résoudre un problème :
( tout notre code est ci-dessous)
Les mots encodés dans la variable "colname" (ou search) de notre FORM doivent pouvoir etre reconnus séparément (fonction : explode). (genre moteur)
Nous ne savons pas comment insérer cette fonction dans notre code sans boulverser tout.
D'avance merci pour l'aide éventuelle ...
Bat
Marc
_________________________________
notre code actuel:
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
| <?php require_once('../Connections/x7562.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;
}
}
$colname_r = "-1";
if (isset($_POST['search'])) {
$colname_r = (get_magic_quotes_gpc()) ? $_POST['search'] : addslashes($_POST['search']);
}
mysql_select_db($database_x7562, $x7562);
$query_r = sprintf("SELECT * FROM test WHERE t1 LIKE %s UNION SELECT * FROM test2 WHERE t1 LIKE %s UNION SELECT * FROM test3 WHERE t1 LIKE %s ORDER BY t1 ASC", GetSQLValueString($colname_r, "text"),GetSQLValueString($colname_r, "text"),GetSQLValueString($colname_r, "text"));
$r = mysql_query($query_r, $x7562) or die(mysql_error());
$row_r = mysql_fetch_assoc($r);
$totalRows_r = mysql_num_rows($r);
?><!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=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="az.php">
<table width="609" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="298"><label>
<input name="search" type="text" id="search" size="30" />
</label></td>
<td width="311"><label>
<input type="submit" name="Submit" value="Submit" />
</label></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</form>
<?php do { ?>
<table width="478" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><?php echo $row_r['id']; ?></td>
<td><?php echo $row_r['t1']; ?></td>
<td><?php echo $row_r['t2']; ?></td>
<td><?php echo $row_r['t3']; ?></td>
<td><?php echo $row_r['t4']; ?></td>
</tr>
</table>
<?php } while ($row_r = mysql_fetch_assoc($r)); ?></body>
</html>
<?php
mysql_free_result($r);
?> |
Partager