i'll be gratified if anyone can help me thru this .....
my problm if that i have to retrieve data from my sql database ... bt itz stored thr from an app created in php .. so stored using preg_match function in php .... hlo<div><br></div> this is format i have it in my database but i need only the text part .... plzzz guide me as m nt knwn to php that much .... regards
Is it always going to be in this hlo<div><br></div> Format? and only the hlo part changes? if that's the case there are numerous methods you can use just off the top of my head something like this
string test = " hlo<div><br></div>";
test = test.Substring(test.IndexOf(";")+1, test.IndexOf("<") - test.IndexOf(";")-1);
Inline Code Example Here void chatting()
string myconnection = "connection string ";
MySqlConnection myConn = new MySqlConnection(myconnection);
MySqlCommand SelectCommand = new MySqlCommand(" select * from livestream.users INNER JOIN livestream.chat INNER JOIN livestream.video ON users.user_id = chat.user_id and chat.channel_id=video.video_id where chat.channel_id ='" + videoid + "' and isACTIVE=1 order by chatID ASC ", myConn);
myReader = SelectCommand.ExecuteReader();
List<string> list = new List<string>();
string test1 = myReader.GetString("user_name");
string test = myReader.GetString("message");
test = test.Substring(test.IndexOf(";") + 1, test.IndexOf("<") - test.IndexOf(";") - 1);
list.Add(test1 + " " + test);
chattingbox.Lines = list.ToArray();
catch (Exception ex)
} ....... i have sent u the snapshot of what error m i getting .. please tel where m i making mistake ..
I am working creating a fully encapsulated, homogeneous singly linked data structure. The Listing class and SinglyLinkedList class that are part of the whole application compile fine, but the problem ...