[RESOLVED] Insert Information into an Array

aspekt9

Say I have an array like so:

$days = array(
        2=>array('/weblog/archive/2006/Dec/02','linked-day'),
        3=>array('/weblog/archive/2006/Dec/03','linked-day'),
        16=>array('/weblog/archive/2006/Dec/08','linked-day'),
        22=>array('/weblog/archive/2006/Dec/22','linked-day'),
		$today=>array(NULL,NULL,'<span style="color:red; font-weight:bold; font-size:12px;">'.$today.'</span>'),
    );

Is it possible for me to have a form for users to input a date and a link and weither its a linked-day or not and have it input it into the form above?

NogDog

It's certainly possible, but you'll need to store the data somewhere outside of the script: either in a database (best) or some sort of file (perhaps a CSV file?).

aspekt9

Well I have all the information into the database and the form to put the data into the database but what would it looks like inserting it into the array?

leatherback

How do you get the array above filled? you'd do it exactly the same:

$query= // some query
$result=mysql_query($query);
if($result)
  {
  while($row = mysql_fetch_array($query))
    {
     $array[$row['id']] = $row['label'];
    ]
  }

aspekt9

Can you explain to me how that exactly works. Arrays are my weakness right now. Can you present an example that pertains to something similar that I'm trying to accomplish? Or provide me with some kind of source I can read about how to input data from mysql into arrays. Thank you for the help.

leatherback

Ok, you first set your query, and push that to mysql. i assume you know how to do that. From there:

// define an array. not required, but good programming practice:
$myarray = array();

// While there are results, you retrieve them from the database, and retain them in the associate array '$row'

if($result)
  {
  while($row = mysql_fetch_array($query))
    { 
    // Now we do the magic: Either fill the array, without defining the key, which will then be 0 => number of values-1:
   $myarray[] = $row'SiomeColum'];

// Or use the ID colum to define the KEY of the array:   
$myarray[$row['ID']] = $row'SiomeColum'];

   // End the for loop
   }

// show the structure & values of the array, for debugging:
print_r($myarray);

aspekt9

Awesome, that explained a lot for me, thank you. So here's my updated code:

<?php
include 'config.php';
$result = mysql_query("SELECT day,link,eventday FROM calendar");
// define an array. not required, but good programming practice:
$myarray = array();
// While there are results, you retrieve them from the database, and retain them in the associate array '$row'
if($result)
  {
  while($row = mysql_fetch_array($result))
    {
    // Now we do the magic: Either fill the array, without defining the key, which will then be 0 => number of values-1:
   // $myarray[] = $row['day'];

// Or use the ID colum to define the KEY of the array:   
$myarray[$row['day']] = "array('".$row['link']."','".$row['eventday']."'),<br />";

   // End the for loop
   }
}
// show the structure & values of the array, for debugging:
print_r($myarray); 
?>

And it outputs:

Array ( [20] => array('testnow','linked-day'),
[23] => array('test3','linked-day'),
[2] => array('gdde','linked-day'),
[30] => array('asdf','linked-day'),
[19] => array('awerwsd','linked-day'),
)

So it's starting to look like:

$days = array(
        2=>array('/weblog/archive/2006/Dec/02','linked-day'),
        3=>array('/weblog/archive/2006/Dec/03','linked-day'),
        16=>array('/weblog/archive/2006/Dec/08','linked-day'),
        22=>array('/weblog/archive/2006/Dec/22','linked-day'),
		$today=>array(NULL,NULL,'<span style="color:red; font-weight:bold; font-size:12px;">'.$today.'</span>'),
    );

But now how can I get the first numbers like [23] => out of the brackets to make it look like the $days array? As well as add a semicolon at the end after the )?

leatherback

Dare I ask what you are trying to do?

=> you cannot remote the brackets, as they are part of the key identifier in the print_r() statement.

=> you should not need th semicolon, unless you want to write it to file and read it in again as a variable or something.

An explanation of whatyou are tryin to achieve might help explain better how to get cracking on it

aspekt9

It's for a calendar it's how you link events to certain days. The links are the pages linked to that specific day and linked-day just designates that it's a linked day and applies a style to the number (makes the day number blue and bold and linked). The numbers like 22=>array('/blahblah/blah','linked-day'), represent the day. I want to link these to the database so it retreives the day and sets the link and 'linked-day' for all the days in the database.

This is what I currently use and I have to input it manually:

$days = array(
        2=>array('/weblog/archive/2006/Dec/02','linked-day'),
        3=>array('/weblog/archive/2006/Dec/03','linked-day'),
        16=>array('/weblog/archive/2006/Dec/08','linked-day'),
        22=>array('/weblog/archive/2006/Dec/22','linked-day'),
        $today=>array(NULL,NULL,'<span style="color:red; font-weight:bold; font-size:12px;">'.$today.'</span>'),
    );

It's Keith Deven's calendar

leatherback

Hi,

Have you tried feeding the generate darray to the calender? I think you should not 'stare yourself to death' on the way an array is coded when filling the variable:
You need an array with a KEY ( Nr 23) and a value, which in turn again is an aray with two values ('/weblog/archive/2006/Dec/02' and 'linked-day'). That is what the code is generating. When you print_r it, you get some way of displaying it. Filling a variabe with it in code is a different way, and will look different. The internal structure is the same.

aspekt9

I just tried to input it exactly how I had it and generate it. I don't receive any errors, but it doesn't link the days or show any days as being 'linked-days'

leatherback

🙂 Looks like you are using the same calender generator I have used before; This is how I fill it:

$allmessages = mysql_query("select *, DATE_FORMAT(L_date, '%M %d, %Y %h:%m:%s') as 
            date,  DATE_FORMAT(L_date, '%c') as month,  DATE_FORMAT(L_date, '%d') as day from $weblogitems_table order by date desc") or die(mysql_error());
        if($allmessages)
          {
          $days = array();
          while($row = mysql_fetch_array($allmessages))
            {
            if($row['month'] == $month)
              {
              $day = $row[day];
              $days[$day] = array('index.php?link_to='.$row[L_id], 'linked-day');
              }
           }
        }

// and further down:

$days[$today] = array(NULL,NULL,'<span style="color: green; font-weight: bold;">'.$today.'</span>');
$rightcontent= generate_calendar(date('Y', $time), date('n', $time), $days,2);

aspekt9

That's awesome, I can understand this now. I'm a bit confused on the query can you elaborate some more on it? Also what fields do you have in your table that you read from?

Thanks again for the help

leatherback

select *
= Select all colum
, DATE_FORMAT(L_date, '%M %d, %Y %h:%m:%s') as
date,
= Format the date columN IN A SPECIFIC FORM (Check the date format codes on the mysql website for options), and name this 'date'

DATE_FORMAT(L_date, '%c') as month, DATE_FORMAT(L_date, '%d') as day
= format the date colum, show only the day, and name this day

from $weblogitems_table
Select this from the table which name I have stored in variable $weblogitems_table

order by date desc"
Sort the output by date, and sort descending.

CREATE TABLE w_items (
  N_id mediumint(9) NOT NULL auto_increment,
  N_title mediumtext NOT NULL,
  N_content mediumtext NOT NULL,
  N_date timestamp(14) NOT NULL,
  PRIMARY KEY  (N_id)
) TYPE=MyISAM;

// ps: Horribly hyjacked & malfunctioning dates (The month / year do not work: You may need to adjust the query to get the actual current month out or something.. My dates just keep messing up). But in that state in my poorly maintained site (Too much actual work to do, with moving between jobs & continents all the time): http://www.bio-vision.nl/weblog/index.php

aspekt9

I got it all working now 🙂 I set $month equal to the current month, using PHP's lovely date function. I then changed a little bit around in the query to make it all tidy and for a final result I have:

$time = time();
$today = date('j',$time);
$month = date('n');
	$allmessages = mysql_query("SELECT *, DATE_FORMAT(date, '%M %e, %Y %h:%m:%s') as
            date,  DATE_FORMAT(date, '%c') as month,  DATE_FORMAT(date, '%e') as day FROM calevents order by date desc") or die(mysql_error());

		echo $row[month];
    if($allmessages)
      {
      $days = array();
      while($row = mysql_fetch_array($allmessages))
        {
        if($row['month'] == $month)
          {
          $day = $row[day];
          $days[$day] = array('events.php?id='.$row[id], 'linked-day');
          }
       }
    }	
$days[$today] = array(NULL,NULL,'<span style="color: red; font-weight: bold;">'.$today.'</span>');
echo generate_calendar(date('Y', $time), date('n', $time), $days,3);

All works great, thank you very much for walking me through this all I've learned a lot in such a little time span.