PHP - Moved: Mysql - Creating Sequential Column Names

This topic has been moved to Third Party PHP Scripts.

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

This topic has been moved to Third Party PHP Scripts.

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

Hi.

The idea:

I want to pull a client record and simply place all the row columns into editable form field text boxes. Once the user reviews and edits a submit button will update the record.

What I have:

Code: [Select]
$Query01 = "SELECT * FROM `CustomerSignups`
WHERE `Id` = '$_GET[Id]'";
$Result01 = mysql_query($Query01) or die("Error 01: " . mysql_error());

while ($get_info = mysql_fetch_row($Result01))
{
foreach ($get_info as $field)
echo "<p>$field</p>";

It displays as expected, a line for each field.

How can I get this to pull the field names also and then I can use those as text box input fields...?

I need to update a particular table and there be a whole lot of field names. I'd like to do it without having to use them the same way you can access then like $row[12] after a "select" query. The standard for updating (at least how I write it) goes like this ...
Code: [Select]
$query = "UPDATE linguistics SET welcome1='$var3', welcome2='$var4' WHERE language = '$lengua'";
Well, I'd like to do it where I don't have to name welcome1 and welcome2, but instead refer to their numerical position within the database. On a "select" query we can do this. Can this be done on an update? Something perhaps like ...
Code: [Select]
$query = "UPDATE linguistics SET 3='$var3', 4='$var4' WHERE language = '$lengua'";
... where 3 and 4 represent the 4th and 5th fields respectively. I know that this particular phrasing doesn't work because I've tried it, but surely there has to be something. This will save me LOTS of time. Thanks!!

This topic has been moved to MySQL Help.

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

This topic has been moved to Ajax Help.

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

I can get files to  upload to folder and add a new row for each in to a mysql db using the code below, how do I get all the filles in one row with multiple uploads

Code: [Select]
//Check if the form was submitted.
if(isset($_POST['uploadButton'])) {
  //Specify folder path where the file is going.
  $path = 'uploads/';

  //Upload file one by one.
  foreach($_FILES['file']['name'] as $key => $val) {
    if($val != '') {
      $file_name = $_FILES['file']['name'][$key]; //Get file name.
      $file_tmp  = $_FILES['file']['tmp_name'][$key]; //Get temporary file name.
      $file = $path . $file_name;
      mysql_query("INSERT INTO images (img1) VALUES('$file');") or trigger_error('Unable to INsert: ' . mysql_error());
   




 
      //Move uploaded file
      if(move_uploaded_file($file_tmp, $file)) {
        echo 'File was succesfully uploaded to: ' . $file . '<br />';
      } else {
        //Display error message if there was a problem uploading file.
        echo 'Error uploading file "' . $key . '."<br />';
      }
echo $target_path;


        }
     }
  }

?>

I currently have php code that outputs information from my database, but how do i make it also display the name of the fields beside each entry of the database?

heres my PHP code:
Code: [Select]
<?php

$server = "";      // Enter your MYSQL server name/address between quotes
$username = "";    // Your MYSQL username between quotes
$password = "";    // Your MYSQL password between quotes
$database = "";    // Your MYSQL database between quotes

$con = mysql_connect($server, $username, $password);       // Connect to the database
if(!$con) { die('Could not connect: ' . mysql_error()); }  // If connection failed, stop and display error
mysql_select_db($database, $con);  // Select database to use
// Query database
$result = mysql_query("SELECT * FROM Properties");

if (!$result)
{
    echo "Error running query:<br>";
    trigger_error(mysql_error());
}
elseif(!mysql_num_rows($result))
{
    // no records found by query.
    echo "No records found";
}
else
{
    $i = 0;
    echo '<div style="font-family:helvetica; font-size:15px; padding-left:15px; padding-top:20px;">';
    while($row = mysql_fetch_array($result)) {     // Loop through results
        $i++;
         echo '<img class="image1" src="'. $row['images'] .'" />';   //image
        echo "Displaying record $i<br>\n";
        echo "<b>" . $row['id'] . "</b><br>\n";      // Where 'id' is the column/field title in the database
        echo $row['Location'] . "<br>\n";            // Where 'location' is the column/field title in the database
        echo $row['Property_type'] . "<br>\n";       // as above
        echo $row['Number_of_bedrooms'] . "<br>\n";  // ..
        echo $row['Purchase_type'] . "<br>\n";       // ..
        echo $row['Price_range'] . "<br>\n";         // ..
    }
echo '</div>';
}

mysql_close($con);  // Close the connection to the database after results, not before.
?>



thanks in advance

I am using this sql to filter records :

$query = "select * from mobileprices where range='5000'"()
 but i am getting this error message :
mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/dracra/public_html/a.com/range.php

range field contains product prices range and filled with 5000, 10000, 15000, 20000 etc.
I tried the following code to update the range values from numeric to text in phpmyadmin sql area :

Code: [Select]
UPDATE mobileprices
SET range='five'
WHERE range='5000'
but i am getting this error message :

#1064 - 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 'range='five' WHERE range='5000'' at line 2

I am confused as there are thousands of records and manually updating it one by one will take so much time.
Anyone could help me out as how i can change numeric with text in range.

or there is any way by that sql could accept this :

$query = "select * from mobileprices where range='5000'"()

I need a solution, so please help me !!

Hi all,

I have the following MySQL insert query:
Code: [Select]
$insert= mysql_query   ("INSERT INTO tablename (column1,`".$EXPfields."`) VALUES ('$something','".$EXPvalues."')");
where $EXPfields is an array of table-field-names and $EXPvalues is an array of table-field-values.

Now I want to write an equivalent query, but using UPDATE instead of INSERT INTO, but I don't want to write out all the field names/values separately, but again want to use $EXPfields and $EXPvalues.

So something like this:
Code: [Select]
$update = mysql_query ("UPDATE tablename
                     SET (column1,`".$EXPfields."`) = ('$something','".$EXPvalues."')
                     WHERE ....
                  ");

Is this possible? If so, what is the proper syntax? Thanks!

Hi,

I have downloads that are available for users. They can click the links to download the file. Once they do this, I have a query that updates the number of downloads that file has received. I need to create a query that adds up all the rows Total Downloads.

So for example: i have 3 rows:
Name       -       Total Downloads
First       -          2
Second       -        23
Third       -          7

Using the query for these rows would give me an amount of 32.

Any idea how to do this?

I don't want to have to create a new column to find the total number of downloads. Any other ways?

In querying my database, I'm Selecting nameFirst and nameLast, and it produces a name like Joe Smith.  I'm trying to match a photo with the name.  Right now I'm uploading photos into a folder naming the file (e.g. SmithJoe.jpg). 

For reasons that involve writers being able to upload and access photos, I'm trying to use an image plugin.  When uploading photos, it strips capital letters, so SmithJoe,jpg goes in as smithjoe.jpg, and it's not matching my database query. 

Here is the code I'm working with that works quite well with this one exception:


$query = 'SELECT * FROM wp_playerRank';
$results = mysql_query($query);
while($line = mysql_fetch_assoc($results)) {

if ($line['wpID'] == $wp_tagID)  {

echo '<div class="player">';


// Here is the code that produces the image.  I need to get rid of capital letters for ease of use

echo '<div><img src="/wp-content/uploads/' . $line['nameLast'] . $line['nameFirst'] . '.jpg"></div>';



echo '<div class="playerData">' . $line['height'] . ' ';
if ($line['position'] == 'PG')  {echo 'Point Guard';}
elseif ($line['position'] == 'SG')  {echo 'Shooting Guard';}
elseif ($line['position'] == 'SF')  {echo 'Small Forward';}
elseif ($line['position'] == 'PF')  {echo 'Power Forward';}
elseif ($line['position'] == 'C')  {echo 'Center';}
echo '</div>';
echo '<div class="playerData">' . $line['hschool'] . '</div>';
echo '<div class="playerData">' . $line['summer'] . '</div>';
echo '<div class="playerData">Class of ' .$line['year'] . '</div>';

if ($line['committed'] == 'y') {
echo '<div>
<br>Committed to <strong>'. $line['college'] . '</strong></div>
';}

}
}

I am writing a small program that generates a sequential numbering array. I need to include potentially a prefix, leading zeros, a starting number, a suffix and a quantity and also reverse the generated values.

example:
P-000299-001
P-000298-001
P-000297-001
P-000296-001
P-000295-001
P-000294-001
P-000293-001
P-000292-001
P-000291-001
P-000290-001
P-000289-001

Here is my code to generate:

<?php
$quantity = "100";
$start = "200";
$leadingzeros = "000";
$prefix = "P-";
$suffix = "-001";

$i = $start + $quantity - 1;

while ($i >= $start)
{
echo $prefix . $leadingzeros . $i-- . $suffix . "<br />\n";
}
?>


The code all seem to function correctly until I increase the quantity to say 25000 numbers to be generated or if the number string gets too long and the server will just sit and spin until a "cannot be displayed error" appears in IE.


It had been suggested to abandone the array and simply write the generated sequence to a file and this is the code to generated the file it  - it really works great and is really fast.

<?php
$startTime = time(); // this is just for measuring execution time

$quantity = "25000";
$start = "26000";
$length = 6;
$prefix = "P-";
$suffix = "-001";

$file = "test.txt";

$fh = fopen($file, 'w') or die("Could not open $file for writing");
for($ix = 1, $nbr = $start; $ix <= $quantity; $ix++, $nbr--)
{
   fprintf($fh, $prefix.'%0'.$length.'d'.$suffix."\n", $nbr);
}

// all done, let's see how long it took:
$endTime = time();
echo "Script took about " . ($endTime - $startTime) . " seconds to run.";
?>



I am using this program to generate numbering files used in the printing industry. The sequential numbering works great.

I had to change your code slightly in order to produce a usable numbering file, I had to subtract "1" from the $start+$quantity in order to get the correct amount of numbers. For a start of 1000 and quantity of 10 you had 1010 as your first number and it should actually be 1009 to give you 10 numbers.

$fh = fopen($file, 'w') or die("Could not open $file for writing");
for($ix = 1, $nbr = $start+$quantity-1; $ix <= $quantity; $ix++, $nbr--)

P-001009-001
P-001008-001
P-001007-001
P-001006-001
P-001005-001
P-001004-001
P-001003-001
P-001002-001
P-001001-001
P-001000-001

Let's think of this as an 8.5" x 11" piece of paper going through a laser printer - if each page had one number on it the sequential number will be great.

Anyway, here is the next challenge: Let's say we have one 5.5" x 8.5" on an 8.5" x 11" sheet twice or two up. Each with its own number on the left and right side of the paper. That after printing will be cut and stacked on top of one another and produce a pile that is still in the right order. We need to take the $quantity+$start-1 and divide by 2 and then interleave the two sets of numbers and stop the numbering set at the starting number. easy huh!!!

P-001009-001
P-001004-001
P-001008-001
P-001003-001
P-001007-001
P-001002-001
P-001006-001
P-001001-001
P-001005-001
P-001000-001

Here is the code I have for an example:

<?php
$quantity = "10";
$start = "1000";
$leadingzeros = "00";
$prefix = "P-";
$suffix = "-001";

$i = $start + $quantity - 1;
$quantity2 = $quantity / 2;
$j = (int)($i - $quantity2);

while ($j >= $start)
{
echo $prefix . $leadingzeros . $i-- . $suffix ."<br />\n" . $prefix . $leadingzeros . $j-- . $suffix . "<br />\n";



}
?>

The third option is two completely different 5.5" x 8.5" items and two different numbering schemes on an 8.5" x 11" piece of paper.

Here is the code I have been using for it.

<?php
$quantity = "10";
$start = "1000";
$leadingzeros = "00";
$prefix = "P-";
$suffix = "-001";

$quantity2 = "10";
$start2 = "2000";
$leadingzeros2 = "000";
$prefix2 = "Q-";
$suffix2 = "-005";

$i = $start + $quantity - 1;
$k = $start2 + $quantity2 - 1;

while ($i >= $start)
{
echo $prefix . $leadingzeros . $i-- . $suffix . "<br />\n" .$prefix2. $leadingzeros2 . $k-- . $suffix2 . "<br />\n";
}
?>


Which produces:
P-001009-001
Q-0002009-005
P-001008-001
Q-0002008-005
P-001007-001
Q-0002007-005
P-001006-001
Q-0002006-005
P-001005-001
Q-0002005-005
P-001004-001
Q-0002004-005
P-001003-001
Q-0002003-005
P-001002-001
Q-0002002-005
P-001001-001
Q-0002001-005
P-001000-001
Q-0002000-005


Thanks in advance

Hi everyone reading this,

I have used PHP before as a hobby programmer but recently my boss asked me to make a webpage to accept worker's hours and store them in a database. So I realize that in the last few years object oriented style has been added into PHP. I have learnt OOP (C++) about a decade ago and understand the fundamentals of it.

If I am writing this website code, am I going to be better off spending the time to get familiar with the new OOP stuff in PHP and use that or would it be better to just use an old sequential style of programming? I know this may seem like apples and oranges and that it varies based on opinion, but maybe there can be reasons for me to use OOP over sequential.

For instance, if I write this code to be flexible enough that I can do a basic "worker times" table first, then I might be able to add additional functionality later, like worker details and qualifications, all of which could be brought up with the click of a button. Will it generally be easier to add onto code using OOP?

I have a table with an ID column which is the Primary key and auto incremented. I have another column named ORDER that contains a number.  This number is used to define the order in which the row data is displayed on a page.

When I delete a row, the ORDER column will have a gap and I would like to renumber the subsequent rows to remove the gap. ie:

I want to renumber the rows:
ID  ORDER
1    1
2    2
4    3
5    4

When I insert a new row I want the ORDER row to be given the NEXT sequential number

How do I do that using PHP PDO?

Thanks