array of dates with query

Question

Hope someone can help me on this.

I have this code.

$calendar->highlighted_dates = Array('2016-12-03', '2016-12-14', '2016-12-25' );

With it, i can have the dates highlighted in a calendar.

I'm Trying to get the same thing with a query using this code

$sql = mysql_query("SELECT * FROM event Order by Date");
              while($row = mysql_fetch_array($sql)){
                $Date.= "'".$row["Date"]."'".", "; 
            }
$arrayb=array("$Date");
$calendar->highlighted_dates = $arrayb;

If i echo $Date i get

'2016-12-03', '2016-12-14', '2016-12-25',

But if i Print_r ($arrayb) i get

Array([0]=>'2016-12-03', '2016-12-14', '2016-12-25',)

And nothing on Calendar. I guess the problem is the [0]=>, but i don't know how to remove it.

Thanks.

Final Code as suggested by Mark Baker:

$link=   mysqli_connect("$host", "$username", "$password","$db_name")or die("cannot connect"); 
 $dateArray = array();
   $sql = mysqli_query($link, "SELECT * FROM event Order by Date");
            while($row = mysqli_fetch_array($sql)){ $dateArray[] = $row["Date"]; }
$calendar->highlighted_dates = $dateArray;

Don't build a string of dates and cast that to an array, because then you'll have a sinqle array entry containing a long string..... build the array of dates as you iterate through the query resultset.... $dateArray = array(); while($row = mysql_fetch_array($sql)){ $dateArray[] = $row["Date"]; } — Mark Baker
– Mark Baker, Commented Feb 20, 2016 at 19:44
And stop using the old, deprecated MySQL extension..... it's 2016 now, switch to using MySQLi or PDO — Mark Baker
– Mark Baker, Commented Feb 20, 2016 at 19:45

Funk Forty Niner · Accepted Answer · 2016-02-20 20:30:35Z

3

You need to change your code as @Mark Baker suggested:-

$Date = array(); 

while($row = mysqli_fetch_array($sql)){ 
   $Date[] = $row["Date"]; 
}

Now you will get $Date as Array('2016-12-03', '2016-12-14', '2016-12-25') what you want.

Note:- mysql_* is deprecated now, Use mysqli_* or PDO.

edited Feb 20, 2016 at 20:30

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Feb 20, 2016 at 19:50

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Devon Bessemer · Accepted Answer · 2016-02-20 19:48:10Z

1

You haven't created a 3 value array:

Array('2016-12-03', '2016-12-14', '2016-12-25' );

You've created a 1 value array:

Array("'2016-12-03', '2016-12-14', '2016-12-25'");

Notice the 3 strings versus 1 string.

edited Feb 20, 2016 at 19:48

answered Feb 20, 2016 at 19:45

Devon Bessemer

35.6k10 gold badges77 silver badges102 bronze badges

2 Comments

Mestre1966 Over a year ago

no, i have 3 strings separated by a comma. look - $Date.= "'".$row["Date"]."'".", ";

Devon Bessemer Over a year ago

No, you have 3 substrings connected by a comma, they are all concatenated into one string...

Collectives™ on Stack Overflow

array of dates with query

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related