Click here to Skip to main content
15,889,200 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
GeneralRe: using jquery with php to [Add More..] Pin
Mohibur Rashid29-Dec-13 1:33
professionalMohibur Rashid29-Dec-13 1:33 
Questionwhat is the best open source script to manage team wrok Pin
TheSniper10512-Dec-13 1:35
professionalTheSniper10512-Dec-13 1:35 
QuestionRe: what is the best open source script to manage team wrok Pin
Richard MacCutchan12-Dec-13 2:47
mveRichard MacCutchan12-Dec-13 2:47 
AnswerRe: what is the best open source script to manage team wrok Pin
TheSniper10512-Dec-13 5:31
professionalTheSniper10512-Dec-13 5:31 
GeneralRe: what is the best open source script to manage team wrok Pin
Richard MacCutchan12-Dec-13 5:42
mveRichard MacCutchan12-Dec-13 5:42 
QuestionError in PHP application Pin
Member 1025130111-Dec-13 0:41
Member 1025130111-Dec-13 0:41 
AnswerRe: Error in PHP application Pin
Richard MacCutchan11-Dec-13 1:55
mveRichard MacCutchan11-Dec-13 1:55 
QuestionProblem with query result... Pin
Jassim Rahma25-Nov-13 10:15
Jassim Rahma25-Nov-13 10:15 
Hi,

I have the following code:

PHP
$mysql_query = $mysql_connection->prepare("CALL sp_get_company_details(:param_company_guid)");
$mysql_query->bindParam(':param_company_guid', $_GET["id"], PDO::PARAM_STR);
$mysql_query->execute();

$mysql_row_count = $mysql_query->rowCount();

if ($mysql_row_count <= 0) { exit(header("Location: " . $_SESSION["domain_name"] . "home")); }

while ($mysql_row = $mysql_query->fetch())
{
    $company_guid = $mysql_row["company_guid"];
    $company_name = $mysql_row["company_name"];
    $company_industry = $mysql_row["industry_name"];
    $company_country = $mysql_row["country_name"];
    $company_telephone = $mysql_row["company_telephone"];
    $company_fax = $mysql_row["company_fax"];
    $company_website = $mysql_row["company_website"];
    $company_email = $mysql_row["company_email"];
    $about_company = $mysql_row["about_company"];
    $hide_email = $mysql_row["hide_email"];
}

$mysql_query->closeCursor();

if (isset($_SESSION["member_guid"]))
{
    $mysql_query = $mysql_connection->prepare("CALL sp_check_if_company_admin(:param_company_guid, :param_member_guid)");
    $mysql_query->bindParam(':param_company_guid', $company_guid, PDO::PARAM_STR);
    $mysql_query->bindParam(':param_member_guid', $_SESSION["mmeber_guid"], PDO::PARAM_STR);
    $mysql_query->execute();

    while ($mysql_row = $mysql_query->fetch())
    {
        $is_company_admin = $mysql_row["company_admin_id"];
    }        
}

var_dump($company_guid);
var_dump($_SESSION["member_guid"]);
var_dump($is_company_admin);


the result for the three var_dump is:

string(36) "30383394-53bf-11e3-aef0-74de2b9a31a4" string(36) "22e52867-495d-11e3-95af-74de2b9a31a4" NULL


my question, why I am getting NULL? when I run the sp_check_if_company_admin on the database server using the same param's value I get a single record with company_admin_id = 13 so it's not NULL.!

Please Help...


Technology News @ www.JassimRahma.com

AnswerRe: Problem with query result... Pin
Graham Breach25-Nov-13 22:37
Graham Breach25-Nov-13 22:37 
GeneralRe: Problem with query result... Pin
Jassim Rahma25-Nov-13 22:57
Jassim Rahma25-Nov-13 22:57 
SuggestionRe: Problem with query result... Pin
thatraja26-Nov-13 0:59
professionalthatraja26-Nov-13 0:59 
QuestionHow can we remove Secure Login Pages Security in Php ? Pin
Member 103763032-Nov-13 8:05
Member 103763032-Nov-13 8:05 
AnswerRe: How can we remove Secure Login Pages Security in Php ? Pin
Richard Deeming4-Nov-13 1:48
mveRichard Deeming4-Nov-13 1:48 
QuestionPHP 5.2 -> 5.4 problem Pin
Mike Osbahr31-Oct-13 4:42
Mike Osbahr31-Oct-13 4:42 
AnswerRe: PHP 5.2 -> 5.4 problem -> SSI? Pin
Mike Osbahr6-Nov-13 5:44
Mike Osbahr6-Nov-13 5:44 
Questionhow can i split an object into chunks and send them ? Pin
kleymanx9027-Oct-13 0:31
kleymanx9027-Oct-13 0:31 
AnswerRe: how can i split an object into chunks and send them ? Pin
Richard MacCutchan27-Oct-13 2:06
mveRichard MacCutchan27-Oct-13 2:06 
GeneralRe: how can i split an object into chunks and send them ? Pin
kleymanx9027-Oct-13 19:53
kleymanx9027-Oct-13 19:53 
GeneralRe: how can i split an object into chunks and send them ? Pin
Richard MacCutchan27-Oct-13 22:40
mveRichard MacCutchan27-Oct-13 22:40 
GeneralRe: how can i split an object into chunks and send them ? Pin
Albert Holguin14-Nov-13 8:40
professionalAlbert Holguin14-Nov-13 8:40 
AnswerRe: how can i split an object into chunks and send them ? Pin
Albert Holguin14-Nov-13 8:38
professionalAlbert Holguin14-Nov-13 8:38 
QuestionPHP CODES TO DISPLAY SLIDING IMAGES Pin
Member 1034654419-Oct-13 11:12
Member 1034654419-Oct-13 11:12 
AnswerRe: PHP CODES TO DISPLAY SLIDING IMAGES Pin
Peter Leow4-Nov-13 1:52
professionalPeter Leow4-Nov-13 1:52 
QuestionAvailable username on all pages after login Pin
msz90013-Oct-13 6:03
msz90013-Oct-13 6:03 
AnswerRe: Available username on all pages after login Pin
Ringunger24-Oct-13 21:11
Ringunger24-Oct-13 21:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.