Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Migrating a Site to Silverstripe /

What you need to know when migrating your existing site to SilverStripe.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

integrate external PHP code


Go to End
Reply


15 Posts   6022 Views

Avatar
Megabyte

Community Member, 13 Posts

28 December 2008 at 8:39am

Hello,
I am migrating my website to Silverstripe. But I have a question: On my old page I used a special registration form that generates productkeys. I want to integrate this form in my new page with silverstripe.

How can I integrate the external PHP-code in the CMS??

Avatar
UncleCheese

Forum Moderator, 4093 Posts

28 December 2008 at 5:44pm

Of course you can do that. That's what's so great about Silverstripe -- you're never stuck with just the tools they give you.

I'd start with the recipe on custom forms here:
http://doc.silverstripe.com/doku.php?id=recipes:forms&s=recipes%20forms

If you can't get it working, post your code, and I'd be happy to help you out.

Avatar
Megabyte

Community Member, 13 Posts

19 January 2009 at 5:00am

Is there any other possibility to integrate PHP code? For example a wrapper or something like this. I am looking for an opportunity, when I use the code does not adapt.

Thank you for helping!

Avatar
UncleCheese

Forum Moderator, 4093 Posts

19 January 2009 at 6:36am

There's no reason something like that shouldn't work if you follow the tutorial. If you want, post what you're working on and one of us can help you out.

Avatar
Victor

Community Member, 128 Posts

22 March 2009 at 2:15pm

I tried to ask the similar question on another SilverStripe forum

[url]http://www.silverstripe.org/form-questions/show/256267#post256267[/url]

While tutorial describes form with action to write into DB, I am more interested in reading from DB

Victor

Avatar
UncleCheese

Forum Moderator, 4093 Posts

23 March 2009 at 5:15am

Edited: 23/03/2009 5:16am

You don't need custom PHP to do this. Use the wonderful MVC framework that Silverstripe provides.

Here's your code:

// database info

$query ="SELECT * FROM StaffPage WHERE `lastname` LIKE '$_POST[last_name]%'";

$result = mysql_query($query) or die("Could not execute query");
if (mysql_num_rows($result)==0 ) {print("Not found "); return;
}

while($row = mysql_fetch_array($result)) {
echo $row[lastname].", ".$row[lfirstname];
}
?>

Now I want to put on some page form which is

<form action='./dosearch.php'>
<input type='text' name='last_name'>
<input type='submit'>
</form>

Here's how to do it in Silverstripe:

function StaffSearchForm()
{
return new Form(
$this,
"StaffSearchForm",
new FieldSet(new TextField('StaffSearch','')),
new FieldSet(new FormAction('doStaffSearch','Search'))
);
}

function doStaffSearch($data, $form)
{
$results = DataObject::get("StaffPage","lastname LIKE '%".$data['StaffSearch']."%'");
return $this->customise(array('Results' => $results))->renderWith(array('StaffSearch_results','Page'));
}


StaffPage.ss

$StaffSearchForm

StaffSearch_results.ss

$StaffSearchForm
<% if Results %>
<ul>
<% control Results %>
<li><a href="$Link">$firstname $lastname</a></li>
<% end_control %>
</ul>
<% else %>
There were no results that matched your query.
<% end_if %>

I would also look at the recipe on forms if I were you. Also, the LIKE operator is not the best way to do search in MySQL. It's case sensitive and far too exact to return reliable results. I would use the MATCH and AGAINST functions and order by relevance.

Avatar
Victor

Community Member, 128 Posts

23 March 2009 at 10:29pm

Edited: 24/03/2009 1:01am

Thanks! But as no good deed goes unpunished I will need to ask few more questions:

We are trying to build a Department site and People are divided into Faculty, Staff, Students. Currently we are in very early stage and decided (but decision could be changed) to have separate FacultyPage, StaffPage, StudentPage with the same fields, because we want to have the neither the same "fill forms" nor outputs

Right now I am trying to search just Staff by lastname. But the general idea was to search all, so external (working) php script has UNION ALL in querry, also we matched against

`lastname` LIKE '$_POST[lastname]%' AND `firstname` LIKE '$_POST[firstname]%'

(we want lastname starting from ... and firstname starting from ... (those may be empty); here lastname and firstname are fields name in DB

[quota]
I would also look at the recipe on forms if I were you. Also, the LIKE operator is not the best way to do search in MySQL. It's case sensitive and far too exact to return reliable results. I would use the MATCH and AGAINST functions and order by relevance.
[/quota]

No, we really want to order by lastname and we are looking for 'lastname' starts from not contains the string. I am not sure that you are right about case sensitivity: always worked as not case sensitive. Further

[url]http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html[/url] says

"The following two statements illustrate that string comparisons are not case sensitive unless one of the operands is a binary string:"

mysql> SELECT 'abc' LIKE 'ABC';
mysql> SELECT 'abc' LIKE BINARY 'ABC';

Thanks in advance. Victor

Avatar
Victor

Community Member, 128 Posts

24 March 2009 at 1:33am

I ran into little problem:

If search ends in no results it does not display "Your search ..." message but a complete blank

PS Search form is on StaffHolder while people are StaffPage (as in tutorial-2 but much more fields to fill)

Victor

Go to Top