PHP - Php Communication, String Insert

Hi to everybody 

I need ur help because I’m trying to make a script in php to write the same data but with different date in MySQL depending on the splitting ($data06).... like a schedule...

 

For example if $data06 = annual and $data03 = “2019/01/01”

programm must create in MySQL :

2019/01/01

2020/01/01

2021/01/01

2022/01/01

2023/01/01

 

if $data06=“half year” will create 10 date , increasing 6 moths ...

 

But I have a problem at finish of code 

                                                                                                                                                     switch ($data06) {

                                                                                                                                             case 'annual':                                                                                                  $numrate = 5;                                                                                                 $aumdata = "+12 months"; 

break;

                                                                                                                                                                                           case 'half year':                                                                                          $numrate = 10;                                                                                                              $aumdata = "+6 month";                                                                                                              break;

                                                                                                                                                                                                                                                                                                                                                                      default:                                                                                                             echo "error";              
break;                                                                                            
}                                                                                                          

                                                                              $sql = "INSERT into $nometb (                                                                                                              name, scadenza                                                                                                                                    ) values (                                                                                                           '$data01',   '$data03'                                                                                             )";

                                                                                              if ($conna->query($sql) === TRUE) {} else {die('ERROR'. $conna->error); }

                                               

                                                                              //IMPORT NEXT AND NEW DATE

                                                                              $newDate = date_create($data03);                                                                          

                                                                              for ($mul = 2; $mul <= $numrate; ++$mul) {

                                                                                                                                                                                           

                                                                                            

                                                                                              $datanuova = date_create($data03);                                                                                              $datanuova->modify($aumdata);                                                                                            $datanuova->format('yy/m/d');                                                                                            $newDate = $datanuova->format('yy/m/d');

                                                                                             

                                                                                             

$sql = "INSERT into $nometb (                                                                                                              name, scadenza                                                                                                                                    ) values (                                                                                                           '$data01',   '$newDate'                                                                                             )";

                                                                                              if ($conna->query($sql) === TRUE) {} else {die('ERROR'. $conna->error); }

                                                                                          

                                                                                             

//HERE THERE IS ERROR                                                                                              $data03 = $newDate;

                                                                                             

                                                                                             

                                                                                             

                                                                                              if ($conna->query($sql) === TRUE) {} else {die('ERRORE NELL\'IMPORTAZIONE'. $conna->error); }

                                                                               }

                                               

                                                              

                                                               }

                                               }

                               }
 

$data03 need to be a string but I have problem at the end to convert a date in string

 

 How I can resolve ?

 

many thanks 

Francesco 

Hi everyone,

I'm new to this group and new to php. I have created a multi-part form that allows the user the option to add multiple input fields to a form to upload images. Here is the form structu

Code: [Select]
<form action="Scripts/processreports2.php" method="post" enctype="multipart/form-data" name="report_form" target="uploader" class="reportfrm">
<fieldset>
        <legend>Upload your images</legend>
        <ol id="add_images">
          <li>
        <input type="file" class="input" name="files[]" />
          </li>
  <li>
        <input type="file" class="input" name="files[]" />
          </li>
  <li>
        <input type="file" class="input" name="files[]" />
          </li>
        </ol>
        <input type="button" name="addFile"  id="addFile" value="Add Another Image" onclick="window.addFile(this);"/>
</fieldset>
        <p>* indicates a required field.</p>
        <input name="submit" type="submit" id="submit" value="Send Info!" />
</form>

Through php a maximum of three input fields are fed into an array that checks to make sure that the uploaded files are images and not some other type of file. The uploading porition of this script works.

Now I am trying to get the values of the input fields as a string and insert them into the database as one record.

Let's say the user has three files they want to upload. I have managed to get the files as a string ie; file1.jpg, file2.jpg, file3.jpg but what is happening is that I am getting three separate records with  file1.jpg, file2.jpg, file3.jpg in them. If the user has only two files to upload then I get two separate records with file1.jpg and file2.jpg in them. (Hope that makes sense). I want one record.

I have been struggling with this since Monnday and while every day I get closer, this is as close as I can get. Below is the php code.

#connect to the database

mysql_connect("localhost", "root", "");

mysql_select_db("masscic");

//Upload Handler to check image types

function is_image($file) {

$file_types = array('jpeg', 'gif', 'bmp'); //acceptable file types

if ($img = getimagesize($file)){

//echo '<pre>';

//print_r($_FILES); used for testing

//print_r($img); used for testing

if(in_array(str_replace('image/', '', $img['mime']), $file_types))

return $img;

}

return false;
}

//form submission handling

if(isset($_POST['submit'])) {

//file variables

$fname = $_FILES['files']['name'];

$ftype = $_FILES['files']['type'];

$fsize = $_FILES['files']['size'];

$tname = $_FILES['files']['tmp_name'];

$ferror = $_FILES['files']['error'];

$newDir = '../uploads/'; //relative to where this script file resides

for($i = 0; $i < count($fname); $i++) {
    //echo 'File name ' . $fname[$i] . ' has size ' . $fsize[$i]; used for testing

if ($ferror[$i] =='UPLOAD ERR OK' || $ferror[$i] ==0) 

{

if(is_image($tname[$i]))

{

//append the tmp_name($tname) to the file name ($fname) and upload to the server

move_uploaded_file($tname[$i], ($newDir.time().$fname[$i])); 

echo '<li><span class="success">'.$fname[$i].' -- image has been accepted<br></span></li>';

}else 

echo '<li><span class="error">'.$fname[$i].' -- is not an accepted file type<br></span></li>';

}

if (is_array($fname))

$files = implode(', ',$fname);

//else $files = $fname;

$sqlInsert = mysql_query("INSERT INTO files (file_names) VALUES('$files')") or die (mysql_error());

}
}

Hello,

 

is it possible to implement a RSCP (Remote-Storage-Control-Protocol) communication for a PV-battery with PHP?

I'm experienced with PHP, but I have never implemented a socket communication with PHP...

 

How do I create a frame fulfilling the length constraints (see attached image)?

 

For example, what do I have to do to send the following frame:

Frame:    0xE3    0xDC    0x01    0x00    0x11    0x59    0x7B    0x53    0x00    0x00    0x00    0x00    0x00    0x00    0x00    0x00    0x0E    0x00    0x20    0x00    0x00    0x06    0x00    0x00    0x00    0x12    0x00    0x00    0x01    0x00    0x00    0x00

+ CRC32 Checksum

 

Best regards,

 

Brovning

Edited May 24, 2020 by Brovning

Hi,

I need to make web site, which will get requests from users that log in and activate those scripts. But, the problem is that the server has to, when the script is activated,  send request to another PC with the static IP address.  Then, that PC should execute the script, send its results to server, and then the server will notice user who activated it (clicked on the link).
So, the main problem is that server - client (static ip) communication, when the server is the first who sends request, not the client.

Any instructions would be appreciated, thanks in advance.

Hello!
I'm making a program in C++ which has some variables that I need to show inside my .php page.

So, I have 2 main questions
1) Is there a possible way to detect when my .php page is being requested
2) After this to inform the C++ program that the page is being requested (editing a file or writing to files would be preferable to be avoided)
and
3) After this the C++ program to give to php the variables that I want to show (again writing to files isn't preferable)

Perhaps question (3) is not for these forums, but I'd like to know if someone has an idea about the issue....

Unfortunately I have the impression that PHP is a simple script language and cannot do s0 high-level things...
Prove me wrong, please

Hi my website has been working all day now everypage is getting this error also get the same error when i try to login into phpmyadmin

Lost connection to MySQL server at 'reading initial communication packet', system error: 111

is this most likely a problem with the server?

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=353212.0

I have a table with postcodes in it. At some point some of the codes will be entered with spaces (LA12 5TH) and some without (LA17HU) what i need is a function to check if there is a space, if not - count back 3 characters from the end of the string and insert a space.

I don't know which string function to use - looked at pad but that seems to be for either end of string and not the middle - any ideas?

I have two servers: WebServer and FaxServer.  WebServer needs to send a fax.  Is my approach shown below fairly secure?

Before sending a fax, ServerWeb needs to store a record in a table representing the message, and I am using a pseudo random value for the PK which is generated as 2147483648+mt_rand(-2147483647,2147483647).

WebServer then generates a hash equal to hash('sha256',$pk.'secretCodeWhichOnlyWebServerAndFaxServerKnow').

WebServer then sends curl request to FaxServer using POST which includes $pk, the hash, the fax number, some text to include in the fax, and an optional array of document to include (array(array('id'=>321,'name')=>'fileName.pdf')).

FaxServer verifies that the hash is correct given $pk, that the minimum information has been received, and that the fax number is a valid phone number, and quickly responds to WebServer by echoing 0 or 1 so the code in the WebServer could continue and inform the user.  If all looks okay, a new instance of PHP is started.
 

if(missingInformation) {echo(0);}
else {
   session_start();
   $_SESSION['_xfr']=$_POST;
   exec('/usr/bin/php -q /path/to/send_fax.php '.session_id().' >/dev/null &');
   echo(1);
}

New instance of PHP send_fax.php then does the following:
 

session_id($argv[1]);//Set by parent
session_start();
$data=$_SESSION['_xfr'];

$doc_list=null;
foreach ($data['documents'] AS $doc)
{
    if(ctype_alnum($doc['id']))
    {
        $file='/some/tmp/directory/'.$doc['id'];
        if(!file_exists($file))
        {
            $url='http://machine.WebServer.com/index.php?task=displayDocument&id='.$doc['id'].'&x='.hash('sha256','displayDocument'.$doc['id'].'secretCodeWhichOnlyWebServerAndFaxServerKnow');
            $cmd='wget -O '.$file.' '.escapeshellarg($url);
            exec($cmd);
        }    
        $doc_list.=' '.$file;
    }
    exit('invalid document');
}

//Send the fax...

//Send another CURL request to the WebServer similar to the wget giving the fax status.
exit;

When WebServer receives the wget request for a document, it confirms the hash and sends the document to the FaxServer using X-Sendfile.

When WebServer receives the CURL request regarding status, it updates the database for the applicable message.   Seem reasonably secure?
 

I'm missing something here. I have a form, and when the submit is pressed, the relevant post data inserts into table one, then I want the last insert id to insert along with other form data into a second table. The first table's still inserting fine, but I can't get that second one to do anything. It leapfrogs over the query and doesn't give an error. EDIT: I forgot to add an error: I get: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'usage, why VALUES ('14', '', '123', '','1234', '', '')' at line 1

query:INSERT INTO tbl_donar (donar_fname, donar_name, donar_address, donar_address2, donar_city, donar_state, donar_zip, donar_email, donar_phone, donar_fax, donar_company) VALUES ('test 14', 'asdfa', 'asdf', 'adf','asdf', '', '', '', '123', '', '')


Code: [Select]
if (empty($errors)) {

require_once ('dbconnectionfile.php');

$query = "INSERT INTO tbl_donar (donar_fname, donar_name, donar_address, donar_address2, donar_city, donar_state, donar_zip, donar_email, donar_phone, donar_fax, donar_company)
 VALUES ('$description12', '$sn', '$description4', '$cne','$description5', '$description6', '$description7', '$description8',
'$description9', '$description10', '$description11')";

$result = @mysql_query ($query);


if ($result) {

$who_donated=mysql_insert_id();

$query2 = "INSERT INTO tbl_donation (donor_id, donor_expyear, donor_cvv, donor_cardtype, donor_authorization, amount, usage, why)
 VALUES ('$who_donated', '$donate2', '$donate3', '$donate4','$donate5', '$donate6', '$donate7')";
$result2 = @mysql_query ($query2);

if ($result2) {echo "Info was added to both tables! yay!";}

echo "table one filled. Table two was not.";
echo $who_donated;

//header ("Location: http://www.twigzy.com/add_plant.php?var1=$plant_id");

exit();
} else {
echo 'system error. No donation added';

Can anyone tell me why this is not INSERTing? My array data is coming out just fine.. I've tried everything I can think of and cannot get anything to insert.. Ahhhh!

<?php
  $query = "SELECT RegionID, City FROM geo_cities WHERE RegionID='135'";
  $results = mysqli_query($cxn, $query);
  $row_cnt = mysqli_num_rows($results);
  echo $row_cnt . " Total Records in Query.<br /><br />";
  if (mysqli_num_rows($results)) {
      while ($row = mysqli_fetch_array($results)) {
          $insert_city_query = "INSERT INTO all_illinois SET state_id=$row[RegionID], city_name=$row[City] WHERE id = null" or mysqli_error();
          $insert = mysqli_query($cxn, $insert_city_query);
          if (!$insert) {
              echo "INSERT is NOT working!";
              exit();
          }
          
          echo $row['City'] . "<br />";
          
          echo "<pre>";
          echo print_r($row);
          echo "</pre>";
      }
      //while ($rows = mysqli_fetch_array($results))
      
      } //if (mysqli_num_rows($results))
      
      else {
          echo "No results to get!";
      }
?>

Here is my all_illinois INSERT table structu

CREATE TABLE IF NOT EXISTS `all_illinois` (
  `state_id` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here is my source table geo_cities structu

CREATE TABLE IF NOT EXISTS `1` (
  `CityId` varchar(255) NOT NULL,
  `CountryID` varchar(255) NOT NULL,
  `RegionID` varchar(255) NOT NULL,
  `City` varchar(255) NOT NULL,
  `Latitude` varchar(255) NOT NULL,
  `Longitude` varchar(255) NOT NULL,
  `TimeZone` varchar(255) NOT NULL,
  `DmaId` varchar(255) NOT NULL,
  `Code` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Hi,

I am trying to make some adjustments to uploadify.php which comes with the latest version of uploadify (3.0 beta), so that it works with a session variable that stores the login username and adds it to the path for uploads.  Here is uploadify.php as it currently looks:

Code: [Select]
<?php
session_name("MyLogin");
session_start();

$targetFolder = '/songs/' . $_SESSION['name']; // Relative to the root

if (!empty($_FILES)) {
$tempFile = $_FILES['Filedata']['tmp_name'];
$targetPath = $_SERVER['DOCUMENT_ROOT'] . $targetFolder;
$targetFile = rtrim($targetPath,'/') .'/'. $_FILES['Filedata']['name'];

// Validate the file type
$fileTypes = array('m4a','mp3','flac','ogg'); // File extensions
$fileParts = pathinfo($_FILES['Filedata']['name']);

if (in_array($fileParts['extension'],$fileTypes)) {
move_uploaded_file($tempFile,$targetFile);
echo '1';
} else {
echo 'Invalid file type.';
}
}

echo $targetFolder;

?>
I added Code: [Select]
echo $targetFolder; at the bottom so that I could make sure that the string returned was correct, and it is, i.e. '/songs/nick'.  For some reason though, uploads are not going to the correct folder, i.e. the username folder, but instead are going to the parent folder 'songs'.  The folder for username exists, with correct permissions, and when I manually enter Code: [Select]
$targetFolder = '/songs/nick';all works fine.  Which strikes me as rather strange.  I have limited experience of using php, but wonder how if the correct string is returned by the session variable, the upload works differently than with the manually entered string.

Any help would be much appreciated.  It's the last issue with a website that was due to go live 2 days ago!

Thanks,

Nick

Hey there,

Thanks for taking the time to read my thread. My issue is that I can't think of a way to edit a XML file using PHP's XML functionality and then assign the edited contents to a string instead of saving the file. Because my issue is that I have to edit the XML file based upon a string brought from a remote location then give it back to that remote location using a string again, to be exact I am doing it via Linux command line utilizing SSH2.

This is what I managed to complete on my own.


function CheckIVMPConfig($ServerID)
{
global $Panel;

if(is_numeric($ServerID) && $this->IsValidServer($ServerID))
{
// We select the game server that the FTP account was created for.
$Servers = mysql_query("SELECT * FROM control_servers WHERE server_id = '".mysql_real_escape_string($FTPAccount['ftp_server'])."'");
$Server = mysql_fetch_array($Servers);

// Here we select the Box ID that the game server is on.
$Boxs = mysql_query("SELECT * FROM control_machines WHERE machine_id = '".$Server['server_machine']."'");
$Box = mysql_fetch_array($Boxs);

// Now we select the required package for the box.
$Packages = mysql_query("SELECT * FROM control_packages WHERE package_id = '".$Server['server_package']."'");
$Package = mysql_fetch_array($Packages);

// Retrive the file.
$Config = $CProtocol->exec("cat /home/{$Server['server_id']}/{$Package['package_config']}");

$Parse = SimpleXMLElement($Config);

foreach($Parse as $Entry) // loop through our books
{
if($Entry->port != $Server['server_port'])
{
// edit the value
}
else if($Entry->maxplayers > $Server['server_slots'])
{
// edit the value
}
}
}
}

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=326004.0