How do I connect a 3rd party XMPP client to Cisco's Jabber Video?

Question

Below is a code which gets blogs from the database and displays them in single column on screen, I want to display one or the first post in the first column which will have a bigger text and image than the rest, the second column to have two posts and the third final column having three posts.

A good example would be The New York Times website. How do i go about this?

<?php
  $query = "SELECT * FROM posts WHERE tag='us' ORDER BY updated_on DESC";
  $run_query = mysqli_query($conn, $query) or die(mysqli_error($conn));
  if (mysqli_num_rows($run_query) > 0) {
  while ($row = mysqli_fetch_assoc($run_query)) {
   $post_title = $row['title'];
   $post_id = $row['id'];
   $post_author = $row['author'];
   $post_date = $row['postdate'];
   $post_image = $row['image'];
   $post_content = $row['content'];
   $post_tags = $row['tag'];
   $post_status = $row['status'];
   if ($post_status !== 'published') {
    echo "NO POST PLS";
   } else {


?>

    <div class="img">
      <img src="allpostpics/<?php echo $post_image; ?>" alt="900 * 300"></a>
    </div>
    <h3 class="title" size="200" class="column">
      <b><span><a href="publicposts.php?post=<?php echo $post_id; ?>"><?php echo $post_title; ?></a></span> <br> <br></b>
      <span style="font-weight: normal;"><?php echo substr($post_content, 0, 200) . '.........'; ?> <br></span>
    </h3>

    <div class="details">
      <p>Posted on <?php echo $post_date; ?></p>
      <p>By <a href="#"><?php echo $post_author; ?></a></p>
    </div>


<?php }}}?>

     

Solution

To save people time:

Cisco Webex Connect IM uses Jabber as its chat protocol, so Pidgin (or any Jabber client) should be able to work with it. Here’s how to configure a Webex Connect account in Pidgin:

XMPP protocol
    Basic tab
        Username: first part of your Webex username before the @domain
        Domain: the part of your webex username after the @ sign.
        Resource: blank
        Password: your Webex IM password
        Local alias: whatever you want to show up for you locally in
            the chat window when you send messages, such as your
            username, instead of the lengthy Jabber ID string
    Advanced tab
        Connect port: 5222
        Connect server: c2s.<your domain>.webexconnect.com

Jabber (and obviously Pidgin) has conference/chat room support, and so does Webex Connect via a custom conference server:

Buddies menu: Join a chat
    Account: choose the XMPP Webex account
    Room name: whatever you want, or a known existing one
    Server: conference.isj1.webex.com (should already be filled in)
    Handle: whatever username you want
Inviting people once in the room:
    Conversation menu: Invite
    Buddy: enter their email address. Should show a list of matching names to select and invite.

Source: http://csh.us/2012/07/09/pidgin-support-for-cisco-webex-im/

Comments

[Dharman]

It is a very bad idea to use die(mysqli_error($conn)); in your code, because it could potentially leak sensitive information. See this post for more explanation: mysqli or die, does it have to die?

[Ethan Denis]

Thank you for pointing out my mistake and i had no idea about it (new to programming). I'll rectify it, thanks.

[Dharman]

If you are only starting to learn PHP then you should learn PDO instead of mysqli. PDO is much easier and more suitable for beginners. Start here phpdelusions.net/pdo & websitebeaver.com/…