PHP - Php Mysql - How To Alternate Table Row Colors?

Hello everyone,

Sorry if this has been answered but if it has I can't find it anywhere. So, from the begining then.  Lets say I had a member table and in it I wanted to store what their top 3 interests are.  Their$ row has all the usual things to identify them userID and password etc.. and I had a further 3 columns which were labled top3_1 top3_2 & top3_3 to put each of their interests in from a post form.

If instead I wanted to store this data as a PHP Array instead (using 1 column instead of 3) is there a way to store it as readable data when you open the PHPmyadmin?

At the moment all it says is array and when I call it back to the browser (say on a page where they could review and update their interests) it displays 'a' as top3_01 'r' as top3_02 and 'r' as top3_03 (in each putting what would be 'array' as it appears in the table if there were 5 results. Does anyone know what I mean?

For example -

If we had a form which collected the top 3 interests to put in a table called users,

Code: [Select]
<form action="back_to_same_page_for_processing.php" method="post" enctype="multipart/form-data">
   
    <input name="top3_01" type="text" value="enter interest number 1 here" />
    <input name="top3_02" type="text" value="enter interest number 2 here" />
    <input name="top3_03" type="text" value="enter interest number 3 here" />
    <input type="submit" name="update_button" value=" Save and Update! " />

   
    </form> // If my quick code example for this form is not correct dont worry its not the point im getting at :)
And they put 'bowling' in top3_01, 'running' in top3_02 and 'diving' in top3_03 and we catch that on the same page with some PHP at the top -->

Code: [Select]
        if (isset($_POST)['update_button']) {
   
    $top3_01 = $_POST['top3_01']; // i.e, 'bowling' changing POST vars to local vars
    $top3_02 = $_POST['top3_02']; // i.e, 'running'
    $top3_03 = $_POST['top3_03']; // i.e, 'diving'

With me so far? If I had a table which had 3 columns (1 for each interest) I could put something like -

  Code: [Select]
   include('connect_msql.php');
   
    mysql_query("Select * FROM users WHERE id='$id' AND blah blah blah");
   
    mysql_query("UPDATE users SET top3_01='$top3_01', top3_02='$top3_02', top3_03='$top3_03' WHERE id='$id'");


And hopefully if ive got it right, it will put them each in their own little column. Easy enough huh? But heres the thing, I want to put all these into an array to be stored in the 1 column (say called 'top3') and whats more have them clearly readable in PHPmyadmin and editable from there yet still be able to be called back an rendered on page when requested.

Continuing the example then, assuming ive changed the table for the 'top3' column instead of individual colums,  I could put something like this -


Code: [Select]
            if (isset($_POST)['update_button']) {
       
        $top3_01 = $_POST['top3_01']; // i.e, 'bowling' changing POST vars to local vars
        $top3_02 = $_POST['top3_02']; // i.e, 'running'
        $top3_03 = $_POST['top3_03']; // i.e, 'diving'
   
    $top3_array = array($top3_01,$top3_02,$top3_03);
   
    include('connect_msql.php');
   
    mysql_query("UPDATE members SET top3='$top3_array' WHERE id='$id' AND blah blah blah");
But it will appear in the column as 'Array' and when its called for using a query it will render the literal string. a r r in each field instead.  Now I know you can use the 'serialize()' & 'unserialize()' funtcions but it makes the entry in the database practically unreadable. Is there a way to make it readable and editable without having to create a content management system?

If so please let me know and I'll be your friend forever, lol, ok maybe not but I'd really appreciate the help anyways.  The other thing is, If you can do this or something like it, how am I to add entries to that array to go back into the data base?

I hope ive explained myself enough here, but if not say so and I'll have another go.  Thanks very much people,  L-PLate (P.s if I sort this out on my own ill post it all here)

I know I'm doing it something right, but can someone tell me why only one table is showing up? Can you help me fix the issue?

Heres my code:


function showcoords()
{
echo"J3st3r's CoordVision";
$result=dbquery("SELECT alliance, region, coordx, coordy FROM ".DB_COORDFUSION."");
dbarray($result);
$fields_num = mysql_num_fields($result);

echo "<table border='1'>";
// printing table headers


    echo "<td>Alliance</td>";
    echo "<td>Region</td>";
    echo "<td>Coord</td>";


// printing table rows
while($row = mysql_fetch_array($result))
{
    

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row AS $Cell)
     echo "<tr>";     
     echo "<td>".$row['alliance']."</td>\n";
     echo "<td>".$row['region']."</td>\n";
     echo "<td>".$row['coordx'].",".$row['coordy']."</td>\n";
     echo "</tr>\n";
    
}
echo "</table>";
mysql_free_result($result);

}



I have 2 rows inserted into my coords table. Just frustrated and ignorant to php.

Hi guys i need a little help to list data in different coloured rows

i need to list 1st name in <td class="alt1"> 2nd name in <td class="alt2"> and so on
currently it is listing only in <td class="alt1">

here is my code any help really appreciated

[php]<?php
   
$result[0] = mysql_query("SELECT * FROM videos ORDER BY viewtoday
DESC LIMIT 10");
   
   for($i=0;$i<count($result);$i++) {
      echo '';
      while($row=mysql_fetch_array($result[$i])) {
         $id = $row['id'];
         $cat = $row['cat'];
         $title = $row['title'];
         $numviews = $row['viewtoday'];
   
$max_length = 25;
$title = ( strlen($title) > $max_length ?
substr($title,0,$max_length)."..." : $title );


echo '<table class="listOfShows listOfShowsFirst"><tr>
<td class="alt1">
            <a href="videos.php?id=' . $id . '">'. $title . '</a>   </td>
      </tr>';

}

}

?>      
      </table></td></table>/php]

I've been using php's strstr() function to find data before an @ character in a string. Work fine for my local ide. I just uploaded all my files to a host to start debugging emails and it came to my attention that my hosting environment is running version 5.2.9 and strstr() isn't fully supported.

Heres a bit of code from the manual to show i'm talking about

Code: [Select]
<?php
$email  = 'name@example.com';
$domain = strstr($email, '@');
echo $domain; // prints @example.com

$user = strstr($email, '@', true); // As of PHP 5.3.0 <-- 
echo $user; // prints name
?>


I can't use the third argument apparently. Is there another way to go about doing this?

I have a table like this:
http://empirebuildingsestate.com/company.html

How can I separate the table values into variables so I can insert them into my mySQL database?
I have been trying DOMDocument but i need some help.

Hi all, i want delete old updated images with considering its index in array.

<?php
global $oldimg;
$oldimg = array();
//action: edit news
if (isset($_GET['id'])) {

$NewsID = (int)$_GET['id'];

if ($NewsID == 0) {

$rdir = '<META HTTP-EQUIV="Refresh" CONTENT="1.4;URL=panel-news.php">';

die($rdir);}

//get user from the database and put data into $_POST variables.

//Include database connection details

require_once('../config.php');

//Connect to mysql server

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

if(!$link) {

 die('Failed to connect to server: ' . mysql_error());

}

//Select database

 $db = mysql_select_db(DB_DATABASE);

 if(!$db) {

die("Unable to select database");

  

  }

$rs = mysql_query("SELECT  newsimg1, newsimg2, ".
    " newsimg3 FROM news WHERE id = $NewsID");
if (mysql_num_rows($rs) == 0) die('no such a  newsID!');

$row = mysql_fetch_assoc($rs);

$oldimg[0] = $row['newsimg1'];

$oldimg[1] = $row['newsimg2'];

$oldimg[2] = $row['newsimg3'];
}
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>"
             enctype="multipart/form-data">
                <input type=file name="file[]" size=20 
                accept="image/jpg,image/jpeg,image/png">
                <input type=file name="file[]" size=20 
                accept="image/jpg,image/jpeg,image/png">
                <input type=file name="file[]" size=20 
                accept="image/jpg,image/jpeg,image/png">
                <input type="hidden" name="MAX_FILE_SIZE" value="2097152" />
                <input type="hidden" name="NewsID" 
                value='<?php echo (isset($NewsID))?$NewsID:"0";?>'>

<input type="submit" value="edit" id="save"  name="save"/>

</form>
            <?php

if (isset($_POST['save']) && isset($_POST['NewsID'])){

$NewsID = (int)$_POST['NewsID'];

  //Include database connection details

  require_once('../config.php');

  //Connect to mysql server

  $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

  if(!$link) {

   die('Failed to connect to server: ' . mysql_error());

  }

  //Select database

  $db = mysql_select_db(DB_DATABASE);

  if(!$db) {

  die("Unable to select database");

}

  //max fle size value

  $max_file_size = 2097152;

  //Global newsimg

  global $newsimg;global $ctr;

  $ctr = 0;

  //timestamp to make files unique names

  $timestamp = time();

  //destination folder path

  $destpath = "../Dir/Newsimg/";

  //looping each file or image from the form

  while(list($key,$value) = @each($_FILES["file"]["name"])) {

  //check if any empty or errors

  if(!empty($value)){

  if ($_FILES["file"]["error"][$key] > 0) {

  $edir ='<div id="fail" class="info_div">';

  $edir .='<span class="ico_cancel"><strong>';

  $edir .="err : ".  $_FILES["file"]["error"][$key]  .'</strong></span></div>';

  echo($edir);

  } else {

  //add the timestamp to filename

  $file_name = $timestamp.$_FILES['file']['name'];

  //temp name from upload form,  key of each is set

  $source = $_FILES["file"]["tmp_name"][$key] ;

  //getting the file type

  $file_type = $_FILES["file"]["type"][$key];

  //placing each file name into a variable

  $filename1 = $_FILES["file"]["name"][$key];

  //lowering the file names

  $filename = strtolower($filename1);

  //adding timestamp to front of file name

  $filename = "$timestamp$filename";

  ++$timestamp;

  if ($file_type != "image/jpeg" && $file_type != "image/png" && $file_type != "image/jpg") {

die("

<div id='fail' class='info_div'>

<span class='ico_cancel'><strong>

Invalid Format!</strong></span><br />

<a href=\"javascript: history.go(-1)\">Retry</a>

</div>"); }

 //moving the file to be saved from the temp location to the destination path

  move_uploaded_file($source, $destpath . $filename);

  //the actual final location with timestamped name

  $final_file_location = "$destpath$filename";

  if (file_exists($final_file_location)) {

  if (isset($oldimg[$ctr])) {

  chdir('../Dir/Newsimg/');

  echo $oldimg[$ctr];

  unlink($oldimg[$ctr]);}

  $newsimg[$ctr] = $filename;

  $ctr++;

  
?>TNX.

Hi all,

    I am still learning all the variations of code commonly used with sites. I have one particular issue of which I am having trouble locating an answer or returning a proper result.  I want to be able to use one page to query a distinct date, say 1-1-11 and the results return with the other columns matching this date and separating the time to be displayed for the entry row. So it would look something like this in the results.

Acct: Tester User: John.Smith Time: 1:30 PM

Currently there are 4 columns to the table, ID, Acct, Logintime, User.  I have tried splitting this off the table but that fails out, unless someone knows an insert command to enter date and time individually. This would make it much easier for my purposes as well.

Below is one of the many codes I have tried for this from examples.

<?php
$con = mysql_connect("localhost","gram","compassion");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("tester", $con);

$result = mysql_query("SELECT * FROM test_history");

echo "<table border='1'>
<tr>
<th>Date:</th>
<th>Time:</th>
</tr>";

while($row = mysql_fetch_array($result))
  (explode(" ",$row['logintime']));
  echo $row[0];
  echo $row[1];

  {
  echo "<tr>";
  echo "<td>" . $row[0] . "</td>";
  echo "<td>" . $row[1] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>


I know I am newb but I am a fast learner if I can merely get some points in the right direction.

Without using FFMPEG that is, since my host refuses to allow it. I really don't want to change hosts just for this one thing, I'm happy otherwise, but I need this work.

I just need to grab a frame from a video when the user uploads the video. I can't use FFMPEG like I said, but I saw a suggestion someone had that said "have PHP open the video in fullscreen and take a screencap". That would work perfectly, I just have not a CLUE how to do it.

Does anyone have experience doing this? I just want it to grab a screenshot and have it saved as a jpg with the same filename as the video, for obvious reasons...call the video player and pass it the filename with a .jpg attached for the screenshot param.

Any help is appreciated! Thanks.

This topic has been moved to JavaScript Help.

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

Can anyone provide a snip of code that I could insert into the "coupon code" field on a formmail form which has the following effect:

on submit form, user goes to the normal payment page (this is already implemented)
if coupon code field is filled out with correct code, user is taken to alternate payment page on form submit.

Either this or another approach which has the same result is OK. I am a novice coder working in a wysiwyg - I don't REALLY know php at all - I just need a snip I can insert and a clear instruction.

Thanks so much for any help.

Hello,

So I need a bit of help with tables. I currently have my website set up with the following tables:

products (productId, productName, link, productPrice, productDesc)

productscents (scentId, scentName, scentDesc)

salves (productId, productName, productDesc)


So now most products in the products table can be made in any of the scents in the productScents table (except for the salves and reed diffuser jar).  I have a separate table of the salve types that can be ordered. How do I join each product with each productScent.

For example:

If I have the following products with their Id number:
1 Body Mist
2 Massage Oil
3 Reed Diffuser Jar


and the following scents with their id (id has leading zeros):
0001 Mango
0002 Passionfruit
0003 Grapefruit

How would I create a master products table that will display the following:
3        Reed Diffuser Jar
10001 Mango Body Mist
10002 Passionfruit Body Mist
10003 Grapefruit Body Mist
20001 Mango Massage Oil
20002 Passionfruit Massage Oil
20003 Grapefruit Massage Oil


I hope this makes sense. lol.

Any help would be greatly appreciated.

Hi

$eid2 = mysql_query("SELECT id FROM engines WHERE keyword = '%$tricker_engine%' LIMIT 1") or die(mysql_error());
$row = mysql_fetch_assoc($eid2);
$eid = $row['id'];

I want $eid to be the ID of the row where keyword = '%$tricker_engine%'.

What is wrong with my code above?

Hi,

I don know how to explain this in words too well, so i have create 2 images to show what I need.

What I need to do is use whats in the first image (table.jpg)(the database) to create whats in the second image (dropdown.jpg)(the drop-down menu)

The results of the form will be entered into the database.  category_id will be the value thats inserted.

Many kind regards

Eoin





[attachment deleted by admin]

Hi,   The following code was written by someone else. It allows me to upload images to a directory while saving image name in the mysql table.   I also want the code to allow me save other data (surname, first name) along with the image name into the table, but my try is not working, only the images get uploaded.   What am I missing here?

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

$path=$path.$_FILES['file_upload']['name'];

if(move_uploaded_file($_FILES['file_upload']['tmp_name'],$path))
{
echo " ".basename($_FILES['file_upload']['name'])." has been uploaded<br/>";
echo '<img src="gallery/'.$_FILES['file_upload']['name'].'" width="48" height="48"/>';
$img=$_FILES['file_upload']['name'];
$query="insert into imgtables (fname,imgurl,date) values('$fname',STR_TO_DATE('$dateofbirth','%d-%m-%y'),'$img',now())";
if($sp->query($query)){
echo "<br/>Inserted to DB also"; 
}else{
echo "Error <br/>".$sp->error; 
}
}
else
{
echo "There is an error,please retry or check path";
}
}

?>

joseph

Greetings,   My current code logs into a database, opens a table named randomproverb, randomly selects 1 proverb phrase, and then SHOULD display the proverb in the footer of my web page. As of right now, the best I can do is get it to display "Array", but not the text proverb... this code below actually causes my whole footer to not even show up. Please help!

<?php

include("inc_connect.php"); //Connects to the database, does work properly, already tested

$Proverb = "randomproverb";
$SQLproverb = "SELECT * FROM $Proverb ORDER BY RAND() LIMIT 1";
$QueryResult = @mysql_query($SQLproverb, $DBConnect);
	while (($Row = mysql_fetch_assoc($QueryResult)) !== FALSE) {
	echo "<p style = 'text-align:center'>" . {$Row[proverb]} . "</p>\n";
	}
	$SQLString = "UPDATE randomproverb SET display_count = display_count + 1 WHERE proverb = $QueryResult[]";
	$QueryResult = @mysql_query($SQLstring, $DBConnect);
...
?>