PHP - Php Redirection, Youtube Fault.

Greetz,


I am trying to write a simple newsletter sign up form using HTML FORM + PHP + MySQL.

I seem to be having a problem getting it working and I suspect the issue is in my PHP code and was wondering if someone could take a look at it for me to see if they can spot any obvious mistakes.

<?php
$link = mysql_connect('localhost', 'testuser', 'pass1');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_select_db("testdb", $link);
$sql="INSERT INTO newsletters(mens)
VALUES
('$_POST[e-mail]')";
if (!mysql_query($sql,$link))
   {
   die('Error: ' . mysql_error());
   }
echo "Done!";
mysql_close($link);
?>

Note: My SQL Database is named "testdb", I have a table called "newsletters" and a field called "mens".

Kind regards.

Hi,
I have been running a stream of PHP scripts using cron. Most of the sites are working perfectly except one.

That is getting failed only when invoked using cron.  It works fine, when invoked normally in a webpage.
It gives me the below error message.

/bin/sh: line 1:  3430 Segmentation fault

I have a similar code (99% same execution steps - 1% change in names) that is executed properly in cron.

I'm really confused on why the segmentation error happens only for a particular site, even though its clone is working properly in cron.

Any help would be much appreciated

Thanks,
Ursvmg

I am trying to protect my queries to check the user's ip address to make sure they are not banned...

When I comment out the if statement in $db->query the error goes away...

The checkIp function works in other instances, I am just trying to call it so nobody can inject things by trying to go around the actual pages...

my db function class looks like this:

Code: [Select]
class dblib {


function query($sql) {
if ($this->checkIp($_SERVER['REMOTE_ADDR']) == true) {
die("GH".$ip);  // Used to see if I can get that far...
$result = mysql_query($sql) or die("Database error: " . mysql_error() . "<br /><br /><h2>SQL</h2><p>$sql</p>");

return $result;
}

else
{
die("<h1>Banned</h1>");
}
    }

/// .......some other functions

    function checkIp($ip) {

$sql = "SELECT * FROM block WHERE ip='$ip' LIMIT 1 ";
$result = $this->query($sql);

if (mysql_num_rows($result) == 0)
return true;
else
return false;
}

Hi,

Help would be very appreciative

I am doing some preliminary testing for future projects.  A company we are working with supplied us with a wsdl file to communicate with their system.

I want to use PHP to run functions in the wsdl file but I got stuck after calling a function and I get no response back.  Below is my test snippet PHP code.  Below the PHP code is the wsdl file (also attached change the extension from .txt to .wsdl before using it).

When I run the php code from command line (linux server) I get a "Segmentation fault" back.  I am assuming that the error is coming from the wsdl file.  I am not high fly on wsdl code and I would not really know what I'm doing if I started chopping and dicing the wsdl file.


<?php
$client = new SoapClient("http://172.21.1.24:7070/comactivity/axis2services/OrderEntryWebService?wsdl/");
//if the wsdl exist locally use
//$client = new SoapClient("file.wsdl");

//echo var_export($client->__getFunctions(),true);

$arr_head=array(
  "cuno"  =>"1234",
  "ortp"  =>"ORD",
  "faci"  =>"M00",
  "rldt"  =>"20110811"
);

try {
  $arr = $client->__soapCall("addBatchHead", $arr_head);
   
}
catch (SoapFault $exception){
  echo $exception;
}
?>





=========== WSDL file within these tags =============

<?xml version="1.0" encoding="utf-16"?>
<wsdl:definitions xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:ns="http://services.web" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl" xmlns:ns1="http://org.apache.axis2/xsd" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" targetNamespace="http://services.web" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
  <wsdl:documentation>Order Entry Web Service</wsdl:documentation>
  <wsdl:types>
    <xs:schema attributeFormDefault="qualified" elementFormDefault="unqualified" targetNamespace="http://services.web">
      <xs:element name="addBatchHead">
        <xs:complexType>
          <xs:sequence>
            <xs:element minOccurs="0" name="cuno" nillable="true" type="xs:string" />
            <xs:element minOccurs="0" name="ortp" nillable="true" type="xs:string" />
            <xs:element minOccurs="0" name="faci" nillable="true" type="xs:string" />
            <xs:element minOccurs="0" name="rldt" nillable="true" type="xs:string" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="addBatchHeadResponse">
        <xs:complexType>
          <xs:sequence>
            <xs:element minOccurs="0" name="addBatchHeadReturn" nillable="true" type="xs:string" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="addBatchLine">
        <xs:complexType>
          <xs:sequence>
            <xs:element minOccurs="0" name="tempOrno" nillable="true" type="xs:string" />
            <xs:element minOccurs="0" name="itno" nillable="true" type="xs:string" />
            <xs:element minOccurs="0" name="orqt" nillable="true" type="xs:string" />
            <xs:element minOccurs="0" name="whlo" nillable="true" type="xs:string" />
            <xs:element minOccurs="0" name="dlsp" nillable="true" type="xs:string" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="addBatchLineResponse">
        <xs:complexType>
          <xs:sequence>
            <xs:element minOccurs="0" name="addBatchLineReturn" nillable="true" type="xs:string" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="confirm">
        <xs:complexType>
          <xs:sequence>
            <xs:element minOccurs="0" name="tempOrno" nillable="true" type="xs:string" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="confirmResponse">
        <xs:complexType>
          <xs:sequence>
            <xs:element minOccurs="0" name="confirmReturn" nillable="true" type="xs:string" />
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:schema>
  </wsdl:types>
  <wsdl:message name="addBatchLineRequest">
    <wsdl:part name="parameters" element="ns:addBatchLine" />
  </wsdl:message>
  <wsdl:message name="confirmRequest">
    <wsdl:part name="parameters" element="ns:confirm" />
  </wsdl:message>
  <wsdl:message name="confirmResponse">
    <wsdl:part name="parameters" element="ns:confirmResponse" />
  </wsdl:message>
  <wsdl:message name="addBatchHeadResponse">
    <wsdl:part name="parameters" element="ns:addBatchHeadResponse" />
  </wsdl:message>
  <wsdl:message name="addBatchLineResponse">
    <wsdl:part name="parameters" element="ns:addBatchLineResponse" />
  </wsdl:message>
  <wsdl:message name="addBatchHeadRequest">
    <wsdl:part name="parameters" element="ns:addBatchHead" />
  </wsdl:message>
  <wsdl:portType name="OrderEntryWebServicePortType">
    <wsdl:operation name="addBatchLine">
      <wsdl:input wsaw:Action="urn:addBatchLine" message="ns:addBatchLineRequest" />
      <wsdl:output wsaw:Action="urn:addBatchLineResponse" message="ns:addBatchLineResponse" />
    </wsdl:operation>
    <wsdl:operation name="addBatchHead">
      <wsdl:input wsaw:Action="urn:addBatchHead" message="ns:addBatchHeadRequest" />
      <wsdl:output wsaw:Action="urn:addBatchHeadResponse" message="ns:addBatchHeadResponse" />
    </wsdl:operation>
    <wsdl:operation name="confirm">
      <wsdl:input wsaw:Action="urn:confirm" message="ns:confirmRequest" />
      <wsdl:output wsaw:Action="urn:confirmResponse" message="ns:confirmResponse" />
    </wsdl:operation>
  </wsdl:portType>
  <wsdl:binding name="OrderEntryWebServiceHttpBinding" type="ns:OrderEntryWebServicePortType">
    <http:binding verb="POST" />
    <wsdl:operation name="addBatchLine">
      <http:operation location="OrderEntryWebService/addBatchLine" />
      <wsdl:input>
        <mime:content part="addBatchLine" type="text/xml" />
      </wsdl:input>
      <wsdl:output>
        <mime:content part="addBatchLine" type="text/xml" />
      </wsdl:output>
    </wsdl:operation>
    <wsdl:operation name="addBatchHead">
      <http:operation location="OrderEntryWebService/addBatchHead" />
      <wsdl:input>
        <mime:content part="addBatchHead" type="text/xml" />
      </wsdl:input>
      <wsdl:output>
        <mime:content part="addBatchHead" type="text/xml" />
      </wsdl:output>
    </wsdl:operation>
    <wsdl:operation name="confirm">
      <http:operation location="OrderEntryWebService/confirm" />
      <wsdl:input>
        <mime:content part="confirm" type="text/xml" />
      </wsdl:input>
      <wsdl:output>
        <mime:content part="confirm" type="text/xml" />
      </wsdl:output>
    </wsdl:operation>
  </wsdl:binding>
  <wsdl:binding name="OrderEntryWebServiceSoap11Binding" type="ns:OrderEntryWebServicePortType">
    <soap:binding transport="http://schemas.xmlsoap.org/soap/http" />
    <wsdl:operation name="addBatchLine">
      <soap:operation soapAction="urn:addBatchLine" style="document" />
      <wsdl:input>
        <soap:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap:body use="literal" />
      </wsdl:output>
    </wsdl:operation>
    <wsdl:operation name="addBatchHead">
      <soap:operation soapAction="urn:addBatchHead" style="document" />
      <wsdl:input>
        <soap:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap:body use="literal" />
      </wsdl:output>
    </wsdl:operation>
    <wsdl:operation name="confirm">
      <soap:operation soapAction="urn:confirm" style="document" />
      <wsdl:input>
        <soap:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap:body use="literal" />
      </wsdl:output>
    </wsdl:operation>
  </wsdl:binding>
  <wsdl:binding name="OrderEntryWebServiceSoap12Binding" type="ns:OrderEntryWebServicePortType">
    <soap12:binding transport="http://schemas.xmlsoap.org/soap/http" />
    <wsdl:operation name="addBatchLine">
      <soap12:operation soapAction="urn:addBatchLine" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
    </wsdl:operation>
    <wsdl:operation name="addBatchHead">
      <soap12:operation soapAction="urn:addBatchHead" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
    </wsdl:operation>
    <wsdl:operation name="confirm">
      <soap12:operation soapAction="urn:confirm" style="document" />
      <wsdl:input>
        <soap12:body use="literal" />
      </wsdl:input>
      <wsdl:output>
        <soap12:body use="literal" />
      </wsdl:output>
    </wsdl:operation>
  </wsdl:binding>
  <wsdl:service name="OrderEntryWebService">
    <wsdl:port name="OrderEntryWebServiceHttpEndpoint" binding="ns:OrderEntryWebServiceHttpBinding">
      <http:address location="http://172.21.1.24:7070/comactivity/axis2services/OrderEntryWebService/" />
    </wsdl:port>
    <wsdl:port name="OrderEntryWebServiceHttpSoap12Endpoint" binding="ns:OrderEntryWebServiceSoap12Binding">
      <soap12:address location="http://172.21.1.24:7070/comactivity/axis2services/OrderEntryWebService/" />
    </wsdl:port>
    <wsdl:port name="OrderEntryWebService" binding="ns:OrderEntryWebServiceSoap11Binding">
      <soap:address location="http://172.21.1.24:7070/comactivity/axis2services/OrderEntryWebService/" />
    </wsdl:port>
  </wsdl:service>
</wsdl:definitions>

============== End WSDL file ===================


Thank you

/Martin

[attachment deleted by admin]

I have a db class that contains several db functions.

The biggie is $db->query($sql) function.

EVERYTHING that goes to the database goes through this function, and I want to add some security...

I have a another function in the db class, checkIp($ip) that checks to see if the ip is in the block list or not.

Whenever I update the code (from the simple $result = mysql_query()... and return $result to have the if..else statement, I get a signal Segmentation fault...

Any ideas?

Code: [Select]
class dblib {


function query($sql) {
if ($this->checkIp($_SERVER['REMOTE_ADDR'])) {
//die("GH");  // For testing...
$result = mysql_query($sql) or die("Database error: " . mysql_error() . "<br /><br /><h2>SQL</h2><p>$sql</p>");

return $result;
}
else
{
die("<h1>Banned</h1>");
}
}



function checkIp($ip) {

$sql = "SELECT * FROM block WHERE ip='$ip' LIMIT 1 ";
$result = $this->query($sql);

if (mysql_num_rows($result) == 0)
return true;
else
return false;
}
}