PHP - Mysqli_real_escape_string() Not Working Right!

i dont understand what is wrong plz help me. here is code

$name = "img/".rand(1,9999999).".png";
$myFile = $name;
$fh = fopen($myFile, 'w') or die("can't open file");
$stringData = $html;
fwrite($fh, $stringData);
fclose($fh);
$file=$name;
$fst=file_get_contents($file);
$im=imagecreatefromstring($fst);
imagefilter($im, IMG_FILTER_GRAYSCALE);
imagefilter($im, IMG_FILTER_NEGATE);
//Convert to Grey Scale
for($i=0;$i<123;$i++){
for($j=0;$j<50;$j++){
$px=imagecolorat($im,$i,$j);
if($px<0x303030){
imagesetpixel($im,$i,$j,0);
}else{
imagesetpixel($im,$i,$j,0xffffff);
}
}
}
$database = unserialize(@file_get_contents("db.txt"));
if($database === false) $database = array();
// modify the database if needed
if($_SERVER['REQUEST_METHOD'] == 'POST'){
	if($_POST['submit'] == 'Add')
		$database[$_POST['ident']] = substr($_POST['letter'], 0, 1);
	if($_POST['submit'] == 'Del')
		unset($database[$_POST['ident']]);
	if($fh = @fopen('db111.txt', 'w+')){
		fwrite($fh, serialize($database));
		fclose($fh);
}
}else{
$newimage = true;
}
$width   = 130;
$height  = 40;
$captcha_gridstart   =1;
$captcha_gridspace   =2;
$letters = findletters($im, $width, $height, $captcha_gridstart, $captcha_gridspace);
$count   = count($letters);
$cellw   = ($count > 0) ? intval(100 / $count) : 0;
//dispeckle the image and GET co-ordinates of the characters of captcha image and return them. 
function findletters($image, $width, $height, $gridstart, $gridspace){
	$offsets  = array(); $o = 0;
	$atstartx = true;
	for($x = 0; $x < $width; $x++){
		$blankx = true;
		for($y = 0; $y < $height; $y++){
			if(imagecolorat($image, $x, $y) == 0){
				$blankx = false;
				break;
			}
		}
		if(!$blankx && $atstartx){
			$offsets[$o]['startx'] = $x;
			$atstartx = !$atstartx;
		}else if($blankx && !$atstartx){
			$offsets[$o]['endx']   = $x;
			$atstartx = !$atstartx;
			$o++;
		}
	}
	$count = $o;
	for($o = 0; $o < $count; $o++){
		for($y = 0; $y < $height; $y++){
			$blanky = true;
			for($x = $offsets[$o]['startx']; $x < $offsets[$o]['endx']; $x++){
				if(imagecolorat($image, $x, $y) == 0){
					$blanky = false;
					break;
				}
			}
			if(!$blanky){
				$offsets[$o]['starty'] = $y;
				break;
			}
		}
		for($y = $height-1; $y > $offsets[$o]['starty']; $y--){
			$blanky = true;
			for($x = $offsets[$o]['startx']; $x < $offsets[$o]['endx']; $x++){
				if(imagecolorat($image, $x, $y) == 0){
					$blanky = false;
					break;
				}
			}
			if(!$blanky){
				$offsets[$o]['endy'] = $y;
				break;
			}
		}
	}
	for($o = 0; $o < $count; $o++){
		$offsets[$o]['ident'] = "";
		for($x = $offsets[$o]['startx'] + $gridstart; $x < $offsets[$o]['endx']; $x += $gridspace){
			for($y = $offsets[$o]['starty'] + $gridstart; $y < $offsets[$o]['endy']; $y += $gridspace){
				$offsets[$o]['ident'] .= ((imagecolorat($image, $x, $y) == 0) ? "0" : "1");
				#echo $offsets[$o]['ident'].'<br>';
			}
		}
	}
	return $offsets;
}
$a="";
foreach($letters as $letter){
$asciiletter = $database[$letter['ident']];
if(!empty($asciiletter)) {
$a.=$asciiletter;
}
}

I need bit of help, so I am looking into a plugin created for newsletter where default is it shows ad but it has option to remove ads by checking the check box. Default is to send ads in newsletter but if you don't want to send ads through newsletter then check the box. The problem is, it seems like checkbox selected is not being picked up. Some help would be appreciated.

The custom field in wp:

 

'label' => 'Hide newsletter ads',
           'name' => 'hide_ads', 
          'type'  => 'checkbox',
                'instructions'      => 'Checking the checkbox will remove ads',
                'required'          => 0,
                'conditional_logic' => 0,
                'wrapper'           => array(
                    'width' => '',
                    'class' => '',
                    'id'    => '',
                ),
                'choices' => array(
                    'Hide newsletter ads' => 'Hide newsletter ads',
                ),
                'allow_custom' => 0,
                'default_value' => array(
                ),
                'layout' => 'block',
                'toggle' => 0,
                'return_format' => 'value',
                'save_custom' => 0,
               ),

 

This is the php code for it:

  <!doctype html>
    <html lang="en-GB">
 <head>
<meta name="viewport" content="width=device-width" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta name="x-apple-disable-message-reformatting">
<title><?php the_title(); ?></title>
<style>
    <?php require ABSPATH . 'path/newsletter.css'; ?>
</style>
<!--[if mso]>
<style type="text/css">
.outlook-fallback-font {
    font-family: 'Lucida Bright', 'Cambria', -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif;
}
</style>
 <![endif]-->
 </head>

 <?php
$hide_newsletter_ads = get_field('hide_ads');
echo $hide_newsletter_ads;
?>

 <body itemscope itemtype="http://schema.org/EmailMessage">

 <div class="wrap">

    <?php
    if (!$hide_newsletter_ads) {
        include ABSPATH . 'path/ad-banner.php';
        }
    ?>
    <div class="header">
        <a href="<?php bloginfo( 'url' ); ?>">
            <img src="<?php echo get_home_url().'logo.png' ?>" alt="News" 
       />
        </a>
    </div>

    <?php
    if ( have_posts() ) :
        while ( have_posts() ) :
            the_post();
            ?>

            <?php if ( get_field( 'newsletter_summary' ) ) { ?>
                <div class="newsletter-summary"><?php the_field( 'newsletter_summary' ); ?></div>
            <?php } ?>

            <?php if ( have_rows( 'newsletter_content' ) ) : ?>

                <?php
                // Loop through the ACF blocks
                $count = 0;
                while ( have_rows( 'newsletter_content' ) ) :
                    the_row();

                    if ( get_row_layout() === 'story' ) :
                        ?>

                        <?php if ( 0 === $count ) { ?>
                            <span class="date outlook-fallback-font"><?php the_time( 'd M Y' ); ?></span>
                        <?php } ?>

                        <?php if ( get_sub_field( 'story_heading' ) ) : ?>
                            <h1><?php the_sub_field( 'story_heading' ); ?></h1>
                        <?php endif; ?>

                        <div class="content">
                            <?php the_sub_field( 'story_content' ); ?>
                        </div>

                        <?php
                    endif;

                    if ( 'post_list' === get_row_layout() ) :
                        ?>

                        <?php
                        $posts = get_sub_field( 'post_list' );
                        if ( $posts ) :
                            ?>

                        </div>
                        <div class="story-list">
                            <h2><span class="wrap"><?php the_sub_field( 'post_list_heading' ); ?></span></h2>
                            <div class="wrap-table">
                                <table width="100%" cellpadding="0" cellspacing="0" border="0">

                                    <?php
                                    // Output story cards
                                    foreach ( $posts as $i => $post ) {
                                        if ( 0 === $i % 2 ) {
                                            echo '<tr>';
                                        }

                                        $class = ( 0 === $i % 2 ) ? 'odd' : 'even';

                                        $image_src    = wp_get_attachment_image_src( get_post_thumbnail_id( $post->ID ), array( 640, 345 ) );
                                        $image_srcset = wp_get_attachment_image_srcset( get_post_thumbnail_id( $post->ID ) );
                                        echo sprintf(
                                            '<td class="story-cell %4$s" valign="top">
                                            <a href="%1$s" class="story-card outlook-fallback-font">
                                            <img src="%3$s" alt="" height="120" style="height: 150px; object-fit: cover;" />
                                            <span>%2$s</span>
                                            </a>
                                            </td>',
                                            esc_url( get_permalink( $post->ID ) . '?utm_source=newsletter&utm_medium=email&utm_campaign=newsletter' ), // permalink
                                            esc_html( get_the_title( $post->ID ) ), // title
                                            // esc_attr( $image_src[0] ), // image  - src
                                            esc_attr( $image_src[0] ), // image  - src
                                            esc_attr( $class ) // class
                                        );

                                        if ( 0 !== $i % 2 || count( $posts ) === ( $i + 1 ) ) {
                                            echo '</tr>';
                                        }
                                    }
                                    ?>

                                </table>
                            </div>
                        </div>
                        <div class="wrap">
                            <?php
                        endif;
                    endif;

                    if (!$hide_newsletter_ads) {

                     (0 === $count) {
                        include ABSPATH . 'path/mpu-1.php';
                    }

                    if (1 === $count) {
                        include ABSPATH . 'path/mpu-2.php';
                    }
                }

                    $count++;

                endwhile;

            endif;
            ?>

            <div class="footer">
                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                    <tr>
                        <td align="left">
                            &copy;  <?php echo esc_html( date( 'Y' ) ); ?>
                        </td>
                        <td class="footer-link">
                            <a href="<?php echo get_permalink( get_page_by_path( 'privacy-policy' ) ); ?>">Privacy Policy</a> &middot;
                            <a href="%unsubscribe_url%">Unsubscribe</a>
                        </td>
                    </tr>
                </table>
            </div>

        </div>

        <?php
    endwhile;
endif;
?>

 

I'm trying to turn this while loop into a for loop and am unable to get my result set to display properly in the for loop.  The while works fine I just want to be able to have more control over which information is shown in my table as I loop and was wanting to use a for loop that way I can take advantage of the counter variable while i"m displaying my information.  Any help would be appreciated. 

while ($row = mysql_fetch_assoc($data_result_set)) {
            echo "<td>".$row["product_id"]."</td>";
            echo "<td>".$row["city"]."</td>";
            echo "<td>".$row["quantity"]."</td>";
            }


*** I'm wanting it to look like something like this but can't figure out how to properly work in which row to display with the $i variable.

$count=mysql_num_rows($data_result_set);

for($i = 0; $i <= $count; $i++){
echo "<td>".mysql_fetch_assoc[$i]["product_id"]."</td>";
            echo "<td>".mysql_fetch_assoc[$i]["city"]."</td>";
            echo "<td>".mysql_fetch_assoc[$i]["quantity"]."</td>";

}

I know the syntax for the for loop is totally off with the method mysql_fetch_assoc just dropped in there like a jerk but I'm just kinda pseudoing it out.

Any help would be appreciated.
Thanks in advance.

When I echo the POST, it echoes the correct value.
The MySQL portion seems to just ignore it all together.
I've tried changing the dropdown option to just a text field, same thing occurred.
I have text fields right above this particular one that update just fine with the SAME exactly scripting.
if POST, update query, done. Works.

This one for some reason will not.

MySQL portion:
if ($_POST['bUpdate']){
mysql_query("UPDATE `Patients` SET `b` = '$_POST[bUpdate]' WHERE `id` = '".$_GET['id']."'");
}
echo $_POST['bUpdate'];

Form Portion:
Code: [Select]
    <tr onmouseover="color(this, '#baecff');" onmouseout="uncolor(this);">
    <td width="310" colspan="2" align="center"><span class="fontoptions">Postcard Status </span><br />
<?
if ($data['b'] == 1){
echo '<select name="bUpdate"><option value="1" selected>Yes</option><option value="0">No</option></select>';
} else {
echo '<select name="bUpdate"><option value="1">Yes</option><option value="0" selected>No</option></select>';
}

?>
</td>
    </tr>

Hi,

I have the following file structure

/.htaccess
/index.php
/displaypage.php

All files are on root.

I have following written in .htaccess file

Options FollowSymLinks
RewriteEngine On

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule ^([a-z0-9-]+)$ displaypage.php?page=$1 [NC,L]

I have following written in displaypage.php

echo $_GET["page"];

Now when I run http://localhost/ then it shows index.php page which is correct. If I run http://localhost/something then it shows a blank page. Previously it used to display that "page" variable on screen. mod_rewrite is enabled and I am using Windows with XAMPP.

What am I doing wrong?

Thanks

I just did a huge import from an app I have been working on. No issues except for this.

I uploaded & imported all files & databases from my wampserver (localhost, local server) to my main online server.

Before I continue with the problem, I have to give you info on how the files work.

I am using a "controller" to view the files. Meaning, from index.php, I call all the files. For example, instead of mysite.com/register.php, its mysite.com/index.php?page=register.

The index defines the doctype & html tags etc.

The other files that are called through index.php are just pure php code, it does not contain the head & body tags etc.

So, the issue is , when the surfer submits a form, i need to set a cookie. this cookie is VERY important.
I cannot get it to work. I am getting the header warnings after submit

Of course, this is to be expected. But I tried it on my local server, & it worked. I am not very familiar with cookies, this is a side of PHP i never really even touched. I know almost everything but that.  So the php code is before the html code on the page, so I figured it was worth a shot.
Im guessing the problem here is, since the code being outputted as index.php code + the form page code. So the cookie is being set after the html tags.

How can I fix this? I need it to work thru the controller. I cannot just make it a single file, all files on the site needs to be thru this controller, otherwise it will mess everything up.

Ino I could just add the code from index.php plus the form page code & just run the php code before all of the html tags, but like I said it has to be called thru index.php.

I appreciate your replies, & I hope you guys dont think im an idiot & can understand my question, im terrible with words!

OK, i've used it before, but for some reason it's not working.

I have 2 pages

PAGE 1  (bfbc2.php)
Code: [Select]
<?php

$url = 'http://api.bfbcs.com/api/pc';
$value = $_GET['playername'];

$postdata = "players=$value&fields=basic";

$ch = curl_init($url);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $postdata);
$data = curl_exec($ch);
curl_close($ch);

$data = json_decode($data,true);
$player = $data['players'];
$stuff = $player['0'];
$rank = $stuff['rank'];
echo ('<img src="http://www.oskgaming.com/images/bfbc2ranks/'.$rank.'.jpg" />');
?>

PAGE 2 (test.html)

Code: [Select]
<img src="http://www.oskgaming.com/images/bfbc2.php?playername=Lark.s">

if I type http://www.oskgaming.com/images/bfbc2.php?playername=Lark.s  I get the image requested

if  type http://www.oskgaming.com/test.html I get a broken image.

Any ideas?  Did I make a mistake somewhere?

$newsletter_settings_query = "SELECT * FROM newsletter_settings";
$newsletter_settings = mysql_query($newsletter_settings_query) or die("There was a problem with the SQL query: " . mysql_error());

$header_image = $newsletter_settings['sHeaderImage'];
$header_name = $newsletter_settings['sHeaderName'];
$header_text = $newsletter_settings['sHeaderText'];


None of those variables are displaying data.

hello, the following is pulling all my records.  is it written wrong?

Code: [Select]
$result4 = mysql_query("SELECT * FROM schedule WHERE eid = '$posteid' AND status = 1 OR status = 2 ORDER BY date, starttime");

right this is from my database
Database: inbox

right i did this code: <?php $totalmess2 = mysql_num_rows(mysql_query("SELECT read='0' FROM inbox")); ?>

then <?php echo "$totalmess2"; ?>

ive got read in my inbox which just shows whether some one as read the message or not 1=read 0=unread


i want to know the total unread message there is in my inbox database whats going wrong

Hi There,

I am trying to create a webpage that displays tasks that need to be completed on specific days. For example, every tuesday, every Friday etc etc. I am finding problems though then I try to display tasks that need to be done on, for example, the first working day of the month.

Is there any way that PHP can work out the first working day of the month? Our working days are Monday to Friday.

I have a database backend to this that has the following columns if that helps:

TASK_NAME
TASK_SUMMARY
TASK_WEEKDAY
TASK_DAY_IN_MONTH
TASK_MONTH

Happy to change the DB if I need to as it is empty at the moment.

Thanks in advance
Matt

I am developing a CMS to make Samsung's Digital Display management even easier for a school making use of them.


But, one part of the screen uses a slideshow that grabs images from an XML fed file. Here is a snipped of said file.


Code: [Select]
<slide>
      <url><![CDATA[3.jpg]]></url>
      <description>
        <heading>Image Three Title</heading>
        <paragraph>Image Three description taken from database to appear here.</paragraph>
      </description>
    </slide>

How would I use PHP to make the document think itself as XML whilst still being able to populate these tags with MySQL fetched data.


I.e.


<paragraph><? echo "This was taken: Monday...."; ?></paragraph>


Any ideas? - Thanks in advance.


George.

I want to use css and PHP together

Let say I have simple PHP page:
Code: [Select]
<html> <head>
<title>Coupon Sample </title> </head>
<body>

<div id="test">
<?php
echo ("Test"); 
?>
</div>
</body></html>
Now if I want to add css to this I have two options
1. add css code in head tag
2. add external css file with <link> tag

My simple css is
Code: [Select]
#test
{
color:orange;
}
if I am using first option like
Code: [Select]
<html> <head>
<title>Coupon Sample </title>

#test
{
color:orange;
}
</head>
Its working fine, for second option
Code: [Select]
<title>Coupon Sample </title>
<link rel="stylesheet" type="type/css" href="simple.css"/>
</head>
where simple.css contain css code
but its not working.. it shows text in black color instead of orange

Does anyone has idea about it. or is their other way to add css in this situation.

Thanks in advance

navpath.php
<br><br><img src='./images/nav.png'> <a href='./index.php?act=idx'><? echo FORUM_NAME; ?></a>
<?
    if ($act != idx) {
    if ($act == viewforum) {
        $forumId = $_GET['forumid'];
        $PathQuery = "SELECT * FROM "+FORUM_NAME_TABLE+" WHERE forum_id='"+$forumId+"'";
        $PathResult = mysql_query($PathQuery, $db);
        $CatID = mysql_result($PathResult, 0, 'cat_id');
        $ForumTitle = mysql_result($PathResult, 0, 'forum_name');
        $CatQuery = "SELECT cat_name FROM "+FORUM_CAT_TABLE+" WHERE cat_id='"+$CatID+"'";
        $CatResult = mysql_query($CatQuery, $db);
        $CatName = mysql_result($CatResult, 0, 'cat_name');
        ?>
        &middot; <a href='./index.php?act=viewcat&catid="<? echo $CatID; ?>"'> <? echo $CatName; ?>
        &middot; <a href='./index.php?act=viewforum&forumid="<? echo $forumId; ?>"'><? echo $ForumTitle; ?>
            <?
    }

This is meant to select the information from the address bar with $_GET and then read relavent information from the db.

Basically what i'm doing is making a forum system from scratch using 1 file that users will access. Heres the index page:


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

<table width="760" border="0" align="center" cellpadding="3" cellspacing="0" bgcolor="#979797" height="100%" bordercolor="#000000" bordercolordark="#000000" bordercolorlight="#000000">
<tr> 
<td width="100%" height="100%" bgcolor="979797" bordercolor="#000000" bordercolorlight="#000000" bordercolordark="#000000" valign="top">
    
<!-- Header/Logo Section -->
<div id="logostrip">
    <center><a href="./index.php?act=idx"><img src="./images/logo.png" alt="Forum Index" Border="0"></a></center>
</div>
<!-- End Head/Logo -->
        
<!-- Navigation -->      
<?php include("navigation.php"); ?>
<!-- End Navigation -->
<div align='center' style='margin-bottom:3px;'></div>

<!-- User Nav -->
<?php include("usernav.php"); ?>

<!-- Navigation Path -->
<?php include("navpath.php"); ?>
</td>
</tr>
</table>
</body>
</html>
<?php
mysql_close($db);
?>


Headers.php


<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<?php
session_start();
//Connect to Database and Check cookies for logged in user
require_once('_connect.php');
if (!isset($_GET['act'])) {
    if (!isset($_POST['act'])) {
        $act = 'idx';
    }
    if (isset($_POST['act'])) { 
        $act = $_POST['act']; 
    }
}
if (isset($_GET['act'])) { $page = $_GET['act']; }
if (isset($_SESSION['SESS_MEMBER_ID'])) {
    $memid = $_SESSION['SESS_MEMBER_ID'];
}
if (isset($memid)) {
    $db = mysql_connect(MSQL_HOST, MYSQL_USER, MYSQL_PASS);
    mysql_select_db(MYSQL_DB_NAME);
    $query_meminfo = "SELECT * FROM " + MYSQL_DB_NAME + "." + MYSQL_PROFILE_TABLE + " WHERE `user_id`="+ $memid;
    $query_result = mysql_query($db, $query_meminfo);
    $MemName = mysql_result($query_result, 0, 'display_name');
    $MemGroup = mysql_result($query_result, 0, 'Group');
}

?>
<html>
<head>
    <title>Rayth ..::Forum::..</title>
        <?php include("style.php"); ?>
    <base href="http://rayth.eyes2design.com/" />
</head>
<body text="#000000" link="#000000" vlink="#000000" alink="#000000" leftmargin="3" topmargin="3" marginwidth="3" marginheight="0" bgcolor="979797">


_connect.php

<?php
//_connect.php contains all information for all databases
//MySQL Login Information
    define('MYSQL_HOST', 'localhost');
    define('MYSQL_USER', 'xxxxxxxxxx');
    define('MYSQL_PASS', 'xxxxxxxxxx');
    define('MYSQL_DB_NAME', 'rayth');
    
    //Member Stuff (Forum/Member Section Tables)
    define('MEMBER_LOGIN_TABLE', 'user_login'); //Contains Username, Password and ID Number ONLY
    define('MEMBER_PROFILE_TABLE', 'user_profile'); //Contains ID, Username, Forum Posts, Avatar, Email Address , Rank, BlogID, signature
    define('MEMBER_GROUPS', 'user_groups'); //group list
    //Forum Settings
    define('FORUM_CAT_TABLE', 'forum_cat'); //All Forum Categories (ID, Title)
    define('FORUM_NAME_TABLE', 'forum_names'); //All Forums EXCEPT SUB FORUMS (ID, Title, Description, CatID, Permission [PostLevel, ReplyLevel, ViewLevel - 2 = Admin, 1 = Logged In, 0 = Guest])
    define('FORUM_THREADS', 'forum_threads'); //Contains all Forum Thread (Title, ID, CreatorID)
    define('FORUM_POSTS', 'forum_posts'); //Contains ALL forum posts. PostID, ThreadID, PosterID,  Message, Time/Date, 
    define('FORUM_NAME', 'Rayth Forum');
?>


What it is doing so far is everything in index.php/headers.php and then when it gets to navpath.php it only displays the forum name with the initial image. Why won't it get the whole navigation path if I use adress.com/index.php?act=viewforum&forumid=1