PHP - How To Get A Counter Related Value That Works With My Server?

I am moving my website to a new Service Provider. The script I use for multiple updating worked on the older server but not on the new one. It shows the information but does not update the records.
Any help would be greatly appreciated.

Old Server   : PHP 5.2.11    MYSQL: 5.0.92-community
New Server : PHP 5.2.17    MYSQL: 5.1.47-community

Script:
<?php 

include("head.php");
$host="localhost"; // Host name
$username="xxxxxxx"; // Mysql username
$password="xxxxxxx"; // Mysql password
$db_name="xxxxxxx"; // Database name
$tbl_name="xxxxxxx"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
 
$sql="SELECT * FROM $tbl_name limit 20";
$result=mysql_query($sql);

// Count table rows
$count=mysql_num_rows($result);
?>
<title>PowerMan South Africa</title>
   <META HTTP-EQUIV="Pragma" CONTENT="no-cache">
   <META HTTP-EQUIV="Expires" CONTENT="-1">
   <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   <link rel="stylesheet" href="style.css" type="text/css" media="screen" />
      <style type="text/css" media="screen,projection">
         @import url(calendar.css);
      </style>
 
 
      </head>
<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">
<tr>
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">


<tr>
<td align="center"><strong>ID</strong></td>
<td align="center"><strong>Company</strong></td>
<td align="center"><strong>contact</strong></td>
<td align="center"><strong>Email</strong></td>
<td align="center"><strong>Telephone</strong></td>
<td align="center"><strong>Type</strong></td>

</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center"><? $id[]=$rows['id']; ?><? echo $rows['id']; ?></td>
<td align="center"><input name="company[]" type="text" id="company" value="<? echo $rows['company']; ?>"></td>
<td align="center"><input name="contact[]" type="text" id="contact" value="<? echo $rows['contact']; ?>"></td>
<td align="center"><input name="email[]" type="text" id="email" value="<? echo $rows['email']; ?>"></td>
<td align="center"><input name="telephone[]" type="text" id="telephone" value="<? echo $rows['telephone']; ?>"></td>
<td align="center"><input name="type[]" type="text" id="type" value="<? echo $rows['type']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<?php
// Check if button name "Submit" is active, do this
if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE $tbl_name SET company='$company[$i]', contact='$contact[$i]', email='$email[$i]',type='$type[$i]', telephone='$telephone[$i]' WHERE id='$id[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1){
header("location:update_multiple.php");
echo "<meta http-equiv=Refresh content=0;url=update_multiple.php>";
}
mysql_close();
?>

Hi, I have

Code: [Select]
$to      = 'rberbe2002@msn.com';
$subject = 'the subject';
$message = 'hello';
$headers = 'From: webmaster@example.com';

mail($to, $subject, $message, $headers);
which works fine on a shared hosting website I have, but not on a website I have on my dedicated server.

Any ideas or suggestions please?

I was hoping someone could help me figure out why my
  Code: [Select]
header('Location: .');works right on my localhost testing computer but not when I load it onto the actual server.

Here are the two files in question.  The first is a snippet from my index.php controller file.
Code: [Select]
if (isset($_POST['action']) and $_POST['action'] == 'Edit')
{
include '../../includes/db.inc.php';
  {
$id = mysqli_real_escape_string($link, $_POST['id']);
$sql = "Select * from s_times where id = '$id'";
$result = mysqli_query($link, $sql);
if (!$result)
{
$error = 'Error fetching service time details ' . mysqli_error($link);
include '../../includes/error.php';
exit();
}

$row = mysqli_fetch_array($result);
$pagetitle = 'Edit Category';
$action = 'editform';
$id =  $row['id'];
$day = $row['day'];
$time =  $row['time'];
$event =  $row['event'];
$avail =  $row['avail'];
$orderby = $row['orderby'];
$button = 'Update';

 }
include 'stimes_modify.php';
exit();
}

if (isset($_GET['editform']))
{
include '../../includes/db.inc.php';

$id = mysqli_real_escape_string($link, $_POST['id']);
$day = mysqli_real_escape_string($link, $_POST['day']);
$time = mysqli_real_escape_string($link, $_POST['time']);
$event = mysqli_real_escape_string($link, $_POST['event']);
$avail = mysqli_real_escape_string($link, $_POST['available']);
$orderby = mysqli_real_escape_string($link, $_POST['orderby']);
$sql = "Update s_times set
day = '$day',
time = '$time',
event = '$event',
avail = '$avail',
orderby = '$orderby'
where id = '$id'";
if (!mysqli_query($link, $sql))
{
$error = 'Error updating service times ' . mysqli_error($link);
include '../../includes/error.php';
exit();
}

header('Location: .');
exit();
}


here is the stimes_modify.php file code
Code: [Select]
if (isset($_POST['action']) and $_POST['action'] == 'Edit')
{
include '../../includes/db.inc.php';
  {
$id = mysqli_real_escape_string($link, $_POST['id']);
$sql = "Select * from s_times where id = '$id'";
$result = mysqli_query($link, $sql);
if (!$result)
{
$error = 'Error fetching service time details ' . mysqli_error($link);
include '../../includes/error.php';
exit();
}

$row = mysqli_fetch_array($result);
$pagetitle = 'Edit Category';
$action = 'editform';
$id =  $row['id'];
$day = $row['day'];
$time =  $row['time'];
$event =  $row['event'];
$avail =  $row['avail'];
$orderby = $row['orderby'];
$button = 'Update';

 }
include 'stimes_modify.php';
exit();
}

if (isset($_GET['editform']))
{
include '../../includes/db.inc.php';

$id = mysqli_real_escape_string($link, $_POST['id']);
$day = mysqli_real_escape_string($link, $_POST['day']);
$time = mysqli_real_escape_string($link, $_POST['time']);
$event = mysqli_real_escape_string($link, $_POST['event']);
$avail = mysqli_real_escape_string($link, $_POST['available']);
$orderby = mysqli_real_escape_string($link, $_POST['orderby']);
$sql = "Update s_times set
day = '$day',
time = '$time',
event = '$event',
avail = '$avail',
orderby = '$orderby'
where id = '$id'";
if (!mysqli_query($link, $sql))
{
$error = 'Error updating service times ' . mysqli_error($link);
include '../../includes/error.php';
exit();
}

header('Location: .');
exit();
}


The functionality of both pages seems to be working in relation to editing the database but the page will not redirect back to the main page when it gets back down to the header line.  Like I said it works on localhost just not on actual server.  I also tried putting in the full URL like this
Code: [Select]
header('Location: http://www.bbcpa.org/dbsite/admin/stimes/stimes/php');and still got a blank page.

The URL in the address bar shows this
http://www.bbcpa.org/dbsite/admin/stimes/?editform
it should show this
http://www.bbcpa.org/dbsite/admin/stimes/
so maybe something is wrong with this line in stimes_modify.php
Code: [Select]
<form action="?<?php htmlout($action); ?>" method="POST">
anyway any help would be greatly appreciated.
Thanks

So, I'm trying to read a file from a different filepath than the current working directory.    I have some simple PHP like this :

<?php
 
    $input_map = "readfile.php";
    $map_contents = file_get_contents($input_map);
    echo $map_contents."<br />\n";
?>

And this'll work fine because it's in the same directory but if I try to set $input_map = "/home/...", the browser will return an empty string. This script will work from the command line though. So how do I get file_get_contents() to read from the server's file structure instead of just the working directory?   Edit : For example, this will not work through the browser :

<?php
 
    $input_map = 
"/home/...";
    $map_contents = file_get_contents($input_map);
 
    echo $map_contents."<br />\n";
    var_dump($map_contents);
?>

Edited by MutantJohn, 21 January 2015 - 06:35 PM.

    
    $account="54646456456464";
    $station= "12345";
    $options="11-1";
    $image="C:/Desktop/Sample Images/usco1.jpg";
    
    
$ch = curl_init();

curl_setopt($ch, CURLOPT_URL,"http://dfdgfsfs.com/kgdfgd.php");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, array(
            'image' => '@'.$image, 'account' => $account, 'station' => $station, 'options' => $options));


$postResult = curl_exec($ch);


curl_close ($ch);

$xmlobj = simplexml_load_string($postResult);

echo (string)$xmlobj->ID->attributes()->value;
echo (string)$xmlobj->FullName->attributes()->value;

All, I have spend days trying to figure this out without any luck.  I am now in crisis mode.  I need to get this working asap.  The following code works perfect on my local xampp machine.  As soon as I upload it to my web server, I don't get any data back.  I have narrowed it down to the image i am trying to send is not being received properly.  Thanks in advance.

Hi all,

I wonder if any of you have this problem before..

I have a login page with "checked box remember me" - It is working fine in my localhost machine I can see the COOKIE in my browser's option setting (Firefox).

But now the problem is: When I run the script in my test server; and do exactly the same thing..the COOKIE did not seem know.

When I logged in as an admin and checked the box. And closed all the browser. Then, open the browser (Firefox)and go to the index page (landing page) then it redirect me to the login page instead. I looked the at COOKIE setting in my Firefox and I can it is stored there.

Any ideas whats wrong?

Hi guys, I need a help to find out what is a problem. Some of my code does not work on my local comp and in the same time it works well when I place it on Internet server.
First example:
Code: [Select]
<body>
<?php 
if($_POST['submit_form'] == "Submit") 
{ $varNewTeam = $_POST['Reg_Team']; 
$varNewCity = $_POST['Reg_City']; 

 $db = mysql_connect('localhost', 'root', '') or die ('no connection with server');
  mysql_select_db('db_m ,$db) or die('DB error');
mysql_query ("INSERT INTO reg2012 VALUES ('$varNewTeam','$varNewCity')") or die('insert error');
} 
?>
<form action="registration_2012_form.php" method="post">
<p>Team: <input type="text" name="Reg_Team" size="20" maxlength="50" value="<?=$varNewTeam;?>" /><br /></p>
<p>City: <input type="text" name="Reg_City" size="20" maxlength="50" value="<?=$varNewCity;?>" /><br /></p>
<p><input type="Submit" value="Submit" name="submit_form" /></p>
</form>
</body>
On local comp: It gives me message "Undefined index: submit_form".
On Net server works well.
If I split the code in two files. In the first one I leave the form with "action=FILE2.php" and put my php code in the second file "FILE2.php" - it starts work even on local server.

second example:
Code: [Select]
<body>
<?php 
  $db = mysql_connect('localhost', 'root', '') or die ('no connection with server');
  mysql_select_db('db_m' ,$db) or die('DB error');
mysql_query ("CREATE TABLE temp1 (team char(50), city char(50) )") or die('create tables error');
?>
</body>
It works in the Net and can not create the TABLE on my local comp.

I use XAMPP on my local comp (if it's important)

Some of you may have seen one of my many posts about email issues.  Some users don't get them, and I have determined it is probably because we are marked as spam.   We are a service that grades sales team members on their phone skills.  Listening to pre-recorded calls, grading and uploading them to our site, and then another part of our business looks them over and sometimes leaves a message that then get's forwarded to this persons work email.   I have determined there is ways to get marked as spam as default by not having an opt out link.  This is not an option, these sales members employer has opted in, and the emails are going to work related accounts hosted at that employer.  Also, if one of these staff members is not so bright, or disgruntled they may mark us as spam anyways.  The bottom line is that we have very little control over whether we are or are not marked as spam.   So we want to start looking into sending text messages and this is where I start to question how good of an idea this is.   First off, if it was me, and the messages where being sent to a device that my employer did not provide, I would in no way want work related text messages coming to me.  Unless there is a vested interest in getting them.  IE, I'm the boss at this place and am always on the clock.  What if you are on the bottom?  It's just a job for you.   What if it is a pre-paid device, text messages cost money.  What then?  What if they don't even have, or want a cell phone?   The short of it is this.  If I'm at a job that is just another job, and this employer tells me that I have to get these messages.  I'm going to look for another job.  I see the organizations having continuous issues and complaints from their employees.  Thus us as a business having issues keeping clients.   What am I getting into here?  What are your opinions on this matter?  What are your recommendations as to alerting users of something on our site that we can rest assured are being received 100% of the time?   Thanks!   Nick

I have a PHP web system that store in a windows server. In the system, there is a function for user to upload files to another server (Shared server in Unix).

When i try to upload a file, it gives warning:

Warning: move_uploaded_file(\\unixserver/sharedfolder/upload/test.txt) [function.move-uploaded-file]: failed to open stream: Permission denied in C:\wamp\www\upload\index.php on line 40

For your information, my username has been assigned in xxx's group that has access to read and write on that folder. Besides, i'm able to open,create and delete files on that folder's server manually (samba).

The safe mode setting is off.

Does anybody has any idea why this thing happen?

Hi,  I am not a PHP programmer.

I took on a new client with a simple PHP site, without any databases.
The site is up and running on the web.
I would like to get it running on my local machine for further development.
I have latest version of WAMP installed, running Apache version 2.2.11 and PHP version 5.3.0
I created a directory in the WAMP "www" project directory and it shows up there like it's supposed to when I browse to "localhost"

Problem:

The home page of website displays text but no, images, styles, footer, header, nav links, etc.


Here is the code for the home page:

<?
  define("NAV","home");
require_once('local/local.php');
?>
<!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">
  <head>
    <title>TITLE</title>
    <meta name="keywords" content="">
    <meta name="Description" content="">

<? include("common/dochead.php"); ?>

    </head>

<body onLoad="<? include('common/preloads.php'); ?>">

<!-- ============================ main ============================= -->
<div id="main-frame"><div id="main" class="noCollapse">

<? include("common/sign.php"); ?>

<div id="right-frame">

<? include("common/navigation.php"); ?>

<div id="content-frame">
<div id="content">


<h1>Welcome</h1>
<p>This is the content area. This is the content area. This is the content area. </p>


</div><!-- end content -->
</div><!-- end content-frame -->

</div><!-- end right-frame -->

<div class="clearFloats"></div>

</div><!-- end main --></div><!-- end main-frame -->

<? include("common/footer.php"); ?>

   </body>
</html>



Any help would be greatly appreciated. I have spent many hours on this.

Regards

I'm trying to make a simple website where people register to my website.

When the user doesn't fill anything inside the boxes they get a message "Please fill all required fields" on the register.php page

On my local host require_once works good. It shows up.

 

But when i upload the files to my sever the require_once does not show up on the register.php

It just refreshes and i dont get the message "Please fill all required fields"

 

This is the code that works in local host but not in a live server

<?php require_once 'messages.php'; ?>

 

 

Here is my full code

 

Register page:

<html>


<?php require_once 'messages.php'; ?>

<br><br>


<form action="register-clicked.php" method="POST">

Username:<br>
<input type="text" name="usernamebox" placeholder="Enter Username Here">
<br><br>
Email:<br>
<input type="text" name="emailbox" placeholder="Enter email here">
<br><br>
Password:<br>
<input type="password" name="passwordbox" placeholder="Enter password here">
<br><br>
Confirm Password:<br>
<input type="password" name="passwordconfirmbox" placeholder="Re-enter password here">
<br><br>

<input type="submit" name="submitbox" value="Press to submit">
<br><br>

</form>

</html>

 

 

Register clicked

<?php


session_start();



$data = $_POST;

if( empty($data['usernamebox']) ||
    empty($data['emailbox']) ||
    empty($data['passwordbox']) ||
    empty($data['passwordconfirmbox'])) {
    $_SESSION['messages'][] = 'Please fill all required fields';
    header('Location: register.php');
    exit;

}




if ($data['passwordbox'] !== $data['passwordconfirmbox']) {
    $_SESSION['messages'][] = 'Passwords do not match';
    header('Location: register.php');
    exit;
}


$dsn = 'mysql:dbname=mydatabase;host=localhost';
$dbUser='myuser';
$dbPassword= 'password';

try{
$connection = new PDO($dsn, $dbUser, $dbPassword);
} catch (PDOException $exception){
    $_SESSION['messages'][] = 'Connection failed: ' . $exception->getMessage();
    header('Location: register.php');
    exit;
}

 

 

messages.php

<?php
session_start();

if (empty($_SESSION['messages'])){
    return;
}

$messages = $_SESSION['messages'];
unset($_SESSION['messages']);
?>



<ul>
    <?php foreach ($messages as $message): ?>
        <li><?php echo $message; ?></li>
    <?php endforeach; ?>
</ul>

 

Edited Wednesday at 12:49 AM by bee65

Hi folks,

I'm curious if I can for example, save a file from my server and it will save to all other servers - obviously if they accepted the connection first. It's for a software I developed and is almost complete and know there will be frequent updates to it. Instead of users downloading upates, I want the update files from my server to somehow synchronize to their server automatically?

Anything called this??

Thanks for info.

This isn't exactly an application design question, but rather a system design one.   I am about to install an Inventory Control System inside this store I work in.   The store itself also owns a Linode VPS running Centos 6.4 which hosts our website.   This new Inventory System will come built in with a Microsoft SQL Server, and supposedly it is a SQL Anywhere database, but I'm not too sure what that means.     I need to make this database publicly accessible, but only via the Linode VPS.  Surely, setting restrictions is easy enough to address that issue.  That isn't my question.   My first idea is to put this server into the DMZ, easy.  But it doesn't exactly sound safe.  So my next idea was to put a middleman server in the DMZ, this way the Linode can send queries to that middleman server and it will send that data to the SQL Server and back.  This is very vaguely described I know, but I don't want to get too much into details, but rather, understand how I can create that middleman server, and what could Install onto it that would allow me to securely process queries?   My first thought was to install a webservice, that accepts an XML/JSON request and returns an XML/JSON response. Then, I realized directly afterwards that I don't have any experience setting up a webservice like that. What kind of options are there out there?
  Ultimately, my question is, should I just put the Server in the DMZ or should I create the middleman, and if so, can someone point me in the right direction as to getting a webservice set up?
Edited by Zane, 15 July 2014 - 11:28 PM.

Hey. I am wanting to move a couple of files from my current server to another.

If i am uploading the file this is fine but if it is already on the server then im not sure how to move it.

When uploading I can just use ftp_put($conn_id, $destination_file, $myFile, FTP_BINARY);

What i need to do is figure out how to get a hold of the file and store it in $myFile then this would work fine.

Is this possible?

Cheers

(This might be the wrong forum; it might be server-side configuration, but alas it is the code that *calls* fwrite, so I'll start here.)

I have written a script, and one thing it does is generate a file to disk using fwrite. No big deal.

Here's what interests me:
On most servers, the file is written successfully when the folder's permissions are 755 with recursive permissions. On some servers, 755 fails. Only 777 works.
How could this be? Are permissions=permissions=permissions? Why will 755 work on one machine but not another?

I'm just a logic guy; I know very little of server-side configuration and/or why there would be a difference here. Just trying to learn.