PHP - Error W/ Curl (lots Of Urls)

so im trying to display error message which is (Error!</font> Currently no updates available.) if nothing from the url returns but all i see is the error message when i try to check for error the data which is available does not show. why so?

Code: [Select]
function weather(){
$ch = curl_init("http://www.domain.com/weather.html");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
if(curl_errno($ch)){
$page = curl_exec($ch);
preg_match('#<table[^>]*>(.+?)</table>#is', $page, $matches);
foreach ($matches as &$match) {
$match = $match;
}
echo '<table height=\"200px\">';
echo $matches[1];
echo '</table>';
}else{
echo "<table>";
echo "<tr>";
echo "<td>";
echo '<font align="center" color="red">Error!</font> Currently no updates available.';
echo "</td>";
echo "</tr>";
echo "</table>";
}
}

Hi all

i am trying to use curl function recursively but when the function first execute it get the content but next time it give the following error
Protocol http not supported or disabled in libcurl

Code: [Select]
$url = "http://www.example.com";
pager($url);

function pager($url){
        $urlArray = array();
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        $result = curl_exec($ch);
echo curl_error($ch);

        // code to get url from result
        // i get an array here $urlArray

        curl_close($ch);

        foreach($urlArray as $value){
$urlval = urlget($value);
if($urlval)
{
$urlval = str_replace("href=","",$urlval);
$urlval = str_replace("'","",$urlval);
echo $urlval.'<br>';
pager($urlval);
}

        }

    }

Hi,
Could somebody please explain to me why the following code returns a 400 error.  I've been sitting looking at it for hours and I can't see anything wrong with it, but then again I don't know too much about cURL.
Code: [Select]
<?php

// INSTANTIATE CURL.
$curl = curl_init();

// CURL SETTINGS.
curl_setopt($curl, CURLOPT_URL, "http://twitter.com/statuses/user_timeline/96966578.xml");
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl, CURLOPT_CONNECTTIMEOUT, 0);

// GRAB THE XML FILE.
$response = curl_exec($curl); 
// Get information about the response 
$responseInfo=curl_getinfo($curl); 
// Close the CURL connection curl_close($curl);
curl_close($curl);

// Make sure we received a response from Twitter 
if(intval($responseInfo['http_code'])==200){ 
// Display the response from Twitter 
$content .= "Success code response:". $response; 
}else{ 
// Something went wrong 
$content .= "Error: " . $responseInfo['http_code']; 
} 


// SET UP XML OBJECT.
$xmlObjTwitter = simplexml_load_string( $response );

$content .="<h3>Your last 10 twitter posts....</h3>\n" ; 

$content .= "<ul> \n";

$tempCounter = 0;

foreach ( $xmlObjTwitter -> item as $item )
{                    
    // DISPLAY ONLY 10 ITEMS.
    if ( $tempCounter < 11 )
    {
        $content .= "<li><a href=\"{$item -> guid}\">{$item -> title}</a></li>
";
    }

    $tempCounter += 1;
}

$content .="</ul>\n";

echo $content ;


?>

Hi, 

I have this curl string required by an email verification vendor I use. Inside my php file I wish to run it.  Apparently there is a problem with the syntax as I’m getting the following error in the browser:

”Parse error: syntax error, unexpected '--' (T_DEC) in /var/www/html/wp-content/plugins/dw_functionality_plugin/dw_functionality_plugin.phpon line 398

Here is the code string:

<
curl --request POST\
  --url 'https://api.neverbounce.com/v4/single/check?key={' . api_key . '}&email={' . email . '};

>

any help much appreciated!

Edited March 23 by dwest100

Hi there,

I'm writing an application that pulls from two separate web based APIs, collates the data into a single array of data.  Once done, it then enters a loop that cycles through the array and executes a cURL call for each cycle.  This worked perfectly for a controlled set of 10 artificial records and so I've started testing with live data.

On running the code, I eventually the following :
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

I'm not sure how to debug this and so I'm hoping I can find some help here.
I'm running WAMP, and the php.ini contains the following:
max_execution_time = 0   ; Maximum execution time of each script, in seconds
max_input_time = 0   ; Maximum amount of time each script may spend parsing request data

Through testing, I have discovered the following :
The script can do exactly 35 iterations through the loop in under 2 minutes.
Any number greater than this causes the error.
If I skip the first 20 curl submits, I can then do 21 to 55 iterations before failure, so I do not believe it is the 36th value.
If I put a sleep(5) command into the loop, I can still do 35 and no more iterations than that.
If I put a sleep(10) command into the loop, it fails on 35 and needs less.

Code: [Select]
$action = "post";
$url = "http://url.url.url/api/v1.0/udo_Position/create"; // I've replaced the actual URL out of necessity

// set user agent {
print("Setting CURL options, using URL ".$url."<br>");
$cd = curl_init();
curl_setopt($cd, CURLOPT_HEADER, 1);
curl_setopt($cd, CURLOPT_URL, $url);
curl_setopt($cd, CURLOPT_USERPWD, 'username:password');
curl_setopt($cd, CURLOPT_RETURNTRANSFER, 1); // Don't send return value to screen
curl_setopt($cd, CURLOPT_USERAGENT, "Firefox/2.0.0.1"); // spoofing FireFox 2.0
curl_setopt($cd, CURLOPT_VERBOSE, true);
// }

if ($action == 'get') {
;
} elseif ($action == 'post') {
print("POST set;<br>");
print("<pre style='font-family:verdana;font-size:13'>");
print_r($pointval);
print("</pre>");
$pointval["save"] = "Save"; // The AddNew step form requires this.

curl_setopt($cd, CURLOPT_POSTFIELDS, $pointval);
} else {
print("Invalid usage. Please see example<br>");
return;
}

$reply = curl_exec($cd);

$http_status = curl_getinfo($cd, CURLINFO_HTTP_CODE);
print("<pre style='font-family:verdana;font-size:13'>");
print_r($http_status);
print("</pre>");

print("Here is the reply from the AddNew function: <br>");
print("<pre style='font-family:verdana;font-size:13'>");
print_r($reply);
print("</pre>");

if (curl_error($cd)) {
print("Error: ".(curl_error($cd))."<br>");
}

curl_close($cd);
print("Insert Successful.<br>");

I am uncertain whether it is a PHP, Apache or cURL issue at this point.  I have another script that pushes a great deal more cURL calls to the same system but pulls from only one external resource, instead of two.  Any help or suggestions would be appreciated.

My dad loves these frozen cheeseburgers from meijer so I was gonna write a little script I can run in cron that will check Meijer's website and txt or email or something if they go on sale.

Whenever I run the below script I get an Access Denied response from the server instead of the html for the cheesburger page.

I'm sure I just need a CURL option or something. 

Thank You in Advance

 

function curl_download($Url){ if (!function_exists('curl_init')){ die('cURL is not installed. Install and try again.'); } $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $Url); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_VERBOSE, true); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:47.0) Gecko/20100101 Firefox/47.0"); $output = curl_exec($ch); curl_close($ch); return $output; } print curl_download("https://www.meijer.com/shop/en/frozen/frozen-meals/sandwiches/meijer-bacon-cheeseburger-4-9-oz/p/71373326278");
 

First, I gotta say I am new to JavaScript, but not new to languages like PHP/C++.   I am working on a large huge JS file that has a lot of things and I have a feeling that it can be made better.  How is where I am at a loss.  If it was PHP, I'd split that JS file into probably 20 other smaller JS files, aka "classes", and it may or may not be the right thing to do, but let me focus on one particular aspect for now, and maybe deal with others later.   Here is the piece of code that bugs the me most (truncated for clarity):

   if (selection[index].selected) {

        result += '<TABLE class="list_grey" style="float: left; margin-left: 20px;">';
        result += '<TR>';
        result += '<TH colspan="2">Data</TH>';
        result += '</TR>';
        
        var flag = "All";

        if (selection[index].flag == 'P')
            flag = "Premium";
        
        result += '<TR>';
        result += '<TD>Flag</TD>';
        result += '<TD>' + flag + '</TD>';
        result += '</TR>';
        result += '</TABLE>';
    }
    else
    {
        result += '<TABLE class="list_grey" style="float: left; margin-left: 20px;">';
        result += '<TR>';
        result += '<TH colspan="2">Frame</TH>';
        result += '</TR>';
        result += '<TR>';
        result += '<TD>Frame</TD>';
        result += '<TD>' + selection[index].frame + '</TD>';
        result += '</TR>';
        result += '</TABLE>';
    }

So what it does is this:   1.  it gets "selection" var with eval() from a DIV block of HTML page, where that DIV has a looooong prepared-by-PHP JSON string with all the options prepopulated from various sources accessible to PHP.

var selection    = eval("(" + document.getElementById("result").innerHTML + ")");

2.  It then dynamically constructs and populates further HTML using logic and data found in "selection" var.   3.  This particular JS implements a selection algorithm, where basically user clicking buttons can navigate "selection" var forwards and backwards, and as user does, the dynamic portion of HTML updates per behavior defined in the JS file.   My Problem / Question:  I have a feeling that putting HTML the way it is done here in JS file is not proper separation of concerns and not good way to code.  HTML should be. .. in HTML, when possible, but being new to JS I don't know if there is a better way.  Is there a more recommended way to code what I have now ?    

I am trying to get more than one row from a database at once, then explode each value into a seperate variable. is there a way of doing this?

Hey guys! im currently learning javascript, PHP and SQL. I have a pretty solid understanding of HTML and CSS. I want to make a site similar to facebook (a good facebook). this is going to be a big project and i plan on moving to a bigger server system in a year or so to keep up with demands.    Heres how the site will function:    1. Basic registration/splash page. I understand that the finished form is sent to a php file on the server side, correct?  (ill change my server name files of course)   2. after the registration page, while the user is logged in with their new account, there are 3 pages after that that explain what the website is all about and how to use it. the last page allows the user to setup their profile information, ask friends to join, and asks what type of things they like. After the last page, it sends the user to their main control panel, where social media feed can be seen, friends and online chats, news, advertisements, links, pages and groups (think facebook and linkedin)   3. the user will have the ability to look at their profile (not the control panel), and of course switch back to their control panel. social media, friends, groups and ads will also be on their individual profile page as well.   4. i want the site to have two views: a standard view and an enhanced view. the enhanced view will reposition divs and all that stuff so they can see a background image (either stock or one they uploaded) this image will eventually change to an animated image of a 3d environment.   5. the site is going to be heavily social media based. This means social media feeds, image uploading, a structured comment system, a friend system, search functions and targeted advertising.   This is obviously a lot to ask, but since their is so much to learn related to PHP and SQL, can someone point me to the right tutorials on how to get these things done? I am currently learning javascript, PHP and SQL on lynda.com. Expect me to be on this forum a lot and asking a lot of questions. Thanks for any help. 
Edited by PHPlearner32, 10 January 2015 - 11:19 PM.

good day dear community,

i am workin on a Curl loop to fetch multiple pages:

i have some examples - and a question:

Example: If we want to get information from 3 sites with CURL we can do it like so:


$list[1] = "http://www.example1.com";
$list[2] = "ftp://example.com";
$list[3] = "http://www.example2.com";


After creating the list of links we should initialize the cURL multi handle and adding the cURL handles.


$curlHandle = curl_multi_init();
for ($i = 1;$i <= 3; $i++)
 $curl[$i] = addHandle($curlHandle,$list[$i]);


Now we should execute the cURL multi handle retrive the
content from the sub handles that we added to the cURL multi handle.

ExecHandle($curlHandle);
for ($i = 1;$i <= 3; $i++)
{
 $text[$i] =  curl_multi_getcontent ($curl[$i]);
 echo $text[$i];
}

In the end we should release the handles from the cURL multi handle by calling curl_multi_remove_handle and close the cURL multi handle!

If we want to another Fetch of sites with cURL-Multi - since this is the most pretty way to do it!
Well I am not sure bout the string concatenation. How to do it - Note I want to fetch several hundred pages:
see the some details for this target-server sites - /(I have to create a loop over several hundred sites).

    * siteone.example/?show_subsite=9009
    * siteone.example/?show_subsite=9742
    * siteone.example/?show_subsite=9871

.... and so on and so forth Question: How to appy this loop into the array of the curl-multi?



<?php
/************************************\
* Multi interface in PHP with curl  *
* Requires PHP 5.0, Apache 2.0 and  *
* Curl         *
*************************************
* Writen By Cyborg 19671897         *
* Bugfixed by Jeremy Ellman         *
\***********************************/

$urls = array(
   "siteone",
   "sitetwo",
   "sitethree"
   );

$mh = curl_multi_init();

foreach ($urls as $i => $url) {
       $conn[$i]=curl_init($url);
       curl_setopt($conn[$i],CURLOPT_RETURNTRANSFER,1);//return data as string 
       curl_setopt($conn[$i],CURLOPT_FOLLOWLOCATION,1);//follow redirects
       curl_setopt($conn[$i],CURLOPT_MAXREDIRS,2);//maximum redirects
       curl_setopt($conn[$i],CURLOPT_CONNECTTIMEOUT,10);//timeout
       curl_multi_add_handle ($mh,$conn[$i]);
}

do { $n=curl_multi_exec($mh,$active); } while ($active);

foreach ($urls as $i => $url) {
       $res[$i]=curl_multi_getcontent($conn[$i]);
       curl_multi_remove_handle($mh,$conn[$i]);
       curl_close($conn[$i]);
}
curl_multi_close($mh);


print_r($res);

?>





I look forward to your ideas.

hi,

I am building a web app and need all my php on one page and links posting to same page etc, at the moment, I am linking to my townpubs.php page see code below:

townpubs.php
Code: [Select]
<!doctype html>
<?php 
 include "../config.php";
$loggedIn = (isset($_COOKIE['loggedin']) && $_COOKIE['loggedin'] == 'true')?true:false;

$town = $_REQUEST['RSTOWN'];
$towns = mysql_query("SELECT * FROM pubs WHERE RSTOWN = '".$town."' ORDER BY RSTOWN ASC");
?>
<html>
    <head>
        <meta charset="UTF-8" />
        <title>My Pub Space v1.0 &beta;</title>
        <style type="text/css" media="screen">@import "jqtouch/jqtouch.min.css";</style>
        <style type="text/css" media="screen">@import "themes/jqt/theme.min.css";</style>
        <script src="jqtouch/jquery.1.3.2.min.js" type="text/javascript" charset="utf-8"></script>
        <script src="jqtouch/jqtouch.min.js" type="application/x-javascript" charset="utf-8"></script>
        <script type="text/javascript" charset="utf-8">
            var jQT = new $.jQTouch({
                icon: 'jqtouch.png',
                addGlossToIcon: false,
                startupScreen: 'jqt_startup.png',
                statusBar: 'black',
                preloadImages: [
                    'themes/jqt/img/back_button.png',
                    'themes/jqt/img/back_button_clicked.png',
                    'themes/jqt/img/button_clicked.png',
                    'themes/jqt/img/grayButton.png',
                    'themes/jqt/img/whiteButton.png',
                    'themes/jqt/img/loading.gif'
                    ]
            });
        </script>
    </head>
    <body>
<!-- TOWNS -->
<div id="towns" class="current">
            <div class="toolbar">
                <h1>View Pubs</h1>
                <a class="back" href="index.php" rel="external">Home</a>
            </div>
<h2>Pubs in <?php echo $town ?></h2>
            <ul class="plastic">
               <?php while($row1 = mysql_fetch_array($towns))
{
echo '<li class="arrow"><a href="pubinfo.php?PUBID='.$row1['PUBID'].'" rel="external">'.$row1['rsPubName'].'</a></li>'; 
}
?>
            </ul>
        </div>
    </body>
</html>

I would like to have this on my index.php page:
index.php
Code: [Select]
<!doctype html>
<?php 
 include "../config.php";
$loggedIn = (isset($_COOKIE['loggedin']) && $_COOKIE['loggedin'] == 'true')?true:false;
$query1 = "SELECT DISTINCT rsTown FROM pubs ORDER BY rsTown asc";
$result = mysql_query($query1);


$towns = mysql_query("SELECT DISTINCT RSTOWN, COUNT(PUBID) As PubCount FROM pubs GROUP BY RSTOWN  ORDER BY RSTOWN ASC");
$counties = mysql_query("SELECT DISTINCT RSCOUNTY, COUNT(PUBID) As PubCount1 FROM pubs GROUP BY RSCOUNTY  ORDER BY RSCOUNTY ASC");
if ($loggedin == 'true'){
$locals = mysql_query("SELECT * FROM pubs INNER JOIN favepub_copy ON pubs.PUBID=favepub_copy.PUBID WHERE USERID='".$_SESSION['USERID']."' ORDER BY rsPubName asc");
}
?>
<html>
    <head>
        <meta charset="UTF-8" />
        <title>My Pub Space v1.0 &beta;</title>
        <style type="text/css" media="screen">@import "jqtouch/jqtouch.min.css";</style>
        <style type="text/css" media="screen">@import "themes/jqt/theme.min.css";</style>
        <script src="jqtouch/jquery.1.3.2.min.js" type="text/javascript" charset="utf-8"></script>
        <script src="jqtouch/jqtouch.min.js" type="application/x-javascript" charset="utf-8"></script>
        <script type="text/javascript" charset="utf-8">
            var jQT = new $.jQTouch({
                icon: 'jqtouch.png',
                addGlossToIcon: false,
                startupScreen: 'jqt_startup.png',
                statusBar: 'black',
                preloadImages: [
                    'themes/jqt/img/back_button.png',
                    'themes/jqt/img/back_button_clicked.png',
                    'themes/jqt/img/button_clicked.png',
                    'themes/jqt/img/grayButton.png',
                    'themes/jqt/img/whiteButton.png',
                    'themes/jqt/img/loading.gif'
                    ]
            });
        </script>
    </head>
    <body>
    <div id="about" class="selectable">
<p><img src="jqtouch.png" /></p>

<p><strong>My Pub Space</strong><br />Version 1.0 beta<br />
  <a href="http://www.jbiddulph.com" target="_blank">By John Biddulph</a></p>
<p><em>Mobile Web Development</em></p>
<p><a href="mailto:john.mbiddulph@gmail.com" target="_blank">E-mail</a></p>
<p><a href="http://twitter.com/#!/jmbiddulph" target="_blank">@jmbiddulph on Twitter</a></p>
<p><br /><br /><a href="#" class="grayButton goback">Close</a></p>
</div>
      <div id="home" class="current">
  <?php if (!$loggedIn){ ?>
<div class="toolbar">
<h1>My Pub Space</h1>
<a href="#about" id="infoButton" class="button slideup">About</a>
</div>
<ul class="rounded">
<li class="forward"><a href="#signup">Register an account</a></li>
<li class="forward"><a href="#login">Login</a></li>
<li class="forward"><a href="#towns">View pubs by town</a></li>
<li class="forward"><a href="#counties">View pubs by county</a></li>
</ul>
<div class="info">
          <p>All Rights Reserved &copy; 2011 mypubspace.com Created by: jbiddulph.com</p>
         </div>
<?php } else { ?>
<div class="toolbar">
<h1>Hi <?php echo $_SESSION['s_username'];?></h1>
<a href="dologoff.php" rel="external" class="button">Logout</a>
</div>
<ul class="rounded">
<li class="forward"><a href="#locals">View Locals</a></li>
<li class="forward"><a href="#towns">View Towns</a></li>
<li class="forward"><a href="#counties">View Counties</a></li>
</ul>
<div class="info">
          <p>All Rights Reserved &copy; 2011 mypubspace.com Created by: jbiddulph.com</p>
         </div>
<?php } ?>
</div>

<!-- LOCALS -->
<div id="locals">
            <div class="toolbar">
                <h1>My Locals</h1>
                <a class="back" href="#home">Back</a>
            </div>
            <ul class="plastic">
               <?php while($row1 = mysql_fetch_array($locals))
{
echo '<li class="arrow"><a href="pubinfo.php?PUBID='.$row1['PUBID'].'" rel="external">'.$row1['rsPubName'].', '.$row1['rsTown'].'</a></li>'; 
}
?>
            </ul>
        </div>

<!-- TOWNS -->
<div id="towns">
            <div class="toolbar">
                <h1>View Towns</h1>
                <a class="back" href="#home">Back</a>
            </div>
<ul class="edgetoedge">
<?php
$ltr = '';
while($row1 = mysql_fetch_array($towns)) {
 $letter1 = substr($row1['RSTOWN'],0,1);
 if ($letter1 != $ltr) {
 print'<li class="sep">'. $letter1 .'</li>';
 }
 $ltr = $letter1;
 echo '<li class="forward"><a href="townpubs.php?RSTOWN='.$row1['RSTOWN'].'" rel="external">'.$row1['RSTOWN'].'<small class="listcounter">'.$row1['PubCount'].'</small></a></li>';
}
?>
</ul>
        </div>
 
  <!-- COUNTIES -->
  <div id="counties">
            <div class="toolbar">
                <h1>View Counties</h1>
                <a class="back" href="#home">Back</a>
            </div>
            <ul class="edgetoedge">
                <?php
$ltr = '';
while($row1 = mysql_fetch_array($counties)) {
 $letter1 = substr($row1['RSCOUNTY'],0,1);
 if ($letter1 != $ltr) {
 print'<li class="sep">'. $letter1 .'</li>';
 }
 $ltr = $letter1;
 echo '<li class="forward"><a href="countypubs.php?RSCOUNTY='.$row1['RSCOUNTY'].'" rel="external">'.$row1['RSCOUNTY'].'<small class="listcounter">'.$row1['PubCount1'].'</small></a></li>';
}
?>
            </ul>
        </div>
 
 
        <form id="login" action="dologin.php" method="POST" class="form">
            <div class="toolbar">
                <h1>Login</h1>
                <a class="back" href="#">Back</a>
            </div>
            <ul class="rounded">
                <li><input type="text" name="rsUser" value="" placeholder="Username" /></li>
<li><input type="Password" name="rsPass" value="" placeholder="Password" /></li>
            </ul>
            <a style="margin:0 10px;color:rgba(0,0,0,.9)" href="#" class="submit whiteButton">Submit</a>
        </form>
  <form id="signup" action="dosignup.php" method="POST" class="form">
            <div class="toolbar">
                <h1>Sign up</h1>
                <a class="back" href="#">Back</a>
            </div>
            <ul class="rounded">
                <li><select name="RSTOWN" class="postcodedrop">
<option value="">Choose your Town...</option>
<?PHP while($row = mysql_fetch_array($result))
{

echo '<option value="'.$row['rsTown'].'">';
echo $row['rsTown'];
echo '</option>';
}?>
</select></li>
<li><input name="RSUSER" type="text" class="textbox" id="RSUSER" value="" placeholder="Username" /></li>
<li><input type="Password" name="RSPASS" value="" placeholder="Password" /></li>
<li>Male&nbsp;<input name="RSGENDER" type="radio" value="Male" />&nbsp;&nbsp;Female&nbsp;<input name="rsGender" type="radio" value="Female" /></li>
<li><input name="RSEMAIL" type="text" class="textbox" id="rsEmail" placeholder="Email" /></li>
<li><input name="RSMOBILE" type="text" class="textbox" id="rsMobile" placeholder="Mobile No." /></li>
<li><input name="RSAGE" type="text" class="textbox" id="datepicker" placeholder="DOB: dd/mm/yyyy" /></li>
            </ul>
            <a style="margin:0 10px;color:rgba(0,0,0,.9)" href="#" class="submit whiteButton">Submit</a>
        </form>
    </body>
</html>

I need to set empty variables at the top and link page to itself?!

We have a database that shows for example:

2500-5000

5000-10000

10000-15000

15000-20000

I need to show in a screen what people are have 3000 followers, and as such as grouped into that 2500-5000.

The best way I can see how to do this, is to run through the database table for these values.

Then for each value, put the first and second set of numbers into two respective variables, say $low, $high.

Then find those people who are on a particular platform with followers between those two values.

So how do I turn $row->followsrange (which might be for example: "2500-5000"), into:

$low = 2500
$high = 5000.

Many thanks.  ps  I have a feeling the hyphen might play a bit part, as it cannot be done by the amount of characters..........

My site seems to be going well, but on the back end, the users database is going crazy with duplicate entrys. but its not doing it from an INSERT. it seems to be doing it with this code:
Code: [Select]
               $bitquery = $bitcoin->move("bittleship$username", "bittleships", $cost, $minconfirmations);
               if ($bitquery == true){
               $query = mysql_query("INSERT INTO `transactions` ( `id` , `username` , `type` , `amount`, `address`) VALUES ('', '$username', 'buyclicks', '$cost', '')")  or die(mysql_error());
               $query = mysql_query("UPDATE users SET `clicks` = `clicks`+$quantity, `balance`=`balance`-$cost WHERE `username` = '$username' ") or die(mysql_error());
               include('update.php');

Hi i followed a guid to create a login area to my site however i believe its a little outdated and therefore not working, i have done a little bit but being quite new i cannot find all the problems at the moment i have:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/a9855336/public_html/checklogin.php on line 12
here is my script line 12 is marked

<?php
$host="*************"; // Host name 
$username="a9855**6_root"; // Mysql username 
$password="************"; // Mysql password 
$db_name="****3***36_mail; // Database name 

// Connect to server and select databse.
mysql_connect($host, $username, $password)
mysql_select_db($db_name);

// username and password sent from form 
$myusername=$_POST['myusername']; // line 12
$mypassword=$_POST['mypassword'];

// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

// encrypt password 
$encrypted_mypassword=md5($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$encrypted_mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword"); 
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>

if you help please tell me the error so i can learn to debug scripts myself in the future

thanks

blink359

Hi there,

I'm creating a shopping cart and to work out postage cost I need to add all the items weights together.

The weight of each item is in the database.

I currently have this code:

Code: [Select]

$basket = $_SESSION['basket'];
if ($basket) {
$items = explode(',',$basket);
$contents = array();
foreach ($items as $item) {
$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
}
foreach ($contents as $id=>$qty) {
$sql = "SELECT * FROM store WHERE id LIKE '$id' AND live LIKE '0'";
$result = mysql_query($sql);
while ($rows = mysql_fetch_array($result)) {
extract($row);

so to work out each item's weight I can do $rows['weight'] * $qty.

but how could i add all the item's weight together?

i hope that makes some sense.

thanks,

jack