index.php code
<html>
<head>
<meta charset="UTF-8">
<title>Our Local site</title>
</head>
<body>
<form action="welcome.php" method="post">
<input id="t1" name="t1"type="text" placeholder="table name"><br>
<input id="s1"type="text" name="skill[]"placeholder="skill or item or spec">
<input id="s2" type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s3" type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s4"type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s5"type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s6"type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s7"type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s8"type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s9"type="text" name="skill[]" placeholder="skill or item or spec">
<input id="c1"type="text" name="city[]"placeholder="city">
<input id="c2"type="text" name="city[]"placeholder="city">
<input id="c3"type="text" name="city[]" placeholder="city">
<input id="c4"type="text" name="city[]" placeholder="city">
<input id="c5"type="text" name="city[]" placeholder="city">
<input id="c6"type="text" name="city[]"placeholder="city"><br>
<input id="r1"type="text" name="region[]"placeholder="Region in city">
<input id="r2"type="text" name="region[]" placeholder="Region in city">
<input id="r3"type="text" name="region[]" placeholder="Region in city">
<input id="cn1"type="text" name="country[]" placeholder="country">
<input id="cn2"type="text" name="country[]" placeholder="country">
<input id="cn3"type="text" name="country[]" placeholder="country">
<input id="l1"type="text" name="lat"placeholder="Latitude in degrees">
<input id="l2"type="text" name="long"placeholder="Longitude in degrees">
<input type="submit">
</form>
</body>
</html>
wel.php code----->>>`
<?php
$count = 0;
foreach($_POST as $item)
{
$count += (is_array($item)) ? count($item) : 1;
}
echo "Items = $count";
$skills = explode(" ", $_POST["skills"]);
$table = explode(" ", $_POST["table"]);
$city = explode(" ", $_POST["city"]);
$region = explode(" ", $_POST["region"]);
$country = explode(" ", $_POST["countrys"]);
print_r($table);
?>
i just wanna create different views for each and every string of arrays...
i have a column of skills in which skills of various people are added like p1 has skills of "cpppl,javapl,flashpl,cook,runner,businessman,bodybuilder".u can say all the different things a man can do is placed in a single column..
how can i query this same column for multiple world....like cpppl and javapl simultaneously???
i am thinking of using nesting by using views but there should be a more faster way available in mysql if i could know...?