Learn VBA & Macros in 1 Week!

PHP - Display Existing Database Where I Can Edit In Html

Full Excel VBA Course - Beginner to Expert

Display Existing Database Where I Can Edit In Html	View Content

// user edit
 	$('body').on('click', '.username-edit', function() {

    	$('#modal').html(' ');

 		var output = '<div class="modal-content"><h5><?php echo lang::get("Change password")?></h5><hr />';
 		output += '<h5><?php echo lang::get("New password:")?></h5><input type="password" name="password" id="password" value="" class="text ui-widget-content ui-corner-all" />';
 		output += '<h5><?php echo lang::get("Confirm password:")?></h5><input type="password" name="password2" id="password2" value="" class="text ui-widget-content ui-corner-all" />';

 		output += '</div>';

 		output += '<div class="modal-buttons right">';
 		output += '<button id="confirm-button" type="button" class="nice radius button"><?php echo lang::get("Change")?></button>';
 		
		output += '</div>';
 		
 		output += '<a class="close-reveal-modal"></a>';
 		
 		$('#modal').append(output);
 		$('#second_modal').hide();
 		$('#modal').reveal();

 		$('#confirm-button').click(function(){

 			$('#password').css('border-color', '#CCCCCC');
 			$('#password2').css('border-color', '#CCCCCC');
 			
			var password = $('#password').val();
			var password2 = $('#password2').val();

			if(typeof(password) === 'undefined' || password == ''){
				$('#password').css('border-color', 'red');
				return false;
			}
			
			if(password != password2){
				$('#password2').css('border-color', 'red');
				return false;				
			}

			password_data = encodeURIComponent(password);
			
			$.post("<?php echo gatorconf::get('base_url')?>", { changepassword: password_data} ).done(function(data) {
				// flush 
				window.location.href = '<?php echo gatorconf::get('base_url')?>';
			});
			


	    });

    });

If the code above can be edited to work with what I'm trying to do, it of course only needs one textbox and doesn't have to be confirmed by a second input. Please help! Thanks!

Display And Edit Events Using Fullcalendar Event Calendar

Similar Tutorials

View Content

Hello , I am trying to display my planned events in calendar using full calendar json, jquery. But its not getting displayed, but its getting inserted. I am not very good at jquery or json. please somebody help me in this... here is my code in my calendar.php (display page)

<div class="span8">
                       <div class="w-box w-box-green">
                            <div class="w-box-header"></div>
                            <div class="w-box-content">
                                <div id='calendar_json'></div>
                            </div>
                            <div class="w-box-footer">
                                <p class="f-text">JSON events fetched from a script</p>
                            </div>
                        </div>
                    </div>  
                </div>

and in my calendar.js

 jsonEvents: function() {
            if($('#calendar_json').length) {
                $('#calendar_json').fullCalendar({
                    header: {
                        left: 'month,agendaWeek,agendaDay',
                        center: 'title',
                        right: 'prev,next'
                    },
                    buttonText: {
                        prev: '<i class="icon-chevron-left icon-white cal_prev" />',
                        next: '<i class="icon-chevron-right icon-white cal_next" />'
                    },
                    editable: true,
                    firstDay: 1, // 0 - Sunday, 1 - Monday
                    events: "php_helpers/json-events.php",
                    eventDrop: function(event, delta) {
                        alert(event.title + ' was moved ' + delta + ' days\n' +
                            '(should probably update your database)');
                    }
                });
            }

json-events.php

include("connect.php");
$year = date('Y');
$month = date('m');


//$db=public_db_connect();
$year = date('Y');
$month = date('m');


$command = "SELECT * FROM planner";


$result = mysql_query($command) or die (mysql_error());


while ($row = mysql_fetch_array($result)) {
echo "hi";
    //$start = date("D, j M Y G:i:s T", strtotime($row['start']));
    //$end = date("D, j M Y G:i:s T", strtotime($row['end_time'])); 
$start = date("Y-m-d", strtotime($row['from_time']));
//$start = "$year-$month-20";
    $myid =  $row['plan_id'];
$eventsArray['plan_id'] =  (int)trim($myid); 
    //$eventsArray['title'] = $row['title'];  
$title = $row['company']; 
//$title = $row['title']; 
//echo $title;
$eventsArray['company'] = $title; 
    $eventsArray['from_time'] = $start;
$eventsArray['to_time'] = $start;
    $eventsArray['url'] = "edit_calendar.php?calendarid=".$row['plan_id'];
    // $eventsArray['end'] = $end;
    // $eventsArray['allDay'] = false;
    $events[] = $eventsArray;
}


echo json_encode($events);

Edit Php To Output Xml Results And Display Flash Chart

Similar Tutorials

View Content

Help please.. 50yr old PHP noob..
I have a PHP script that runs a personality survey and returns the dominant personality type, but I need to display the results as a bar chart reflecting the % totals for each of the 4 personality types.
Code is he http://codepad.org/wQN3qN3v Grateful for any help!

How To Modify/edit Loop Values From Mysql Database

Similar Tutorials

View Content

Hi friends. I want to php code on how i can modify my retrieved database values from a particular table before echoing out. Please could you help me correct the code. Or if there is any better way of editing loop datas before printing out, please kindly drop the code for me. Thanks

<?php    

$q = "SELECT * FROM threads WHERE catid='2'";

  $get = $database->query($q) or die(mysql_error());

 $row=mysql_fetch_row($get);


$value=$row['0']['title'];

$one='first value'; 

echo $value.$one;


$value=$row['1']['name'];

$two='second value'; 

echo $value.$two;


$value=$row['2']['category'];

$three='third value'; 

echo $value.$three;

?>

<?php
require_once('upper.php');

require_once('database.php');
if(isset($_COOKIE['LoginIdCookie']))
{
echo '<h4>Welcome '.$_COOKIE['LoginIdCookie'].'</h4>';
}
else{ echo '<h4>Events</h4>';}
$result=mysqli_query($dbc,"select * from events") or die('Not Connected');
echo "<html>
<body>";
  echo "<form method='post' action='EventParticipator.php'>";
  echo "<u><h4>Please tick events in which you want to participate</h4></u>";
  /*echo "<table cellspacing='0' cellpadding='15'>
   <th><b>Event Title:</b></th>
   <th ><b>Event City:</b></th>
<th><b>Content:</b></th>
<th><b>Images:</b></th>
<th><b>Event Date:</b></th>";*/

//while($row=mysqli_fetch_array($result))
$row=mysqli_fetch_array($result);
for($i=0;$i<5;$i++)
{
$Title=$row['Title'];
$City=$row['City'];
$Content=$row['Content'];
//$Photo=$row['Photo'];
$Date=$row['Date'];
$EventId=$row['EventId'];
$Photo=$row['Photo'];
//echo $Photo;

echo "<tr><td><img src='$Photo' width='120' height='90'/></td><td>$City</td><td>,</td><td>$Date</td><td>:</td><td>$Title</td></tr>
<tr><td>$Content</td></tr>
<tr><td><a href='#'>Know more</a></td><td>/</td><td><a href='#'>Click here to participate</a></td></tr>";
}
//echo "<tr><td><input type='submit' name='submit' value='Participate'</td>";
if(isset($_COOKIE['LoginIdCookie']))
{
echo "<td><a href='log_out.php'>Log out</a></td>";
echo "<td><a href='EditActivity.php'>Edit Your Activities</a></td></tr>";
}
echo "</table></form></body></html>";
require_once('lower.php');
?>

Quote

Hi friends ..........
I write above code to display top 5 rows from the database but it not works properly. It displays first row 5 times which is undesireable.
Anyone please help?????????????????
thanks in advance..................