₦airaland Forum

That through sha because technology is fast outdated. What I was trying to develop is an app that should be responsive. But I built it on so many Ajax request. I was wondering if some mobile browsers could cope

Rilamaka:
"Controlled demolition" really? With people inside? Do you understand what you have just written? So the people that died sacrificed their lives for tbj's "controlled demolition" or the "controlled demolition" wouldn't be complete or successful without taking lives of innocent people? What are you saying? If you lost a family member would you be displaying this amount of... you guys really need Jesus!

What he meant wasn't that Scoan demolished the building. He meant the building collapsed in the same way a building would collapse if its demolition was controlled. Pls make una dey understand before una comment. You guys here re quick to comment

add me on whatsapp 07030763334 or bbm 75c7344b

All these webmasters no gree ans me o. Wetin happen

Thank you for your time. Please i need experienced webmasters on this problem. I am developing an application with PHP/MYSQL. I was wondering how i can achieve a twitter-like follow system where a user sees all tweets or posts by people he is following. Or that of facebook where you see all post by your friends only. How the structure of the mysql tables would be like? and possible query techniques.Once again Thank you very much

MrDoGood: op na poverty do u dis one?

if u were rich as u claimed why not school in the US

hmmmm please let truth be told. I attended a fed uni. i cud afford any private sch in naija. pls stop saying poverty. a graduate is a graduate whether private or public. I Ve encountered so many private uni graduates. a friend of mine was in a private school 200l med surgery n wanted to change to a public sch but he failed post Ume woefully. I was shocked cus he didn't fail with pride. and for the girls(or some of them) they are just too dump for me and kinda cheap. sometime myself and friends go just drive go their gate on the day of their vacation we must catch fishes na. dem no go travel go house immediately o. na hotel tins. just cus say den lock them. but all the same u can't judge all with just a few. for me some of them learn abt life after graduation. just imagine for nysc camp one guy just shout for one of their babes n she just start cry. @op no be by public sch ooo. labour market no know Ur sch o.
make Una take am easy o

waiting

not bad for a start as times goes u keep upgrading. its simple. keep working until u get there

considering RWD (responsive web design) how do i handle ajax request and javascript or jquery functionalities for browsers like opera mini and other old browsers wen developing an app?

na wa o. guy u better do it for free if u need a portfolio than charge 3k. haba na Ur own worse pass. am not a pro but I turn down 25k for website. which level sef or u forget to add anoda zero for the back? maybe

Ur design is not mobile friendly at all especially opera mini. the future of the web is mobile. so work on that. One more thing use a color wheel. all the d same its not easy to develop such projects. Gud work

please webmasters have u worked on an app that requires php geolocation to identify a user's location? or do u have any idea on it? I Ve done sm projects like this. I used php to get the IP of the users. but just IP addresses. Any better way of getting the city and country with php?

WebRabbi: @ daddynasa, you can use my own solution ie

<?php

$server = 'localhost'; $username = 'root'; $password = ''; $database = 'messagBox';
$conn = new PDO("mysql:host=$server; dbname=$database", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->exec("SET CHARACTER SET utf8";


function SoftUserName($conn, $userID){

$SoftQuery = "SELECT uname

FROM users

WHERE userid = :userid";


$soft_prep = $conn->prepare($SoftQuery);

$soft_prep->bindValue(':userid', $userID);

$soft_prep->execute();

$rows_count = $soft_prep->rowCount();

if($rows_count == 1) {

while($row = $soft_prep->fetch(PDO::FETCH_ASSOC)) {

$userName = $row['uname'];

}

}else{

$userName = 'Anonymous';
}

return $userName;

}

$senderID = 1;
$recepID = 2;

$SenderName = SoftUserName($conn, $senderID);
$RecepName = SoftUserName($conn, $recepID);

$SoftQuery = "SELECT msgid, senderid, recipientid, msg, datesent

FROM message

WHERE senderid = :senderid

OR senderid = :recipientid

OR recipientid = :recipientid

OR recipientid = :senderid

ORDER BY datesent ASC";


$soft_prep = $conn->prepare($SoftQuery);

$soft_prep->bindValue(":senderid", $senderID);
$soft_prep->bindValue(":recipientid", $recepID);

$soft_prep->execute();


$rows_count = $soft_prep->rowCount();

if($rows_count >= 1) {

while($row = $soft_prep->fetch(PDO::FETCH_ASSOC)) {

$msgid = $row["msgid"];
$msg = $row["msg"];
$datesent = $row["datesent"];
$senderid = $row["senderid"];
$recipientid = $row["recipientid"];

if(($senderid == $senderID) && ($senderid != $recipientid)){

echo "<div style='float:left; border: 1px solid #333; color:#03F; padding: 30px; margin: 10px;'>
$SenderName : $msg, $datesent</div><br clear='all' />";

}


if (($recipientid == $senderID) && ($senderid != $recipientid)){

echo "<div style='float:right; border: 1px solid #333; color:#03F; padding: 30px; margin: 10px;'>
$RecepName : $msg, $datesent</div><br clear='all'/>";

}

$senderid = ''; $recipientid = ''; $msg ='';


}

}else{

echo "Error Msg";

}

?>

good one. thank you

dhtml: Yeepa! see query o! Unsubscribes and runs away from the thread very fast.

what I now did is select * from msg where((senderid=1 or recipientid=1)and(senderid=2 or recipientid=2))

yawatide: So I am looking at the tables and I don't see a (primary) key in one that would serve as the "hook" for the (secondary) key in the other. Maybe it's there, though column names don't match, but I don't see it. You may want to start by making the correction.

At any rate, off the top of my head without giving it much thought and based on how you have structured your tables, I would probably do a SELECT * on all msg where userid = senderid AND userid = recipientid

Good luck!

your query does not get the messages between two users it fetches all messages where user is both sender and recipient.

dhtml: Yeepa! see query o! Unsubscribes and runs away from the thread very fast.

no mind me hate.. smtimes too much code no good

got it. treated each conversation between pair as a thread using thread Id. thanks a lot for Ur contribution

When u visit m.Facebook.com and u go to messages u ll see all Ur messages from different users after when u click the person's name it takes u to the chat between two of u and a reply box under. this is exactly what I am trying to achieve. I don't know if am table design is right
for this goal. thank u

I tried (SELECT * FROM messages WHERE recipientid=1 AND senderid=2) UNION (
SELECT * FROM messages WHERE recipientid=2 AND senderid=1) but only one of the users sees the messages between the two users
and secondly getting their uname from users table with their IDs using INNER JOIN is futile

I believe u saw the asterisk beneath. and that serves as the correction. which one come be dies? .

Must u show Ur self?

then u don't understand English

****between two users e.g userId =1 and userid=2****

I ve created two mysql tables namely 'users'
and 'messages' the 'users' table contains
userid and uname, 'message' table contains
msgid, senderid, recipientid, msg, datesent .
How can I retrieve all(conversation) messages
btw to users, the sender and recipient uname?
A good example is the facebook msg system at
m.facebook.com

Chelsea don spoil ma bet tire. wetin self

Checkout this site where football fans Rep your football club and battle the rest, share funny football photos
http://www.fansnoni.com

@lovetinz....noted. thank u

kingthreat don't get me wrong pls...I appreciate u

Kingthreat Thank you. how many colors can u see cos i can see on one family of colors which is green. Pls tell me if i am color-blind

@ mobilextera thank u and @kingthreat thank u also but dnt u think is senseless jst sayin its garbage cus u changed notin by nt pointin 2 d fault cos that was d reason d topic was created. Pls more criticisms are welcumd

http://www.fansnoni.com football fans gathering. Share funny football moments