PHP - Truncate Script Is Putting In Unwanted Numbers...

Hey guys, I'm a little confused to how I can do this.   I am basically wanting to give my first column a 'NOT NULL AUTO_INCREMENT' and give each row it's own 'id'. The issue I am having is that the script I am using truncates the whole SQL table with a CSV file that is cron'd daily to update data.   I am currently using this script:

<?php


$databasehost = "localhost";
$databasename = "";
$databasetable = "";
$databaseusername="";
$databasepassword = "";
$fieldseparator = ",";
$lineseparator = "\n";
$enclosedbyquote = '"';
$csvfile = "db-core/feed/csv/csv.csv";

if(!file_exists($csvfile)) {
die("File not found. Make sure you specified the correct path.");
}

try {
$pdo = new PDO("mysql:host=$databasehost;dbname=$databasename",
$databaseusername, $databasepassword,
array(
PDO::MYSQL_ATTR_LOCAL_INFILE => true,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
)
);
} catch (PDOException $e) {
die("database connection failed: ".$e->getMessage());
}

$pdo->exec("TRUNCATE TABLE `$databasetable`");

$affectedRows = $pdo->exec("
LOAD DATA LOCAL INFILE ".$pdo->quote($csvfile)." REPLACE INTO TABLE `$databasetable`
FIELDS OPTIONALLY ENCLOSED BY ".$pdo->quote($enclosedbyquote)."
TERMINATED BY ".$pdo->quote($fieldseparator)." 
LINES TERMINATED BY ".$pdo->quote($lineseparator)." 
IGNORE 1 LINES");

echo "Loaded a total of $affectedRows records from this csv file.\n";

?>

Is it possible to amend this script to ignore my first column and truncate all of the data in the table apart from the first column?   I could then give all of the rows in the first column their own ID's any idea how I could do this?   I am still very nooby so please go easy on me

Hi,
I need to sort variables in groups of up to 15 and put it in an array. For example:
$exstract['center_tabOpBody_0'] =5
$exstract['center_tabOpBody_1'] =6
$exstract['center_tabOpBody_2'] =8
$exstract['center_tabOpBody_3'] =1


Should yield:
ARRAY(
          = center_tabOpBody_1,center_tabOpBody_2,center_tabOpBody_3 // <-----15 [1] = center_tabOpBody_0 //<----5
)

Is there some simple function do do the "efficiency" sort?

Thanks,
Vadim

I am parsing an rss feed from my flickr photostream using this:-

<?php

$url = "http://api.flickr.com/services/feeds/photos_public.gne?id=49466419@N05&lang=en-us&format=rss_200";
$rss = simplexml_load_file($url);
	if($rss)
	{
	echo '<h1>'.$rss->channel->title.'</h1>';
	echo '<li>'.$rss->channel->pubDate.'</li>';
	$items = $rss->channel->item;
		foreach($items as $item)
		{
		$title = $item->title;
		$link = $item->link;
		$published_on = $item->pubDate;
		$description = $item->description;
		echo '<h3><a href="'.$link.'">'.$title.'</a></h3>';
		echo '<span>('.$published_on.')</span>';
		echo '<p>'.$description.'</p>';
	}
}

?>

which gives me this as the description for each image:-

public 'description' => string '
<p><a href="http://www.flickr.com/people/alfthomas/">Alf Thomas</a> posted a photo:</p>
	
<p><a href="http://www.flickr.com/photos/alfthomas/14064465890/" title="harlaw_12">
<img src="http://farm6.staticflickr.com/5077/14064465890_83c02ecec6_m.jpg" width="240" height="110" alt="harlaw_12" />
</a>
</p>

<p>A view of Harlaw Reservoir.</p>' (length=338)

What I actually want is the photo (linked back) without the "Alf Thomas posted a photo" bit, does anyone have any idea how I would go about cloning that bit out?
Edited by foucquet, 31 May 2014 - 08:14 AM.

Hi,

I have the following script:


<?PHP

$match = '/.*?\\d+.*?(\\d+)(\\s+)/is' ;

$dbh = new PDO('mysql:host=localhost;dbname=xxxx', 'xxxx', 'xxxx') ;

$result = $dbh->query("SELECT companyName, invoiceAddress FROM detail_sheets WHERE area = 'Germany'") ;
$codes = array() ;
$names = array() ;
$c0s = array() ;
$c1s = array() ;
$c2s = array() ;
$c3s = array() ;
$c4s = array() ;
$c5s = array() ;
$c6s = array() ;
$c7s = array() ;
$c8s = array() ;
$c9s = array() ;
while($row = $result->fetch(PDO::FETCH_ASSOC)) {

if(preg_match($match, $row['invoiceAddress'], $matches)) {

$codes[] = substr($matches[1], 0, 1) ;
$names[] = $row['companyName'] ;
//array_push($found, substr($matches[1], 0, 1), $row['companyName']) ;

}

}

$i = 0 ;
foreach($codes as $current) {

$currentName = $names[$i] ;

$result = $dbh->prepare("SELECT (sum(partbaskets.total) - sum(pourbaskets.total)) AS Margin
   FROM partbaskets, pourbaskets, enquiries, jobs
   WHERE partbaskets.enquiryRef = enquiries.id
   AND pourbaskets.enquiryRef = enquiries.id
   AND jobs.enquiryRef = enquiries.id
   AND jobs.status != 'Cancelled'
   AND enquiries.enqState != 'Inert'
   AND enquiries.companyName = ?
   ") ;
$result->bindParam(1, $currentName, PDO::PARAM_STR) ;
$result->execute() ;

while($row = $result->fetch(PDO::FETCH_ASSOC)) {

if($current == 0 && $row['Margin'])
array_push($c0s, $row['Margin']) ;
if($current == 1 && $row['Margin'])
array_push($c1s, $row['Margin']) ;
if($current == 2 && $row['Margin'])
array_push($c2s, $row['Margin']) ;
if($current == 3 && $row['Margin'])
array_push($c3s, $row['Margin']) ;
if($current == 4 && $row['Margin'])
array_push($c4s, $row['Margin']) ;
if($current == 5 && $row['Margin'])
array_push($c5s, $row['Margin']) ;
if($current == 6 && $row['Margin'])
array_push($c6s, $row['Margin']) ;
if($current == 7 && $row['Margin'])
array_push($c7s, $row['Margin']) ;
if($current == 8 && $row['Margin'])
array_push($c8s, $row['Margin']) ;
if($current == 9 && $row['Margin'])
array_push($c9s, $row['Margin']) ;
}
$result = NULL ;
$i++ ;
}

echo "<table><tr><td>Area</td><td>Margin</td></tr>" ;
echo "<tr><td>Area 0</td><td>" . array_sum($c0s) . "</td></tr>" ;
echo "<tr><td>Area 1</td><td>" . array_sum($c1s) . "</td></tr>" ;
echo "<tr><td>Area 2</td><td>" . array_sum($c2s) . "</td></tr>" ;
echo "<tr><td>Area 3</td><td>" . array_sum($c3s) . "</td></tr>" ;
echo "<tr><td>Area 4</td><td>" . array_sum($c4s) . "</td></tr>" ;
echo "<tr><td>Area 5</td><td>" . array_sum($c5s) . "</td></tr>" ;
echo "<tr><td>Area 6</td><td>" . array_sum($c6s) . "</td></tr>" ;
echo "<tr><td>Area 7</td><td>" . array_sum($c7s) . "</td></tr>" ;
echo "<tr><td>Area 8</td><td>" . array_sum($c8s) . "</td></tr>" ;
echo "<tr><td>Area 9</td><td>" . array_sum($c9s) . "</td></tr></table>" ;
?>


But what is happening is that the Margin is being multiplied by the number of rows in partbaskets (which is the same amount of rows in pourbaskets).

So for instance, if there is one part per job for a companyName, there is no problem and I get the correct margin.

But, if there is say 4 parts for one of the jobs, then the margin for that job will be multiplied by 4, which is wrong.

I have tried using GROUP but it didn't help.

Can someone please give me the missing link in my SQL statement?

Hi guys,   I am using this code to open and close a pop up window, but as soon as i click the close button this   http://localhost/popup.php?random=&button=   automatically adds in the url, Please tell me what is wrong with the script

<script type="text/javascript">

 $(document).ready(function(){
    $('a.popup-window').click(function(){
       
       var popupBox = $(this).attr('href');
       $(popupBox).fadeIn(400);
	   
	   var popMargTop = ($(popupBox).height() + 24)/2;
	   var popMargLeft = ($(popupBox).width() + 24)/2;
	   
	   $(popupBox).css({
		   'margin-top' : -popMargTop,
		   'margin-left' : -popMargLeft
	   });
	   
	   $('body').append('<div id="mask"></div>');
	   $('#mask').fadeIn(400);   
	   return false;
	});
    
	$('button.close,#mask').live('click', function(){
		   $('#mask,.popupInfo').fadeOut(400,function(){
			   $('#mask').remove();
			   });	
			   return false;
			});	  	
    
       
 
 });
 $(document).keyup(function(e){
	 if(e.keyCode ==27){
		 $('#mask,.popupInfo, #popup-box').fadeOut(400);
		 return false;
		 }
	 });

 </script>
</head>

<body>
<a href="#popup-box" class="popup-window">Click</a>
  <div id="popup-box" class="popupInfo">
    <form>
      <label>ANYTHING</label></br>
      <input type="text" name="random"/></br>
      <button type="submit" name="button" class ="close">close</button>
    </form>
   </div> 

</body>
</html>

Edited by chauhanRohit, 27 June 2014 - 09:46 AM.

Hi everyone,
I don't know whether this is a PHP or MySql problem, but I think it is the former. The following code queries the database correctly, (and before you ask, there are no duplicate database entries), but the output duplicates every row. e.g.,

hammer (jpg image)
hammer
hammer (jpg image)
hammer
saw (jpg image)
saw
saw (jpg image)
saw
screwdriver (jpg image)
screwdriver
screwdriver (jpg image)
screwdriver

and so on.
I cannot see why the code causes the row to repeat.

Code: [Select]
<?php session_start(); 
if (isset($_SESSION['id'])) 
{
// Put stored session variables into local php variable
     $id   = $_SESSION['id'];
     $userId = $_SESSION['userId'];
$userGroup = $_SESSION['userGroup'];
$managerId = $_SESSION['managerId'];
}
include_once("demo_conn.php"); 
$sql = mysql_query("SELECT * FROM users WHERE id='$id'"); 
while($row = mysql_fetch_array($sql))
    { 
        // Get member data into a session variable
        $egroup = $row["egroup"];   
        session_register('egroup'); 
        $_SESSION['egroup'] = $egroup;
}   
$query = mysql_query("SELECT topics.url_big, topics.url_small, topics.title, topics.$egroup, quiz.passState, quiz.userDate FROM topics INNER JOIN quiz ON (topics.managerId = quiz.managerId) WHERE topics.$egroup = 1 ORDER BY title ASC"); 
while ($row1 = mysql_fetch_array($query))
{
 echo "<a href='../../wood/wood_tool_images/{$row1['url_big']}' target='_blank'><img src='../../wood/wood_tool_images/{$row1['url_small']}' /><br />\n"; 
 echo "{$row1['title']} <br />\n";              
}
?>

Hi Everyone,

I am writing a PHP script to allow some of my site members to add links to their site. The script is setup to use a supplied link to an image, then make that image a clickable link which in turns opens that webpage.  Here is my code:

Code: [Select]
<?php
if($_POST['formsubmit'] == "Submit")
{
  $varLink = $_POST['Link'];
  $varImage = $_POST['Image'];
  $varDescription = $_POST['Description'];
}
$filea = "temp.tmp";
$fileb = "original.txt";
$filec = "newfile.txt";
$fa=fopen($filea,'w');                /* Open Temp File and Write $_POST data */
if($fa) {
   fwrite($fa,"<a href='$varLink'><img src='$varImage'></a><br>$varDescription<br><br>\n");
fclose($fa);
}
$fa=fopen($filea,'r');               /* Open Temp File and Read Contents */
if($fa) {
   $bufa=fgets($fa);
fclose($fa);
}
$fc=fopen($filec,'w');               /* Open New File to merge new and old Links */
if($fc) {
   fwrite($fc, $bufa);               /* Write Newest Link First */
}

$fb=fopen($fileb,'r');               /* Open Original file and Read it */
if($fb) {
   while(!feof($fb)) {               /* Loop through complete old file and write to new file */
     $bufb=fgets($fb);
     fwrite($fc, $bufb);
   }
}

fclose($fb);
fclose($fc);

unlink('original.txt');                  /* Delete Original File */
unlink('temp.tmp');                      /* Delete Temp File */
rename('newfile.txt', 'original.txt');   /* Rename New File to the Old Filename */

?>
NOTE The above code has been 'expanded' in my troubleshooting efforts... (i.e. I wrote the first write to file code, executed it and checked the file contents manually, then the 2nd step, etc....) so my final code will be shorter.

The problem I am having,.... when i write the 1st file 'temp.tmp', I get the expected data in the file (below).

<a href='http://www.somesite.com'><img src='http://www.somesite.com/pic.jpg'></a><br>Description of site<br><br>

However, when I read the temp.tmp and original.txt files and write it to the newfile.txt (to merge it all together) the expected data is there but with an extra entry after each 'good' entry (below):

<a href='http://www.somesite.com'><img src='http://www.somesite.com/pic.jpg'></a><br>Description of site<br><br>
<a href=''><img src=''></a><br><br><br>

I don't understand why i am getting the extra entry '<a href=''><img src=''></a><br><br><br>' in the file. Can anyone shed some light on this?

My head is sore from banging it on the wall!

I have an exercise for school that I have to work out. My teacher is letting us figure it out ourselves, but I've ran into some troubles:

- We have to make 2 files: sescook1.php and sescook2.php.
- We have to make a form for the user to fill out their name and favorite color (in sescook1.php).
- We have to check the input (whether there is input or no). If there's isn't any input, we have to echo 'Please fill out __' (in sescook1.php)
- We have to store the name in a session variable and the color in a cookievariable (in sescook1.php)
- If both fields are filled in, we ave to show a link 'go to the next page' (where 'next page' is an URL to sescook2.php).
- All info has to be shown in sescook2.php (Entered name: __, Entered color: ___)
- You have a link 'Go back to previous page' (where 'previous page' is an URL to sescook1.php)

My code:
Quote

<?php
session_start();
function checkContent() {
   if($_POST["name"] == "")
         echo "Please enter your name";
   elseif($_POST["favcolor"])
         echo "Please enter your favorite color";
   else
      echo "Go to <a href='http://localhost/webadv1011/PHPCookiesSessies/sescook2.php'>next page";
}
?>

<form name="color" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>" onsubmit="<?php checkContent(); ?>">
<p>Name: <input type="text" name="naam" /></p>
<p>Favourite color: <input type="text" name="favcolor" /></p>
<p><input type="submit" name="submit" value="send" /></p>
</form>



This is the code I got so far. My problem is that the page refreshes itself after it does the checkContent function. I'm also not sure how I save my name in a session variable and the color in a cookie variable (and pass them to the next page as well!).

We haven't learned anything on cookies and sessions except our own trial and error and things I found on the internet. Unfortunately, I can't really find lots of useful info (most people refer to Ajax, but we can only use php), or I'm looking in the wrong place.

Thanks for your help in advance!

Code: [Select]
<?php
# This script does get included into the document create_new_tag_from.php




    if(isset($_POST['tag_name_submit'])){
    $tag_name_submit = $_POST['tag_name_submit'];
    }
    
    if(!empty($_POST['tag_name'])){
    $tag_name = strip_tags($_POST['tag_name']);
    }
    
    if(!empty($_POST['tag_description'])){
    $tag_description = strip_tags($_POST['tag_description']);
    }


if(isset($tag_name_submit)){

    
    
    # The Validation of User Entered Data
    # Do validate for solely alphabetic characters with ctype_alpha

    # ctype_alpha($tag_name) && 
    if(ctype_alpha($tag_description)){
        $tag_name = strtolower($tag_name);
        $tag_description = strtolower($tag_description);

        
    # The Insertion Into the Database
    $db_connect = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
    
    # Do research if SQL query has to be modified into a PHP comform query
    
    $sql_query = sprintf(
            
            "set @newid = convert(
                
              ( select 
               max(convert( (substring(tag_id, 2)) , unsigned integer))+1
               from tags), char(10) );

                set @newid = if(length(@newid) = 1, concat('0', @newid), @newid);
                set @newid = concat('c', @newid);

                INSERT INTO tags (tag_id, tag_name, tag_description, added_by_user_id,
                                creation_date, last_edited)
                VALUES (@newid, '%s', '%s', 7, now(), '0')",
            
                mysqli_real_escape_string($db_connect, $tag_name),
                mysqli_real_escape_string($db_connect, $tag_description)
            
            
            );
    
    $sql_query_run = mysqli_multi_query($db_connect, $sql_query);
   
    # Print Test to See If It Works
    echo "works_ ";
    echo $tag_name . "_ ";
    echo $tag_description . "_ ";
                     
    
        } else { # End of the Validation
            echo "The entered data must be in alphabetic characters.";
        }
    
}



?>


Here is the form:

Code: [Select]
<?php
include_once('../../header.php');
include_once('../../model/contribution/create_new_tag_script.php');
?>

<form action="" method="post">
    <input type="text" name="tag_name" value="" />
    <textarea maxlength="60" type="text"  name="tag_description" value=""></textarea>
    <input type="submit" name="tag_name_submit" value="Submit the New Tag" />
</form>


<?php
include_once('../../footer.php');
?>
By the script as given above the conditional check will skip to the error message.

Though I have to say that ctype_alpha does return TRUE when I do try it with "tag_name" which is entered data from the input field, while the other is from the textarea.

I simply cannot see the reason for the returned FALSE.

I have 2 files; Newfault.php and thankyou.php

1) Data is entered into a form in Newfault.php
2) The data from this form is retieved in thankyou.php and is then inserted into a table called "Calls"

Problem:

My entered record is being added to my database OK, but it is also adding a blank record for some reason and I can't work out why. Can anyone help? This is for my uni assignment.

Thanks,

Ladykudos

This topic has been moved to HTML Help.

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

I'm having a problem with some php code that allows you to edit a text file. No matter what file it loads, it always adds four horizontal tabs and two spaces to the end of the text. I've attached the code to this post.

If anyone can help me with this, it would be greatly appreciated.

Cindy

Ok so for some reasons on my register and edit profile page when i hit submit it says that i have not filled in all the info i need.. Even after i fill all of them in..

but heres the code for the register form..

Code: [Select]
<?php require("top.php"); ?>
<div id='homeright'>
<?php


echo "<font size='6'>Sign up</font>";

echo "<hr width='75%' align='left'/>";
$form = "<form action='index.php' method='post'>
<table cellspacing='5px'>



<tr>
<td>First Name:</td>
<td class='register'><input type='text' name='firstname' class='textbox' size='35'></td>
</tr>

<tr>
<td>Last Name:</td>
<td><input type='text' name='lastname' class='textbox' size='35'></td>
</tr>

<tr>
<td>Username:</td>
<td><input type='text' name='username' class='textbox' size='35'></td>
</tr>

<tr>
<td>E-mail:</td>
<td><input type='text' name='email' class='textbox' size='35'></td>
</tr>

<tr>
<td>Password:</td>
<td><input type='password' name='password' class='textbox' size='35'></td>
</tr>

<tr>
<td>Confirm Password:</td>
<td><input type='password' name='repassword' class='textbox' size='35'></td>
</tr>

<tr>
<td></td>
<td><input type='submit' name='submitbtn' value='Register' class='button'></td>
</tr>
</table>

</form>";


if ($_POST['submitbtn']){


$firstname = fixtext($_POST['firstname']);
$lastname = fixtext($_POST['lastname']);
$username = fixtext($_POST['username']);
$email = fixtext($_POST['email']);
$password = fixtext($_POST['password']);
$repassword = fixtext($_POST['repassword']);
$website = fixtext($_POST['website']);
$youtube = fixtext($_POST['youtube']);
$bio = fixtext($_POST['bio']);

$name = $_FILES['avatar'] ['name'];
$type = $_FILES['avatar'] ['type'];
$size = $_FILES['avatar'] ['size'];
$tmpname = $_FILES['avatar']['tmpname'];
$ext = substr($name, strrpos($name, '.'));

if ($firstname && $lastname && $username && $email && $password && $repassword){
if ($password == $repassword){
if (strstr($email, "@") && strstr($email, ".") && strlen($email) >= 6){

require("scripts/connect.php");
/*$query = mysql_query("SELECT * FROM users WHERE username='$username' ");*/
$query=mysql_query("SELECT * FROM users WHERE username='$username' ") or die(mysql_error());
$numrows = mysql_num_rows($query);
if ($numrows == 0){

/*$query=mysql_query("SELECT * FROM users WHERE email='$email' ");*/
$query=mysql_query("SELECT * FROM users WHERE email='$email' ") or die(mysql_error());
$numrows=mysql_num_rows($query);
if ($numrows == 0){

$pass = md5(md5($password));
$date = date("F d, Y");

if($name){
move_uploaded_file($tmpname, "avatars/$username.$ext");
$avatar = "$username.$ext";
}
else
$avatar = "/avatars/default_avatar.png";

$code = substr (md5(rand(11111111111, 999999999999999)), 2,  25);

 
mysql_query("INSERT INTO users (`first_name`,`last_name`,`username`,`email`,`password`,`avatar`,`bio`,`website`,`youtube`,`last_login`,`active`,`code`,`locked`,`date`) VALUES ( '$firstname', '$lastname', '$username', '$email', '$pass', '$avatar', '$bio', '$website', '$youtube', '', '0', '$code', '0', '$date')");

/*mysql_query("INSERT INTO users (Field, Type) VALUES ('', '$firstname', '$lastname', '$username', '$email', 'pass', '$avatar', '$bio', '$website', '$youtube', '', '0', '$code', '0', '$date')");*/

$webmaster = "Admin@trucksite.com";
$subject = "Activate Your Account!";
$headers = "From: Admin <$webmaster>";
$message = "Hello $firstname.\n\nWelcome to trucksite below is a link for you to activate your account!.\n http://tprofiletesting.net23.net/activate.php?code=$code";

mail($email, $subject, $message, $headers);
echo "Your activation email has been sent to <b>$email</b>.";
}
else
echo "That email is currently in use.";

}
else
echo "That username is currently in use.";
}
else
echo "You did not enter a vaild email.";
}
else
echo "Your passwords did not match.";
}
else
echo"You did not fill in all the required fields.";
}
echo "$form";


?>

</div>
<div id='homeleft'>
<center><font size='6'>Create! Showoff! Educate!</font></center>
<hr />

</div>
</body>
</html>

Howdy All i currently have Code: [Select]
<? echo $guild ['name'];?> and i want to put <> around what is shown from the $guild ['name'] , but where ever i try the <> it cancels out and just doesnt show the name any more - currently its making us do the following <-<? echo $guild ['name'];?>-> as even if we try an echo with jsut the < and > it cancels it out

Any specific way in which i can do this

thanks

i'm back again and i am not very good with tables as the <tr> and <td> tags confuse me 
i need to put 2 sets of links into 2 columns in the table and they come out jumbled up.

Code: [Select]
<table>
<tr>
<th>column 1</th>
<th>column 2</th>
</tr>
<?php

$sites = array_map('trim',file('websites.txt')); //read the whole file into an array & trim the newline character from the end of each line
foreach ($sites as $link) {
   echo "<tr><td><a href='$link'>$link</a></td>";
}


$sites = array_map('trim',file('websites2.txt')); //read the whole file into an array & trim the newline character from the end of each line
foreach ($sites as $link) {
   echo "<td><a href='$link'>$link</a></td></tr>";
}

?>

</table>