I know how to do a fetch array to create a while loop as well as the mysql query in ASC order. What I'm trying to sort out is how I might be able to make it create the ASC order but to ignore the initial words "The" or "A" in the results example if the records have -Running Around -The End Game -A Robotic Arm -Mighty Mouse I want the result to show 1. The End Game 2. Might Mouse 3. A Robotic Arm 4. Running Around when it shows me the listed results in ASC order Thanks for …

Member Avatar
Member Avatar
+0 forum 2

Link for API: [Click Here](http://api.uptimerobot.com/getMonitors?apiKey=u118216-ae6b502f1b3f6d272d0f9437&logs=1&alertContacts=1&responseTimes=1&responseTimesAverage=180&format=json) I want to get datetime and type parameters i try to but i get: Notice: Trying to get property of non-object Here is my try t $api_key = "apikey here"; $server = "http://api.uptimerobot.com/getMonitors?apiKey=$api_key&logs=1&alertContacts=1&responseTimes=1&responseTimesAverage=180&format=json"; $server2 = file_get_contents($server); $obj = @json_decode($server2); $cc = $alert->datetime; echo $cc; its not working maybe because its an arrayed json. Can someone give me whole (right) code to get it work ? I need only type and datetime parameters in while cycle (prefer)

Member Avatar
Member Avatar
+0 forum 6

this is what i want to do but it seems my code doesn't do what i wanted. when i select an item in cbo_Item i want to loop the corresponding Item_Stock into cbo_QTY where all the numbers below Item_Stock is shown in cbo_QTY...here is my code... Private Sub loop_QTY() Dim qty As Integer sqlstring = "SELECT Item_Stock from tbl_Products as '" & qty & "' WHERE Item_Name = '" & cbo_Items.Text & "' " con.Open() Dim i As Integer For i = 0 To Val(qty) cbo_QTY.Text = i + 1 Next End Sub did i miss anything..please help...

Member Avatar
Member Avatar
+0 forum 2

hi i'm new to php but i tried to make my own edu website but i'm facing lot of problem to fetch the result using php external site is about one of the Engineering university where 10k students result will be displayed by this website bcoz of this its server will be busy.so i tried to fetch the result from it. coming to reqirement when the students enter their usn no(eg:1db11cs001) when user hit submit button it must fetch result from external website(eg:http://results.vtu.ac.in/vitavi.php) and it must display result on my website so plz help me by giving complete code for …

Member Avatar
Member Avatar
-4 forum 19

plz help me to solve it

Member Avatar
Member Avatar
+0 forum 3

Wordpress - I want to use a title condition for displaying info on a page, from a MySQL table "country". The condition must compare the title with the names in the column "name" and when it match a value than display on the page the text from column "description" from the same row with the matching value. Example : title(USA)=column name (USA) get/fetch column (description) (the description from row USA). I had tryed a code <?php $page_name = $wp_query->post->post_name; query_posts('category_name='. $page_name); ?> <?php global $wpdb; $result = $wpdb->get_row ("SELECT name FROM country WHERE parent IN (SELECT parent FROM country WHERE …

Member Avatar
Member Avatar
+0 forum 2

I made a new MySQL table in Phpmyadmin in Wordpress in the same database from Wordpress but a new table. I want to make a new page and add a script in the body that allows: 1. when i insert the page title to the new page, the script should search the database table "workers" just in the column "name" and when it matches title(example "Jimbo") to the value in the column "name" (example "Jimbo") than display the "description" from name "Jimbo" (as in the table look down just "Jones"). It must search and display automatically. 2. or when i …

Member Avatar
Member Avatar
+0 forum 2

hi, in the mysql we can fetch data and store them into variables, like the code below: if (mysql_num_rows($userquery) != 1) { die ("that member could not be found!"); while($row = mysql_fetch_array ($userquery, MYSQL_ASSOC)){ $first_name = $row['first_name']; $last_name = $row['last_name']; $email = $row['email']; $password = $row['password']; $sex = $row['sex']; $dbusername = $row['username']; } but how can i do the same with pdo??

Member Avatar
Member Avatar
+0 forum 1

so, im editing my site and i made a blog, it worked earlier but idk why its not working now. it may be something small that im just over looking but my table of entries come up empty when i know my mysql server has 1 entry in that table. im using easyphp for development. here is the code. <?php $con=mysqli_connect("localhost","root","","admin"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } include "menu.php"; ?> <center> <table border="1" width = "1250px" style="height:500px;color:white;" bordercolor="red"> <tr> <td style="color:white;text-align:left;vertical-align:top;background-color:black;background: rgba(0, 0, 0, 0.3);"> <table> <tr> <td style='color:white;'><b>BLOG ENTRIES</b></td> …

Member Avatar
Member Avatar
+0 forum 3

Dear all, Im getting a problem in Excel. Vlookup formula is working correct. Now the problem is when more than one time asc-1 comes in posting column, it do not show the 2nd name with asc-1. Formula for the vlookup is : =VLOOKUP(N15,A11:G87,2,FALSE) What will be the solution and how? Replyies will be appreciated.

Member Avatar
Member Avatar
+0 forum 1

Hello, I am having trouble fetching content from a web-page, actually i wanted to fetch all the inner text from div name 'displaybody' but my code doesn't seems working, it is fetching all the content of the page and after 4 page successfully fetched i get an error, [CODE][B]Fatal error: Maximum execution time of 30 seconds exceeded in E:\Installations\xampp\htdocs\wp\simple_html_dom.php on line 127[/B][/CODE] Here is the code for the script, I want my script to open all the sub-pages(/txt/any number) inside the url mentioned in the code and fetched the content from its particular div (displaybody) [CODE] <?php include ('simple_html_dom.php'); $request_url …

Member Avatar
Member Avatar
+0 forum 1

i am printing the values using ajax. Can i store those value in database?

Member Avatar
Member Avatar
+0 forum 23

I am using a framework, and I am having an issue with getting the results of this particular associative array. All others work except for this one and I am not sure why. This one only returns one result. Here is what I have in my model: public function listStats($id) { $sql = DB::inst()->query( "SELECT * FROM ". TP."tracking WHERE mID = '$id' GROUP BY mID" ); $data = array(); if($sql->num_rows > 0) { while($row = $sql->fetch_assoc()) { $data[] = $row; } return $data; } } And here is what I have in my view: <?php foreach($this->listStats as $k => …

Member Avatar
Member Avatar
+0 forum 4

Thanks you all in advance. I want to make a website showing the result of exams that are conducted in India. I want the user to enter his/her Roll Number in the form created at my website and as he/she press enter. His/her results should be displayed on the page. I have a several websites as a demo. Those are using the same feature and displaying results. http://www.examresults.net http://www.indiaresults.com/ Hope I will get the results from the experts.

Member Avatar
Member Avatar
+0 forum 7

I am using PHP Simple HTML DOM Parser * [Manual] to fetch data from websites. Now what i wanna do is to remove first three words from all span which has `class="yeah"` from the fetched content So i have implement this code but it has a problem: foreach($html->find('span.yeah') as $xdat) { $x_des = implode(' ', array_slice(explode(' ', strip_tags($xdat)), 0, 3)); $result = str_replace($x_des, ' ', $result); $result = str_get_html($result); } Though it delete first three words from all `<span class="yeah">` but the problem is, this modify full fetched content. But i wanna modify only those data whose are in `<span …

Member Avatar
Member Avatar
+0 forum 2

Dear all, how i can fetch image path in input field. when i update form the image path has lost their path so it is not updated so please do some help. thanks

Member Avatar
Member Avatar
+0 forum 3

Hello, I am getting the following error message: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mochas/domains/zoink.sx33.net/public_html/includes/blogpost.php on line 54 My code (Line 54): while($row = mysql_fetch_assoc($query))

Member Avatar
Member Avatar
+0 forum 6

how to get content from a table id in [simple html dom parser](http://simplehtmldom.sourceforge.net), the table id is `products` and i have tried with this code: <?php include("dom.php"); $html = file_get_html("http://www.example.com"); $result = $html->find('table[id=products]'); echo "$result"; ?> but don't works, any idea to fetch content of a table which id is `products`? Thanks

Member Avatar
Member Avatar
+0 forum 1

I am just starting with Simple PHP HTML DOM PARSER so, what is the way to replace text only of any fetched content. Suppose i have fetched some content from a website with full HTML codes, but while applying PHP code like `$html = str_replace(".", "DOT", $html);` it cause a error. Because in this case it replace all `.` with `DOT` so that all links are broken, but what i want is just to replace `.` to `DOT` in texts but all code should be untouched. Assuming, The fetched data is something like this `<a href="http://example.com">Example.com</a>` The Output should be …

Member Avatar
Member Avatar
+0 forum 6

i have tow tables, posts and sections, i want to get the last 10 posts WHERE section = 1, but use the 10 results in different places, i make a function function sectionposts($section_id){ mysql_set_charset('utf8'); $maxpost1 ="SELECT max(id) from posts WHERE section_id = $section_id ORDER BY ID DESC LIMIT 10"; $maxpost10 =mysql_query($maxpost1); return($maxpost10); } $query2 = sectionposts(6); while ($rows = mysql_fetch_array($query2)){ echo $rows['title']; echo $rows['id']; echo $rows['image_section']; echo $rows['subject']; echo $rows['image_post']; how can in take this ten results but use them with different places ,and keep them Arranged from one to ten . Thanks...

Member Avatar
Member Avatar
+0 forum 4

i wonder if it is possible to fetch images using [PHP Simple HTML DOM Parser](http://simplehtmldom.sourceforge.net/) and obtain it in a specific URL. Suppose it fetched a Image in a variable like $img = 'http://www.example.com/some_image_address.JPEG'; Now is it possible to get this image in my own domain path, like $new_img = 'http://mysite.com/some_image_address.JPEG'; I am a PHP beginner so please describe it

Member Avatar
Member Avatar
+0 forum 2

i have a script which will fetch content from a website, what i wanna do is modify all that links. Suppose: $html = str_get_html('<h2 class="r"><a class="l" href="http://www.example.com/2009/07/page.html" onmousedown="return curwt(this, 'http://www.example.com/2009/07/page.html')">SEO Result Boost <b> </b></a></h2>'); so, is it possible to modify or rewrite it in this way> <h2 class="r"><a class="l" href="http://www.site.com?http://www.example.com/2009/07/page.html">SEO Result Boost <b> </b></a></h2> I have read it's manual but can not understand how to figure it ( http://simplehtmldom.sourceforge.net/#fragment-12 ) Is It Possible, Any Idea?

Member Avatar
Member Avatar
+0 forum 5

My PHP script can fetch content from a div id, but what is the way to filter this fetch data and exclude some of its content which has this div id `<div id="navbar" class="n">content here content here</div>` I have tried with this code but its not working $regex = '#\<div id="navbar"\>(.+?)\<\/div\>#s'; preg_match($regex, $displaybody, $matches); $match = $matches[0]; echo "$match"; To fetch content i am using SIMPLE HTML DOM Parser( http://sourceforge.net/projects/simplehtmldom/files/ ), any idea?

Member Avatar
Member Avatar
+0 forum 11

Hello, i wanted to know what you guys use with PDO. Do you use ->fetchAll() or ->fetch() + while based on some reading i have done, it seems that PDO->fetchAll() is faster but uses more momory...

Member Avatar
Member Avatar
+0 forum 1

In datasource i have 5 columns and i want 3 columns data in particular dropdownlist having a distinct value... plz help

Member Avatar
Member Avatar
+0 forum 14

Can someone tell me what's the difference between Instruction Cycle and Fetch&Execute Cycle? Thanks

Member Avatar
Member Avatar
+0 forum 2

Hi guys... I need some help from you all.. **Actual Scenario is :** This is Module to Update today's price of products and these TextBoxes below is created in loop with <input type="text" id="<?="rate2".$i?>" name="<?="rate2".$i?>" size="5" /> ($i is increment variable of loop) also I already got abc rate (Standard price). **Now Problem is :** Whenever user enters the value on 1 TBX it should compare this.value with abc rate and if this.value is low then entire row's text color should be red, so on. then finally, it should also highlight the lowest of all. **Please help me in this …

Member Avatar
Member Avatar
+0 forum 3

I need to fetch content from a file that is located at a URL say "http://example.com/sample.html?user=." This file will contain data in the following format:- Item =Name|Unit=1 QTY|Market=INDORE|Price=5000|UpdatedDateTime=Jun 27 2012 8:149PM After this line a <br> tag is used. How do I store the content into database. What I actually wish to do is insert or update this content (such as Name, Indore, 5000, Jun 27 2012 8:14 PM) to their respective fields' name. I am stuck up here. Any help would be appreciated. I thought of using php's f-read mechanism but am not aware of how to pause after …

Member Avatar
Member Avatar
+0 forum 3

hello, i am creating client server module.i want username and password from active directory for authentication. first time when i run program it it authenticate users but when i delete user & change password policy after that created new user and run the program then i got error authentication error. what should i do

Member Avatar
Member Avatar
+0 forum 2

Hey Guys, I m new here. I need a help I am working with a s/w where I need to fetch data from database onchange event. actually scene is the user will select one option (ie. name of company) from the dropdown box. According to that value the s/w should run query and fetch that company's data from MySQL db and the fetched data will be displayed on its related textboxes. This all should happen onchange event itself here is my code: <form action='form1.php' method='post'> <select name="<?="company".$a?>" id="<?="company".$a?>" onchange="search1()"> <option value=""></option> <? $comp_list = mysql_query("SELECT name FROM comp_name"); while($comp= mysql_fetch_array($comp_list) …

Member Avatar
Member Avatar
+0 forum 5

The End.