PHP - Need Help Grabbing Data From External Html.

This question is part PHP, part MySQL.

I have a survey_responses table...

	- id
	- survey_id
	- question_id
	- member_id
	- response
	

 

For satisfaction questions (i.e. 1 = Strongly Disagree, 2 = Disagree, 3 = Neither, 4 = Agree, 5 = Strongly Agree), I'm trying to figure out how to get the counts for each of those responses into PHP so I can then feed them to a Bar Chart I hope to create with HTML/CSS.

1.) Should I create some kind of loop in PHP, and look for each value (e.g. 1 = Strongly Disagree) and one at a time plug them into variables called: $stronglyDisagree, $disagree, $neighter, $agree, $stronglyAgree?

 

2.) Or do I first need a "cross-tab" query in MySQL?

 

3.) Would this be easier if the database values were in a PHP array?

 

Not sure where to begin with this, and more importantly, I want to make sure that my data model in MySQL is sufficient so i can do reporting like this!!

 

Thanks.

 

Hey guys,

I have a script that grabs data from a separate .txt file which is used to perform certain actions within a user's account. The data I'm having trouble with is user key which is used to authenticate an http header. An example of what the txt file would hold is this:

360235276 PbI1c5+PGHSshccYd58AklmTgf5u+tbWZplMRYYxFSivRYw4AZhaVNHwADozYZhZhPnXRSV1rmsrhf1td7w6bJbySZmPHLl+hleyz/Ht4iM=
477947328 cXTnFEVP74RWtAgqM5BlwtgW2i9rP/v44oANzwF+yJZ+9mpvaschyo/HaYP1qUXgIK8nK7jy74iSCEHAgpPgPdryzpReM5cbnVDjRw7h9S0=
503724987 XXEJsklZTFaTx8MLjuNIz0S65Sn02rgbHl2sahdReQdadKP39 evIXUoYdr5NyQMWDVE7cRpvn+zJ7mteH7WJzVh0U/sOcSG7kfcuaWpAOfo=

The format I have is: account_ID user_key
New account on a fresh line. So in my script I have it grabbing the data as so:


$User_DataFile = "accountdata.txt";

$AccData = file($User_DataFile, FILE_SKIP_EMPTY_LINES);


foreach($AccData as $line_num => $line)
{
$AccData = explode(" ", htmlspecialchars(str_replace("    "," ",$line)));

if(stristr($AccData[1], "\n")) $AccData[1] = substr($AccData[1], 0, strlen($AccData[1])-2);

$AccountID = $AccData[0];
$UserKey = $AccData[1];
echo "Account ID: ".$AccountID."<br/>User Key: ".$UserKey."<br/><br/>";


I have it set to simply echo out the data for debugging which is where I noticed that any slashes or plus or equal signs were not included.
When run in Apache it returns this:

Account ID: 360235276
User Key: PbI1c5+PGHSshccYd58AklmTgf5u+tbWZplMRYYxFSivRYw4AZhaVNHwADozYZhZhPnXRSV1rmsrhf1td7w6bJbySZmPHLl+hleyz/Ht4iM

Account ID: 477947328
User Key: cXTnFEVP74RWtAgqM5BlwtgW2i9rP/v44oANzwF+yJZ+9mpvaschyo/HaYP1qUXgIK8nK7jy74iSCEHAgpPgPdryzpReM5cbnVDjRw7h9S0

Account ID: 503724987
User Key: XXEJsklZTFaTx8MLjuNIz0S65Sn02rgbHl2sahdReQdadKP39 evIXUoYdr5NyQMWDVE7cRpvn+zJ7mteH7WJzVh0U/sOcSG7kfcuaWpAOfo

So as you can see by comparison there is no slashes or plus or equal signs present, which is going to be a major problem. Is there any way of getting around this problem?

Thanks.

This is what i have..

I basicly need to take the Make and Model And Year Not the TYPE that needs to be left out and combine them into a drop down list.

So example below would be like this

Yamaha WR450F 2003-2006
Yamaha YZ450F 2003-2005


Code: [Select]
<table>
                                    <tr>
                                        <th>Type</th>

                                        <th>Make</th>
                                        <th>Model</th>
                                        <th class='tar'>Year</th>
                                    </tr>
                                   
                                       
                                       
                                       
                                       
                                       
                                       
                                       
                                           
                                       
                                       
                                       
                                        <tr class='even'>
                                            <td>Offroad</td>
                                            <td>Yamaha</td>

                                            <td>WR450F</td>
                                            <td class='tar'>2003-2006</td>
                                        </tr>
                                   
                                       
                                       
                                       
                                           
                                       
                                       
                                       
                                       
                                       
                                           
                                       
                                       
                                       
                                        <tr class='odd'>
                                            <td>Offroad</td>
                                            <td>Yamaha</td>
                                            <td>YZ450F</td>

                                            <td class='tar'>2003-2005</td>
                                        </tr>
                                   
                                </table>

Hi,

I need help to get data from a external URL.

URL: http://statistik.innebandy.se/ft.aspx?scr=playercareer&fplid=182506

Here is my code today:

$data = file_get_contents($url);

$dom = new domDocument;

@$dom->loadHTML($data);
$dom->preserveWhiteSpace = false;
$tables = $dom->getElementsByTagName('table');

$rows = $tables->item(2)->getElementsByTagName('tr');
print_r($rows[0]);
foreach ($rows as $row) {
        $cols = $row->getElementsByTagName('td');
}	

This i what i want:
I want to get every <tr> from table in a array.
How can i do that?

When I use PHP to gain data from another webpage I usually use
file_get_contents

Is there a faster way to retrieve data from webpages faster since it only seems to do around 200 website line retrievals per minute?

Is cURL faster?
Thank you

I'm trying to send some POST data to a page and then get the contents of it. The page is not on my server, so I can't use Sessions or GET. Google hasn't provided me with a definite answer. How would I do this?

Hi,

Is there a way to send extracted information from one (local) MySQL db, via PHP, to an external web form - having that web form submit that info to it's connected MySQL db without human interaction?

Basically, I need to automate a process using the $_GET function to that form but not sure if there is a way to accomplish this from just connecting to the web form (itself); bypassing direct MySQL access which is the later option.

Any input appreciated - thanks!

I have been given a task, and I gotta say it is kicking my butt.   Here is what I have to do.   1. Have user fill out and submit a form. 2. Data gets sent to: http://www.ffiec.gov...de/Default.aspx 3. Data is set as values for input fields in the sites form. 4. Form executes. 5. Retrieve result data. 6. Display data back to my site.   I have no idea how to do this.   Usually when I have done something like this I use an API.   Hope my question is clear.   Thanks for the help.

Hello, I've tried to get a dynamic table from an external page, and searching for entries in it, so i used a dynamic XLS file using php excel reader. I only exported the file, but i couldn't search for data. Can i get some help please ?

I need to pass captured data, basically, a list of email addresses that are being read from a CSV file and (1st) saved to an local database, then sent over to an external source via URL string.

I have everything working except - script opens the file, read and validates all emails in the specified column, and saves to local db.

ISSUE: after validating then INSERTING the data into local mySQL db, I need to then pass each piece of data to an external source via URL string.
Example: www.domain.com?email={$new_email}

I was initially think to just add the URL in a header function but, I'm not sure if the HEADER() function the right method to pass all of the data - during the loop - via the URL string.

For example, if the CSV file contain 500 emails:

Q: how can I continue that loop until the last email read, passing each up to the external source via the URL string?

I'm not sure if using the HEADER() function at the end of the script - but within the loop - will interate and send each capture email via that URL string.
Can anyone advise a possible solution to this?

thanks

Hi!

I am trying to use the View Model Design Pattern in my application

The problem is that it is the first time I use it and I am a beginner.

So, I have the logic in the Model and the "front end" in View. I am talking about a sign up page.

In the current Html file I am trying to access an error array from the model file and display it to the user above the input field.

 

Here is the a snippet from the Model (Signup.php)

$account = new Account($con); //the account which takes as param the db connection
$error = null; //the array

// anything the user writes gets inside this array
if (isset($_POST["submitButton"])) {

 $firstName = UnifyFormInput::unifyUserFLName($_POST["firstName"]);
 $lastName = UnifyFormInput::unifyUserFLName($_POST["lastName"]);
 $username = UnifyFormInput::unifyFormUserName($_POST["username"]);
 $email = UnifyFormInput::unifyFormEmail($_POST["email"]);
 $password = UnifyFormInput::unifyFormPassword($_POST["password"]);

 //contain true or false based on the query being successful or not
 $success = $account->register($firstName, $lastName, $username, $email, $password);
 if ($success) {
  $_SESSION["userLoggedIn"] = $username;
     header("Location:index.php");
 }else{
    $error = $account->getError(Constants::$registerFailed);

 }
}
//compact — creates array containing variables and their values
//call render function from View file to show the register page content
View::render('register', compact('error'));

And here is the view:

 <?php                 
        if (!empty($error)) {
          echo  $account->getError(Constants::$loginFailed);
       }                        
?>
<input type="text" class="form-control" name="firstName" placeholder= "First Name" value="<?php getInputValue("firstName"); ?>" required>

 

Hello guys,

I currently have a problem with echoing text coming from an external site, using file_get_contents. I won't consider myself a great PhP programmer, so I'll gladly appraciate any help! The code I am using is very simple:

<?php
$homepage = file_get_contents('http://www.live365.com/scp/web/stn/playlist.html?station=kolonku');

echo $homepage;
?>

However, the result comes out blank. If I change the link to a page made out of HTML, the code works, but the text here is a tracklist of a Live365 radio station. It changes dynamically according to what song is currently playing. I guess the code behind all this is formidable, to say the least, and I can't tell if it's made out of Javascript or PhP, or something else. Is there any way that I can solve this? I was thinking of getting the contents, then have the function updating every 10 seconds or so, so that the text is up to date most of the time. The current problem however, is getting something at all in the first place!

Link to the site I want to get the contents from (it updates atomatically! The source code won't give me a clue to what's going on..):
http://www.live365.com/scp/web/stn/playlist.html?station=kolonku

Hello to all,

I have problem figuring out how to properly display data fetched from MySQL database in a HTML table.

In the below example I am using two while loops, where the second one is nested inside first one, that check two different expressions fetching data from tables found in a MySQL database. The second expression compares the two tables IDs and after their match it displays the email of the account holder in each column in the HTML table.

The main problem is that the 'email' row is displayed properly while its while expression is not nested and alone(meaning the other data is omitted or commented out), but either nested or neighbored to the first while loop, it is displayed horizontally and the other data ('validity', 'valid_from', 'valid_to') is not displayed.'

Can someone help me on this, I guess the problem lies in the while loop?
Here is part of the HTML code:

<thead>
 <tr>
 <th data-column-id="id" data-type="numeric">ID</th>
 <th data-column-id="email">Subscriber's Email</th>
 <th data-column-id="validity">Validity</th>
<th data-column-id="valid_from">Valid From</th>
 <th data-column-id="valid_to">Valid To</th>
</tr>
</thead>

Here is part of the PHP code:

 

    <?php
    while($row = $stmt->fetch(PDO::FETCH_ASSOC))
    {
        echo '
            <tr>
                <td>'.$row["id"].'</td>
        ';
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)) {
        echo '
                <td>'.$row1["email"].'</td>
        ';
        }
        if($row["validity"] == 1) {
            echo '<td>'.$row["validity"].' month</td>';
        }else{
            echo '<td>'.$row["validity"].' months</td>';
        }
        echo '  <td>'.$row["valid_from"].'</td>
                <td>'.$row["valid_to"].'</td>
        </tr>';
    }
    ?>

P.S. Please know that I have purposely omitted the connection part and the methods in the class that are used in this code to keep the spot of the problem as clean as possible. If you need me to rephrase the question, please ask.

Thank you.

I'm trying to make a League of Legends (a video game) community website, both as a personal project and for practice.
Now the game has a lot of champions, each of whom have 5 unique abilities. Now, I thought about manually inputting all the details about each champion into a MySQL database, but that would long and tedious, and I don't really have the time for it now. Also, the game patches very oftern (like, once every 2 weeks) which changes many of the stats, etc. of the champion, and it is not possible for me to keep manually updating these every time there is a patch.

Fortunately, there is a League of Legends Wiki which has all the data I need in their specific champion pages, which they keep updated per patch. So I was wondering if there was any way to get the data from the divs in the wiki, and have it display on my site. What I want to do in my website is that whenever someone types a champion's name (in a post or whatever), I want it to display a hover-over dialog with some of the champions details. And a lot of other features such as that.

In plain English I need a way to :
> Tell PHP to go to the wiki's source code on a specific page
> Find a specific div container
> Get X data from there
> Pass X data into a function to display the hover-over

I think this way, I would not have to maintain a database as I can leech off the wiki's data.
I have not coded anything like this before, so I would like a few pointers as to how to achieve this. Any help will be appreciated!

Hi guys. I'm very new to PHP, and I'm trying to create a simple mail script.

Mail a friend
A user will click an image on the site which will open a pop up box. They input their name and the email of the friend that they want to send the current URL to. The email will send the current URL via email and display a confirmation message once it has sent successfully.
The friend will receive an email with a link to the URL.

The problem
The email part works fine, it's the URL in the message that is the issue. When the user clicks the 'Email a friend' it opens a popup box - which is where the URL is being grabbed from and emailed.
Is there a way to grab the URL from the page before the popup?

Here is my (rather amateur) code. Also, feel free to let me know if I can make improvements to it if anything seems a bit strange!

The popup link:
<a onclick="window.open(this.href,'win2','width=400,height=350,menubar=yes,resizable=yes'); return false;" title="E-mail" href="mailform/form.html">Send to a friend</a>

The popup form:

<html>
<body>
<form method="post" action="code.php">
    Friends Email: <input name="email" type="text" /><br />
    Your Name: <input name="name" type="text" /><br />
    <input type="submit" />
</form>
</body>
</html>


The PHP code:

<?php
// Declaring Variables
    $email = $_REQUEST['email'] ;
    $name = $_REQUEST['name'];
    $geturl = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
    $message = "Hello. $name has suggested a page for you to view on our website. Please click the following link: $geturl";

// Email Settings
    mail( $email, "Send page to a friend",
        $message, "From: Timaru District Council" );
    header( "Location: http://www.c4clever.com/sandbox/mailform/sent.html" ); // Confirmation page (Change this to appropriate URL)
?>

Feel free to test it out if you want to (http://www.c4clever.com/sandbox)


Looking forward to replies, thanks in advance!