need to convert code dynamically

andyellen · October 25, 2015

this is my website http://www.mytestingvlog.co.nf/post.html

I want that when someone types into text area and submits the text via ask button that post will be submitted to http://www.mytestingvlog.co.nf/feed.html

the two arrows on the rights sides will be votes. the one with most votes will moved higher

Please help me how do i do this?

thank you all

benanamen · October 25, 2015

What have you tried? What was the result?

hansford · October 25, 2015

You are going to have to use Ajax calls if you want to dynamically shift the questions up or down based on vote clicks.

As far as initially displaying the page.

<form action="feed.php" method="post">
    <textarea required="" name="question" placeholder="Write Something..." id="text" cols="30" rows="10"></textarea>
<input type="submit" name="submit" value="ask">
</form>

feed.php

if ( ! isset($_POST['question']))
{
    // give error or send them back to the page etc.
    exit;
}

// here is where your database will come in 
// based on the number of votes you display the page html

andyellen · October 25, 2015

I havent tried anything yet. I am new to php/mysql

andyellen · October 25, 2015

feed.php

if ( ! isset($_POST['question']))
{
    // give error or send them back to the page etc.
    exit;
}

// here is where your database will come in 
// based on the number of votes you display the page html

Thank you sir. can you please tell me that when I write something on post.php http://www.mytestingvlog.co.nf/post.html then that post should be displayed similarly to http://www.mytestingvlog.co.nf/feed.html same design and style

benanamen · October 25, 2015

I havent tried anything yet. I am new to php/mysql

Have you gone through any tutorials?

Edited October 25, 2015 by benanamen

andyellen · October 25, 2015

Have you gone through any tutorials?

yes I did

but I am not getting them exactly and also some tuts are very old.

All I want to start with post.html.

can you please tell me when a user post on http://www.mytestingvlog.co.nf/post.html

how do I display that text into http://www.mytestingvlog.co.nf/feed.html with same style and design its in that page.

thanks in advanced

benanamen · October 25, 2015

I assume you don't want to just display it, but also have each post stay on the page. That will be sending you to database territory.

You will need to learn up on form handling

http://www.w3schools.com/php/php_forms.asp

And MySQL

http://www.w3schools.com/php/php_mysql_intro.asp

Jacques1 · October 25, 2015

Don't use w3schools as a reference. This site is infamous for spreading wrong information, dangerous code and plain nonsense. They seem to have improved their tutorials a bit, but they still output unescaped variables and display internal error messages all over the place.

A much better resource for anything HTML-related is the Mozilla Developer Network.

andyellen · October 26, 2015

my index.php

<?PHP
    include('db.class.php');
    $bdd = new db();
    ?>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
    <head>
        <title>Voting System</title>
        
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
     
        <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css" type="text/css">
        
        <script type="text/javascript" src="jquery/jquery-1.10.1.min.js"></script>
        
        <style>
        .arrow_up a { display: block; background: url("voteup.png") no-repeat; width: 26px; height: 13px }
        .arrow_up a:hover { background-position: 0 -13px; width: 26px; height: 13px }
        .arrow_up_voted { display: block; background: url("votedown.png") no-repeat; width: 26px; height: 13px }
        .arrow_down a { display: block; background: url("votedown.png") no-repeat; width: 26px; height: 13px }
        .arrow_down a:hover { background-position: 0 -13px; width: 26px; height: 13px }
        .arrow_down_voted { display: block; background: url("votedown.png") no-repeat; width: 26px; height: 13px }
        
        .number { font-size: 18px; color: #818185; padding: 7px 0 7px 0; }
        .voting_table { margin-right: 20px; }
        </style>
    </head>
     
    <body>
     
    <div class="container">
        <div class="row">
            <div class="col-md-12">
            <?php
            $articles = $bdd->getAll('SELECT * FROM tc_tuto_voting_system'); // Select the article list
            
            foreach($articles as $article) { // Loop - for each article...
                $cookie_name = 'tcVotingSystem'.$article['id']; // Set up the cookie name
                
                echo '<div class="panel panel-default">';
                    echo '<div class="panel-heading">Article '.$article['id'].'</div>'; // Article name + id
                    echo '<div class="panel-body">';
                    echo '<table class="voting_table pull-left">';
                        echo '<tr>';
                            echo '<td align="center">';
                                if( isset($_COOKIE[$cookie_name]) ) { // If the cookie exists (means if we have already voted for this article)
                                    echo '<div class="arrow_up_voted"></div>'; // We display a simple "arrow up", not clickable
                                } else {
                                ?>
                                <!-- else we display the clickable "arrow up". We call a function and pass the arguments article ID and the value +1 -->
                                <div class="arrow_up" id="arrow_up<?php echo $article['id']; ?>"><a href="#" id="arrowUp" onclick="vote(<?php echo $article['id']; ?>, '+1'); return false;"></a></div>
                                <?php
                                }
                            echo '</td>';
                        echo '</tr>';
                        echo '<tr>';
                            echo '<td align="center">';
                                echo '<div class="number" id="number'.$article['id'].'">'.$article['total'].'</div>'; // We display the number of click
                            echo '</td>';
                        echo '</tr>';
                        echo '<tr>';
                            echo '<td align="center">';
                                if( isset($_COOKIE[$cookie_name]) ) { // Same for the "arrow down": if the cookie exists (means if we have already voted for this article)
                                    echo '<div class="arrow_down_voted"></div>'; // We display a simple "arrow down", not clickable
                                } else {
                                ?>
                                <!-- else we display the clickable "arrow down". We call a function and pass the arguments article ID and the value -1 -->
                                <div class="arrow_down" id="arrow_down<?php echo $article['id']; ?>"><a href="#" id="arrowDown" onclick="vote(<?php echo $article['id']; ?>, '-1'); return false;"></a></div>
                                <?php
                                }
                            echo '</td>';
                        echo '</tr>';
                    echo '</table>';
                    echo '<span id="message'.$article['id'].'"></span>'; // Display message "Thank you for voting"
                    echo 'Up branch to easily missed by do. Admiration considered acceptance too led one melancholy expression. Are will took form the nor true. Winding enjoyed minuter her letters evident use eat colonel. He attacks observe mr cottage inquiry am examine gravity. Are dear but near left was. Year kept on over so as this of. She steepest doubtful betrayed formerly him. Active one called uneasy our seeing see cousin tastes its. Ye am it formed indeed agreed relied piqued.';
                    echo '</div>';
                echo '</div>';
            }
            ?>
            </div>
        </div>
    </div>
     
    <script type="text/javascript" src="tuto-voting-system.js"></script>
        
    </body>
    </html>

my db.class.php

<?php
    class db {
        private $conn;
        private $host;
        private $user;
        private $password;
        private $baseName;
        private $port;
        private $Debug;
     
        function __construct($params=array()) {
            $this->conn = false;
            $this->host = 'localhost'; //hostname
            $this->user = 'root'; //username
            $this->password = ''; //password
            $this->baseName = 'db'; //name of your database
            $this->debug = true;
            $this->connect();
        }
     
        function __destruct() {
            $this->disconnect();
        }
        
        function connect() {
            if (!$this->conn) {
                try {
                    $this->conn = new PDO('mysql:host='.$this->host.';dbname='.$this->baseName.'', $this->user, $this->password, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'));  
                }
                catch (Exception $e) {
                    die('Erreur : ' . $e->getMessage());
                }
     
                if (!$this->conn) {
                    $this->status_fatal = true;
                    echo 'Connection BDD failed';
                    die();
                }
                else {
                    $this->status_fatal = false;
                }
            }
     
            return $this->conn;
        }
     
        function disconnect() {
            if ($this->conn) {
                $this->conn = null;
            }
        }
        
        function getOne($query) {
            $result = $this->conn->prepare($query);
            $ret = $result->execute();
            if (!$ret) {
               echo 'PDO::errorInfo():';
               echo '<br />';
               echo 'error SQL: '.$query;
               die();
            }
            $result->setFetchMode(PDO::FETCH_ASSOC);
            $reponse = $result->fetch();
            
            return $reponse;
        }
        
        function getAll($query) {
            $result = $this->conn->prepare($query);
            $ret = $result->execute();
            if (!$ret) {
               echo 'PDO::errorInfo():';
               echo '<br />';
               echo 'error SQL: '.$query;
               die();
            }
            $result->setFetchMode(PDO::FETCH_ASSOC);
            $reponse = $result->fetchAll();
            
            return $reponse;
        }
        
        function execute($query) {
            if (!$response = $this->conn->exec($query)) {
                echo 'PDO::errorInfo():';
               echo '<br />';
               echo 'error SQL: '.$query;
               die();
            }
            return $response;
        }
    }

when I upload it on server. nothing shows up.

please tell me how do i fix this

maxxd · October 26, 2015

First and foremost, php won't be parsed on pages with an .html extension unless the server is specifically set up to do so, which is a waste of resources as then every .html page will be passed through the php parser. So, if you're going to be dynamically building output, you'll need to change the extension to .php.

As for the previous post, add the following

error_reporting(-1);
ini_set('display_errors',true);

to index.php, before the line

include('db.class.php');

and after the opening <?php tag and see what that has to say.

Sign In

need to convert code dynamically

Recommended Posts

andyellen

Link to comment

Share on other sites

benanamen

Link to comment

Share on other sites

hansford

Link to comment

Share on other sites

andyellen

Link to comment

Share on other sites

andyellen

Link to comment

Share on other sites

benanamen

Link to comment

Share on other sites

andyellen

Link to comment

Share on other sites

benanamen

Link to comment

Share on other sites

Jacques1

Link to comment

Share on other sites

andyellen

Link to comment

Share on other sites

maxxd

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information