Learn VBA & Macros in 1 Week!

PHP - Load Dynamic Data

Full Excel VBA Course - Beginner to Expert

Load Dynamic Data	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

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Unable To Load Image Data With Dynamic Folders

No Dynamic Variables Able To Load?

Load Dynamic Content Into Div Via Ajax

Unable To Load Dynamic Library '/usr/lib64/php/modules/oci8.so'

Load Data From Db Into A Option Box

Unable To Load Image Data

Moved: Load Data Infile

Load Data Infile Not Working In Script

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

Export Dynamic Data To Pdf With Php

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

Emailing Dynamic Form Data?

Display Data In Dynamic List

Updating Data From Dynamic Rows...

Submitting Data From Dynamic Form

How To Display Data According To Dynamic List Box

Echo Dynamic Data From Api Call To Owl Carousel

Creating Google Charts With Dynamic Data

Dynamic Image And Data Upload Simultaneously

[php][mysql]display Dynamic Data From Database

Learn VBA & Macros for Excel in 1 Week!

Unable To Load Image Data With Dynamic Folders

Similar Tutorials

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

No Dynamic Variables Able To Load?

Similar Tutorials

Ok, so I have some basic jquery allowing me to refresh and "hopefully" track _SESSION changes.

I am running into a issue where only basic PHP functions and variables can be used inside.

jQuery Code Loading PHP page
Code: [Select]
<script type="text/javascript">
var auto_refresh = setInterval(
function () {
$('#load_options').load('session_options.php');
}, 5000); // refresh every 10000 milliseconds

</script>

<div id="load_options" style="position:fixed; z-index:100; margin-left:700px; width:200px; padding:10px; background-color:#fff;">
<?php require("session_options.php"); ?>
</div>

session_options.php

<p><?php

echo $myNow = date("g:i:s A");
?></p>
<div class="cartinfo">
<h1><b><?php echo $_SESSION['dep_city']; ?>⇒<br /><?php echo $_SESSION['arr_city']; ?></b></h1>
<p>Date: <b><?php echo $_SESSION['dep_date']; ?></b></p>
<p>Passengers: <b><?php echo $_SESSION['passengers']; ?></b></p>
<p>Cost: $<b><?php echo $_SESSION['total']; ?></b></p>
<br />

...blah blah blah

What I end up seeing is the Time (WHICH DOES REFRESH PROPERLY) & the static text.

HOWEVER, right before the 1st refresh takes place all the variables WORK.... but as soon as that refresh hits... poof "black hole of death".

If i include the file with PHP it all works perfectly, but then it won't refresh and update .

Load Dynamic Content Into Div Via Ajax

Similar Tutorials

Hi All, Am hoping someone can point out my perhaps obvious issue here. I've a series of links that are dynamically created:

<a class="team-link" rel="<?php the_ID(); ?>" href="#">

When a link is clicked, I'm trying to get content to load into this DIV:

<div id="single-post-container"></div>

I have the following jquery:

<script>
$(document).ready(function(){
 
        $.ajaxSetup({cache:false});
        $(".team-link").click(function(){

			var post_id = $(this).attr("rel");

            $.ajax({
                url        : "http://www.domain.co.uk/wp-content/themes/name/loop.php",				
                data       : {"the_team": post_id },
				type       : "POST",
                dataType   : "html",                
				success: function(response) {
					$("#single-post-container").html(response);						
				}
        return false;
        });
		
 
});
</script>

This is my loop.php file:

require_once('../../../wp-load.php');

// Our variables
$the_team = (isset($_GET['post_id'])) ? $_GET['post_id'] : 0;

echo $the_team;

query_posts(array(
			'post_type' => 'work',
			'meta_key' => 'author_name',
			'meta_value' => $the_team
));

// our loop
if (have_posts()) {
	while (have_posts()){
	the_post();	
	?>

		<h1><?php the_title(); ?></h1>
		<?php the_content(); ?>
        <hr />
	
	<?php
	}
}
wp_reset_query();

However, when you click the link, nothing happens. I know loop.php works as I can specify a value and manually browse to it to see the content. I feel I'm missing something obvious as I'm new to AJAX. Your help/patience is very much appreciated

Unable To Load Dynamic Library '/usr/lib64/php/modules/oci8.so'

Similar Tutorials

hi all, this is my setup Apache/2.2.15 (Unix) PHP 5.4.36 (cli) (built: Dec 19 2014 06:28:27) CentOS release 6.6 i am having intermmittent issues whenever in install pdo_oci and oci8 for PHP following this procedure http://shiki.me/blog...ntos-6-4-64bit/ this is the full error [root@localhost ~]# php -v
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/oci8.so' - /usr/lib64/php/modules/oci8.so: undefined symbol: php_checkuid in Unknown on line 0
PHP Warning: PHP Startup: PDO_OCI: Unable to initialize module location of oci8 [root@localhost ~]# cd /usr/lib64/php/
[root@localhost php]# ll
total 8
drwxr-xr-x. 2 root root 4096 Jan 6 20:16 build
drwxr-xr-x. 2 root root 4096 Jan 6 20:16 modules
[root@localhost php]# cd modules/
[root@localhost modules]# ll
total 4052
-rwxr-xr-x. 1 root root   69304 Dec 19 13:32 curl.so
-rwxr-xr-x. 1 root root 2708336 Dec 19 13:32 fileinfo.so
-rwxr-xr-x. 1 root root   46152 Dec 19 13:32 gmp.so
-rwxr-xr-x. 1 root root   41576 Dec 19 13:32 json.so
-rwxr-xr-x. 1 root root   49288 Dec 19 13:32 mssql.so
-rwxr-xr-x. 1 root root 482372 Jan 6 14:15 oci8.so<<<<<========
-rwxr-xr-x. 1 root root   20256 Dec 19 13:32 pdo_dblib.so
-rwxr-xr-x. 1 root root 124216 Jan 6 13:32 pdo_oci.so
-rwxr-xr-x. 1 root root 101784 Dec 19 13:32 pdo.so
-rwxr-xr-x. 1 root root   25984 Dec 19 13:32 pdo_sqlite.so
-rwxr-xr-x. 1 root root 265584 Dec 19 13:32 phar.so
-rwxr-xr-x. 1 root root   45744 Dec 19 13:32 sqlite3.so
-rwxr-xr-x. 1 root root   41008 Dec 19 13:32 sybase_ct.so
-rwxr-xr-x. 1 root root   94808 Dec 19 13:32 zip.so
[root@localhost modules]# [root@localhost modules]# cd /etc/php.d
[root@localhost php.d]# ll
total 56
-rw-r--r--. 1 root root 49 Dec 19 13:32 curl.ini
-rw-r--r--. 1 root root 57 Dec 19 13:32 fileinfo.ini
-rw-r--r--. 1 root root 47 Dec 19 13:32 gmp.ini
-rw-r--r--. 1 root root 49 Dec 19 13:32 json.ini
-rw-r--r--. 1 root root 51 Dec 19 13:32 mssql.ini
-rw-r--r--. 1 root root 18 Jan 6 14:16 oci8.ini
-rw-r--r--. 1 root root 59 Dec 19 13:32 pdo_dblib.ini
-rw-r--r--. 1 root root 47 Dec 19 13:32 pdo.ini
-rw-r--r--. 1 root root 22 Jan 6 13:59 pdo_oci.ini
-rw-r--r--. 1 root root 61 Dec 19 13:32 pdo_sqlite.ini
-rw-r--r--. 1 root root 49 Dec 19 13:32 phar.ini
-rw-r--r--. 1 root root 55 Dec 19 13:32 sqlite3.ini
-rw-r--r--. 1 root root 59 Dec 19 13:32 sybase_ct.ini
-rw-r--r--. 1 root root 47 Dec 19 13:32 zip.ini
[root@localhost php.d]# more oci8.ini
extension=oci8.so but if i do this [root@localhost php.d]# rm -fr oci8.ini
[root@localhost php.d]# ll
total 52
-rw-r--r--. 1 root root 49 Dec 19 13:32 curl.ini
-rw-r--r--. 1 root root 57 Dec 19 13:32 fileinfo.ini
-rw-r--r--. 1 root root 47 Dec 19 13:32 gmp.ini
-rw-r--r--. 1 root root 49 Dec 19 13:32 json.ini
-rw-r--r--. 1 root root 51 Dec 19 13:32 mssql.ini
-rw-r--r--. 1 root root 59 Dec 19 13:32 pdo_dblib.ini
-rw-r--r--. 1 root root 47 Dec 19 13:32 pdo.ini
-rw-r--r--. 1 root root 22 Jan 6 13:59 pdo_oci.ini
-rw-r--r--. 1 root root 61 Dec 19 13:32 pdo_sqlite.ini
-rw-r--r--. 1 root root 49 Dec 19 13:32 phar.ini
-rw-r--r--. 1 root root 55 Dec 19 13:32 sqlite3.ini
-rw-r--r--. 1 root root 59 Dec 19 13:32 sybase_ct.ini
-rw-r--r--. 1 root root 47 Dec 19 13:32 zip.ini
[root@localhost php.d]# php -v
PHP Warning: PHP Startup: PDO_OCI: Unable to initialize module
Module compiled with module API=20090626
PHP    compiled with module API=20100525
These options need to match
in Unknown on line 0
PHP 5.4.36 (cli) (built: Dec 19 2014 06:28:27)
Copyright © 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright © 1998-2014 Zend Technologies no errror on PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/oci8.so' - /usr/lib64/php/modules/oci8.so: undefined symbol: php_checkuid in Unknown on line 0 [root@localhost php.d]# thanks in advance
Edited by taliez, 06 January 2015 - 11:40 PM.

Load Data From Db Into A Option Box

Similar Tutorials

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

Unable To Load Image Data

Similar Tutorials

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: Load Data Infile

Similar Tutorials

This topic has been moved to MySQL Help.

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

Load Data Infile Not Working In Script

Similar Tutorials

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,

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

Similar Tutorials

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

Export Dynamic Data To Pdf With Php

Similar Tutorials

Hello,
I had page that display results dynamically from the database, I need to export that html table to pdf.
Any help?
Thanks

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

Similar Tutorials

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

Emailing Dynamic Form Data?

Similar Tutorials

Hi - I'm trying to speed up part of my business. I sell photos taken on site...I dump said photos in a directory and my little app pulls all images from a given directory and displays them on a page. I can get the filename etc displayed on screen, added to the image attributes, whatever. I'd like to have a checkbox next to each image, and the user checks a few and it'll send an email to me so I can fill their order.

Looks like this: http://www.limitedwave.com/reflex/

I can use a sendmail like I've tried, but it can take like 10 minutes to actually send from the server which is lame. I'd be cool with just dropping the data in my database, then retrieving selections by user's name, but I don't know how to set up a form/insert page that will insert from a somewhat random set of checkboxes.

Thoughts? Thanks.

Display Data In Dynamic List

Similar Tutorials

Updating Data From Dynamic Rows...

Similar Tutorials

Hey guys,

I got another one that i could use some help on. I have a input form that utilizes a javascript that adds additional rows to my table. here is a look at what i got.

Code: [Select]
<script type="text/javascript">
function insertRow()
{
var x = document.getElementById('results_table').insertRow(-1);
var a = x.insertCell(0);
var b = x.insertCell(1);
var c = x.insertCell(2);
var d = x.insertCell(3);
var e = x.insertCell(4);

a.innerHTML="<input type=\"text\" name=\"id\">";
b.innerHTML="<input type=\"text\" name=\"place\">";
c.innerHTML="<input type=\"text\" name=\"username\">";
d.innerHTML="<input type=\"text\" name=\"earnings\">";
e.innerHTML="<input type=\"button\" value=\"delete\" onClick=\"deleteRow(this)\">";
}

function deleteRow(r)
{
var i=r.parentNode.parentNode.rowIndex;
document.getElementById('results_table').deleteRow(i);
}

</script>
this is my code stored in the header of my page. basically just a button to add a new row and a button in each row to delete rows if needed.

here is a look at my html table, pretty basic...

Code: [Select]
<table id="results_table">

<th>Event ID</th><th>Place</th><th>Username</th><th>Earnings</th>

<tr>
<td><input type="text" name="id"></td><td><input type="text" name="place"></td><td><input type="text" name="username"></td><td><input type="text" name="earnings"></td><td><input type="button" value="delete" onClick="deleteRow(this)"</td>
</tr>

</table>
Now what I am hoping to acheive is once i submit all of these rows to the database i will insert each of these rows into their own row in the database. is this doable?

the structure of my database is:

ResultID (Primary Key)
Place
Earnings
UserID (Foreign Key)
EventID (Foreign Key)

now i think the biggest problem i'm having with submitting data to the database is that in the original HTML form I am typing in the actual username and not the userID.

so when it comes to processing I need to do a switch of these two things before I run my query. Should something like this work?

Code: [Select]

$username = $_POST['username'];

$userID = "SELECT userID FROM users WHERE username="$username";

$query = mysql_query($userID);

also i've never tried to submit multiple entries at a time. maybe i have to create an array somehow in order to capture each rows data. any thoughts?

as always thanks for the help.

Submitting Data From Dynamic Form

Similar Tutorials

Hi,

I have a dynamic form which uses javascript to add rows on the fly. The name of the element on my test page is txtRow1, txtRow2, etc; the number is added when I add a new row.

I am trying to figure out how I will extract the data once the form had been POSTED.

I have tried

Code: [Select]
$tags = $_POST['txtRow'];

foreach ($tags as $t)
{
echo "$t<br />";
}

but that shows nothing.

I would be grateful for any assistance.

Thanks

How To Display Data According To Dynamic List Box

Similar Tutorials

please help me the concept or code to retrive data from the database and display data according to the data from the dynamic list box option.

Echo Dynamic Data From Api Call To Owl Carousel

Similar Tutorials

Hi all new to php and this forum i have been looking around and im very impressed most questions get answered not like on some of the forums around. Is there any one kind enough to help me out i have an api call via php and would like to output the results to owlcarousel where do i start with this. Code i have is:

<?php
 
 
error_reporting(E_ALL); // Turn on all errors, warnings and notices for easier debugging
 
// API request variables
$endpoint  = 'http://svcs.ebay.com/services/search/FindingService/v1'; // URL to call
$version   = '1.0.0'; // API version supported by your application
$appid     = 'YourAppID'; // Replace with your own AppID
$globalid  = 'EBAY-GB'; // Global ID of the eBay site you want to search (e.g., EBAY-DE)
$query     = 'tools'; // You may want to supply your own query
$safequery = urlencode($query); // Make the query URL-friendly
 
 
 
// Construct the findItemsByKeywords HTTP GET call
$apicall = "$endpoint?";
$apicall .= "OPERATION-NAME=findItemsIneBayStores";
$apicall .= "&SERVICE-VERSION=$version";
$apicall .= "&SECURITY-APPNAME=$appid";
$apicall .= "&GLOBAL-ID=$globalid";
$apicall .= "&keywords=$safequery";
$apicall .= "&storeName=yourstorename";
$apicall .= "&paginationInput.entriesPerPage=6";
$apicall .= "&paginationInput.pageNumber=1";

 
// Load the call and capture the document returned by eBay API
$resp = simplexml_load_file($apicall);
 
// Check to see if the request was successful, else print an error
if ($resp->ack == "Success") {
    $results = '';
    // If the response was loaded, parse it and build links
    foreach ($resp->searchResult->item as $item) {
        $pic   = $item->galleryURL;
        $link  = $item->viewItemURL;
        $title = $item->title;
        $price = $item->currentPrice;
 
        // For each SearchResultItem node, build a link and append it to $results
        $results .= "<div id='item'><div class='img-wrap' align='center'><img src=\"$pic\" class='itemimg'></div> <div class='itemtxt' align='center'><a href=\"$link\">$title</a>$price</div></div>";
    }
}
// If the response does not indicate 'Success,' print an error
else {
    $results = "<h3>Oops! The request was not successful. Make sure you are using a valid ";
    $results .= "AppID for the Production environment.</h3>";
}
?>

<html>
<head>
<body>
 
<table>
    <tr>
        <td> 
                <div id="result">
                    <?php echo $results;?>

                </div>
        </td>
    </tr>
</table>
 
</body>
</html>

Im sure is pretty basic but being new to this i have no idea where to start, any advice would be much appreciated. thanks
Edited by didz666, 25 January 2015 - 02:22 PM.

Creating Google Charts With Dynamic Data

Similar Tutorials

i've to populate google charts with dynamic data.

the data looks llike.

+----+-------+---------+-------+-----------+---------+------+
| id | name  | physics | maths | chemistry | biology | sst  |
+----+-------+---------+-------+-----------+---------+------+
|  1 | Name1 |      10 |    25 |        35 |      42 |   62 |
|  2 | Name2 |      80 |    45 |        45 |      45 |   25 |
|  3 | Name3 |      63 |    25 |        63 |      36 |   36 |
|  4 | Name4 |      82 |    36 |        75 |      48 |   42 |
|  5 | Name5 |      45 |    45 |        78 |      25 |   24 |
|  6 | Name6 |      36 |    36 |        15 |      75 |   36 |
|  7 | Name7 |      99 |    45 |        24 |      24 |   45 |
|  8 | Name8 |      45 |    85 |        85 |      85 |   96 |
+----+-------+---------+-------+-----------+---------+------+

i have to create google charts based on this such that

# namewise - such that when i select a name it displays all subject marks of that particular name in a column chart

#markswise - when i select a subject, it displays all the names with marks in that particular subject.

conisdiering that data may be added and i've to accumulate that also, for namewise i did

// chart.php
<?php

include("connection.php");

$query = "SELECT name FROM csv GROUP BY name DESC";

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

?>
<!DOCTYPE html>
<html>
    <head>
        <title>Google charts</title>
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
        <script src="https://code.jquery.com/jquery-1.12.4.js"></script>
    </head>
    <body>
        <br /><br />
        <div class="container">
          <div class="panel panel-default">
                <div class="panel-heading">
                    <div class="row">
                        <div class="col-md-9">
                            <h3 class="panel-title">Student Wise Marks Data</h3>
                        </div>
                        <div class="col-md-3">
                            <select name="name" class="form-control" id="name">
                                <option value="">Select Student</option>
                            <?php
                            foreach($result as $row)
                            {
                                echo '<option value="'.$row["name"].'">'.$row["name"].'</option>';
                            }
                            ?>
                            </select>
                        </div>
                    </div>
                </div>
                <div class="panel-body">
                    <div id="chart_area" style="width: 1000px; height: 620px;"></div>
                </div>
            </div>
        </div>
    </body>
</html>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load('current', {packages: ['corechart', 'bar']});
google.charts.setOnLoadCallback();

function load_student_data(name, title)
{
    var temp_title = title + ' '+name+'';
    $.ajax({
        url:"fetch.php",
        method:"POST",
        data:{name:name},
        dataType:"JSON",
        success:function(data)
        {
            drawStudentwiseChart(data, temp_title);
        }
    });
}

function drawStudentwiseChart(chart_data, chart_main_title)
{
    var jsonData = chart_data;
    var data = new google.visualization.DataTable();
    data.addColumn('number', 'Physics');
    data.addColumn('number', 'Maths');
    data.addColumn('number', 'Chemistry');
    data.addColumn('number', 'Biology');
    data.addColumn('number', 'SST');
    $.each(jsonData, function(i, jsonData){
        var Physics = jsonData.Physics;
        var Maths = jsonData.Maths;
        var Chemistry = jsonData.Chemistry;
        var Biology = jsonData.Biology;
        var SST = jsonData.SST;

        data.addRows([[Physics,Maths,Chemistry,Biology,SST]]);
    });
    var options = {
        title:chart_main_title,
        hAxis: {
            title: "Subjects"
        },
        vAxis: {
            title: 'Percentage'
        }
    };

    var chart = new google.visualization.ColumnChart(document.getElementById('chart_area'));
    chart.draw(data, options);
}

</script>

<script>

$(document).ready(function(){

    $('#name').change(function(){
        var name = $(this).val();
        if(name != '')
        {
            load_student_data(name, 'Student wise marks data');
        }
    });

});

</script>

and in order to fetch data

// fetch.php

<?php

//fetch.php

include('connection.php');

if(isset($_POST["name"]))
{
 $query = "
 SELECT * FROM csv
 WHERE name = '".$_POST["name"]."'
 ORDER BY id ASC
 ";
 $statement = $connect->prepare($query);
 $statement->execute();
 $result = $statement->fetchAll();
 foreach($result as $row)
 {
  $output[] = array(
   'Physics'   => $row["Physics"],
   'Maths'   => $row["Maths"],
   'Chemistry'   => $row["Chemistry"],
   'Biology'   => $row["Biology"],
   'SST'   => $row["SST"],

  );
 }
 echo json_encode($output);
}

?>

it diplays a blank page.

however when i play with singular values i.e one subject at a time it displays fine

Edited March 19, 2019 by zetastreak

Dynamic Image And Data Upload Simultaneously

Similar Tutorials

Ok so I have a form to submits to a .php file that creates an image. This works fine, but I also want the info from the form to be sent to MySQL database. The problem is that something in a script I "required" called core.inc.php is interfering and so no image is output. Here is core.inc.php: Code: [Select]
<?php
ob_start();
session_start();
$current_file = $_SERVER['SCRIPT_NAME'];

if(isset($_SERVER['HTTP_REFERER'])&&!empty($_SERVER['HTTP_REFERER'])) {
$http_referer = $_SERVER['HTTP_REFERER'];
}

function loggedin() {
if(isset($_SESSION['user_id'])&&!empty($_SESSION['user_id'])) {
return true;
} else {
return false;
}
}

function getuserfield($field) {
$query="SELECT `$field` FROM `Users` WHERE `id`='".$_SESSION['user_id']."'";
if($query_run=mysql_query($query)) {
if($query_result = mysql_result($query_run, 0, $field)) {
return $query_result;
}
}
}

?>

Here is the code for the image creating .php file:
Code: [Select]
<?php
require 'connect.inc.php';
require 'core.inc.php';
$title = $_REQUEST['title'] ;
$user_id = getuserfield('id');
$query = "INSERT INTO `---` VALUES ('".mysql_real_escape_string($title)."','".mysql_real_escape_string($user_id)."')";
$query_run = mysql_query($query);
//There is some more code in here obviously, but it's irrelevant
header('Content-type: image/png');
imagepng($image_f);
imagedestroy($image_f)

Can anybody give me some idea of what is conflicting or what I can do to fix it?

[php][mysql]display Dynamic Data From Database

Similar Tutorials

im making a game and i need to show a users money but i dont know how help?