Member Avatar for ankit1122

hello all;

<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<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>

i wanna use nested views on a same column....

like there is a column of "skills" in my database and i wanna query it for three words....

c++,java,python

i wanna find a person with all these three skills ,,

so i am using regexp like
create view a1 as
SELECT "email" from e where (skills) regexp "java";

then
create view b1 as
SELECT "email" from a1 where (skills) regexp "java";

then
create view c1 as
SELECT "email" from b1 where (skills) regexp "java";

i want to get the values from form

and then want to create an array of views like

create view anyname as
SELECT "email" from e where (skills) regexp "java";

here "java" should be taken from the skills textbox..

Edited by pritaeas because: Closed. Do NOT cross-post.
  • 2 Contributors
  • 3 Replies
  • 184 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by pritaeas

Recommended Answers

All 3 Replies

Member Avatar for pritaeas

You may want to take a look at the FIND_IN_SET function, assuming the column values are comma separated.

IMO creating views for a basic query is overkill.

Edited by pritaeas
Member Avatar for ankit1122

there is no extra advantage set gives a user for nesting.....i have read the documentation

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.