Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $DB_host = "localhost";
- $DB_user = "root";
- $DB_pass = "";
- $DB_name = "test_shop";
- $options = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf-8');
- try
- {
- $DB_con = new PDO("mysql:host={$DB_host};dbname={$DB_name}",$DB_user,$DB_pass);
- $DB_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $DB_con->exec('SET NAMES utf8');
- }
- catch(PDOException $e)
- {
- $e->getMessage();
- }
- ?>
- <html>
- <head>
- <script src="http://code.jquery.com/jquery-latest.js"></script>
- <script>
- $(function(){
- $('.number').click(function(a){
- a.preventDefault();
- var rno = $(this).data('id');
- $.ajax({
- type: "POST",
- url: "php_obrob.php",
- data: {id:rno}
- }).done(function( result )
- {
- $("#msg").html(result);
- });
- })
- $('.cat').click(function(e){
- e.preventDefault();
- var idd = $(this).data('id');
- $.ajax({
- type: "POST",
- url: "new.php",
- data: {id:idd}
- }).done(function( result )
- {
- $("#product").html(result);
- });
- })
- })
- </script>
- </head>
- <body>
- <?php
- $stmt = $DB_con->query("SELECT * FROM `test_table`");
- while ($row = $stmt->fetch())
- {
- echo
- '
- <li><a class="number" data-id="'.$row['number'].'" href="#">'.$row['name'].'</a></li>
- ';
- }
- ?>
- <br /><br />
- <div id="msg"> </div>
- <div id="product"></div>
- </body>
- </html>
- php_obrob.php
- <?php
- $rno = $_POST['id'];
- ?>
- <?php
- /*В базе существует 1,2,3,4 number только разбираюсь почему передается только 1 во всех случаях?*/
- $stmt = $DB_con->query("SELECT * FROM `cat_woman` WHERE number='$rno'");
- while ($row = $stmt->fetch())
- {
- echo
- '
- <li><a id="cat" data-id="'.$row['id'].'" href="#">'.$row['shop'].'</a></li>
- ';
- }
- ?>
- new.php
- <?php
- $idd = $_POST['id'];
- ?>
- <?php
- $stmt = $DB_con->query("SELECT * FROM `product` WHERE id_cat='$idd'");
- while ($row = $stmt->fetch())
- {
- echo
- '
- <li><a class="numberss" data-id="'.$row['id'].'" href="#">'.$row['name'].'</a></li>
- ';
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement