Showing posts with label Search in all column in the table fields. Show all posts
Showing posts with label Search in all column in the table fields. Show all posts

Tuesday, February 22, 2011

Search in all column in the table fields

<?php
$conn = @mysql_connect( 'localhost','root' ,'')
or die( mysql_errno().': '.mysql_error().NL );
$db=mysql_select_db('kiwi',$conn);
$result = mysql_query("SHOW COLUMNS FROM $table");
if (mysql_num_rows($result) > 0)
{
$i=0;
while ($row = mysql_fetch_array($result))
{
if($i==0)
{

echo $q="select * from $table where ".$row[0]."=".$condition;
}
else
{
$q.=" or ".$row[0]."=".$condition;
}
$i++;
}
}
echo 'a';

echo $q;

?>

Kubernetes in one shotcat

root@srv509172:~# cat kind1/config.yaml   kind: Cluster apiVersion: kind.x-k8s.io/v1alpha4 nodes: - role: control-plane   image: kindest/nod...