PHP - Allow Third Party Application From Other Mvc Based Application

Hello there,
I'm quite new on PHP language.I'm trying to make an simple Phone book apps.I added insert & show options in Phone book.Now i want to add "update & delete" option.How can i do that.
This is add code:
Code: [Select]
<?php
mysql_connect("localhost","admin","");
mysql_select_db("simphp");
//Get Values from form
$name=$_POST['name'];
$email=$_POST['email'];
$number=$_POST['number'];
mysql_query("insert into phonebook(name,email,number) values('$name','$email','$number')");
echo"Saved Sucessfully";
echo "<br/>";
echo '<a href="index.php/">Homepage</a>';
echo "<br/>";
echo '<a href="select.php/">Show Data</a>';
echo "<br/>";
echo '<a href=update.php>Update</a>';
mysql_close();
?>Show.php=>>
Code: [Select]
<?php
mysql_connect("localhost","admin","");
mysql_select_db("simphp");
$query="select *from phonebook";
$result=mysql_query($query);
$num=mysql_numrows($result);
echo"Number of records Stored:$num";
$i=0;
while($i<$num)
{

$name=mysql_result($result,$i,"Name");
$email=mysql_result($result,$i,"Email");
$number=mysql_result($result,$i,"number");
echo "<br/>";
echo "Name  :<b> $name </b><br/>";
echo "<br/>";
echo "Email : <b>$email</b> <br/>";
echo "<br/>";
echo "Phone :<b>$number</b><br/>";
echo '<a href=update.php>Update</a>';

$i++;
}
?>
 
How can i update and delete data?? :confused:help me

I am new to PHP. I have been trying to do some research online for a few days and not getting very far. I feel like I know less now than I did before I started.

Here's the story:

I've set up a LAMP server that runs a Wiki and AppGini (http://www.bigprof.com/appgini/) - AppGini allows you to "Create web database applications instantly without writing any code" - The only downside we have with it, is it's got it's own set of user accounts. My team all logs in with the default admin account which isn't a big deal but we'd prefer to use LDAP to AD for reasons I won't get into right now.

I emailed AppGini support and asked about LDAP integration. Their response was that it's "a little bit of work" and "You can modify the login authentication function to authenticate using LDAP ... please see the example code he http://code.activestate.com/recipes/101525-ldap-authentication/ (needs some modifications to work with AppGini)"

I've googled around and found 2 dozen different LDAP PHP samples. I've gotten some of them to work. By work I mean they connect to my domain controller and say "success" I'm not actually logged into anything.

So I'm looking for a little help from square one. I need to have a better understanding of how things are supposed to work so I know where I'm supposed to go with all of this. Where do I start? What do I do? What would YOU do?


This is the current "index.php" that logs you into the site.
Code: [Select]
<?php

error_reporting(E_ALL ^ E_NOTICE);
$d=dirname(__FILE__);
include("$d/defaultLang.php");
include("$d/language.php");
include("$d/incCommon.php");
$x->TableTitle=$Translation['homepage'];
include("$d/header.php");

if($_GET['signOut']==1){
logOutMember();
}

$tablesPerRow=2;
$arrTables=getTableList();

?>
<div align="center"><table cellpadding="8">
<?php if($_GET['loginFailed']==1 || $_GET['signIn']==1){ ?>
<tr><td colspan="2" align="center">
<?php if($_GET['loginFailed']){ ?>
<div class="Error"><?php echo $Translation['login failed']; ?></div>
<?php } ?>
<form method="post" action="index.php">
<table border="0" cellspacing="1" cellpadding="4" align="center">
<tr>
<td colspan="2" class="TableHeader">
<div class="TableTitle"><?php echo $Translation['sign in here']; ?></div>
</td>
</tr>
<tr>
<td align="right" class="TableHeader">
<?php echo $Translation['username']; ?>
</td>
<td align="left" class="TableBody">
<input type="text" name="username" value="" size="20" class="TextBox">
</td>
</tr>
<tr>
<td align="right" class="TableHeader">
<?php echo $Translation['password']; ?>
</td>
<td align="left" class="TableBody">
<input type="password" name="password" value="" size="20"class="TextBox">
</td>
</tr>
<tr>
<td colspan="2" align="right" class="TableHeader">
<span style="margin: 0 20px;"><input type="checkbox" name="rememberMe" id="rememberMe" value="1"> <label for="rememberMe"><?php echo $Translation['remember me']; ?></label></span>
<input type="submit" name="signIn" value="<?php echo $Translation['sign in']; ?>">
</td>
</tr>
<tr>
<td colspan="2" align="left" class="TableHeader">
<?php echo $Translation['go to signup']; ?>
<br /><br />
</td>
</tr>
<tr>
<td colspan="2" align="left" class="TableHeader">
<?php echo $Translation['forgot password']; ?>
<br /><br />
</td>
</tr>
<tr>
<td colspan="2" align="left" class="TableHeader">
<?php echo $Translation['browse as guest']; ?>
<br /><br />
</td>
</tr>
</table>
</form>
<script>document.getElementsByName('username')[0].focus();</script>
</td></tr>
<?php } ?>
<?php
if(!$_GET['signIn'] && !$_GET['loginFailed']){
if(is_array($arrTables)){
if(getLoggedAdmin()){
?><tr><td colspan="<?php echo ($tablesPerRow*3-1); ?>" class="TableTitle" style="text-align: center;"><a href="admin/"><img src=table.gif border=0 align="top"></a> <a href="admin/" class="TableTitle" style="color: red;"><?php echo $Translation['admin area']; ?></a><br /><br /></td></tr><?php
}
$i=0;
foreach($arrTables as $tn=>$tc){
$tChk=array_search($tn, array());
if($tChk!==false && $tChk!==null){
$searchFirst='?Filter_x=1';
}else{
$searchFirst='';
}
if(!$i % $tablesPerRow){ echo '<tr>'; }
?><td valign="top"><a href=<?php echo $tn; ?>_view.php<?php echo $searchFirst; ?>><img src=<?php echo $tc[2];?> border=0></a></td><td valign="top" align="left"><a href=<?php echo $tn; ?>_view.php<?php echo $searchFirst; ?> class="TableTitle"><?php echo $tc[0]; ?></a><br /><?php echo $tc[1]; ?></td><?php
if($i % $tablesPerRow == ($tablesPerRow - 1)){ echo '</tr>'; }else{ echo '<td width="50">&nbsp;</td>'; }
$i++;
}
}else{
?><tr><td><div class="Error"><?php echo $Translation['no table access']; ?><script language="javaScript">setInterval("window.location='index.php?signOut=1'", 2000);</script></div></td></tr><?php
}
}
?>

</table><br /><br /><div class="TableFooter"><b><a href=http://bigprof.com/appgini/>BigProf Software</a> - <?php echo $Translation['powered by']; ?> AppGini 4.61</b></div>

</div>
</html>

There are ten list or bookmarks from Prof. Horner's Bible-Reading System found (http://www.facebook.com/group.php?gid=46416541831) each having set number of books from the Bible. One is to read ten chapters a day, one chapter from each of the bookmarks.

Type in what day you are on and the program will show you on each of the lists as to what chapter you are suppose to be on.

Also want to show statistics that will display how many times the Bible has been read with a break down of all 66 books of the Bible.

Started a git respo http://github.com/Kutakizukari/Prof-Horners-Bible-Reading-System

Bookmark list as follows:

//List 1
$Matthew = 28;
$Mark = 16;
$Luke = 24;
$John = 21;

//List 2
$Genesis = 50;
$Exodus = 40;
$Levitieus = 27;
$Numbers = 36;
$Deuteronomy = 34;

//List 3
$Romans = 16;
$I_Corinthians = 16;
$II_Corinthians = 13;
$Galatians = 6;
$Ephesians = 6;
$Philipians = 4;
$Colossians = 4;
$Hebrews = 13;

//List 4
$I_Thessalonians = 5;
$II_Thessalonians = 3;
$I_Timothy = 6;
$II_Timothy = 4;
$Titus = 3;
$Philemon = 1;
$James = 5;
$I_Peter = 5 ;
$II_Peter = 3 ;
$I_John = 5;
$II_John = 1;
$III_John = 1;
$Jude = 1;
$Revelation = 22;

//List 5
$Job = 42;
$Ecclesiastes = 12;
$Songs_of_Solomon = 8;

//List 6
$Psalms = 150;

//List 7
$Proverbs = 31;

//List 8
$Joshua = 24;
$Judges = 21;
$Ruth = 4;
$I_Samuel = 31;
$II_Samuel = 24;
$I_Kings = 22;
$II_Kings = 25;
$I_Chronicles = 29;
$II_Chronicles = 36;
$Ezra = 10;
$Nehemiah = 13;
$Esther = 10;

//List 9
$Isaiah = 66;
$Jeremiah = 52;
$Lamentations = 5;
$Ezekiel = 48;
$Daniel = 12;
$Hosea = 14;
$Joel = 3;
$Amos = 9;
$Obadiah = 1;
$Jonah = 4;
$Micah = 7;
$Nahum = 3;
$Habakkuk = 3;
$Zephaniah = 3;
$Haggai = 2;
$Zechariah = 14;
$Malachi = 4;

so on day 1 it should readout

Matthew Chapter 1
Genesis Chapter 1
Romans Chapter 1
I Thessalonians Chapter 1
Job Chapter 1
Psalms Chapter 1
Proverbs Chapter 1
Joshua Chapter 1
Isaiah Chapter 1
Acts Chapter 1

on the second day it should all say Chapter two but Matthew reaches day 28 it should move on to Mark Chapter 1 and so on and so on and with each bookmark list.

Hey all I have an error in my Facebook application and I'm not sure what's wrong (New to PHP).

The error output is:

Code: [Select]
Warning: array_rand() [function.array-rand]: Second argument has to be between 1 and the number of elements in the array in /home/app/view.php on line 15
And the PHP lines are as follows:

$friends = $facebook->api('/me/friends');
                print_r(array_rand($friends, 3));