Linux, Apache, MySQL, PHP

Re: Is there Dictionary Object in PHP

11-Dec-11 8:28

You can do that using an array:

<?php
$dict = array('a' => 1, 'b' => 2, 'z' => 0);
$dict['c'] = 5;
$dict['a more complex value'] = array('X' => 'OK');

foreach($dict as $key => $value)
  echo "$key : $value<br />\n";

awedaonline11-Dec-11 10:57

11-Dec-11 10:57

Thanks Graham.

Your solution works.

Thanks.

date format problem

Jassim Rahma10-Dec-11 21:40

10-Dec-11 21:40

I have this date in mysql datetime field:

2011-12-10 18:27:51

I am using this code in php to display it:

PHP

$created_date = mysql_result($result, $i ,"created_date");
		
echo date("d/m/Y", $created_date);

but the result is wrong! here is the result:

31/12/1969

how can I fix it please?

Re: date format problem

Graham Breach10-Dec-11 23:09

10-Dec-11 23:09

If a function doesn't do what you expect it to, you should go back and read the manual. The second argument to the date function should be an integer timestamp, but you are giving it a string.

You can get an integer timestamp from your string using the strtotime function[^].

Re: date format problem

awedaonline11-Dec-11 7:57

page not showing in full height

11-Dec-11 7:57

Have you tried

<?php echo date_format($date, 'd-m-Y H:i:s'); ?>

Re: date format problem

cjoki12-Dec-11 6:40

cjoki

12-Dec-11 6:40

2nd arguement requires a unix timestamp. Take a look at date() and mktime() functions in the manual.

If your dat coming from the db is a datetime stamp you may want to use strtotime() to convert it into the unix timestamp needed for the 2nd date arg.

Chris J
www.redash.org

Jassim Rahma10-Dec-11 3:46

Re: page not showing in full height

10-Dec-11 3:46

I am using an iframe with 100% table and td as well as iframe but the ifarame is still not going into full height..

here is my code:

!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-us">
<head>
	<title>Jassim Rahma</title>
	<?php include("tags.php"); ?>
	<meta name="description" content="Where technology meets business intelligence." />
</head>
<body dir="ltr" lang="en-us">
<table width="100%" cellpadding="0" cellspacing="0" height="100%">
	<tr><td colspan="3" style="border-bottom-color: #D3D3D3; border-bottom-style:solid;; border-bottom-width: thin"><?php include("header.php"); ?></td></tr>
	<tr>
		<td valign="top" style="padding: 10px" height="100%">
			<iframe src="http://www.boutell.com/newfaq/creating/include.html" style="border:0px #FFFFFF none;" name="headline" scrolling="no" frameborder="0" marginheight="0px" marginwidth="0px" height="100%" width="100%"></iframe>            
		</td>
	</tr>
</table>

<?php include("Piwik.php"); ?>

</body>
</html>

cjoki12-Dec-11 6:42

cjoki

12-Dec-11 6:42

does the include file Piwik.php have any output?

try hiding it and see if you issue persist.

Chris J
www.redash.org

Re: page not showing in full height

Danny Martin5-Jan-12 2:48

Danny Martin

5-Jan-12 2:48

This is not a PHP problem, it's a CSS style issue. Try setting the height of the and tags to 100% and 'absolutely' position the outer table (or better still, replace it with a div)

That should solve the problem...

Danny

include question

Jassim Rahma10-Dec-11 3:35

10-Dec-11 3:35

I am trying to use include to place a web page from another webiste on my website using this code but I am just getting it blank! how can I fix this please..

XML

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-us">
<head>
    <title>Jassim Rahma</title>
    <?php include("tags.php"); ?>
    <meta name="description" content="Where technology meets business intelligence." />
</head>
<body dir="ltr" lang="en-us">
<table width="100%" cellpadding="0" cellspacing="0">
    <tr><td colspan="3" style="border-bottom-color: #D3D3D3; border-bottom-style:solid;; border-bottom-width: thin"><?php include("header.php"); ?></td></tr>
    <tr>
        <td valign="top" style="padding: 10px">
            <?php include("http://www.boutell.com/newfaq/creating/include.html"); ?>
        </td>
    </tr>
</table>

<?php include("Piwik.php"); ?>

</body>
</html>

awedaonline11-Dec-11 7:52

11-Dec-11 7:52

This is how I do this within my site but have not tried the remote side of it.

include_once $_SERVER['DOCUMENT_ROOT'] . 'aweklin/classes/StringHelper.php';

Gerben Jongerius11-Dec-11 19:34

Gerben Jongerius

11-Dec-11 19:34

You can't do a cross server include like that. PHP include directive only works with files on the same webserver. The way I see it you have two options to solve this:

* put the file on the same server and use normal include directives
* use the file_get_contents or an iframe to load the external resource

Jassim Rahma11-Dec-11 21:44

11-Dec-11 21:44

I used file_get_conetnts and it's working fine except with some links but I don't know why..

if you check www.JassimRahma.com[^] you'll see all links are working perfectly under my domain but getting external page excet:

http://www.jassimrahma.com/16[^]

and:

http://www.jassimrahma.com/17[^]

both from http://www.telegraph.co.uk/[^]

what could be the reason?

Mohibur Rashid12-Dec-11 15:17

Mohibur Rashid

12-Dec-11 15:17

This is not including. in php including is far different thing you are trying to do. all you need to use is html tag iframe and in the src attribute use the address.

Jassim Rahma12-Dec-11 18:35

12-Dec-11 18:35

i would love to... but iframe doest support 100% height and 200% width.

so how can i fix it in iframe?

error in login page

Jassim Rahma10-Dec-11 2:14

10-Dec-11 2:14

Hi,

can anyone help please.

I am getting this error:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/jassimrahma/JassimRahma.com/admin/get_login.php on line 10

Warning: Cannot modify header information - headers already sent by (output started at /home/jassimrahma/JassimRahma.com/admin/get_login.php:10) in /home/jassimrahma/JassimRahma.com/admin/get_login.php on line 20

here is my code:

PHP

<?php
	session_start();
	
	$username = $_POST['username'];
	$password = $_POST['password'];

    $dbC = mysql_connect('mysql.jassimrahma.com', 'jassimdb', 'mujtaba');
    $sql = "SELECT * FROM website_admin WHERE website_admin_user_name = '$username' and website_admin_password = '$password'";
	$result = mysql_query($sql, $dbC);
	$count = mysql_num_rows($result);
	
	if($count == 1)
	{
		// session_regenerate_id();
		$_SESSION['status'] = 'logged';
		header("location:index.php");
	}
	else
	{
		header("location:login.php");
	}
?>

Re: error in login page

Graham Breach10-Dec-11 3:46

10-Dec-11 3:46

The first warning is telling you that the value returned from mysql_query(), which you stored in $result is a boolean. This means that the query failed, because mysql_query returns FALSE when a SELECT query fails.

The second warning is telling you that it cannot output any headers, because it has already sent output to the browser - in this case, the first warning message.

You should check the return values from your database function calls. mysql_connect might have failed, or mysql_query could have failed for any number of reasons - use mysql_error[^] to find out what went wrong and fix it.

You should also sanitize all user input before building a query from it. Google for "sql injection" if you don't know what I'm talking about.

Re: error in login page

Jassim Rahma10-Dec-11 3:55

10-Dec-11 3:55

I got it... no database selected..

BUT...

now I have another problem..

everytime I enter the correct user id and password it's just going back to login.php with no error message.

I am 1000000% sure about the user id and password, infact I added another uder and having the same problem.

user ID : abc123
Password : abc123

Re: error in login page

Graham Breach10-Dec-11 4:10

10-Dec-11 4:10

Okay... I won't try to guess which page is doing what wrong, but I will give you this handy code snippet:

echo '<pre>' . print_r(get_defined_vars(), true) . '</pre>';

If you insert that into a page where you think things are going wrong, it will dump all the variables into the page. I would try putting it before your if statement that does the redirects first, and see if $count is what you expect it to be.

You should turn on all errors and warnings when you are developing too:

ini_set('display_errors', 1);
error_reporting(E_ALL | E_STRICT);

plz help - htaccess

Jassim Rahma9-Dec-11 2:52

Help me in configuring the PHP .How to run a PHP program

9-Dec-11 2:52

Hi,

can anyone help on how to do this in htaccess please..

I want to make every:

www.mydomain.com/news.php?id=777

shows as

www.mydomain.com/777

where 777 is the primary key in my news table.

Thanks,
Jassim

Simple PHP

omanzo_barrett8-Dec-11 8:39

omanzo_barrett

8-Dec-11 8:39

I been looking around for a good tool to learn PHP and i stumble up on this http://be2f81j9hp809o6rpk2bhbxkd5.hop.clickbank.net/?tid=1 site. Please tell me what you think about it?

VickyVicki8-Dec-11 4:32

VickyVicki

8-Dec-11 4:32

Hi Friends,
I am new to PHP and I want to know how to run a PHP program .Would like to know how to configure it and kindly help in suggesting what kind of software to be used to run it.I tried with WAMP Server but i was not able to run it. Frown | :(

.Thanks in Advance.

Re: Help me in configuring the PHP .How to run a PHP program

awedaonline8-Dec-11 10:01