Learn VBA & Macros in 1 Week!

PHP - Moved: Load Data Infile

Full Excel VBA Course - Beginner to Expert

Moved: Load Data Infile	View Content

This topic has been moved to MySQL Help.

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

Full Excel VBA Course - Beginner to Expert

Load Data Infile Not Working In Script

Similar Tutorials

View Content

Hello there,

I have a script which uses the LOAD DATA LOCAL INFILE command see below:

<?php

//connect to your database
mysql_connect("localhost", "xxx", "xxx"); //(host, username, password)

//specify database
mysql_select_db("xxx") or die("Unable to select database"); //select which database we're using

// Build SQL Query
$query = "LOAD DATA INFILE  '/public_html/admin/files/test-jp-stock.csv' INTO TABLE 'jpaero_stocksearch' FIELDS TERMINATED BY  ',' LINES TERMINATED BY  '\r\n' IGNORE 1 LINES";

if(mysql_query($query)){

echo ">> New Stock Data has now been uploaded. Database is now live and searchable.";}
else{

echo "Upload failed. Please contact support.";}

?>

Initially I uploaded the csv file through phpmyadmin and everything worked fine - so I then used the SQL generated inside my script, changing the location to where the file actually is - however now nothing happens at all.

Any ideas on whats gone wrong, gratefully received!

Thanks,

Load Data From Db Into A Option Box

Similar Tutorials

View Content

i have a dropdown menu that displays the options i have in a database. i have this all working in mysqli as i didnt write this part on another website. but i am struggling to convert it back to mysql.

the original code is:

$query = "SELECT gallery_type_id, gallery_type_desc FROM gallery_type ORDER BY gallery_type_id";

/* run the query */
$result = $dbLink->query($query);

/* load the query's results into an array */
$i=1;
while($row=$result->fetch_assoc()){
$galleryTypes[$i] = $row;
$i++;
}
$num_results = $result->num_rows;

<select name="gallery_type" id="gallery_type">
<option>Please Select an Album
<?php
for($i = 1; $i < $num_results+1; $i++) {
echo "<option value=\"" . $galleryTypes[$i]['gallery_type_id'] . "\">";
echo $galleryTypes[$i]['gallery_type_desc'];
echo "</option>\n";
}
?>

the code i have got so far:

$query1 = "SELECT id, question FROM securtiyq ORDER BY id";

/* run the query */
$result= mysql_query($query1);
$row = mysql_fetch_array($result);

/* load the query's results into an array */
$i=1;
while ($row = mysql_fetch_assoc($result)) {
$galleryTypes[$i] = $row;
$i++;
}

$num_results = mysql_num_rows($result);

<select name="gallery_type" id="gallery_type">
<option>Please Select A Security Question
<?php
for($i = 1; $i < $num_results+1; $i++) {
echo "<option value=\"" . $galleryTypes[$i]['id'] . "\">";
echo $galleryTypes[$i]['question'];
echo "</option>\n";
}
?>
</option>
</select>

the only problem is nothing from the database is displayed in the dropdown box. could someone point out where im going wrong

thanks in advance

Load Dynamic Data

Similar Tutorials

View Content

Hello. If someone can help me, i'll be grateful
So i have a foreach and an $output .= function that fills some infos in a table. Inside it i have a div for each line that when hovering your mouse should get some data .. Here i have a big problem, because for each line it should get some data and i don't know how to do it ...

i'll post here some of my code for better understanding.

Quote

//some java here
<?php
require "class.php";

$server_list = query_group();
$misc = server_misc($server);

foreach ($server_list as $server)
{
$misc = server_misc($server);
$server = server_html($server);
$idi = "{$server['o']['id']}";
$harta = "<a onmouseover=\"ShowContent('harta'); return true;\" onmouseout=\"HideContent('harta'); return true;\" href='".link($server['o']['id'])."' target=\"_self\">{$server['s']['map']}</a>
<div style=\"position:absolute;\" id=\"harta\" class=\"FAQ\">file_get_contents('http://mysite/player.php?d={$idi}')</div> ";

$output .= "
<table>
........... some code.....
<td>
{$harta}
</td>
.......

so basicly when i hover my mouse over each row it should get data from the file for that id... The problem is that only one page can be loaded with file_get_contents. I read over the internet that some ajax functions can do it but i really don't know how.
Please help me, i've been looking for 3 days already without any luck

Unable To Load Image Data

Similar Tutorials

View Content

I wonder whether someone may be able to help me please.

I'm trying to put together a PHP within Aurigma Image Uploader which will create an image gallery. To do this I need to extract the image from a folder called 'Thumbnails' and image data from a file called 'files.xml'.

The code below is an extract of the default script that performs this functionality and I've tested and it works without any issues.

Code: [Select]
<?php

  //This variable specifies relative path to the folder, where the gallery with uploaded files is located.
  //Do not forget about the slash in the end of the folder name.
  $galleryPath = 'UploadedFiles/';

  $thumbnailsPath = $galleryPath . 'Thumbnails/';

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR;

  $descriptions = new DOMDocument('1.0');
  $descriptions->load($absGalleryPath . 'files.xml');
?>
I have now changed my folder and file structure to the following:

UploadedFiles (Folder)
username (Subfolder containing the 'location' folder) location (Subfolder containing 'Thumbnails folder and image, and 'files.xml') Please note that both the 'username' and 'location' folders are dynamically created when the user initially uploads the images.
To try and accomodate the new file structure I changed my code to:

Code: [Select]
<?php

  //This variable specifies relative path to the folder, where the gallery with uploaded files is located.
  //Do not forget about the slash in the end of the folder name.
  $galleryPath = 'UploadedFiles/';

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $usernamefolder . DIRECTORY_SEPARATOR . $locationfolder . DIRECTORY_SEPARATOR;

  $thumbnailsPath = $galleryPath . 'Thumbnails/';

  $descriptions = new DOMDocument('1.0');
  $descriptions->load($absGalleryPath . 'files.xml');
?>
But when I run this I receive the following error:

Quote

d333603417/htdocs/development/UploadedFiles/files.xml" in /homepages/2/d333603417/htdocs/development/gallery.php on line 14

Line 14 is this line:
Code: [Select]
$descriptions->load($absGalleryPath . 'files.xml');

I've been working on this for days and I just can't seem to find the answer.

I just wondered whether someone could possibly look at this and let me know where I'm going wrong.

If it helps, I've added the upload script below.

Code: [Select]
<?php
require_once 'Includes/gallery_helper.php';
require_once 'ImageUploaderPHP/UploadHandler.class.php';
$galleryPath = 'UploadedFiles/';

function onFileUploaded($uploadedFile) {
  global $galleryPath;

  $packageFields = $uploadedFile->getPackage()->getPackageFields();
  $username=$packageFields["username"];
  $locationid=$packageFields["locationid"];
  $username = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['username']);
  $location = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['locationid']);
  $dirName = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['folder']);

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $username . DIRECTORY_SEPARATOR . $location . DIRECTORY_SEPARATOR;
  $absThumbnailsPath = $absGalleryPath . 'Thumbnails' . DIRECTORY_SEPARATOR;

  if (!is_dir($absGalleryPath)) mkdir($absGalleryPath, 0777, true);
  chmod($absGalleryPath, 0777);
  if (!is_dir($absGalleryPath . $dirName)) mkdir($absGalleryPath . $dirName, 0777, true);
  chmod($absGalleryPath . $dirName, 0777);

  if ($uploadedFile->getPackage()->getPackageIndex() == 0 && $uploadedFile->getIndex() == 0)
    initGallery($absGalleryPath, $absThumbnailsPath, FALSE);

  $originalFileName = $uploadedFile->getSourceName();
  $files = $uploadedFile->getConvertedFiles();
  $sourceFileName = getSafeFileName($absGalleryPath, $originalFileName);
  $sourceFile = $files[0];

  if ($sourceFile) $sourceFile->moveTo($absGalleryPath . $sourceFileName);
  $thumbnailFileName = getSafeFileName($absThumbnailsPath, $originalFileName);
  $thumbnailFile = $files[1];
  if ($thumbnailFile) $thumbnailFile->moveTo($absThumbnailsPath . $thumbnailFileName);

  $descriptions = new DOMDocument('1.0', 'utf-8');
  $descriptions->load($absGalleryPath . 'files.xml');

  $xmlFile = $descriptions->createElement('file');
  // <-- please check the following line
  $xmlFile->setAttribute('name', $_POST['folder'] . '/' . $originalFileName);
  $xmlFile->setAttribute('source', $sourceFileName);
  $xmlFile->setAttribute('size', $uploadedFile->getSourceSize());
  $xmlFile->setAttribute('originalname', $originalFileName);
  $xmlFile->setAttribute('thumbnail', $thumbnailFileName);
  $xmlFile->setAttribute('description', $uploadedFile->getDescription());
  $xmlFile->setAttribute('username', $username);
  $xmlFile->setAttribute('locationid', $locationid);
  $xmlFile->setAttribute('folder', $dirName);

  $descriptions->documentElement->appendChild($xmlFile);
  $descriptions->save($absGalleryPath . 'files.xml');
}

$uh = new UploadHandler();
$uh->setFileUploadedCallback('onFileUploaded');
$uh->processRequest();
?>
Many thanks

Moved: How To Ensure Images Load?

Similar Tutorials

View Content

This topic has been moved to Third Party PHP Scripts.

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

Moved: Load Testing Options

Similar Tutorials

View Content

This topic has been moved to Miscellaneous.

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

Unable To Load Image Data With Dynamic Folders

Similar Tutorials

View Content

I wonder whether someone may be able to help me please.

I've put together the following script which saves user defined images to server folders using the Aurigma Image Uploader software.

Code: [Select]
<?php
require_once 'Includes/gallery_helper.php';
require_once 'ImageUploaderPHP/UploadHandler.class.php';
$galleryPath = 'UploadedFiles/';

function onFileUploaded($uploadedFile) {
  global $galleryPath;

  $packageFields = $uploadedFile->getPackage()->getPackageFields();
  $username=$packageFields["username"];
  $locationid=$packageFields["locationid"];
  $usernamefolder = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['username']);
  $locationfolder = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['locationid']);
  $dirName = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['folder']);

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $usernamefolder . DIRECTORY_SEPARATOR . $locationfolder . DIRECTORY_SEPARATOR;
  $absThumbnailsPath = $absGalleryPath . 'Thumbnails' . DIRECTORY_SEPARATOR;

  if (!is_dir($absGalleryPath)) mkdir($absGalleryPath, 0777, true);
  chmod($absGalleryPath, 0777);
  if (!is_dir($absGalleryPath . $dirName)) mkdir($absGalleryPath . $dirName, 0777, true);
  chmod($absGalleryPath . $dirName, 0777);

  if ($uploadedFile->getPackage()->getPackageIndex() == 0 && $uploadedFile->getIndex() == 0)
    initGallery($absGalleryPath, $absThumbnailsPath, FALSE);

  $originalFileName = $uploadedFile->getSourceName();
  $files = $uploadedFile->getConvertedFiles();
  $sourceFileName = getSafeFileName($absGalleryPath, $originalFileName);
  $sourceFile = $files[0];

  if ($sourceFile) $sourceFile->moveTo($absGalleryPath . $sourceFileName);
  $thumbnailFileName = getSafeFileName($absThumbnailsPath, $originalFileName);
  $thumbnailFile = $files[1];
  if ($thumbnailFile) $thumbnailFile->moveTo($absThumbnailsPath . $thumbnailFileName);

  $descriptions = new DOMDocument('1.0', 'utf-8');
  $descriptions->load($absGalleryPath . 'files.xml');

  $xmlFile = $descriptions->createElement('file');
  // <-- please check the following line
  $xmlFile->setAttribute('name', $_POST['folder'] . '/' . $originalFileName);
  $xmlFile->setAttribute('source', $sourceFileName);
  $xmlFile->setAttribute('size', $uploadedFile->getSourceSize());
  $xmlFile->setAttribute('originalname', $originalFileName);
  $xmlFile->setAttribute('thumbnail', $thumbnailFileName);
  $xmlFile->setAttribute('description', $uploadedFile->getDescription());
  $xmlFile->setAttribute('username', $username);
  $xmlFile->setAttribute('locationid', $locationid);
  $xmlFile->setAttribute('folder', $dirName);

  $descriptions->documentElement->appendChild($xmlFile);
  $descriptions->save($absGalleryPath . 'files.xml');
}

$uh = new UploadHandler();
$uh->setFileUploadedCallback('onFileUploaded');
$uh->processRequest();
?>
This code saves the files in the following structu

UploadedFiles (Pre-existing folder)
'username' (Subfolder created dynamically on image upload if it doesn't already exist. This folder contains the 'location' folder) 'location' (Subfolder created dynamically on image upload if it doesn't already exist. This contains original image, 'files.xml' and 'Thumbnails' folder) 'Thumbnails' (Subfolder created dynamically on image upload if it doesn't already exist. This contains thumbnail of original image)
I'm now trying to put together a script which creates an image gallery, with those images pertinent to the current user and location. The code below is the piece of my script which deals with the loading of the images.

Code: [Select]
<?php
  $galleryPath = 'UploadedFiles/';

  $thumbnailsPath = $galleryPath . 'Thumbnails/';

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR;

  $descriptions = new DOMDocument('1.0');
  $descriptions->load($absGalleryPath . 'files.xml');
?>
The initial problem I had, was resolved from guidance I received on this site, and that was to find the correct 'realpath' of the 'Thumbnails' folder and 'files.xml'
These are as follows: Quote

/homepages/2/d333603417/htdocs/development/UploadedFiles/IRHM73/1

and Quote

/homepages/2/d333603417/htdocs/development/UploadedFiles/IRHM73/1/Thumbnails

with 'IRHM73' being the 'username' value and '1' the 'location' value.

The problem I now have lies within this line of code:

`$absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR;`

Because the 'username' and 'location' are dynamic and hence contain different values for each user and location, I've found it impossible to find a way of creating the correct file path to open the 'Thumbnails' folder and 'files.xml'.

I had tried this:

Code: [Select]
<?php

  $galleryPath = 'UploadedFiles/';

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $usernamefolder . DIRECTORY_SEPARATOR . $locationfolder . DIRECTORY_SEPARATOR;
  $absThumbnailsPath = $absGalleryPath . 'Thumbnails' . DIRECTORY_SEPARATOR;

  $descriptions = new DOMDocument('1.0');
  $descriptions->load($absGalleryPath . 'files.xml');
?>
But I receive the following error: DOMDocument::load() domdocument.load: I/O warning : failed to load external entity /homepages/2/d333603417/htdocs/development/UploadedFiles/'files.xml'; in /homepages/2/d333603417/htdocs/development/gallery.php on line 13 and line 13 is this: Code: [Select]
$descriptions->load($absGalleryPath . 'files.xml');

I really am stumped with what to do next to get this to work. I appreciate that this is a fairly lengthy post, but thought it would be better to post all the information.

I just wondered whether someone could perhaps take a look at this and let me know where I'm going wrong and how I can get it to work.

Many thanks and regards

Display Data That Has Been Written To The Database On The Same Page Load

Similar Tutorials

View Content

Hi guys,

Should be a simple 1.

If i have the following at the top of the page:

$page_views = $row['page_views'] + 1;
mysql_query("UPDATE table SET page_views='$page_views'");

and then the following at the bottom of the page:

echo $row['page_views'];

Should I see the page views as 1 the first time the page is visited, 2 the second time the page is visited, and so on......?
At the moment im seeing 0 on the first page visit, 1 on the second page visit, 2 on the third.....

I had this problem before on another page i was working, and i simply solved it by displaying the mysql query above the echo similar to the code above. However now it does not seem to be working.

Am i missing something really simple? lol

Thanks

How To Load File As Binary Data And Operate On It With Bitwise Operators?

Similar Tutorials

View Content

Hi all,

Is it possible in php to read data from file as binary and operate on it with bitwise operators and save result as binary.

Thanks

Moved: Cannot Load Mysql Extension. Please Check Your Php Configuration. - Documentatio

Similar Tutorials

View Content

This topic has been moved to PHP Installation & Configuration.

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

Moved: Need A Way To Load Database Information On Right Side Based On Selection On Left

Similar Tutorials

View Content

This topic has been moved to Ajax Help.

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

Moved: Url Get Data

Similar Tutorials

View Content

This topic has been moved to mod_rewrite.

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

Php Locks Session When Page Load Interrupted Before Complete Load.

Similar Tutorials

View Content

I'm having a problem and need an answer to why its happening and how to prevent it.

Scenario:

I begin load my home page which starts with a session_start(); .... Before it FULLY completes loading I try to navigate to another page and BOOM, that page will not load and any other page that begins with session_start(); will not load unless I close and restart the entire browser or wait about 10 minutes....

I will note my website makes ajax calls every 5 seconds or so, but I use setTimeout for them.

Any help??? Thanks ahead!

Moved: Google Data Api In Php

Similar Tutorials

View Content

This topic has been moved to Other Libraries and Frameworks.

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

Moved: Getting Data From Database

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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

Moved: How To Display Data For Every Day

Similar Tutorials

View Content

This topic has been moved to Application Design.

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

Moved: Dealing With Data From Mysql

Similar Tutorials

View Content

This topic has been moved to Application Design.

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

Moved: To Retrieve Data Using Joining

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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

Moved: Grouping Database Data

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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

Moved: Extracting Data With Regex

Similar Tutorials

View Content

This topic has been moved to PHP Regex.

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