Update php code/function

Fertiggestellt Veröffentlicht vor 3 Monaten Bezahlt bei Lieferung
Fertiggestellt Bezahlt bei Lieferung

When I updated from php5 to php8, the code/function used in my full text search engine stopped working. I needs to be updated. Some functions are probably deprecated.

Function:

function getWhereString($sKeywords, $sAndor, $aFields){

$sKeywords = ereg_replace(" +", " ", trim($sKeywords));

$aKeywords = split('[ +]', $sKeywords);

$sWhere = '';

for($i=0;$i<count($aKeywords);$i++){

$sWhere .= (($i==0)?' ':' '.$sAndor.' ').(($sAndor=='AND')?'( ':'');

for ($iK = 0; $iK<count($aFields); $iK++){

$sWhere .= (($iK==0)?' ':' OR ').$aFields[$iK]." LIKE '%".$aKeywords[$i]."%' ";

}

$sWhere .= (($sAndor == 'AND')?' ) ':' ');

}

return $sWhere;

}

Search code:

$stmt = $dbh->prepare("SELECT * FROM table1 AS hc, table2 AS ho

WHERE [login to view URL] = [login to view URL]

AND ".getWhereString($_GET['q'], 'AND', array('[login to view URL]', '[login to view URL]', '[login to view URL]', '[login to view URL], '[login to view URL]', '[login to view URL]', '[login to view URL]'))

."

GROUP BY [login to view URL]

ORDER BY [login to view URL] ASC ");

$stmt->execute();

PHP MySQL

Projekt-ID: #37744180

Über das Projekt

29 Vorschläge Remote Projekt Aktiv vor 3 Monaten

Vergeben an:

aatishkumar001

Hey there, I will update your function to work with PHP 8 within 30 minutes. Let's get started!!!!!!!!!!!!!!!!!!!

€15 EUR in 1 Tag
(29 Bewertungen)
3.9

29 Freelancer bieten im Durchschnitt €21 für diesen Job

amitpandeyposin

Hello there I have a very good experience in PHP. I can update your php code function as per your requirement. I will try to finish asap. Please come on chat to discuss the details.

€30 EUR in 2 Tagen
(154 Bewertungen)
7.4
testotorko

Hey. I am an experienced Web Developer and have worked with wide variety of skills like PHP, MySQl, jQuery / Prototype, Javascript, HTML, CSS and more for many years. Can start right now.

€15 EUR in 1 Tag
(122 Bewertungen)
5.8
vineetagrawalggc

As an experienced professional with over a decade in PHP development and extensive proficiency in programming skills like MySQL and PHP, I am confident that I am the perfect candidate to update your deprecated code/fun Mehr

€10 EUR in 7 Tagen
(18 Bewertungen)
4.8
rahulg5466

Hi there. ⭐⭐ I am a full stack Developer ⭐⭐ with experience in HTML, Javascript, Blockchain, AWS, MY SQL, Bot Developement, Web, Machine Learning (ML), PYTHON, Deep Learning and Communications. I have worked with many Mehr

€30 EUR in 1 Tag
(16 Bewertungen)
4.5
Milos2023

Hi Steve, I hope you’re doing well! I’m interested in the role you posted. Are you open to a quick chat to discuss the position? I’d love to learn more about it, and share more about my own qualifications. I look forw Mehr

€10 EUR in 7 Tagen
(7 Bewertungen)
3.8
ravindrababbar9

As a seasoned PHP developer with over 7 years of experience, I'm well-versed in dealing with code migration and updates like the one required for your all-important full text search engine. I understand just how crucia Mehr

€19 EUR in 7 Tagen
(11 Bewertungen)
3.4
ExpertItSolution

Hello There, I am prepared to update your PHP code to ensure compatibility with PHP 8 and restore functionality to your full-text search engine. With my expertise in PHP, I will swiftly address any deprecated function Mehr

€49 EUR in 1 Tag
(8 Bewertungen)
3.4
juan09dev

With my background in PHP and MySQL, I am more than qualified to handle your project. While focusing primarily on front-end development with a specialization in React and GraphQL, I have also had extensive experience d Mehr

€19 EUR in 7 Tagen
(3 Bewertungen)
2.8
Tahayousuf1011

Hey, Hope you're doing good! Having been a PHP developer for over five years, I’ve successfully updated numerous codebases from php5 to php8. As such, I'm intimately familiar with the common deprecations and changes t Mehr

€25 EUR in 2 Tagen
(3 Bewertungen)
2.0
pbonline2

Hello Steve D., Good afternoon I have a few questions in relation to the specifications of the project. Could we please have a word? My Skills: PHP and MySQL

€8 EUR in 10 Tagen
(2 Bewertungen)
1.1
IreneA0110

Hi, Steve D.. I have just read your project description in details and fully understood your requirements. I am ready to do your projects and I think I am the most proficient in your project. I am expert in languages s Mehr

€25 EUR in 82 Tagen
(0 Bewertungen)
0.0
jay696

Hello. I can start/end without any time. This issues can be done by me in no time. Please contact me. Thanks

€19 EUR in 1 Tag
(0 Bewertungen)
0.0
derekjlaporte

Drawing from my extensive experience as a developer and specifically in MySQL and PHP, I am more than capable of helping you update your full text search engine code to function on the latest PHP8 platform. Over the co Mehr

€35 EUR in 1 Tag
(0 Bewertungen)
0.0
nikoloziSv

Hello, I have strong experience with PHP search engine and version conversion. I think this is very simple bug. I can fix for 30 minutes. Best Regards.

€15 EUR in 1 Tag
(0 Bewertungen)
0.0
oba24com

HI. I can fix your issue now. Please contact me via chat now. THanks

€20 EUR in 1 Tag
(0 Bewertungen)
0.0
leomer3

My name is Leomer, and I have a deep understanding of MySQL and PHP- the foundation of your full-text search engine. Your current code sample demonstrates possible issues with the update from php5 to php8, like deprec Mehr

€19 EUR in 1 Tag
(0 Bewertungen)
0.0
Prabaveer

I am offering my service on short notice. Relevant skills and experience please consider me and given me a chance to impress you by my quality services

€19 EUR in 7 Tagen
(0 Bewertungen)
0.0
eric303

Hello, I 'm skilled php developer and I can do task in 1 hour. If you want to solve it, please contact me immediately.

€20 EUR in 1 Tag
(0 Bewertungen)
0.0