Linux, Apache, MySQL, PHP

Re: hide url from search engine

31-Dec-13 9:32

Hi,

I am using the following url for my website admin:

http://www.mywebsite.com/site.admin

I would like to know how can prevent search engines from indexing the above url and anything under that folder e.g. site.admin/new.php, site.admin/edit.php, etc?

Thanks,
Jassim

Technology News @ www.JassimRahma.com

Graham Breach1-Jan-14 1:50

Graham Breach

1-Jan-14 1:50

Use a robots.txt file: http://www.robotstxt.org/robotstxt.html[^]

how to check variable if null?

Jassim Rahma31-Dec-13 9:24

Re: how to check variable if null?

31-Dec-13 9:24

Hi,

I am using the following code to check if the $company_region is empty of NULL in the database but it's not working:

PHP

<?php if (!isset($company_region) || !empty($company_region) || !is_null($company_region)) { ?>
<tr>
    <td align="left" valign="top" style="width: 100px;">State / City</td>
    <td align="center" valign="top" style="width: 20px;">:</td>
    <td align="left" valign="top"><?php echo $company_region; ?></td>
</tr>
<?php } ?>

I tried all the combinations but I am still getting the row show on the page with a blank State/City! The value in the database is NULL when I run the stored procedure on the database itself.

What can I do?

Thanks
Jassim

Technology News @ www.JassimRahma.com

_debasis6-Jan-14 0:44

_debasis

6-Jan-14 0:44

You can check the data type for $company_region and check accordingly.
If it comes li null then you only need to check with null

if($company_region != NULL) {

// tasks you wanted
}

Please check the data type you get from the database.
Note:Can check it by var_dump($company_region);

Thanks
Debasis Behera
www.mindfiresolutions.com

change file format after upload

Jassim Rahma29-Dec-13 21:57

Re: change file format after upload

29-Dec-13 21:57

Hi,

I am using the jqeury-file upload[^] to upload members photos but it's uploading the same file with the same format. However, I want to save all photoz in PNG format.

How can I do this on the server side? and is it enough to just rename JPG, GIF or BMP to PNG?

Thanks,
Jassim

Technology News @ www.JassimRahma.com

Richard MacCutchan29-Dec-13 22:59

using jquery with php to [Add More..]

29-Dec-13 22:59

No, you cannot rename a file and expect it to be converted into a different type. You will need to provide a program to do the conversion.

Veni, vidi, abiit domum

Jassim Rahma24-Dec-13 6:53

24-Dec-13 6:53

I have a problem with this code. I am not sure if it's jquery's or php's problem.

I am using jquery and php to implement [Add More..]

first I'll list the code:

here is my jquery function:

JavaScript

<script type="text/javascript">
    $(function() {
        var counter = 0;
        $('#add_industry').click(function() {
            counter++;
            var newField = $('#cboIndustry').clone().
                attr({id: 'cboIndustry_' + counter,
                    // name: 'cboIndustry_' + counter});
                    name: 'cboIndustry[]'});
            $('#container').append(newField);
        });
    });
</script>

then here:

HTML

<tr>
    <td valign="middle">Industry</td>
    <td valign="middle">:</td>
    <td valign="middle">                
        <div id="container">
        <select id="cboIndustry" name="cboIndustry" style="width: 100%" required>
            <option value="" selected>[Industry..]</option>
            <?php
                $mysql_command = "CALL sp_populate_industry()";				
                $mysql_query = $mysql_connection->prepare($mysql_command);

                $mysql_query->execute();

                while($mysql_row = $mysql_query->fetch())
                {
            ?>
            <option value="<?php echo $mysql_row['industry_id']; ?>" <?php if ($mysql_row['industry_id'] == $company_industry) { echo 'selected'; } ?>><?php echo $mysql_row['industry_name']; ?></option>
            <?php } ?>
        </select>
        </div>
    </td>
</tr>
<tr>
    <td valign="middle"></td>
    <td valign="middle"></td>
    <td valign="middle"><p id="add_industry"><a href="javascript:void(0)"><span>Add Industry</span></a></p></td>
</tr>

and in my php code I am inserting into mysql using:

PHP

if ($_POST['cboIndustry']) 
{ 
    foreach ( $_POST['cboIndustry'] as $key => $value ) 
    { 
        $mysql_query = $mysql_connection->prepare('CALL sp_add_new_company_industry(:param_member_guid, :param_company_guid, :param_company_industry, :param_created_ip_address)'); 
        $mysql_query->bindParam(':param_member_guid', $_SESSION["xoompage_member_guid"], PDO::PARAM_STR); 
        $mysql_query->bindParam(':param_company_guid', $company_guid, PDO::PARAM_STR); 
        $mysql_query->bindParam(':param_company_industry', $value, PDO::PARAM_STR); 
        $mysql_query->bindParam(':param_created_ip_address', $_SERVER['REMOTE_ADDR'], PDO::PARAM_STR); 
        $mysql_query->execute(); 
    } 
}

now the problem is... if I am adding two industries then only one will be inserted in the database and if I add 10 only 9 will be added.. why?

Thanks,
Jassim

Technology News @ www.JassimRahma.com

Mohibur Rashid27-Dec-13 13:12

Mohibur Rashid

27-Dec-13 13:12

First of all, I do not like your programming style. Next is in your second code you named your select object without third bracket []. That is why php is rulling out your first post input. You should know which data is missing. Its the first input data.

I do not fear of failure. I fear of giving up out of frustration.

Jassim Rahma27-Dec-13 22:20

27-Dec-13 22:20

Thanks I will check the bracket, meantime.. I appreciate if you tell me what do you mean by (programming style) so that I can have it done in a better way.

Thanks

Technology News @ www.JassimRahma.com

Jassim Rahma28-Dec-13 5:54

28-Dec-13 5:54

Thank you Chris.

My problems is solved after adding the brackets.

Thank you once again..

Technology News @ www.JassimRahma.com

what is the best open source script to manage team wrok

Mohibur Rashid29-Dec-13 1:33

Mohibur Rashid

29-Dec-13 1:33

who is crish?

I do not fear of failure. I fear of giving up out of frustration.

TheSniper10512-Dec-13 1:35

TheSniper105

12-Dec-13 1:35

i want script that manage my time work assign tasks etc....

Re: what is the best open source script to manage team wrok

Richard MacCutchan12-Dec-13 2:47

Re: what is the best open source script to manage team wrok

12-Dec-13 2:47

What do you mean by 'script' in this context? There are plenty of products around for time and calendar management, that Google will find for you.

Veni, vidi, abiit domum

TheSniper10512-Dec-13 5:31

TheSniper105

12-Dec-13 5:31

script == web app

Re: what is the best open source script to manage team wrok

Richard MacCutchan12-Dec-13 5:42

Re: Error in PHP application

12-Dec-13 5:42

TheSniper105 wrote:
script == web app

While a web app may well contain some script (Javascript, PHP), there is more to it than that. And asking what is the best, is the same as asking what is the best anything. It depends on what you are looking for, what your experience is, etc.

Veni, vidi, abiit domum

Error in PHP application

Member 1025130111-Dec-13 0:41

Member 10251301

11-Dec-13 0:41

I am New in PHP, and getting following error message in my app, please help me to solve this.

fatal error call to undefined function mysql_connect()

Richard MacCutchan11-Dec-13 1:55

Problem with query result...

11-Dec-13 1:55

You have to define athe function called mysql_connect before you can use it. Either add the code yourself, or find a library that already includes it.

Veni, vidi, abiit domum

Jassim Rahma25-Nov-13 10:15

Re: Problem with query result...

25-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

Graham Breach25-Nov-13 22:37

Graham Breach

25-Nov-13 22:37

There's a typo in the last bind:

PHP

$mysql_query->bindParam(':param_member_guid', $_SESSION["mmeber_guid"], PDO::PARAM_STR);

"mmeber_guid" should be "member_guid"

Re: Problem with query result...

Jassim Rahma25-Nov-13 22:57