Jump to content

web designer

Members
 View Profile  See their activity

  • Posts

    16

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by web designer

    clickable map -- help ! , please !

    in PHP Coding Help

    Posted

    [color=brown]hello..

    I need someone's help  :-[ please !

    I have a map that has many blue dots... and I have their latitude and longitude in my database..

    I can easily do a search and pick few dots from my database..

    [b]1st step:[/b]
    I need these few dots to be coloured by red in the result page that shows the map with all of the blue dots + new red dots ( where they should be above some of the blue dots )

    [b]2nd step:[/b]
    I should have the user able to click on these red dots.. so he can after that have all the stuff in the database that are related to this specific dot..

    [b]3rd step:[/b]
    the map is toooo big.. so I should have the user to be able to zoom in (while he is clicking around the red dot) but as in step 2 .. if he clicked on the dot.. results should be displayed..

    how can i do these steps  ::)?? heeelp  ??? please  :)

    web designer[/color]

    Please, Help me.. ( Sessions ) !

    in PHP Coding Help

    Posted

    [color=brown]
    as I'm taking info from my database and showing it in many pages..

    is it right to do this.. for passing variables to the another page ?

    [/color]
    [code]
    <?php
    $num=1;    
    for($i=1;$i<$numPages;$i++)
    {    
    if($num==$pageNo)
    {
    $font="<b>";
    $unfont="</b>";
    }
    else
    {
    $font="";
    $unfont="";
    }
    echo "<a href='query1.php?page=$num&tennis=$_SESSION['tennis']&basketball=$_SESSION['basketball']'>$font $num $unfont</a>&nbsp";
        $num = $num + 1;
    }
    ?>
    [/code]

    [color=brown]
    My question is mostly for this part ( sessions )
    [/color]
    [code]
    <?php

    echo "<a href='query1.php?page=$num&tennis=$_SESSION['tennis']&basketball=$_SESSION['basketball']'>$font $num $unfont</a>&nbsp";

    ?>
    [/code]

    Please, Help me.. ( Sessions ) !

    in PHP Coding Help

    Posted

    [color=brown]
    but still ! .. should I write these lines of code in my query.php ??

    [/color]
    [code]
    <?php
    ............etc

    $ostracodes = $_SESSION['ostracodes'];
    $indetermine = $_SESSION['indetermine'];

    $preQuery="select * from Macrofossiles where (ostracodes = '$ostracodes') || (indetermine = '$indetermine')";

    ............etc
    ?>
    [/code]

    Please, Help me.. ( Sessions ) !

    in PHP Coding Help

    Posted


    [color=brown][b]I figured out that I should write these[/b][/color]

    [code]
    <?php
    if($_POST['ostracodes'] == 'x') $_SESSION['ostracodes'] = x;
    if($_POST['indetermine'] == 'x') $_SESSION['indetermine'] = x;
    ?>
    [/code]

    [color=brown][b]in my query.php  not  my form.php[/b][/color]


    I wrote them in this way:

    [code]
    <?php
    if(isset ($_POST['ostracodes']))
          {$_SESSION['ostracodes'] = x;}

    if(isset ($_POST['indetermine']))
          {$_SESSION['indetermine'] = x;}
    ?>

    [/code]

    Please, Help me.. ( Sessions ) !

    in PHP Coding Help

    Posted

    [color=brown]
    Okay  :)

    I wrote in my form.php
    [/color]
    [code]

    ............etc

    <input name="ostracodes" type="checkbox" value="x">Ostracodes
    <br />
    <input name="indéterminé" type="checkbox" value="x">Indéterminé
    <br />
    <br />
    <input name="reset" type="reset" value="Reset"/>
    <input name="submit" type="submit" value="Submit"/>
    </form>
    <?php
    if($_POST['ostracodes'] == 'x') $_SESSION['ostracodes'] = x;
    if($_POST['indetermine'] == 'x') $_SESSION['indetermine'] = x;
    ?>

    ............etc

    [/code]

    [color=brown]now ! .. in my query.php

    should I do this:
    [/color]
    [code]
    <?php
    ............etc

    $ostracodes = $_SESSION['ostracodes'];
    $indetermine = $_SESSION['indetermine'];

    $preQuery="select * from Macrofossiles where (ostracodes = '$ostracodes') || (indetermine = '$indetermine')";

    ............etc
    ?>
    [/code]

    Please, Help me.. ( Sessions ) !

    in PHP Coding Help

    Posted

    [color=brown]
    Oh I really appreciate your help.. thanks alot..

    now.. what about the [u]variables[/u] !! ?

    [b]can I do this:[/b]

    form.php[/color]
    [code]
    ...etc

    <input name="<?php $ostracodes='ostracodes'; ?>" type="checkbox" value="x">Ostracodes
    <input name="<?php $indetermine='indetermine'; ?>" type="checkbox" value="x">Indetermine

    ...etc

    </form>

    <?php
    $_SESSION['ostracodes'] = $ostracodes;
    $_SESSION['indetermine'] = $indetermine;
    ?>
    [/code]

    Please, Help me.. ( Sessions ) !

    in PHP Coding Help

    Posted

    [color=brown]I just started adding the session stuff.. ;D

    now.. I have this code in both files.. the form and the query..

    [b]<?php
    session_start();
    ..............................etc[/b]

    but I got an error..

    in my two files..

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\Documents and Settings\Work Station\Desktop\wamp\www\WebSite\forms\form1.php:[b]9[/b]) in C:\Documents and Settings\Work Station\Desktop\wamp\www\WebSite\forms\form1.php on line [b]61[/b]

    on line 9 there is a usual meta tag
    on line 61 there is session_start();

    so ! what is the problem !![/color]

    Please, Help me.. ( Sessions ) !

    in PHP Coding Help

    Posted

    [color=brown]
    Hello  :)

    I have two files.. form.php  -  query.php

    [b]form.php[/b]
    [/color]
    [code]
    <form action="http://localhost/queries/query.php" method="post" name="form">

    Searching for players which play these games...
    <br />
    <br />
    <input name="football" type="checkbox" value="x">Football
    <br />
    <input name="basketball" type="checkbox" value="x">Basketball
    <br />
    <br />
    <input name="reset" type="reset" value="Reset"/>
    <input name="submit" type="submit" value="Submit"/>

    </form>
    [/code]
    [color=brown]
    [b]query.php[/b]
    [/color]
    [code]
    <?php
    $page=$_GET["page"];
    if(!isset($page))
    {
    $page=1;
    $pageNo = $page +1;
    }

    $pageNo = $page;
    echo "Page Number:&nbsp<b>$pageNo</b>";

    $page=$page-1;

    //connecting to my database.. and for sure it's working..(hidden for now)
    //....
    //....
    //....

    $football = $_POST['football'];
    $basketball = $_POST['basketball'];

    $preQuery="select * from Macrofossiles where (football = '$football') || (basketball= '$basketball')";
    $preResult=mysql_query($preQuery,$server) or die("Could not execute preQuery...");
    $numRows=mysql_num_rows($preResult);
    $numPages=$numRows/1;

    $query = "select * from Macrofossiles where (football = '$football') || (basketball= '$basketball') limit $page, 1";
    $result = mysql_query($query,$server) or die("Could not execute query...");

    while($row = mysql_fetch_array($result))
    {
        echo
    '<table bordercolor="#CC7722" align="center">' .
    "<tr><td>Player Number:</td><td>{$row['Player_No']}</td></tr>" .
    "<tr><td>Hockey:</td><td>{$row['Hockey']}</td></tr>" .
    "<tr><td>Volleyball:</td><td>{$row['volleyball']}</td></tr>" .
    "<tr><td>Tennis:</td><td>{$row['tennis']}</td></tr>" .
    "<tr><td>Football:</td><td>{$row['football']}</td></tr>" .
          "<tr><td>Basketball:</td><td>{$row['Basketball']}</td></tr>" .
    "</table>";
    }  
      echo "<b>Page:</b>&nbsp;&nbsp";
     
      $num=1;  
      for($i=1;$i<$numPages;$i++)
      {
    if($num==$pageNo)
    {
    $font="<b>";
    $unfont="</b>";
    }
    else
    {
    $font="";
    $unfont="";
    }
        echo "<a href='query.php?page=$num'>$font $num $unfont</a>&nbsp";
        $num = $num + 1;
      }

    mysql_close($server);
    ?>
    [/code]
    [color=brown]
    [b]Database:[/b]

    |  Player_No  |  Hockey  |  Volleyball  |  Tennis  |  Football  |  basketball  |
    |      1        |      x      |      x      |            |      x      |                |
    |      2        |              |      x      |      x      |              |        x        |
    |      3        |      x      |              |      x      |      x      |                |
    |      4        |              |      x      |      x      |              |        x        |
    |      5        |      x      |      x      |            |      x      |        x        |
    |      6        |      x      |      x      |            |      x      |                |
    |      7        |              |      x      |      x      |              |        x        |
    |      8        |      x      |              |      x      |      x      |                |
    |      9        |              |      x      |      x      |              |        x        |
    . . . etc

    I hope someone can help..

    Oops.. I didn't tell you guys what is the problem I'm sufferring from in these codes..

    here is it..

    when I check the two checkboxes... and click submit..

    the query.php open and everything seems okey.. the results are perfect.. and exact..

    but !! .. when I click page number 2 or 3 or any number after the first click, everything is changed !! ..

    it geves me the result of this query
    "select * from Macrofossiles where (football = '') || (basketball= '')"

    I mean it gives me the result when football is empty and basketball is empty..

    that means this query-->"select * from Macrofossiles" all the resutls will show up ..  :(

    it seems to me that I need to write sessions..

    but how that will ! .. what should I write and where in my code !!

    any help !  ::)  :D[/color]

    A simple example of php/mysql webpage using dreamweaver

    in Editor Help (PhpStorm, VS Code, etc)

    Posted

    [color=brown]
    Everything is fine..  ;D with connecting to the servers throw my computer..

    _____________________________________________________________________

    but I got another problem !..

    I have two files.. form.php  -  query.php

    [b]form.php[/b]
    [/color]
    [code]
    <form action="http://localhost/queries/query.php" method="post" name="form">

    Searching for players which play these games...
    <br />
    <br />
    <input name="football" type="checkbox" value="x">Football
    <br />
    <input name="basketball" type="checkbox" value="x">Basketball
    <br />
    <br />
    <input name="reset" type="reset" value="Reset"/>
    <input name="submit" type="submit" value="Submit"/>

    </form>
    [/code]
    [color=brown]
    [b]query.php[/b]
    [/color]
    [code]
    <?php
    $page=$_GET["page"];
    if(!isset($page))
    {
    $page=1;
    $pageNo = $page +1;
    }

    $pageNo = $page;
    echo "Page Number:&nbsp<b>$pageNo</b>";

    $page=$page-1;

    //connecting to my database.. and for sure it's working..(hidden for now)
    //....
    //....
    //....

    $football = $_POST['football'];
    $basketball = $_POST['basketball'];

    $preQuery="select * from Macrofossiles where (football = '$football') || (basketball= '$basketball')";
    $preResult=mysql_query($preQuery,$server) or die("Could not execute preQuery...");
    $numRows=mysql_num_rows($preResult);
    $numPages=$numRows/1;

    $query = "select * from Macrofossiles where (football = '$football') || (basketball= '$basketball') limit $page, 1";
    $result = mysql_query($query,$server) or die("Could not execute query...");

    while($row = mysql_fetch_array($result))
    {
        echo
    '<table bordercolor="#CC7722" align="center">' .
    "<tr><td>Player Number:</td><td>{$row['Player_No']}</td></tr>" .
    "<tr><td>Hockey:</td><td>{$row['Hockey']}</td></tr>" .
    "<tr><td>Volleyball:</td><td>{$row['volleyball']}</td></tr>" .
    "<tr><td>Tennis:</td><td>{$row['tennis']}</td></tr>" .
    "<tr><td>Football:</td><td>{$row['football']}</td></tr>" .
           "<tr><td>Basketball:</td><td>{$row['Basketball']}</td></tr>" .
    "</table>";
    }    
       echo "<b>Page:</b>&nbsp;&nbsp";
       
       $num=1;    
       for($i=1;$i<$numPages;$i++)
       {
    if($num==$pageNo)
    {
    $font="<b>";
    $unfont="</b>";
    }
    else
    {
    $font="";
    $unfont="";
    }
        echo "<a href='query.php?page=$num'>$font $num $unfont</a>&nbsp";
        $num = $num + 1;
      }

    mysql_close($server);
    ?>
    [/code]
    [color=brown]
    [b]Database:[/b]

    |  Player_No  |  Hockey  |  Volleyball  |  Tennis  |  Football  |  basketball  |
    |       1        |       x      |       x       |             |      x       |                 |
    |       2        |              |       x       |      x      |              |        x        |
    |       3        |       x      |               |      x      |      x       |                 |
    |       4        |              |       x       |      x      |              |        x        |
    |       5        |       x      |       x       |             |      x       |        x        |
    |       6        |       x      |       x       |             |      x       |                 |
    |       7        |              |       x       |      x      |              |        x        |
    |       8        |       x      |               |      x      |      x       |                 |
    |       9        |              |       x       |      x      |              |        x        |
    . . . etc

    I hope someone can help..

    Oops.. I didn't tell you guys what is the problem I'm sufferring from in these codes..

    here is it..

    when I check the two checkboxes... and click submit..

    the query.php open and everything seems okey.. the results are perfect.. and exact..

    but !! .. when I click number 2 or 3 or any number after the first click, everything is changed !! ..

    it geves me the result of this query
    "select * from Macrofossiles where (football = '') || (basketball= '')"

    I mean it gives me the result when football is empty and basketball is empty..

    that means this query-->"select * from Macrofossiles" all the resutls will show up ..  :(


    any help !  ::)  :D[/color]

    A simple example of php/mysql webpage using dreamweaver

    in Editor Help (PhpStorm, VS Code, etc)

    Posted

    [size=11pt][color=brown]
    Thanks Chris.. I appreciate that..  :)

    I hope you are not going to be tired from the huge number of questions.. lol  ;D just  8) kidding :D

    Ooops :o, here is the first problem ! ..  :-[

    assuming that I have no server.. no domain.. just trying to test the php files using dreamweaver..

    what should I fill these empty boxes  ::) ! in the picture below.. !?  :-\

    [/color][/size]

    [attachment deleted by admin]

    A simple example of php/mysql webpage using dreamweaver

    in Editor Help (PhpStorm, VS Code, etc)

    Posted

    [color=brown][size=11pt]Hi..  :)

    I really liked this forum.. it's all about PHP  8)

    can anyone from the nice people write a simple webpage that includes a clickable map, random photographs browser and a small database with one query..

    I need to understand the connection between all of these.. then discuss that with you people  :D

    I need to see the code and the result page.. after that I can easily connect ideas in my mind  :-\

    I have a good knowledge of HTML CSS .. .. .. etc..  ;)

    but ! .. it's my first time to use the dynamic programing ( php with mysql )  ???

    I usually use dreamweaver..  it's lovely ::)

    I appreciate your kindness in helping me..

    thanks,

    Sara[/size][/color]
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.